Bills - Allow invoice number duplication when importing
When importing bills from a csv file, Xero will currently treat all lines with the same invoice number as one transaction, even if the separate lines are from different suppliers. The system should ideally not ignore the fact that the supplier name is not the same. Would be good to assume that the bill is posted against the correct supplier, even if it happens to have the same invoice number as another supplier's invoice.
Leanne Thurston
shared this idea
-
Steve R
commented
This is a bug. A failure of the design logic being implemented in code.
I wish Xero would fix these things instead of making us make a feature request. -
Monique Catanzariti
commented
It would be great if, when uploading bills in a CSV, Xero allowed the same invoice numbers and detected different supplier names and dates of the invoices.
I have had to upload 5,000 bills for a client and have discovered that Xero merges all supplier bills with the same invoice number into one bill and picks one random supplier name for the bill. They need to be entered in separately and have the corresponding supplier name as stated in the CSV file.
This needs to be looked at. It is common for different suppliers to have the same invoice number!!
With such a huge upload, how will I know which invoices are now correct??????? -
Tony McMahon
commented
I agree, we send invoices to xero from a data xtraction system and it will reject them if the invoice number has already been used...even though the supplier is different. Quickbooks does not do this, this is a proper pain in the butt