Setup A/P & A/R Screen (&) Page 254
Assembly File (A) Page 256
Bill Entry Screen (B) Page 256
Customer File (C) Page 257
Deposit Screen (D) Page 258
Employee File (E) Page 259
Tax Tables & Wage Categories (K) Page 259
Appendix A - Screen Codes & Field Numbers (#)
The following screen codes, field numbers, entry locations and posted field numbers are useful when setting up macros and spreadsheets. Field #s are used on their particular screen in macros with Ctrl+K. Entry Location is used with Ctrl+J. Use the Posted Field # for importing data into a Spreadsheet.
CAUTION: These numbers may be changed when the program is modified or updated. You can check the field # and entry location of most fields by placing the cursor on the field and pressing Ctrl+J.
SET UP COMPANY & G/L SCREEN (#)
Field # Field Name Entry Location Posted Field #
1 Company Name 0
2 Attention Line 1
3 Street Address 2
4 Zip Code 3
5 Zip Extension 6
7 Phone Number 8
8 System Date
9 Year End Month Number 20
10 A/Receivable Acct # 31
11 A/Payable Acct # 36
12 Payroll Cash Acct # 38
13 Inventory Start Acct # 41
14 Inventory End Acct # 42
15 Inventory Reversal Acct # 43
16 Retained Earnings Acct # 40
17 Sales Start Acct # 44
18 Purchase Start Acct # 45
19 Purchase End Acct # 46
20 Ledger 3 Account Name 10
21 Ledger 3 Account # 9
Field # Field Name Entry Location Posted Field #
23 Ledger 4 Account Name 12
24 Ledger 4 Account # 11
26 Ledger 5 Account Name 14
27 Ledger 5 Account # 13
28 Company Number (0-9) 23
29 Ledger 6 Account Name 16
30 Ledger 6 Account # 15
32 Ledger 7 Account Name 18
33 Ledger 7 Account # 17
34 Floor Plan Account # 37
35 Department Multiplier 22
65 A/R Discount Acct. # 32
72 EIN # 7
87 Auto Deposit Post ? 34
92 Payroll & A/P Ledger # 39
95 Department Start # 12
132 Prepay Account # 33
SET UP A/P & A/R SCREEN (&)
Field # Field Name Entry Location Posted Field #
141 Code Generator Indv. Vendor 24
142 Code Generator Comp. Vendor 25
143 Code Generator Indv. Customer 26
144 Code Generator Comp. Customer 27
145 Code Generator Indv. Name 28
146 Code Generator Comp. Name 29
147 Code Generator Indv. Employee 30
160 Credit Card Deposit Acct # 35
191 City 4
192 State 5
25 Sales Order (Printer Selection) 46
31 Labels (Printer Selection) 50
36 Customer Type 0
37 Inventory Markup 1
39 Free Days (Finance Charge) 10
Field # Field Name Entry Location Posted Field #
40 Message (Finance Charge) 14
41 Monthly Rate 7
42 Minimum Charge 8
43 Days till Charge 9
44 G/L Account # 11
45 Compound Interest 12
46 Last Finance Charge Date 13
49 Low Balance Limit 35
50 High Balance Limit 36
51 Ledger # (3-7) 21
52 Discount Account # 22
53 Suspense Account # 23
54 Disable Stock Error 25
55 Price Update Code 26
56 A/P General Ledger Adder 29
57 Overtime Base 38
58 Overtime Factor 39
Field # Field Name Entry Location Posted Field #
62 A)uto,O)ptional B/Ord 3
63 Message (A/R Invoices) 20
64 # of Customer Remarks (1-4) 18
66 Default Sales Account # 4
67 Default Purchase Account # 30
68 Omit P.O. Heading (Y) 19
69 A/P Checks (Printer Selection) 48
70 G/L Checks (Printer Selection) 49
71 A/R Invoices (Printer Selection) 47
73 Subcontract Purchase Account # 31
74 Subcontract Adder 32
75 A/R Invoice Report # 15
76 Labor Sales Account # 40
77 Material Sales Account # 41
78 Subcontract Sales Account # 42
79 A/P Material Markup Percent 43
80 A/P Subcontract Markup Percent 44
Field # Field Name Entry Location Posted Field #
81 List Price Multiplier 27
82 Job Class for Billing 45
83 Price Purchase Orders (Y/N) 33
84 Bank Deposit # 6
85 Create Quote Record (Y) 37
88 Book Increase % 28
89 Point-of-Sale Invoice Report # 17
93 Special Deposit Account # 5
131 Backup Device 52
133 Auto Save User # 53
134 Prepayment Account # 24
135 A/R Invoice # (of copies) 16
148 Envelopes (Printer Selection) 51
151 Omit P.O. Heading (Y) 34
158 Tax on Order Y/N 2
ASSEMBLY SCREEN (A)
Field # Field Name Entry Location Posted Field #
0 Assembly Code 0
1 Labor # 1 hours 1
2 Labor # 2 hours 2
3 Labor # 3 hours 3
4 Labor cost 4
5 Sub-contract 5
6 Material Quantity 6
7 Material Cost 7
8 Sell Price 8
Repeating Fields
10 Item Code 10,14,18,22,26,30, etc.
11 Quantity 12,16,20,24,28,32, etc.
12 Remark 13,17,21,25,29,33, etc.
BILL ENTRY SCREEN (B)
Field # Field Name Entry Location Posted Field #
0 Bill Entry # 0
1 Vendor # 2
2 Invoice Date 20
3 Invoice Number 19
4 Terms 14
5 Due Date
6 Discount Date
7 Discount Amount
8 Job Number 11
9 Pay Code (Y,N,S,F) 15
10 P. Order Date 27
11 P.O.# 26
12 Receive # 24
13 Invoice Amount 13
14 Mat,Dir,Sub 16
Field # Field Name Entry Location Posted Field #
15 Control Date 28
16 Ship To Code 9
17 T & M Contract 17
18 A/R Invoice # 18
19 Date Received 25
Repeating Fields:
20 Item # 33,46,59,72,85,98, etc.
21 Quantity 41,54,67,80,93,106, etc.
22 Price 42,55,68,81,94,107, etc.
23 Amount 43,56,69,82,95,108, etc.
24 G/L Account # 35,48,61,74,87,100, etc.
25 Qty/Case 40,53,66,79,92,105, etc.
26 Price Update Code 44,57,70,83,96,109, etc.
27 Job Class 37,50,63,76,89,102, etc.
28 Serial #
29 Freight Amount 45,58,71,84,97,110, etc.
31 Purchase Order # 39,52,65,78,91,104, etc.
CUSTOMER SCREEN (C)
Field # Field Name Entry Location Posted Field #
0 Customer Code 0
1 Customer Name 1
2 Attention 2
3 Street Address 3
4 Zip Code 4
5 Zip Extension 8
7 Telephone # 13
8 Print Code 24
9 Credit Limit 26
10 Late Charge 32
11 Tax Status 28
12 Discount Level 30
14 Ship Via 31
15 Terms 27
16 Salesperson 17
Field # Field Name Entry Location Posted Field #
17 Advertiser 20
18 Ship to Address 9
19 Customer Type 21
20 Message 1 34
21 Message 2 35
22 Message 3 36
23 Message 4 37
24 Contact Person 16
25 Review Date 33
26 Last Change Date
27 Home Phone # 15
30 P.O. Required 23
31 Tax Number 29
32 Commission 19
33 Zone 11
34 Fax Number 14
36 Old Code 39
Field # Field Name Entry Location Posted Field #
38 Date First Entered
43 Ship (R,C) 12
44 New Code 38
50 Post Date
51 MTD Sales
52 Prior Sales 0
52 Prior Sales 1
53 MTD Pay 2
54 Prior Balance 2
55 Balance 3
56 MTD Cost 4
57 Prior Cost 5
63 Non Invoice Amount 6
64 Sales 1 Year Ago 7
65 Sales 2 Years Ago 13
70 Special Deposit Amount 14
87 Order Deposit Amount 15
101 City 5 20
102 State 6 37
DEPOSIT SCREEN (D)
Field # Field Name Entry Location Posted Field #
0 Reference # 0
1 Customer Code 2
2 Date 1
3 Ledger # 17
4 Check Number 15
5 Check Amount 18
6 Amount Not Applied
7 Total Discount
8 Apply to G/L# 20
9 G/L Amount 22
Repeating Fields
10 Invoice #
11 Invoice Date
12 Invoice Amount
13 (previous) Payment
14 Discount Amount
Field # Field Name Entry Location Posted Field #
15 Discount Date 3 16 Payment Applied 26,36,46,56,66, etc.
17 Discount Applied 27,37,47,57,67, etc.
18 (discount) Earned
19 Balance
EMPLOYEE SCREEN (E)
Field # Field Name Entry Location Posted Field #
0 Employee Code 0
1 Name 1
2 Attention 2
3 Address 3
4 Zip Code 4
5 Zip Extension 7
6 Phone # 8
7 Workman Compensation # 9
8 Social Security # 11
9 Status M/S, P 12
10 Pay Period 15
11 Federal Number of Dependents 13
13 Birth Date 18
14 Hire Date 19
15 Termination Date 20
16 Review Date 21
17 (last) Raise Date 22
TAX TABLES & WAGE CATEGORIES (K)
Field# Field Name Entry Location Posted Field #
61 Current (special Payments) 11
62 1 Mo. Prior (special Payments) 12
63 2 Mo. Prior (special Payments) 13
64 3 Mo. Prior (special Payments) 14
65 Year-to-date (special Payments) 15
Appendix B - Code Order
This is a list in alphabetical order of all letters, numbers and symbols on standard keyboards. The computer uses this to determine code order.
Space Dash - Colon :
Exclamation point ! Period . Semicolon ;
Quotation mark " Slash / "Less than" symbol <
Number sign # Zero 0 Equals =
Dollar sign $ One 1 "Greater than" symbol >
Percent sign % Two 2 Question mark ?
Ampersand & Three 3 "At" sign @
Apostrophe ' Four 4 A
Open parenthesis ( Five 5 B
Closed parenthesis ) Six 6 C
Asterisk * Seven 7 D
Plus + Eight 8 E
Comma , Nine 9 F
G Z m
H Open Bracket [ n
I Backslash o
J Closed Bracket ] p
K Caret ^ q
L Underline _ r
M Accent mark ` s
N a t
O b u
P c v
Q d w
R e x
S f y
T g z
U h Open brace
V i Stile |
W j Closed brace
X k Tilde
Y l