Notifications
Announcements
I've created a new item with a Product Type Code of Service. This new item is a freight surcharge that is added to the sales order. The item is designed to add a 10cents a pound surcharge for every pound in Sales Order to cover rising cost of shipping. the sales order accepts the item code and calculated the freight surcharge correctly, but when the sales order is shipped and invoiced the surcharge amount is not included in the invoice and when viewing the sales order the Line Status indicates the surcharge line is in Open Order. What is needed in order to have D365 include this item?
Hi LDBustos,
When you post the packing slip and invoice, is the item included? What parameters are used and what lines were included on the invoice?
Hi Andre,
No the item is defined as a Service product type, which I believe keeps it out of the warehouse requirement of having inventory. I took all the default parameters when submitting the packing slip post. Originally the Quantity was set to All. I've since made some adjustments to the item and now I get a new error message - The value 5637447583 is not found in the map while posting a sales order
Maybe I should back up a step and state what I want to accomplish. I want to introduce a freight surcharge to my sales orders. I created an item with Product Type of Service, a Product subtype of Product, and an Item Model Group of Service and a Price of ten cents per pound in the order. When I add the new item to a sales order it is accepted. I can place a value in the Quantity that represents the total order pounds and the system does the math correctly.
When I process the shipment, the Service Item is not included (as expected) and I complete my shipment. When I return to Invoice the sales order that is when I see that the Surcharge Line is still in an Open Order Status. The invoice that is generated does not include the freight surcharge.
The error message I get if I try to invoice the surcharge line separately is:
No lines for posting or quantity = 0
There is a value in the quantity so I'm perplexed as to what else it needs.
A new thought regarding applying a Freight Surcharge to sales orders under 10K in weight. Could the item I've created be defined in the same manner as items that must charge a Recycle Fee aka CRV? How would i go about changing the item to have it generate a charge of this nature.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 622 Super User 2025 Season 2
Abhilash Warrier 438 Super User 2025 Season 2
Martin Dráb 354 Most Valuable Professional
