For Creditor Statement, is there any way to change Ref (Purchase Invoice Number) to Supplier Invoice No?


Yes, you can replace the Purchase Invoice No with Supplier Invoice No in Design Report. 


1) After you have click on ‘Inquiry’, click ‘Print Report’ and click 'Design Report' button on the right side. Click 'Design' at the report that you would like to amend.

2) In design report, click on Field List icon(1) > expand objectDataSource1 (2) >expand CreditorStatement (3) > expand Detail (4) > scroll down and look for SupplierDocNo .


3) Click, hold and drag out the SupplierDocNo (5) and replace the DocNo .


You should see something as below after replacing DocNo with SupplierDocNo.

4) After done, click on Menu on the top left and ‘Save As’ new report and name the report.


Your Creditor Statement should display Supplier Invoice No now.

By: Rotcana 220615, Lay Swan 220627, P 220628