Order Billing Inquiry Report

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