ORDER PROCESSING:
O/E Task 1: Order Entry and Editing
- Reduces quantity-on-hand in Warehouse Master file (Inventory module)
- If item is serialized, updates Serialized Master file (Inventory module) to show it has been sold.
- Updates MTD and YTD dollars sold and quantity sold in Warehouse Master (Inventory module)
- Nightly back-up routine moves invoiced orders out of Task #1 into Task #2 (Invoiced Order Holding File)
O/E Task 2: Invoiced Order Holding File
-
Print Edit List.
- Check off and verify with physical invoices, both sales and money (check, cash & credit card) received.
- Changes may be made to invoices & reprinted.
-
Post Invoices:
-
Prints completed order posting register…..save in a binder or e-mail (if this option is available).
-
Updates:
-
Order History (O/E module)
-
Item History (O/E module)
-
-
Moves invoices to Sales Entry and Editing file (Task #1 in A/R module), where the invoices will stay in Edit form until verified and posted. Any cash received will be moved to the Cash Entry and Editing file (Task #2 in A/R module
-
ACCOUNTS RECEIVABLE:
A/R Task 1: Sales Entry and Editing
-
Print/Preview Edit List – information comes from Task #2 (Invoiced Order Holding File) in the O/E module.
- Make any corrections – order level only, not line item level
- Enter Debit Memos
- Enter any other adjustments
-
Post
- Prints Sales Register….save in a binder or e-mail (if this option is available).
-
Updates:
- Customer Master File (A/R module)
- A/R Open File (A/R module)
- Sales History file (A/R module)
- Sales Distribution History file (A/R module)
A/R Task 2: Cash Entry and Editing
-
Print/Preview Edit list – information comes from Task #2 (Invoiced Order Holding File) in the O/E module.
- Verify cash (checks, cash and credit cards) amount is the same as brought over from the Invoiced Order Holding File
-
Enter cash/checks, etc.
-
Enter any money received ‘on-account’
-
Enter ‘cash paid out’ of till
-
Enter any ‘miscellaneous’ money received
-
Enter adjustment for money that is ‘short’ or ‘over’.
-
-
Reprint/Preview Edit list – amount should agree with Bank Deposit ticket.
-
Post
-
Prints Cash Register….save in a binder or e-mail (if this option is available).
-
Updates:
-
Customer Master file (A/R module)
-
A/R Open file (A/R module)
-
Cash History file (A/R module)
-
-
A/R Task 9: Aged Trial Balance
-
Information comes from the A/R Open file
- A/R Open file is the only file which contains both the Sales and the Cash information for each individual customer.
- “Paid” invoices should be cleared from the customers records once a month using the program in the A/R System Management Function task.
-
A/R Task 12: Prepare Monthly Statements
- Information comes from the A/R Open file.
-
A/R Task 32: System Management Functions
- Clear Paid Invoices from customer records (Task #4)
-
Generate A/R to G/L Interface (Task #3). Information moves to General Ledger module.
- Debit column comes from Sales History file
- Credit column comes from the Sales Distribution file
- Cash information – both debit and credit comes from Cash History file