80
Dear Experts,
Our local currency is RUB but we need to track our costs in USD . Most of our products are brought in USD, so we are putting sales prices in USD. All additional costs need to be applied both currencies.
Sales Prices are placed in USD and in some cases in LCY (RUB) .
Does anyone have experience with this kind of request.
To add any new field in value entry and than to update with any batch job?
All suggestions will be appreciated.
Best Regards
*This post is locked for comments
Hello Hano.
Thank you posting on the Community Forum.
The best option to consider is setting up the Additional Reporting Currency for USD in General Ledger Setup (Departments > Financial Management > Administration in RTC or Financial Managment > Setup in Classic).
The ARC Amounts are stored as separate converted values in the G/L Entries Table as well as in the Inventory Subledger for the Value Entries (Table 5802). You can then run reports off of the ARC Amounts instead of the LCY Amounts in certain cases. The ability to do so depends on the specific Report, but the Report will have a check box selection for running using the ARC Amount.
I hope this helps. Please let me know if you have further questions.
Best Regards
Tom
Hi Hano,
this sounds like you can set USD up as your Additional Currency (ACY). The value entries already have ACY fields, and ACY is respected throughout most parts of the NAV application. Setting up the additional currency results in values for LCY and ACY in the G/L and in the value entries (among others).
You should discuss this with accounting, though. The additional currency must be adjusted periodically, resulting in adjustment entries, but AFAIK only in the G/L and in the VAT entries. So, the ACY amounts in the value entry and in the G/L will deviate eventually.
with best regards
Jens
Share
Report
All responses (
Answers (
