General Ledger

[Vapour02]

Hello, I have multiple G/L numbers with multiple posting dates for each. I want to assign zero to the first posting date as the opening balance for each G/L and further calculate the idle balance left.

How should I add zero to each G/L identifying the first posting date.

I have attached an sample.

Thanks

[binu_acs]

@Vapour02 Can you provide the expected output?

[davidskaife]

Hi @Vapour02 

If you just want to assign a value of zero to a new column called 'Opening Balance' per GL numbers, you can use the Multi-Row Formula tool to generate it

Use this formula

IF [Row-1:GL] = [GL]
THEN null()
ELSE 0
ENDIF

and you end up with the output like this

I've attached the workflow for you to look at as well