Intercompany Currency Bug

tricknot
Member Posts: 5
Hi,
We're investigating intercompany functionality on Nav 5. We've found a bug when distributing invoice lines to another company, which we'd like to know if anyone has found/ had resolved?
(btw, we're only using the Cronos demo for this investigation, and have completed all the relevant I/C setup)
We raised a Purchase Invoice in company A (GBP) for 400 USD total.
In the Invoice Lines, we allocated 200USD to a GL Acct (Postage) in company A and 200USD to company B (which is DKK, but irrelevant for this)
Posting the invoice in Co A gave us the following GL Entries:
DR Co. A Postage 223.02 (400USD converted to GBP @1.79- ok)
CR Co. A Creditors (223.02) (400USD converted to GBP @1.79- ok)
DR Co. A I/C Customer 62.17 Wrong
DR Co. A Postage (62.17) Wrong
What it should have done is Credit Co A Postage 111.51 (200USD converted to GBP). Instead it seems to have taken the already converted 111.51 GBP, treat it as USD and then apply the 1.79 conversion rate again (to give 62.17).
In Co A outbox (and Co B Inbox) it shows incorrectly as 111.51 USD (not GBP).
If anyone else has come across this and can provide fix info, or simply can agree that the above looks wrong, I'd be most grateful!!
Thanks
tricknot
We're investigating intercompany functionality on Nav 5. We've found a bug when distributing invoice lines to another company, which we'd like to know if anyone has found/ had resolved?
(btw, we're only using the Cronos demo for this investigation, and have completed all the relevant I/C setup)
We raised a Purchase Invoice in company A (GBP) for 400 USD total.
In the Invoice Lines, we allocated 200USD to a GL Acct (Postage) in company A and 200USD to company B (which is DKK, but irrelevant for this)
Posting the invoice in Co A gave us the following GL Entries:
DR Co. A Postage 223.02 (400USD converted to GBP @1.79- ok)
CR Co. A Creditors (223.02) (400USD converted to GBP @1.79- ok)
DR Co. A I/C Customer 62.17 Wrong
DR Co. A Postage (62.17) Wrong
What it should have done is Credit Co A Postage 111.51 (200USD converted to GBP). Instead it seems to have taken the already converted 111.51 GBP, treat it as USD and then apply the 1.79 conversion rate again (to give 62.17).
In Co A outbox (and Co B Inbox) it shows incorrectly as 111.51 USD (not GBP).
If anyone else has come across this and can provide fix info, or simply can agree that the above looks wrong, I'd be most grateful!!
Thanks
tricknot
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