Skip to main content

Notifications

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

PO invoicing issue

(0) ShareShare
ReportReport
Posted on by 130

Hello Dears,

Please your help in below issue, when user trying to invoice PO that was related to SO but it is not now, error appears  as insuffient inventory transaction with status picked.

0333.pastedimage1673175410219v1.png

 

Thanks in advance.

Best regards,

  • REEBAS Profile Picture
    REEBAS 130 on at
    RE: PO invoicing issue

    thanks for detailed explaination, I found  solution for that which is to cancel or correct product recipt cause it reads project even when I remove it from purchase order lines,

    beacuse when removing the connection the purchase was alraedy received.

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,965 Super User 2025 Season 1 on at
    RE: PO invoicing issue

    Hi Roaa,

    There are references on the inventory transactions which manages the reservations and the link between a PO and SO. Just removing a reference on the SQL database on the purchase order header is not a supported way to manipulate data. It will bypass all X++ business logic.

    Try to remove the references from the user interface. If this is not possible, an x++ script would be recommended to remove the references. This should be tested carefully in a non-production environment first.

  • REEBAS Profile Picture
    REEBAS 130 on at
    RE: PO invoicing issue

    yes due to businsess need we have to lookng for a workaround solution, so we set salesid field for PO as null.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,965 Super User 2025 Season 1 on at
    RE: PO invoicing issue

    Hi Roaa,

    What exactly do you mean with separating the PO (from database)? Did you do data manipulation in the Dynamics database? If so, what changes were done exactly and why?

  • REEBAS Profile Picture
    REEBAS 130 on at
    RE: PO invoicing issue

    The senario as below:

    there was a sales order related to this PO but due to some issues and dealy from vendor side we decided to seprate this PO(from database) and then invoice the sales order using stock instead of waiting vendor, and when items are received, user trying to invoice it after receiving but this error appears.

  • Suggested answer
    365Consultancy Profile Picture
    365Consultancy 10 on at
    RE: PO invoicing issue

    When you invoice the PO it tries to post the packing slip for the related SO due to (probably) marking. If there is no inventory to pick upon posting packing slip then you get this error. Check the marking between the two orders and see if you can remove that as you mention these are not related to each other anymore.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,965 Super User 2025 Season 1 on at
    RE: PO invoicing issue

    Hi Roaa,

    Can you explain what exactly is the case when the "PO was related to SO but it is not now"? Can you provide the procedure and steps how this can be reproduced?

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,836 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans