Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 270 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Inventory Adjustments "Allowed Posting Date"
since2002
Member Posts: 25
A Kit BOM was posted with a Posting Date 10/31/13 USA Date. The allowed posting date for the user posting the transaction was 10/01/13 to 11/30/13. The General Ledger setup had 11/01/13 to 11/30/13 and because the user was alloed to post in October all was good. There were some INVTADJMT records posted to the Value Entry and the GL with posting dates of 11/01/13. I would have expected all the transactions to have the same posting date.
Does the Inventory Adjustment Posting routine ignore the "Allowed Posting Date" for the user doing the posting and just use the General Ledger setup though they all posted together as part of the same transaction?
Does the Inventory Adjustment Posting routine ignore the "Allowed Posting Date" for the user doing the posting and just use the General Ledger setup though they all posted together as part of the same transaction?
0
Comments
From Version 5 upwards: If possible, the posting date is the posting date of the value entry (invoice date) of the item ledger entry which was adjusted. If the inventory period is closed, then the first day of the first open inventory period is used.
If inventory periods are not used, then only G/L Setup."Allow Posting from" is relevant.
The reponsible code snippet from Codeunit 5895
IF GLSetup.IsPostingAllowed("Posting Date") AND InvtPeriod.IsValidDate("Posting Date") THEN ItemJnlLine."Posting Date" := "Posting Date" ELSE ItemJnlLine."Posting Date" := PostingDateForClosedPeriod;So the Inventory Adjustment within the value entries uses ignores user settings completely. But if "Automatic Cost Posting" is activated in the inventory setup which means that "Post to G/L" in the options of the inventory adjustment report 795 is checked, the subsequent posting of the G/L journal batch will use the normal routine checks of the financial management, here the user specific settings override the general settings in the G/L setup as usual.The older NAV versions (3.70 - 4.03) without inventory periods behave slighty different, they had an extra replacement posting date in the options of the inventory adjustment report and used either the date the item ledger entry instead of the value entry or the replacement posting date if the item ledger entry's date was prior to the G/L Setup."Allow Posting From".
NAV 3.60 (and older) used a single fixed posting date for all adjustment entries which you could set in the report options, this solution was, of course, totally inadequate.