Report Generator and Export / Import Utility

The valid values for ‘Invoice Configurable Column 1’ have changed. Use the new values below when importing/exporting or making reports for use with the Distributors invoicing system.

Previous Values:

  • 5 : Sort Key
  • 10 : Supplier SKU
  • 15 : Outer Barcode
  • 20 : RRP
  • 25 : Primary Barcode

Updated Values:

  • 5 : Primary Barcode
  • 10 : RRP
  • 15 : Outer Barcode
  • 20 : Supplier SKU
  • 25 : Sort Key
  • 30 : Zone
  • 35 : Product Division
  • 40 : Product Group
  • 45 : Product Sub Group
  • 50 : Primary Supplier
  • 55 : Brand

Note: Since values are changing, we will update all Debtor Customers on installation in the below way. This will only happen if at least 1 Debtor Customer has a value.

If old value is 5, change to 25

If old value is 10, change to 20

If old value is 15, leave as 15

If old value is 20. change to 10

If old value is 25, change to 5

All others will change to 25