cancel
Showing results for 
Search instead for 
Did you mean: 

Transvalue in XL Reporter

Former Member
0 Kudos

Hi all,

I am designing a XL Reporter template in which have some data of transaction value of inventory in the date range. I got a trouble to split OINM.transvalue into Receipt Transaction Value and Issue Transaction Value.

Item Openning (Value) Receipt (Value) Issue (Value) Closing (Value)

A 30 100 5 125

B 0 30 15 15

C 4 5 7 2

When generating the template, XL show one column only: 95, 15, -2

How to do in this case.

Thanks in advance.

Son.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

This TransValue is a calculated reslt, you have no way to split it. You should check the original entry to get the price and InQty or OutQty to calculate. If you could not get them by XLR, you have to use some other tools to achieve it.

Thanks,

Gordon