Running the Freight Audit Report

Use the Freight Audit Report daily to review freight charges for tagged sales orders. You can pass these freight charges on to your customer.

When you enter A/P items, there is a column for freight. If the item that you reconcile against a purchase order is a tagged sale, the system reviews the order to see if freight has been charged on the sale.

The Freight Audit Report reviews the items in the following order:

  1. Accounts payable for a freight charge

  2. The purchase order to find the number of the tagged sales order

  3. Verifies whether the item has been billed with a freight charge included

If the amount equals zero, you can check the purchase order's received date and verify the freight amount that was charged equals the amount on the Incoming Freight Audit report. If it did, then the user can go to the sales order and add the freight amount to that sales order.

To run the Freight Audit Report:

  1. From the Purch > Reports menu, select Freight Audit Report, to display the Freight Audit Report criteria screen.

  2. In the Branch field, enter the branch to include on the report. Type ALL to include all branches.

  3. In the Start Date field, enter the beginning date of the period to include on the report. Enter a calendar date or a variable date. Press F10 to display a calendar from which you can select a date.

  4. In the End Date field, enter the ending date of the period to include on the report. Enter a calendar date or a variable date.

The system populates the field with the date entered in the Start Date field. Press F10 to display a calendar from which you can select a date.

  1. In the Freight field, indicate if you want to include all freight in the report. Press F10 and select one of the following:

  2. All – The amount in the Frt Amount column includes both incoming freight charges on the purchase order and outgoing freight costs on the associated sales order.

  3. In Only – The amount in the Frt Amount column includes only incoming freight charges on the purchase order.

  1. In the Directs (Inc/Exc/Only) field, indicate if you want to include, exclude or print the report for only direct orders.

  2. In the Paid Activity Only field, type Y if you want to run the report for only purchase orders that have been applied to approved payables. The default is No.

  3. In the Selection Date field, press F10 and indicate how you want to limit the report. This field activates only if the Paid Activity Only field is set to Yes.

  4. Receive Date - Selects only purchase orders that have been received within the date range specified.

  5. Payable Date - Selects only purchase orders that have a payable date within the date range specified.

  1. Set options, if needed, and generate the report.

  2. Press Esc to return to the main menu.

What the Report Shows

The report displays the following:

Column

Description

PO#

Purchase order number for received purchase orders.

RecvDate

Date the purchase order was marked received on its Status screen.

Frt Amount

Amount of freight charged on the purchase order.

Tagged SO#

Corresponding sales order tagged to the purchase order.

ShipDate

Date the products on the purchase order shipped from the vendor.

Shp Qty

Amount of products shipped from the vendor.

Product

Product ID.

Exmpt

Populated with Yes or No, depending on the setting for the Frt Out Exempt (Y/N) field on the Customer Maintenance screen for the customer on the tagged sales order.

Also is effected by the Freight Out Exempt (Y/N) field on the Sales Order Entry Header screen.

Frt Billed

Amount billed for the products shipped.

Frt Expnsd

The amount of freight-in on the purchase order.

$Diff

The difference between the amount in the Frt Amount column and the combines amounts from the Frt Billed and Frt Expnsd columns.

Order Total

Total for the purchase order.

GP%

Gross Profit percentage for the purchase order.

See Also:

Purchasing Reports Overview