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
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 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
2009 R2 single sided Journal Entry
hg1311
Member Posts: 6
I have NAV 2009R2, using the RTC. NAV is letting us post one sided journal entries and I don't understand how.
Here is the situation:
We are importing using a dataport straight into the General Journal Line table (81). This entry brings in about a 50 line entry. This entry is always off by a few cents due to the foreign currency exchange rate. We are then adding the few cents to a new line (just the next available line in the Gen Jnl) posted directly to a currency expense account. However NAV is assigning this new line a new document number, instead of keeping it the same as the last 50 lines. This causes the 50-line entry to be off by a few cents. It also causes the new document line to be posted as a single sided entry with no balancing Debit (or credit). NAV has never let us post unbalanced lines before, especially a single sided entry.
Does anyone know why it is suddenly allowing this?
Thank you in advance for your help!
Here is the situation:
We are importing using a dataport straight into the General Journal Line table (81). This entry brings in about a 50 line entry. This entry is always off by a few cents due to the foreign currency exchange rate. We are then adding the few cents to a new line (just the next available line in the Gen Jnl) posted directly to a currency expense account. However NAV is assigning this new line a new document number, instead of keeping it the same as the last 50 lines. This causes the 50-line entry to be off by a few cents. It also causes the new document line to be posted as a single sided entry with no balancing Debit (or credit). NAV has never let us post unbalanced lines before, especially a single sided entry.
Does anyone know why it is suddenly allowing this?
Thank you in advance for your help!
0
Comments
This is from NAV help for this field.
Force Doc. Balance Field
The Gen. Journal Template Table
Here you can specify whether documents that are posted in this general journal template must balance by document number and document type.
When the program balances the general journal, it always does it on the basis of date. If you place a check mark in the Force Doc. Balance field, you allow posting only of documents that also balance by document number and type.
Place a check mark in the check box if the documents must balance by document number and type.
This imbalance problem only happens when we import a GL entry. We do not have this problem when we are entering through the normal Gen Jnl page, it always errors out if we are out of balance.
It's like the import is overriding the rules?