Show Account Payable (AP) Account instead of Supplier Name in Form Printouts

Modified on Mon, Oct 3, 2022 at 10:56 AM

Show Account Payable (AP) Account instead of Supplier Name in Form Printouts

Overview:

Supplier Accounts are created as sub-accounts of Account Payable. Having this setup, only the Supplier can be selected when making transactions, thus, the system by default, just captures the Supplier Name in GL Journal Posting details and have it reflected in form printouts.

In case the user requires the printout to show the Main/Parent Account, customizing the form design is needed.

Scenario:

To show the Parent Account of the Supplier ‘Accounts Payable’ instead of the Supplier Name on the printout.

Procedure:

1. On the report or transaction screen (e.g. Bills), click the Design button.

2. Select a default format you wish to modify/customize then click Amend. We can use the ‘Bills with Journal Details’ in this example.

3. If it’s the first time that you will be modifying the report format, you need to type a new Display Name (e.g. Bills with Journal Details - Amended), and click Create.

4. Report Designer will open. Double click the 'Subreport2' for the Journal Details.

5. There will be a prompt message, click No.

6. Go to the Field List Panel which is located at the left side of the Report Designer. Right click on any of the fields and select ‘Add Calculated Field’.

7. Created calculated field will be added on the list, right click and choose ‘Edit Calculated Fields’.

8. Change the Name as shown below (can provide your own name).

9. On the same window, go to Expression and click the 3-dot button. This will open the Expression Editor.

10. Input the exact conditional statement as stated below, then click OK.

Conditional Statement:

Iif([Account #].[SACode] ='AP',[Account #].[Sub Account].[Account Name],[Account #].[Account Name])

11. Drag the Calculated Field on the Account Name Column. This will replace the existing default field.

Before:

After:

12. Once done, click the Save Icon and close the Journal Details Subreport.

13. Then click again the Save Icon for the main form.

Application:

1. Create Bill Entries.

2. Preview using the created Report Name. This shall display the Parent Account.

Comparing to Original (System Default)

For further concerns regarding this matter, please contact support to assist you or create ticket thru this link https://support.qne.com.ph

Attachments (1)

pdf

Show Account....pdf
1.95 MB