This report outlines all revenue and payments for a single Order by Item Code and includes transactions originating in Microsoft Dynamics GP (Great Plains). Each transaction is grouped by the branch associated to it (if inter-company is turned on, the branch receiving the payable is associated to the transaction; otherwise the branch receiving the revenue is associated to it).
Parameters
|
Parameter |
Description |
|
Order Number |
Enter the order segment without partial, overflow, or set-off values. |
Report Details
Report Grouping
The report is grouped by Branch then by Item Code (as either “unapplied cash,” “other transactions,” or the Item Code and its description).
Header Information
The following information displays in the header for each invoice produced:
•Shipper
•Coordinator
•Salesperson
•Origin Address
•Destination Address
•Estimated Beginning Pack Date
•Estimated Beginning Load Date
•Estimated Beginning Delivery Date
•Branch ID and Branch Description
•Move Type
•Commodity
•Authority
Detail Information
The report lists the following detailed items:
•Customer ID
•Document Type
•Payment/Statement Reference Number
•Document Number
•Original Document Amount
•Journal Date
•Document Date
•Applied To Document Number
•Revenue Amount
•Payment Amount
•Running Balance per Item Code
Report Totals
The report displays Branch and Grand totals for the following items:
•Revenue Amount
•Payments
•Item Code Balance