Dynamics Community Forum Thread Details

balance brought forward field

Hello,

I have a question that concerns the Vendors report and using the Report Designer in GP 2010

Question: How can I create a balance brought forward field in my Vendors report in Microsoft dynamics GP.

Please note that the balance brought forward field will give the balance of a vendor prior the date specified in the report i.e it summarized the transaction amount/balance to the date specified in the report. Such as it is in Customer statement that can summarized to a particular date as below;

Table 1

Above Table shows where the Customer statement have been summarized to date in the option

Table 2

I discovered that this report (Customer Statement) above show us the beginning balance base on the summarized to date option we have selected.

I want to be able to have such beginning balance in vendors report too

Thank you.

Quick Links