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:

Accounts payable for a freight charge
The purchase order to find the number of the tagged sales order
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:

From the Purchase > Reports menu, select Freight Audit Report, to display the Freight Audit Report criteria window.
In the Branch/Territory field, enter the branch to include on the report. Type ALL to include all branches.
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.
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.

In the Freight field, indicate if you want to include all freight in the following:

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.
In Only - The amount in the Frt Amount column includes only incoming freight charges on the purchase order.

In the Directs field, indicate if you want to include, exclude or print the report for only direct orders.
In the Paid Activity Only field, type Yes, if you want to run the report for only purchase orders that have been applied to approved payables. The default is No.
In the Selection Date field, indicate how you want to limit the report.

This field activates only if the Paid Activity Only field is set to Yes.

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

Set options, if needed, and generate the report.

What the Report Shows

The Freight Audit 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 tab.
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.
Exempt	Populated with Yes or No, depending on the setting for the Frt Out Exempt (Y/N) field in Customer Maintenance for the customer on the tagged sales order. Also is effected by theFreight Out Exempt (Y/N)field on the Sales Order Entry Header tab.
Frt Billed	Amount billed for the products shipped.
Frt	The amount of freight-in on the purchase order.
$Diff	The difference between the amount in the FrtAmountcolumn and the combines amounts from theandcolumns.
Order Total	Total for the purchase order.
GP%	Gross Profit percentage for the purchase order.