Error: Posting date entered on Vendor Ledger Entry

SteveCP
Member Posts: 6
Hi all,
One of our clients receives rental invoices from his supplier and pays them in advance.
For example:
Invoice for 01/02/2014 - 28/02/2014 received on 01/02/2014
Payment made 31/01/2014
Because the posting date of the payment has been made in advance of the posting date of the purchase invoice, NAV does not like applying the payment to the invoice. The error message is:
"The posting date entered must not be before the posting date on the vendor ledger entry"
The reason they are keen to post the payment before the invoice, is because they can reclaim the VAT in the January quarter, as long as the payment has been made in January.
My suggestion to them has been to change the posting date on the invoice to be 31/01/2014 and to make the document date on the invoice 01/02/2014. I was wondering if there is a better way to handle this? Prepayments in NAV are not an option because they do not use shipments/purchase orders.
Thanks in advance!
One of our clients receives rental invoices from his supplier and pays them in advance.
For example:
Invoice for 01/02/2014 - 28/02/2014 received on 01/02/2014
Payment made 31/01/2014
Because the posting date of the payment has been made in advance of the posting date of the purchase invoice, NAV does not like applying the payment to the invoice. The error message is:
"The posting date entered must not be before the posting date on the vendor ledger entry"
The reason they are keen to post the payment before the invoice, is because they can reclaim the VAT in the January quarter, as long as the payment has been made in January.
My suggestion to them has been to change the posting date on the invoice to be 31/01/2014 and to make the document date on the invoice 01/02/2014. I was wondering if there is a better way to handle this? Prepayments in NAV are not an option because they do not use shipments/purchase orders.
Thanks in advance!
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