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.