Sales Credit Memo posting error (version 5)

Noeline
Member Posts: 54
Hi there
When I post a sales credit memo it gives the following error:-
[i]Amount -64,314.681755982 needs to be rounded in Gen. Journal Line Journal Template Name=",Journal Batch Name=",Line No.='0'[/i]
It appears to have to do with the additional reporting currency and it crashes in
The customer has the same foreign currency as the ACY which is EUR, which may or may not be relevant. It does not happen every time with this customer. Just with this one credit note so far. My concern is that it will happen again and I have no idea why, or how to prevent it.
Any ideas will be greatly appreciated.
When I post a sales credit memo it gives the following error:-
[i]Amount -64,314.681755982 needs to be rounded in Gen. Journal Line Journal Template Name=",Journal Batch Name=",Line No.='0'[/i]
It appears to have to do with the additional reporting currency and it crashes in
Code(CheckLine) WITH GenJnlLine DO BEGIN IF EmptyLine THEN BEGIN LastDocType := "Document Type"; LastDocNo := "Document No."; LastLineNo := "Line No."; LastDate := "Posting Date"; EXIT; END; IF CheckLine THEN BEGIN IF OverrideDimErr THEN GenJnlCheckLine.SetOverDimErr; GenJnlCheckLine.RunCheck(GenJnlLine,TempJnlLineDim); END; IF "Currency Code" = '' THEN BEGIN Currency.InitRoundingPrecision; "Amount (LCY)" := Amount; "VAT Amount (LCY)" := "VAT Amount"; "VAT Base Amount (LCY)" := "VAT Base Amount"; END ELSE BEGIN Currency.GET("Currency Code"); Currency.TESTFIELD("Amount Rounding Precision"); IF NOT "System-Created Entry" THEN BEGIN "Source Currency Code" := "Currency Code"; "Source Currency Amount" := Amount; "Source Curr. VAT Base Amount" := "VAT Base Amount"; "Source Curr. VAT Amount" := "VAT Amount"; END; END; IF "Additional-Currency Posting" = "Additional-Currency Posting"::None THEN BEGIN [u][b]IF Amount <> ROUND(Amount,Currency."Amount Rounding Precision") THEN FIELDERROR( Amount, STRSUBSTNO(Text000,Amount));[/b][/u] IF "Amount (LCY)" <> ROUND("Amount (LCY)") THEN FIELDERROR( "Amount (LCY)", STRSUBSTNO(Text000,"Amount (LCY)")); END;
The customer has the same foreign currency as the ACY which is EUR, which may or may not be relevant. It does not happen every time with this customer. Just with this one credit note so far. My concern is that it will happen again and I have no idea why, or how to prevent it.
Any ideas will be greatly appreciated.
0
Comments
-
This is one that had me hammering my head for a while
You are obviousbly trying to apply the credit not against a certain document. In your case you need to see how many decimal point the application currecny are set to as you will probably find that it will only apply to .00001 etc depending how you have it setup.
You can go to the GL entry to see what level of decimals it goes down to.0 -
I found a meantime workaround - If I simply 'ctrl-x' and the 'ctrl-v' on 'line amount excl VAT' it seems to solve the problem and the document posts.
This obviously forces some kind of validate which the 'get posted document lines' did not do automatically as they are loaded.
Regards - Noeline0
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