Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Purchase Advice Report Ignores Quantity on Assembly Component

(1) ShareShare
ReportReport
Posted on by 37
Hello all, 
 
I am looking to better understand the logic of the Purchase Advice report.
 
I have an item that is allocated as a component on assembly orders. From the item card:
 
However, when I run the Purchase Advice report, the QtyAvailable is equal to the Item Inventory. I would expect the QtyAvailable to be 10 less than the Item Inventory, since 10 are allocated to assembly orders. Excel output of Purchase Advice report:
 
Note that QtyAvailable does decrease by the expected amount if the item is allocated to production orders. In this case, the item card will show the quantity allocated to production orders in the "Qty. on Component Lines" field, and the Purchase Advice report behaves as expected.
 
Why does the QtyAvailable field account for "Qty. on Component Lines" but ignore "Qty. on Asm. Component"?
In both cases, inventory has been allocated to orders and the system should calculate purchasing advice accordingly. 
 
Thanks for your help!
  • RB-16101705-0 Profile Picture
    RB-16101705-0 37 on at
    Purchase Advice Report Ignores Quantity on Assembly Component
    Thank you!
  • Verified answer
    gdrenteria Profile Picture
    gdrenteria 13,011 Most Valuable Professional on at
    Purchase Advice Report Ignores Quantity on Assembly Component
    Hi
    Looking at the code I certainly don't see any assembly information added. An issue could be added to the solution repository or a new idea.
    Best
    GR

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,703 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,433 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans