GL postings created by Value Entry posting in prior period

josephdewey
Member Posts: 87
Hi All,
We're having a strange issue that we haven't had since 2007 when we implemented Navision.
This concerns some inventory transactions that decrease inventory, with a posting date of February. When the Value Entry adjustments are running, and trying to create the rounding transaction, they require the period of January to be open, because the transaction is trying to post on January 1, 2011, even though the posting date of the transaction is February 15, 2012.
I'm wondering what could cause this posting of the prior month's date, when the transaction has a posting date with the current month.
The transaction looks like:
1410, Rounding on 01/01/12, 0.03
5131, Rounding on 01/01/12, -0.03
I know this is a normal transaction, even though I don't know specifically what it does. But it's also not normal for our implementation for this transaction to happen on the prior month, and not the current month.
I've been able to track down that this happens when the last of a Remaining Quantity gets adjusted out of an Item Ledger Entry, and then the Value Entry adjustment gets made. But, I'm not really sure what the next step in my research would be.
Thanks in advance! I will really appreciate any help or advice or questions.
We're having a strange issue that we haven't had since 2007 when we implemented Navision.
This concerns some inventory transactions that decrease inventory, with a posting date of February. When the Value Entry adjustments are running, and trying to create the rounding transaction, they require the period of January to be open, because the transaction is trying to post on January 1, 2011, even though the posting date of the transaction is February 15, 2012.
I'm wondering what could cause this posting of the prior month's date, when the transaction has a posting date with the current month.
The transaction looks like:
1410, Rounding on 01/01/12, 0.03
5131, Rounding on 01/01/12, -0.03
I know this is a normal transaction, even though I don't know specifically what it does. But it's also not normal for our implementation for this transaction to happen on the prior month, and not the current month.
I've been able to track down that this happens when the last of a Remaining Quantity gets adjusted out of an Item Ledger Entry, and then the Value Entry adjustment gets made. But, I'm not really sure what the next step in my research would be.
Thanks in advance! I will really appreciate any help or advice or questions.
Joseph Dewey
Microsoft Dynamics NAV User
Microsoft Dynamics NAV User
0
Comments
-
I think I found the answer to it. It's that the date of the Value Entry GL postings is based on the "Allow Posting From" field in the General Ledger Setup.
We had this date set to 1/1/12, but in the User Setup, we had users restricted to the month of February. That's why it was creating entries outside of the allowed posting dates, and the 'current period.'Joseph Dewey
Microsoft Dynamics NAV User0 -
Hi,
there is another reason: The Inventory Period for January is probably still open. Or a user with too many rights.
with best regards
Jens0 -
Thanks Jens. Good to know!Joseph Dewey
Microsoft Dynamics NAV User0
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