Projected available balance value question

hat04
Member Posts: 9
When i view PAB in item availability by period i found PAB is calculated with Item Ledger Entry which have posting date after the period end date of current row in item availability by period.
Item Ledger Entry's posting date in PAB have range from begin to end date of Item Ledger Entry in all rows of item availability by period.
But I think Item Ledger Entry's posting date in PAB have range from begin to period end date of each rows of item availability by period.
How Navision calculate Item Ledger Entry in PAB like that. Please help me. Sorry for my English :-)
Tuan Hoang Anh
Item Ledger Entry's posting date in PAB have range from begin to end date of Item Ledger Entry in all rows of item availability by period.
But I think Item Ledger Entry's posting date in PAB have range from begin to period end date of each rows of item availability by period.
How Navision calculate Item Ledger Entry in PAB like that. Please help me. Sorry for my English :-)
Tuan Hoang Anh
0
Comments
-
hat04 wrote:i found PAB is calculated with Item Ledger Entry which have posting date after the period end date of current row in item availability by period. Tuan Hoang Anh
No, PAB includes orders un posted data only, so it includes ,on a date, what is coming + what is going out. And this is calculated as per every orders date. E.g. it includes Production Orders as well (Planned and later) , and on Firm Planned and Released Production orders u do not have Posting Date. Purchase -> Expected receipt date, Sales -> Shipment Date. As it is projected so it is before the fact and posting date gets in ledgers after the fact.Kapil Khanna0 -
kapil4dynamics wrote:hat04 wrote:i found PAB is calculated with Item Ledger Entry which have posting date after the period end date of current row in item availability by period. Tuan Hoang Anh
No, PAB includes orders un posted data only, so it includes ,on a date, what is coming + what is going out. And this is calculated as per every orders date. E.g. it includes Production Orders as well (Planned and later) , and on Firm Planned and Released Production orders u do not have Posting Date. Purchase -> Expected receipt date, Sales -> Shipment Date. As it is projected so it is before the fact and posting date gets in ledgers after the fact.
Yes, PAB value include SO, PO, Production Order .... and Item Ledger Entry. But why Item Ledger Entry in PAB have posting date after the period end date of current row in item availability by period.
Tuan Hoang Anh
Sorry for my English0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions