Can I import a list of multiple items sold at an auction with different items to different buyers?
I’d collect the sold data in a spreadsheet and save the spreadsheet as an IIF file with unique buyer identifiers.
QB's Customer database will already contain Buyers with name, address, and the same unique identifier.
How would I create invoice numbers? How would one buyer’s six purchased items purchased at various times during the auction show up on one invoice? (Sort the spreadsheet before saving IIF file?)
I have some programming and IIF file experience so I could easily massage the sales data into a proper IIF file. I’m using QB Desktop.