Tracking Shipping Paid for Sales Orders

Question

I’m trying to track down the amount of shipping fees we have paid for out going sales orders. I thought this may live in the ship via code but according to Acumatica Freight Expense Account is only used for POs not SOs.

Freight Expense Account
The general ledger account of the Expense
type to be used to record the freight amounts to be paid to the carrier. This account is not updated by the freight cost amounts from the sales orders shipped by the carrier. The freight amounts from purchase order lines of the Freight type on the Purchase Orders (PO301000) form are posted to this account on release of an AP bill created for this purchase order. When a line of the Freight type is added on the Details tab of the Purchase Orders (PO301000) form, the system copies the freight expense account from the ship via code of the vendor location selected in the purchase order.

When a sales order is shipped and invoiced, I see the “Freight Cost” for that sales order but when I look at the GL batch there isn’t a line for shipping paid

astormo40 · Accepted Answer

We also had a client that had a significant amount of outbound shipping costs that needed to be both accrued and then reconciled against bills received from carriers. We were able utilize a custom GI, business event and import scenario thattook into account various ShipVia codes and their corresponding Vendors. It required the freight costs to be entered onto the shipment document.When an invoice is created from a shipment, a purchase receipt will automatically be created for the appropriate vendor, non-stock freight item to correspond to that carrier’s freight accrual accountand then when the bill is received from the carrier the purchase receipts lines are added to the bill and each line is manually adjusted to the billed cost(ppv-expensed in bill period). This allows them to keep track of their expected freight charges as well as keep the carrier accountable for what is being billed. The Purchase Accrual by Period is a great validation screen to see if any freight accrual has not been billed and potentially not delivered.

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded