Our company imports data into Quick Books using files in excel format. The charge sales are great but when we import cash sales, there's a problem. The cash sales enter as Sales Receipts and take on a numbering sequence that the computer assigns. We want to be able to keep the number that is already associated with the sale. So a cash sale invoice with number 100235 will get imported but Quick Books will assign it's own number. I need to be able to have the cash sales keep their original invoice number. |