Posted transaction with deferrals

Pachi
Member Posts: 25
Hi all,
We are facing a problem with the posted transaction with a deferral in NAV 2016 and 2018.
We create and post a purchase invoice with an expense to be deferred (12M). Initially, transaction is ok but his transaction contains several general ledger entries (T17) with different posting dates (dates along 12M from invoice posting date).
All these entries have the same "Transaction No." that it's the same you have in T45 - G/L Register. In this table the posting date is the invoice one (Dec 27th 2017, for example).
I don't know how it works in other countries but in Spain you have to deliver to authorities every year the "Account - Official Acc. Book" (a report with the detail of every general ledger transaction). This report "reads" T45 registers and print all general ledger entries with the same "Transaction No.", so, if you run the report for 2017, it shows entries for 2018. If you run the report for 2018, it does not show entries with 2018 posting date under a "G/L register" posted in 2017.
So, the real problem is that NAV is not splitting registers in T45 per posting date for deferral entries.
Has someone experienced the same problem? Has someone solved it?
Best regards,
We are facing a problem with the posted transaction with a deferral in NAV 2016 and 2018.
We create and post a purchase invoice with an expense to be deferred (12M). Initially, transaction is ok but his transaction contains several general ledger entries (T17) with different posting dates (dates along 12M from invoice posting date).
All these entries have the same "Transaction No." that it's the same you have in T45 - G/L Register. In this table the posting date is the invoice one (Dec 27th 2017, for example).
I don't know how it works in other countries but in Spain you have to deliver to authorities every year the "Account - Official Acc. Book" (a report with the detail of every general ledger transaction). This report "reads" T45 registers and print all general ledger entries with the same "Transaction No.", so, if you run the report for 2017, it shows entries for 2018. If you run the report for 2018, it does not show entries with 2018 posting date under a "G/L register" posted in 2017.
So, the real problem is that NAV is not splitting registers in T45 per posting date for deferral entries.
Has someone experienced the same problem? Has someone solved it?
Best regards,
0
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