Field Definitions: Inquiry by Order (02-08-21)
Overview
The following describe the fields on the Inquiry by Order screen.
Table of Contents
Header Information
The Header Information is the first block of information that displays when an order is accessed. This block of information includes the Order Number, Transaction Number, Order Status, Bill To Customer Number and Customer Name, Ship To Customer Number and Customer Name, Ticket Branch (Ticket Audit Branch), Order Date, Sold at Branch, Shipping Warehouse (Pickup Branch), Delivery Date and the salesperson information.
This block can display summary or detail information, based on the preferences set up in the Order Inquiry Preferences selection.
Detail Information
The Detail Information displays below the Header Information on the screen. This block of information includes the detail lines for the entered order. The corresponding Item Number, Description, Unit of Measure, Order Quantity, Price, Department, Product Type, Brand, Pickup Branch, and the Delivery Date display. The information that appears on the detail lines can be specified through the Order Inquiry Preferences selection (02-08-90-05).
If the ‘Display Stock Status’ preference is set to Y, the Onhand, Committed, OnOrder, and Available quantities will appear (for Open detail lines only). The specific lines that display depend on the display method that is chosen.
For example, if you choose to view only open Lines, no history lines will display. A note is included with each detail line to inform you whether the line was entered on the original transaction (through POS) or whether it was added through Order Maintenance.
If you see ‘Ticket Line’ on the first line of the item information, the item was added through POS. If you see ‘Order Detail (ADD),’ the item was added through Order Maintenance.
Payment Information
The Payment Information displays below the Detail Information and it includes all amounts owed and amounts paid for the entered order. The Payment Information is divided into two separate tables of information.
The first table includes Subtotal, Tax, Freight, and Total amounts for the current order along with the original DD transaction totals, shipped totals, open lines, and lines being shipped.
The second table of information includes information for each generation of the order and for the original DD/SO transaction.
First Table
Second Table
- the DD/SO or DZ/SZ shipments for each generation of the order
- the entry date of a ‘CO’ or ‘ML’ transaction
- the date a modification was made to an order (DX) through Order Maintenance.
Example 1:
An Order was created on 12-18-02 with a transaction total of 426.90. $100.00 of the total amount was Financed and the rest of the amount was COD. The first shipment was made on 12-18-02. The Shipped amount for this generation was $81.74. The amount due and paid at the time of shipment was $0.00. The amount that displays in the Dep. Appl column is $100.00. This is because the ‘Ship Full Fin.$ in OP’ preference in A/R Master (12-20) is set to Y, meaning that the full Finance amount is applied on the first generation of the order. The amount shipped was only $81.74 so there was a credit of $18.26 on the next generation of the order. This credit is shown in the Charge/COD column.
The next shipment (Generation 1) of this order took place on 12-19-02. The amount shipped was $172.18. The amount due and paid was $153.92, due to the credit from the last shipment ($172.18-$18.26=$153.92). $153.92 of the $153.92 that has been paid was applied to this shipment. In total, $253.92 of the $253.92 paid has been applied to the order.
The third shipment (Generation 2) was made on 12-20-02. The amount shipped was $87.97. The amount due was $87.97 and the amount paid was $90.00. The amount in the Dep. Appl field is $87.97. Since the amount shipped was $87.97, only$ 87.97 of the $90.00 paid on this shipment was used.
The fourth shipment (Generation 3) was made on 12-21-02. The amount shipped was $85.01. The amount due and paid was only $82.98 ($85.01-$2.03), since the previous shipment was over-paid . The amount applied to this generation is $85.01.
Example 2:
An order was created on 12-18-02 with a transaction total of $432.16. $100.00 of the Order was Financed and the rest was paid for using an Open Charge to a permanent A/R Account.
The shipped amount on the first shipment (Generation 0) was $145.51. Because the ‘Ship Full Fin.$ in OP’ preference in A/R Master (12-20) is set to Y,the full Finance amount was applied to the first shipment. For the remaining $45.51 due on this shipment, the Open Charge amount was used.
Unlike Example 1, for each successive shipment there are no amounts that display in the Dep. Recvd and Dep. Appl fields. This is because the full deposit of 100.00 was used on the first generation. The remaining shipments will use the Open Charge amount (shown in the Charge/COD column). For each shipment, the amount in the Charge/Cod column will be the same as the Shipped amount.
Example 3:
An order was entered with a transaction total of $776.86. The entire amount was paid for using a Finance Company.
The entire Finance Amount of $776.86 was applied to the first shipment of the order. The shipped amount for generation 0 of the order was $277.94. The difference between the shipped amount and the amount applied, $-498.92, displays in the Charge/Cod column. No amounts display in the Dep. Recvd and Dep. Appl columns after the first shipment because all of the deposit was used on the first shipment. To keep track of how the dollars were applied to each generation, the amounts display in the Charge/COD column.
An order was entered with a transaction total of $776.86. The entire amount was paid for using a Finance Company.