Furniture Order Entry Concepts

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.