Creditors / Purchases and Payables Module

Use this section to configure the Purchases and Payables module of Business Central. Start by clicking on Creditors from the Home page:

Create Setup and Posting Groups

This is a priority task, which must be done before other tasks are attempted.

Click on ‘▶️Run Setup’ for the task ‘Create Setup and posting groups’. This will update the Purchases and Payables setup table with commonly used settings, and assign the document number series.

It will also create Vendor Posting Groups, which are used to connect the creditors subledger to the general ledger creditors control accounts. A posting group will be created for each general ledger account designated with the key account usage ‘CREDITORS’. To review the Purchases and Payables setup, click on ‘✅REVIEW’ on the task ‘Review Purchases and Payables’. To review the posting groups, click on ‘✅REVIEW’ on the task ‘Review posting groups.

After running the setups, the first Vendor posting group will be inserted in the page header, in the ‘Default Posting Group’ field. This will be used to set the customer posting group when importing accounts from Excel. You can amend this if required.

Vendor Master

Supplier master data is loaded via an Excel template. Along with the supplier details, a default vendor bank account and primary contact are created.

Before importing vendors, select a default payment terms code and payment method code, and check that the default posting group is correct:

Import from Excel

• Click on ‘▶️Run Setup’ for the task ‘Import Vendor master records’.

• Click on ‘Export Template’ to create an empty Excel Sheet.

• Populate the sheet with the supplier information and bank details, and save the file.

• Click on ‘▶️Run Setup’ again, and this time, select ‘Import Data’.

The standard data template includes the following fields (click for details):

When the import is complete, a dialog will be displayed:

Review Supplier Details To review and edit supplier details, click on ‘✅REVIEW’. The Vendor list will open. You can edit details on this page if required, or you can open the Item Card by clicking on the Edit action in the menu bar.

Review Bank Accounts To review vendor bank accounts, click on ‘✅REVIEW’ on the ‘Import Vendor bank accounts’ task. You can now edit or add bank accounts.

Contacts

When you import customers, a primary contact will be created for each new customer. You can review them by clicking on ‘✅REVIEW’ on the customer contacts task. You can also load additional contacts, by following a similar process to the import for customers:

• Click ‘▶️Run Setup’

• Export template

• Populate template

• Click ‘▶️Run Setup’

• Import from template

Report Selections

If you want to change the default document layout selection for customer quotes, order confirmations, invoices, credit notes and statements, click on ‘✅REVIEW’ on the ‘Report Selections - Sales task’.