line item type

[Former Member]

If I know a line item type name how can i find how many Rate Categories currently receive this line item type?

[ivor_martin]

Hi,

Other than writing a BI or other custom report, you could do it in multiple steps:

Run report REAVAR01 for the Line Item Type in question (as the only parameter)

This will list the Variant Program/s that use the line item type.

Then for each Variant you can do a "Where used" to see which Rates the Variant (hence the line item type) is used in.

I hope it helps.

Regards,

Ivor M.

[Former Member]

--"Run report REAVAR01 for the Line Item Type in question (as the only parameter)"

How to set the line item type as the only parameter when run REAVAR01? Thanks.

[ivor_martin]

Hi,

The field name is "Type of Document Line Item".

It should be the last field on the parameter screen.

Regards,

Ivor M.

[Former Member]

It requested to enter Variant Program.

[ivor_martin]

Hi,

If you leave the Variant program parameter blank it lists all the variant programs that relate to the Line Item Type.

Then do a Where Used for each of the Variants that are listed.

Regards,

Ivor M

[Former Member]

Hi,

you can try to build simple query in (SQVI) with following tables:

ETRFV - rate steps with LINE ITEM TYPE

ERTFND - rate determination with rate types and RATE CATEGORIES

Best regards

Vlado