Notifications
Announcements
No record found.
Hello
On Item availability report could someone please help me to clarify what these two columns mean – “quantity on back order” & “projected available balance”
Regards
Selina
*This post is locked for comments
hi,
if you are talking about report "705 Inventory Availability"
MSDN Report definition
msdn.microsoft.com/.../hh172129(v=nav.80).aspx
SCORE Model Supply Chain Definition
Backorder
"An order for a good or service that cannot be filled at the current time due to a lack of available supply."
> NAV: qty on delayed orders & Transfers
Projected available balance
"An inventory balance projected into the future. It is the running sum of on-hand inventory minus requirements plus scheduled receipts and planned orders. Syn: projected available inventory."
> full qty available to date (future)
NAV 2015 Calculations
BackOrderQty :=
Qty. on Purch. Order + Scheduled Receipt + Planned Order Receipt +
Qty. in Transit + Trans. Ord. Receipt (Qty.) + Planning Receipt (Qty.)
+ Purch. Req. Receipt (Qty.);
ProjAvailBalance :=
Inventory + PlannedOrderReceipt + ScheduledReceipt - GrossRequirement;
Yes sorry that's the report I meant. Thank you!
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
