018547: Add System Data payment mapping controls

Add System Data payment mapping controls is not enabled by default.

Please email Development for more information.
Note: there will be additional costs involved if this option is enabled.


KCSL have added a System Data option to Khaos Control which allows the mapping between ledger payment type and sales order payment type to be changed for account and voucher payments.


The mapping between ledger payment types and sales order payment types remains as it is for all of the sales order payment types except Voucher and Account. These will also work as previously, unless changed in the new [ System Data | Payment Type Mapping] screen.

  • 0 -> 0; {cash -> cash}
  • 1 -> 1; {cheque -> cheque}
  • 2 -> 2; {credit card -> credit card}
  • 3 -> 3; {account - DDI}
  • 4 -> 6; {voucher - bacs}
  • 5 -> 6; {credit note - bacs}
  • 6 -> 6; {existing payment - bacs}
  • 7 -> 3; {DDI- DDI}
  • 8 -> 6; {bacs- bacs}


Following the update, the following the additional step is required to change the mapping from the default.

  1. Open a System Data screen (show me how).
  2. Open the [ System Data | Payment Type Mapping] screen.

There will only ever be two lines available; Account and Voucher. The mappings are stored in the ptype_mapping table, along with the other uneditable mapping. The default is that Account maps to DDI and Voucher maps to BACS.

System Data Payment Mapping Screen

These can be changed by;

  1. Press Alt+E or click the green triangle icon is the buttonbar's EDIT button to enter edit mode.
  2. Select the line to change in the right-hand column and press F4 to select the required option.
  3. Press Ctrl+S or click the disk icon is the button bar's SAVE button    to save the changes.


After applying the above Configuration, typical steps for usage would include:

  1. From a [ Supplier | Statement ] tab, select the blue £ icon. Which opens the supplier payments screen.
  2. Selecting one of the options within the “Payment types” filter and having the traffic light green. Lists all of the payments for suppliers with the selected type, as their default payment type.
  3. Green-selected the invoices that require payment, followed by the “Pay Selected” button.
  4. The default “payment type” and corresponding bank based upon the filter will appear. Corresponding to the mapping for the supplier payment type.

For example;

  • A filter of Cash, would have Cash as the default.
  • A filter of BACS, would have BACS as the default.
  • A filter of Account, would have DDI as the default. (This is the option selected within the mapping, so rather than DDI the default will be the payment type setup for Account, such as Account Transfer).

See Also

Visit KhaosWikiX at https://support.khaoscontrol.com/wiki_kcx/ to see the following:

Contact the Khaos Team