Doing a partial unapply
since2002
Member Posts: 25
Is it possible to unapply a single customer invoice from a payment and it not how hard would the coding be. An example is a Payment is applied to 20 different invoices and posted. One or two invoices need to be unapplied. Currently the entire transaction as to be unapplied then re-applied properly. The user does not want to do it that way.
The main code seems to be in codeunit 226 function PostUnApplyCustomer and then codeunit 12 function UnapplyCustLedgEntry. has anyone had the requirement or successfully coded for it?
The main code seems to be in codeunit 226 function PostUnApplyCustomer and then codeunit 12 function UnapplyCustLedgEntry. has anyone had the requirement or successfully coded for it?
0
Comments
-
Hi since2002,
yes this can be done, but it's not a nice task. The application of multiple invoices in one payment is considered as one transaction. The application entries (detailed ledger entries) are accumulated by entry type, so you don't have the splitting information. On the applied invoice, though, you have the information you need, as long as there really is only one payment entry and no credit memo in the bunch. The invoice is usually the applied entry, you need to create un-application entries only for this invoice on the applying entry.
There is another issue: Usually all the adjustments are posted on the applying entry (payment). And they are summed up. Partially unapplying them is next to impossible, the base for the calculation is missing.
All things considered, I would avoid to implement this feature. If I had to and the time is available, I would go the full length of changing the applying logic too, to have very detailed application entries. This can be easily unapplied then, by each application pair.
with best regards
Jens0 -
I agree that this can be done because I have done it
(for a client in the health insurance business), but as Jens has already pointed out, it is not an easy task. Kai Kowalewski0
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
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 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
