cancel
Showing results for 
Search instead for 
Did you mean: 

Inventory audit report

former_member218051
Active Contributor
0 Kudos

Hi All,

what is trans. value and cumulative value in inventory audit report ?

which value is to be considered actually ?

if i add trans value to the opening stock then i get the cumulative value.

For eg.

Apr 08 opening 50,298,110

plus trans. value 13,593,668 (this comes when you see the audit report in expanded form)

=================================================================================

cumulative value 63,891,778 (this is cumulative value when you see the report in collapsed form)

Which value affects the financial statement ?

Thanks

Malhaar

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi!

Transvalue is for individual trancations - same like General ledger report in Finance

Cummulative value is the running total or sum of all transvalue - same like TB in Finance report

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Malhaar,

If you have multiple lines from report, you will know that the cumulative value is nothing but calculated result from the opening balance plus each trans value in sequence.

To answer your question: both are actual from different perspective. Cumulative value may be found in related financial statement because it reflect the amount as of the date range you are selecting. You may only find trans value in detail JE.

Thanks,

Gordon

Former Member
0 Kudos
jitin_chawla
Advisor
Advisor
0 Kudos

Hi,

Trans. Value - It the column where the value that was posted to the inventory account is displayed.

Cumulative Value - It is the column where the total value of inventory after the transaction is displayed.

Inventory Audit Report - Acts as an audit trail for the posted inventory transactions in the chart of accounts.

You use this report to make comparisons between the accounting view (inventory balance accounts) and the logistics view (inventory value displayed by the audit report). The report explains the value changes in inventory accounts.

Kind Regards,

Jitin

SAP Business One Forum Team