Inventory valuation report

(0) Share

Report

Posted on by Community Member

All,

we've implemented a system with 2 currencies: local currency (LCY currency) - which is New Israeli Shekel (ILS) and additional currency (ACY currency) which is USD

our client requires an in 'Inventory valuation report' with ACY currency I.e. based on USD

Has anyone knows how to tackle this point? otherwise are you aware of an3rd party add-on which can help us sort this out?

Thanks!

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Maneesha 5,891 on at

Like (0)

Report
Copy link

Link copied!

are you required this report only or whole operation with ACY currency which is USD

Was this reply helpful? Yes No
Suggested answer

4BzSoftware 6,073 on at

Like (0)

Report
Copy link

Link copied!

Hi Nava,

Our Query and Excel Report tool will help you sort this out. We have this report definition so that you can import and use it immediately. Please contact us via support email, we can support you Licensed Tool to the end of this month for your evaluation before decide to go ahead with us :-)!

More information at Query and Excel Report.

Some pictures on Inventory Valuation Report:

1. Create new report (speed up with Wizard):

2. Select Tables:

3. Define Links of Tables and other Filters:

4. Choose Fields to export:

5. On review Parameters and Filters such as AtDate, LocationCode, ItemNo:

6. Output Excel Report:

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report
Copy link

Link copied!

Hi NAVA,

In both the table i.e Item ledger Entry and Value entry the Addition currency fields are available. Based on that you can make changes in Inventory valuation report and display the values in report.

Check these field :- Cost Amount (Actual) ,Cost Amount (Actual) (ACY)

Was this reply helpful? Yes No