problem with unapplying customer ledger entries

linjmur
Member Posts: 3
when trying to unapply a payment from an invoice, I get the following error message:
Unapplied must be equal to 'No' in Detailed Cust. Ledg. Entry: Entry No.=498. Current value is 'Yes'.
Note that the entry is definitely applied (the only one for this customer). And Entry 498 has not been created yet (last one is 497).
Unapplied must be equal to 'No' in Detailed Cust. Ledg. Entry: Entry No.=498. Current value is 'Yes'.
Note that the entry is definitely applied (the only one for this customer). And Entry 498 has not been created yet (last one is 497).
0
Comments
-
Hi linjmur,
sounds somehow familiar. I just took a tour through the NAV2015 unapply function. Yes, there seems to be a possible bug. The entry that is causing the error was generated during posting. It will be forced to Unapplied = "Yes". A loop later, the newly created entry craps out on the testfield(Unapplied,false).
Now, this is in CU12, UnapplyCustLedgEntry(), NAV2015 CU 10. From what I understand a VAT related unapply is done before the real run, that can create some additional entries. They will show up in the next loop (transaction no. is not filtered), and they are already set to unapplied.
The question is: Is this intended? do they have to be counted into the totals? Looks like it. I don't understand it yet, though. The code in NAV2009R2 (although completely differently distributed in CU 12) doesn't have this second loop. Do you have some additional details regarding this unapply? Maybe the detailed entries of the CL entries you want to unapply as excel?
with best regards
Jens
0 -
thank you for your response Jens. Unfortunately for me your answer is outside of my technical knowledge.. I am an accountant. I'll have to show your response to IS dept. Some more info: we are on 2013R2. Also the error is sporadic. I get the error message again and again and then try again and it will work. I can't see that I'm doing anything different. I've seen this problem posted before but no answer given.0
-
Hi linjmur,
the issue is probably older... 2013R2 is possible, this was the release where Codeunit 12 was refactored. This "sporadic" issue bugs me. It should be deterministic. Do you have automatic jobs like adjust exchange rates, background posting of invoices and so on?
with best regards
Jens0 -
Throw that problems to VAR,
my clients always do that to me. LOL
sounds like either data has been created wrong on previous transactions, or exchange rate related.
(when you have exchange rate, applied date becomes matter again)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