Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

Inventory Transaction was split

(0) ShareShare
ReportReport
Posted on by 10

Hi ,

How is this inventory transaction was split on the same purchase order? both inventory transaction have the same purchase order number but in the purchase order line there is only one item inside and that is item that has 417 quantity. Where did the other item that has 0.00 quantity and 0.01 Cost amount go? I can't find that item.

pastedimage1636365441143v1.png

Can someone help me solve this problem? I would really appreciate it.

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Inventory Transaction was split

    If there is nothing else left open / unanswered then lets please confirm the answers to get this thread completed.

    Cheers,

    Ludwig

  • Dan_213 Profile Picture
    10 on at
    RE: Inventory Transaction was split

    I see.

    Thanks for your help though, I really appreciate it.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Inventory Transaction was split

    Hi Dan 213,

    There is nothing that you can configure directly to avoid that from happening again.

    A good 'workaround' is setting up prices that do not result in rounding differences. That is, try to avoid prices that end with .33 / .67 or something alike that regularly cause rounding issues.

    Best regards,

    Ludwig

  • Dan_213 Profile Picture
    10 on at
    RE: Inventory Transaction was split

    Can we avoid that from happening again?

  • Dan_213 Profile Picture
    10 on at
    RE: Inventory Transaction was split

    So that remaining 0.01 came from the price of 3.97722 per pcs?

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Inventory Transaction was split

    Hi Dan 213,

    It looks like a rounding issue.

    You purchased 417 pcs and the cost price that I see is 1658.50, which gives a price/pcs of 3.97722.

    That seems to be the underlying issue for the additional line with the 0.01 rounding

    Best regards,

    Ludwig

  • Dan_213 Profile Picture
    10 on at
    RE: Inventory Transaction was split

    It should have only one product receipt, I don't know why the inventory transaction is split into two lines.

  • Dan_213 Profile Picture
    10 on at
    RE: Inventory Transaction was split

    It's a Purchase order / Purchase expenditure, un-invoiced.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Inventory Transaction was split

    Hi Dan,

    The first line looks like a line related to a rounding issue.

    What the transaction / posting type of the line with the 0.01 amount?

    Best regards,

    Ludwig

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,884 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,758 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans