Want to Calc Balance of Vendor

Stivan_dsouza21

I want to Filter the Balance LCY field from vendor Card as per the date filter and want to print the field on header level.

Can Somebody Help me out.

mohana_cse06

What about using Net Change (LCY) field?

Stivan_dsouza21

Balalnce LCY

mohana_cse06

Stivan_dsouza21 wrote:

Balalnce LCY

You cant filter Balance LCY on Date Filter.. :thumbsdown:

mohana_cse06

Net Change (LCY) Field

This field displays, in LCY, the net change in the vendor's account for the period entered in the Date Filter field.

The program uses the Amount (LCY) field in the Vendor Ledger Entry table to calculate and regularly update the contents of this field.

You can filter the Net Change (LCY) field so its contents are calculated only on the basis of certain Global Dimension 1 values, Global Dimension 2 values and/or dates.

Balance (LCY) Field
This field displays in LCY the vendor's current balance.

The program uses the Amount (LCY) field in the Vendor Ledger Entry table to calculate and update the contents of this field.

You can filter the Balance (LCY) field so its contents are calculated only on the basis of certain Global Dimension 1 values and/or Global Dimension 2 values.