Furniture Order Entry Concepts
Understanding Furniture Files
A number of files are used to store furniture order entry information. Becoming familiar with these files can help you prevent errors or troubleshoot any errors that may occur. Each file is listed below, along with the function it serves.
|
C-AUX |
Contains customer history information, which is displayed in the Customer History window. |
|
C-DISC |
Contains customer pricing information, which is displayed in the Customer Order Entry tab. |
|
C-INDEX |
Links the customer's name and account number. This lets you select customers by account number. |
|
C-INFO |
Contains additional customer name and contact information, which is displayed in the Additional Name and Contact boxes in the Customer Master tab. |
|
C-MASTER |
Contains basic customer information, such as name and account number. This information is displayed in the Customer Master tab. |
|
CONTRACTS |
Contains contract information, which is displayed in the (ET) Inventory Contract Price screen. |
|
C-REMARK |
Contains customer information, which is displayed in the Remarks box in the Customer Master tab. |
|
C-SHIPTO |
Stores the customer shipping address, which is displayed in the Shipto Address boxes in the Customer Shipto/Attention tab. |
|
EXCEPTIONS |
Contains a record of unusual order entry actions. You can review these actions by printing the Exceptions Report in the (TR) Order Entry Reports screen. |
|
I-AUX |
Contains inventory usage information and yearly totals, which are displayed in the Item History window. |
|
I-CO-INDEX |
Links the inventory company to the item number description. This lets you select the item by company and description. |
|
I-COLUMNS |
Contains column pricing information, such as quantity breaks and column pricing. This is displayed in the Item window. |
|
I-INDEX |
Links the inventory description to the item number. This lets you select the item by description. |
|
I-MASTER |
Stores inventory information that identifies the item. This information is displayed in the Item Master tab. |
|
I-MFG |
Contains the manufacturer (direct-buy) purchasing information, which is displayed in the Item Add Manufacturer dialog box in the Item window. |
|
I-PRICE |
Contains information that is used to calculate during order entry. This information is displayed in the Item window. |
|
I-WHL |
Stores wholesaler information, which is displayed in the Item Add Wholesaler dialog box in the Item window. |
|
JO-PJINDEX |
Stores the journalized furniture project index. |
|
JO-PROJECT |
Contains journalized furniture project information. |
|
JOUR-S |
Stores journalized information, such as completed invoices and credits. |
|
JO-SPECIAL |
Stores archived specials, used with JOUR-S. |
|
JO-SPINDEX |
Links the journalized salesperson index to furniture projects. |
|
JO-TENDER |
Contains journalized tender information for all order entry transactions. Information in the file P-TENDER is flushed to JO-TENDER when an [MA] Daily Backup Procedure is performed. |
|
PARAMETERS |
Stores all system parameters. |
|
P-BAD-ACCT |
Contains bad account information from the (BA) Bad Account Number File screen. |
|
P-CC |
Stores credit card transactions that have not been transmitted or invoiced. |
|
P-CDINDEX |
Links the customer to the item description for all items previously sold to the customer. |
|
P-CMINDEX |
Links the customer to the manufacturer of all items previously sold to the customer. |
|
P-COMMENT |
Stores global and item comments. |
|
P-CPJINDEX
|
Links the customer's account to the project number in furniture. |
|
P-CPOINDEX
|
Links customer long and short P/O numbers to the invoice number. |
|
P-DEPOSIT |
Contains the deposit detail information. |
|
P-GLOBAL |
Contains global pick ticket/invoice information. |
|
P-H-INDEX |
Contains the record of all orders placed on hold. |
|
P-LINE |
Line item supplemental file to P-MASTER for credit returns. |
|
PO-MASTER |
Contains purchase order information. |
|
PO-SPECIAL |
Stores text created through purchasing specials. |
|
P-PJINDEX |
Stores the furniture project index. |
|
P-PROJECT |
Stores furniture project information. |
|
P-SPJINDEX |
Links the salesperson number to the furniture projects. |
|
P-SUMMARY |
Links summary number to invoice number index. |
|
P-TENDER |
Contains tender information for all transactions. |
|
P-TOTDEP |
Contains the deposit total per customer. |
|
S-HISTORY |
Contains salesperson history, which is displayed in the Salesperson Master tab. |
|
S-MASTER |
Contains basic salesperson information, which is displayed in the Item Master tab. |
|
V-ALIAS |
Vendor alias number index. |
|
V-MASTER |
Stores basic vendor information, such as vendor name and number. This information is displayed in the Vendor Master tab. |
|
V-ORDER |
Stores the default communications settings. |
Additional Files Affected by Furniture Order Entry
The furniture order entry application works closely with accounts receivable, general ledger, and customer history. The furniture order entry application updates the following files that pertain to these applications:
|
AR-MASTER |
Contains accounts receivable and COD details. |
|
AR-BATCH |
Stores accounts receivable postings. |
|
AR-INDEX |
Links the invoice number to the customer account number. |
|
AR-PO-IND |
Links invoices to purchase orders for accounts receivable. |
|
PR-BA-DAY |
Stores daily accounts payable, accounts receivable, and bank totals. These are displayed in the President's screens. |
|
PR-BA-YTD |
Stores year-to-date accounts payable, accounts receivable, and bank totals, which are displayed in the President's screens. |
|
PR-SA-DAY |
Contains the daily sales totals, which are displayed in the President's screens. |
|
PR-SAINDEX |
Links the daily totals for previous days to sales totals. |
|
PR-SA-YTD |
Stores the year-to-date sales total, which are displayed in the President's screens. |