Skip to content

x Want to ask a question or reply? Click here to join the group.
Options
  • State Verified Answer
  • Replies 3 replies
  • Answers 1 answer
  • Subscribers 89 subscribers
  • Views 434 views
  • Users 0 members are here
Browse Forums
Announcements
218
topics
135
replies
General Discussion
4k
topics
12k
replies
Payroll & Tax
498
topics
1k
replies
Reporting and Analytics
334
topics
1k
replies
Software Development Kit (SDK)
221
topics
525
replies
Year End
84
topics
147
replies

Sales journal import - duplicates on import

George C
Solved
Posted By

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.

Parents
  • 0
    Suggested

    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.  [email protected] 

  • +1 in reply to bottomline
    Verified 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’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

Reply
  • +1 in reply to bottomline
    Verified 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’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

Children
No Data

*Community Hub is the new name for Sage City