Advance Payment handling in NAV
Hayan
Member Posts: 110
Dear All,
Accounting practices in many countries/regions require that prepayment journal vouchers, or payments in advance, from a customer or to a vendor not be posted to the usual posting accounts for the customer or vendor. Instead, these prepayment journal vouchers must be posted to special ledger accounts for prepayment journal vouchers. When a sales order or purchase order is made, an invoice is issued to the customer or vendor. When the invoice is paid, the prepayment journal voucher and sales tax prepayment journal voucher on the ledger accounts for the prepayment journal vouchers are reversed. The invoice amounts are then automatically posted to the usual summary accounts. I don't want to work with prepayment accounts since they are related to Sales or Purchase Order, I want to have a free Advance Payment. Plus this account has to be included in the Exchange rate adjustment at the end of year closing. Is there a way this can be done?
Best
HAYAN
Accounting practices in many countries/regions require that prepayment journal vouchers, or payments in advance, from a customer or to a vendor not be posted to the usual posting accounts for the customer or vendor. Instead, these prepayment journal vouchers must be posted to special ledger accounts for prepayment journal vouchers. When a sales order or purchase order is made, an invoice is issued to the customer or vendor. When the invoice is paid, the prepayment journal voucher and sales tax prepayment journal voucher on the ledger accounts for the prepayment journal vouchers are reversed. The invoice amounts are then automatically posted to the usual summary accounts. I don't want to work with prepayment accounts since they are related to Sales or Purchase Order, I want to have a free Advance Payment. Plus this account has to be included in the Exchange rate adjustment at the end of year closing. Is there a way this can be done?
Best
HAYAN
0
Answers
-
Hi Hayan,
only if you customize it (some AddOns might have it, though). Plus, if you want to adjust it, you would need a separation of the C/L and V/L entries regarding their reconciliation account - can be done, it's also a customization, though. If there is no link to an order, is this sort of a deposit? If not, it's more like prepayment (with the bugs removed). One our AddOns (Plexada BuildingBlocks) has quite a lot of fixes for prepayment handling. To add the separate accounts and adjustment handling on this would be about half the way.
with best regards
Jens0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 611 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 253 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions