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
Yes sorry that's the report I meant. Thank you!
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;
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (