Sales journal import - duplicates on import

Question

Any thoughts why my sales journal import duplicates on import? No error messages or issues with importing - it just creates a copy of the invoice I imported. 
 I am using the following import fields: 
 1. Customer ID - same all the way down 
 2. Date - same all the way down 
 3. Due Date - same all the way down 
 4. Accounts Receivable Account - same all the way down 
 5. Number of Distributions (number of rows in .csv file less 1 for header row) 
 6. Invoice/CM Distribution (sequentially numbered down the rows 0, 1, 2, etc. - first non-header row with the 0 is a tax type 0 with amount 0 which I included because my initial export file had it) 
 7. Serial Number (left blank - required per "Sales Journal Fields (Import/Export)" article) 
 8. G/L Account (no comments) 
 9. Tax Type - 0 for the first row, 2 the rest of the way down for no tax (see point 6) 
 10. Amount (no comments) 
 11. Sales Tax Agency ID (left blank, except for first row - see point 6.) 
 12. Voided by Transaction (left blank - not needed, yet required per "Sales Journal Fields (Import/Export)" article 
 13. Recur Number - 0 all the way down 
 14. Recur Frequency - 0 all the way down 
 In the meantime, I just delete one of the copies, but I'd like to fix the root problem.

George C · Accepted Answer

John, thanks for your private message; that did the trick. I followed your instructions, copied here to close the thread. A curious note: the columns you recommended I remove show as required on the Sage article "Sales Journal Field (Import/Export)". Since your suggestions worked, I believe the article is outdated. 
 -Add the Credit Memo column to the import job and use FALSE all the way down your file. You are getting duplicates because you do not have an Invoice number column in the file currently and if you don&rsquo;t have the Credit Memo column. Sage for some reason starts over from the beginning and tried to import the same records again. If you had an invoice number then it would not let you import the same invoice number a second time so I do suggest having that, but at least add the Credit Memo column to avoid the repeating import. 
 -Get rid of Columns: Invoice/CM distribution, Voided by Transaction, Recur Number, Recur Frequency

bottomline · Answer

This appears to be your issue: 5. Number of Distributions (number of rows in .csv file less 1 for header row) 
 This should equal the number of rows on the invoice. So if you had 5 line items on the invoice it should show a 5 in each row of the invoice. You also have extra columns that are not needed. Reach out and I can send you a template of a file layout of just what is needed. John@bottomline-acctg.com

Sage 50 US

Sales journal import - duplicates on import

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING