Sales Credit Memo and Sales Invoice amount are not matching

srafeaaa2
Member Posts: 6
Hi,
I have a problem while posting the Sales Credit Memo by using Copy Document the credit memo amount is not equal to the Inovice amount, ther are some decimal fraction amount is differ. Even though in the databse i have checked exact cost reverse in Sales & Receivable Setup. I have raised the invoice amount for $200 but while posting the credit memo its posted for $199.98. Hence in my customer ledger entry the invoice is still open. Can anyone assist me the problem.
Thanks in advance.
Regards,
Rafeeq
I have a problem while posting the Sales Credit Memo by using Copy Document the credit memo amount is not equal to the Inovice amount, ther are some decimal fraction amount is differ. Even though in the databse i have checked exact cost reverse in Sales & Receivable Setup. I have raised the invoice amount for $200 but while posting the credit memo its posted for $199.98. Hence in my customer ledger entry the invoice is still open. Can anyone assist me the problem.
Thanks in advance.
Regards,
Rafeeq
0
Comments
-
Hi Rafeeq,
I was unable to simulate the problem. Can you give us some more details and explain the exact values used, whether you have select the "Recalculate Lines" option when copying the document, which document have you copied, the Posted Invoice, or something else?
Best,
Chn0 -
Hi Chn,
While doing Copy document function, I had selected 'Recalculate Line' of the original Sales Invoice. After lines are get inserted in the Sales Credit Memo while I checked the Sales Credit Memo Statistics its display the exactly the same amount of the original sales invoice amount but the problem is after geting posted the amount gets varies and there was a difference of decimal fraction0 -
srafeaaa2 wrote:Hi,
I have a problem while posting the Sales Credit Memo by using Copy Document the credit memo amount is not equal to the Inovice amount, ther are some decimal fraction amount is differ. Even though in the databse i have checked exact cost reverse in Sales & Receivable Setup. I have raised the invoice amount for $200 but while posting the credit memo its posted for $199.98. Hence in my customer ledger entry the invoice is still open. Can anyone assist me the problem.
Thanks in advance.
Regards,
Rafeeq
6 x 33.33333333 = 200.00
6 x 33.33 = 199.98
Was there a quantity of 3 or 6 in there somewhere?David Singleton0 -
Rafeeq, Please check the "Invoice Rounding Precision" and "Application Rounding Precision", are these two setups different?
Best,
Chn0 -
Hi Chinmoy,
Both "Invoice Rounding Precision" and "Application Rounding Precision" are as same as 0.01.0 -
If I want an exact copy I don't click Re-Calculate Lines. Especially if some time has passed between the creation of the two docs.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