Howdy, Stranger!
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
- 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
- 305 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
How to differenciate entries (invoice vs general journal)
poppins
Member Posts: 647
Hi everyone,
My question is the following:
In table 17 (GL Entry), if I have an entry where Document Type=Invoice, how can I tell if it comes from an invoice or a journal?
Thanks in advance
My question is the following:
In table 17 (GL Entry), if I have an entry where Document Type=Invoice, how can I tell if it comes from an invoice or a journal?
Thanks in advance
0
Comments
you are correct on the Journal Batch field. If populated then origin of that transaction is indeed from that journal batch.
Be aware of system created boolean. This might not always be the case where you did a journal against a G/L account and the other leg of the transaction against bank account. That entry in table 17 for the Bank will be system created but the G/L account transaction will be false.
the best bet will be to check for Journal batch field but also Source Code field. If close to standard NAV it should state something like "GENJNL" or * JNL at least. The number series might also give you a hint.
Hope this helps.