Show customer opening balance

[Former Member]

Hi

I Want to be able to show the customers opening balance on to the customers Monthly AR invoice. Can you please tell me from where i can get this figure onto the layout

thanks

Regards

Apsara

[Former Member · Accepted solution]

Hi,

Use General Ledger Report to take opening Balance of customer.

Put Tick Mark in BP and enter the Opening Balance Loaded date in From date and To Date you will get the results.

Regards

Jambulingam.P

[Former Member]

Dear Apasara,

Create one UDF at document level and assign this FMS Query there.

Select refresh regularly.

SELECT T0.BALANCE FROM OCRD T0 WHERE T0.CardCode =$[OINV.CardCode]

This is showing your Account balance in that UDF.

May this help you.

Regards

MANGESH PAGDAHRE

[Former Member]

Hi Apsara,

If you create a UDF on the Marketing Documents and populate it when the AR Invoice is saved, the value will be there when the AR Invoice is printed next time.

The Open1ng Balance would be the sum of all the JDT1 Debits less Credits for this BP up to the 1st day of the Month.

I hope this gives you an idea of how to solve your problem.

Garry Bates

Leveragetech

Sydney NSW

[Former Member]

Hi Garry

Thank you so much. Are you able to provide a query for this for me if possible

Thanks

Regards

Apsara