We import Sales Invoices from excel sheets. Our reference field is used for a unique inv no. We have on occasion had the import of the Sales Invoice sheet happen twice (processes have been put in place to stop this but I'd like belt and braces!) Is there a way for Sage to check the ref field on import of the sheet(as happens with manual input,) and flag up duplicates in sage instead of just completing the import?
Thanks for using Sage City.
During an import it isn't possible for it to flag up a duplication in the reference field. As you've mentioned, it does do it when entering invoices within the software.
You can log this as a suggestion to help improve the software, on our Sage community. To do this, sign in to https://sagecity.na.sage.com/gb > select the relevant product > click the Ideas option from under the heading > click ‘Submit an idea’