Skip to main content
Post a question

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id : kVMetzBwTqSpSc4r3pOEks
Finance | Project Operations, Human Resources, ...
Answered

PO invoicing issue

Like (0) ShareShare
ReportReport
Posted on 8 Jan 2023 10:58:11 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
    130 on 16 Jan 2023 at 06:27:55
    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
    292,865 Super User 2025 Season 1 on 09 Jan 2023 at 07:28:59
    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
    130 on 09 Jan 2023 at 05:59:25
    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
    292,865 Super User 2025 Season 1 on 08 Jan 2023 at 16:35:07
    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
    130 on 08 Jan 2023 at 16:09:06
    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
    10 on 08 Jan 2023 at 14:49:44
    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
    292,865 Super User 2025 Season 1 on 08 Jan 2023 at 14:21:35
    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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,865 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,723 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans
Loading complete