Freight charge on Sales Order

(0) Share

Report

Posted on by Eric Zhu

Hi, we sell products/items to customers, and sometimes we charge our customer freight.

We currently using a G/L account to charge customer freight costs.

When a sales order consists of both item and G/L (freight),after fully shipped the order from Warehouse Shipment, the Complete Shipped filed will still show a "No" even all items are shipped.

Is there any solutions to this? Or I should change the way how I charge freight to customer?

Thanks.

Categories:

Business Central

All responses (13)

Answers (1)

LaserCopr 188 on at

Like (0)

Report

RE: Freight charge on Sales Order

1) This will work for GL=Freight Charge

2) If we use Charge (Item) = Freight, it needs to assign the cost to item, is there a quicker way to apply the cost to the item automatic? So batch posting can go through?
Alfredo_Iorio 1,260 on at

Like (0)

Report

RE: Freight charge on Sales Order

Hi Kim

I assume warehouse shipments are a requirement because Eric says he uses warehouse shipments in his question.

Therefore, his location is set up with Require Shipments = Yes, which means no sales lines with type = item can be shipped from the sales header unless posting a warehouse shipment.

Using batch post on the sales headers with a filter on that location will ship G/L lines or service items but it will not ship standard items because the setup on the location will prevent it.
Suggested answer

Dallefeld 11,425 User Group Leader on at

Like (0)

Report

RE: Freight charge on Sales Order

Alfredo, how do you make sure that the batch post will ship and invoice only the GL line for freight if there are other item lines that did not and should not be shipped.

Is there a specific reason that you are using Warehouse Shipments? You know that they are not a requirement, correct?
Suggested answer

Alfredo_Iorio 1,260 on at

Like (0)

Report

RE: Freight charge on Sales Order

Hi Eric

You can only ship inventory using a warehouse shipment. Therefore, any order with G/L, Item charges or service item must be re-shipped through the sales header to be completely shipped.

One way of solving your problem will be to batch post your sales orders after the posting of the warehouse shipment.

Here I have an order with a charge, I post the warehouse shipment and I am left with the charge not-shipped

The order is partially shipped

I run a Batch post job. Note that I have filters so the routine does not try to ship orders that are not supposed to be shipped with this routine

The order is now fully shipped, including the freight charge and it can be invoiced as one document
Suggested answer

YUN ZHU 73,696 Super User 2024 Season 2 on at

Like (0)

Report

RE: Freight charge on Sales Order

Hi, of cource, you can do this. But when you manage the AR, the payers (customers) are merged into one.

Hope this will help.

Thanks.

ZHU
LaserCopr 188 on at

Like (0)

Report

RE: Freight charge on Sales Order

But that means- customer will get two invoice, one for the items and second one for the freight charge ( GL) ?

Is there any way to combine both on one invoice - item & freight charge?
Verified answer

Suresh Kulla 43,745 on at

Like (0)

Report

RE: Freight charge on Sales Order

Sorry but you have to do a customization to ship the GL Lines, it cannot be done in standard. or after warehouse shipment is posted you need post it again from the sales order screen the G/L Lines.
Eric Zhu 27 on at

Like (0)

Report

RE: Freight charge on Sales Order

hi Suresh

I use Warehouse Shipment to ship, but Warehouse Shipment won't pick up the G/L, so the G/L line on sales order showing not shipped, that's why the Completely Shipped showing No.

Anything I can do to overcome this?
Eric Zhu 27 on at

Like (0)

Report

RE: Freight charge on Sales Order

1 on sales line and 1 been shipped.

I use Warehouse Shipment to ship, but it won't pick up the G/L, so the G/L line on sales order showing not shipped, that's why the Completely Shipped showing No.
Suggested answer

Suresh Kulla 43,745 on at

Like (0)

Report

RE: Freight charge on Sales Order

Is the G/L Account line is also shipped? Even thought it is not a item it needs to be shipped.