Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

Lines on a Sales Order left in "Open Order" Line Statue after Posting Invoice.

(0) ShareShare
ReportReport
Posted on by 5

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?

pastedimage1675786278625v2.png

  • LDBustos Profile Picture
    LDBustos 5 on at
    RE: Lines on a Sales Order left in "Open Order" Line Statue after Posting Invoice.

    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.

  • LDBustos Profile Picture
    LDBustos 5 on at
    RE: Lines on a Sales Order left in "Open Order" Line Statue after Posting Invoice.

    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.

  • LDBustos Profile Picture
    LDBustos 5 on at
    RE: Lines on a Sales Order left in "Open Order" Line Statue after Posting 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

    pastedimage1675806554391v1.png

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,965 Super User 2025 Season 1 on at
    RE: Lines on a Sales Order left in "Open Order" Line Statue after Posting Invoice.

    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?

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.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,817 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans