Accounting Ideas

Correction to the reference fields from Dext/Receipt Bank to Sage

We use Receipt Bank (Or Dext as it's now known) to automate our purchase invoice entry. As a general rule this integrates fantastically with Sage. However there is a big issue with where they place the supplier reference or invoice number.

There are two fields within Sage for referencing purchase invoices : "Supplier Reference" and simply "reference". If both are these fields are populated, "Supplier reference" will always overide "reference" on statements and the creditors report.

Receipt Bank publishes the supplier invoice number to "Reference" - not supplier reference. As a general rule, I like to use the reference field to record our own purchase order numbers. Therefore for each transaction, I have to manually go into every purchase order entered and move the purchase invoice number and our PO number to the correct fields. This obviously defeats the point of automation.

I have contacted receipt bank and they state this is a limitation within Sage itself. Is this something that can be looked into, surely this is a simple case of correct field mapping between software?

  • Guest
  • Mar 10 2021
  • We're Taking A Look At This
  • Attach files
  • Guest commented
    23 Nov, 2021 04:23pm

    Unfortunately not as yet,

    As a workaround I have had to put both the supplier reference and our reference in the same field seperated by a hyphen. This does have an added bonus of now making our purchase order number searchable within Sage whereas before it was a bit of a nightmare.

  • Guest commented
    20 Sep, 2021 08:20am

    We are having the same problems did you find a solution to this ?