import

Question

I am trying to import a purchase journal and it keeps bombing on line 1 date field. I have checked all three date columns in .csv & they are all ##/##/## date format.

Erzsi_I · Answer

Hi jen.capitalplumbing , 
 Thank you for reaching out. It looks like you've ensured the date format is correct across all date columns in your .csv file, which is great. The date fields should indeed be in the MM/DD/YY format. 
 If the error persists, here are a few additiona l things to check: 
 
 Ensure there are no hidden characters or spaces before or after the dates in your .csv file. Sometimes these can cause issues even if the date appears correct visually. 
 Verify that all other required fields for the Purchase Journal import are correctly formatted, especially the Vendor ID, Invoice/CM #, and Amount fields. 
 Double-check that the Accounts Payable Account number matches exactly with one in your Chart of Accounts and that it is set up correctly as an Accounts Payable type. 
 
 Remember to always make a backup before attempting the import. And if you need the exact format for each field, refer to this article for a comprehensive overview. 
 If you've checked all the above and the issue remains unresolved, it could be beneficial to reach out to your Sage business partner, network administrator, or accountant for further assistance, as there may be a specific issue with the file or the import process that requires a closer look. 
 Please let us know if you need any further assistance. 
 Warm Regards, Erzsi

KimClement · Answer

The easiest way I think to do this is to manually enter 1 or 2 purchases, with a few lines per purchase. Then export those 2 purchases with the header. Make your purchase import match up with the column headers. 
 FYI- If you are importing a purchase where the invoice number starts with a zero, the purchase.csv file will remove any leading zero, so before you make any changes to the csv file save it to an Excel file. Make your changes, then save it back as a CSV (be sure to choose the Comma delimited.csv choice. 
 Good luck! 
 Kimclement@sbcglobal.net 
 Accounting Conversions

KimClement · Answer

In trying to troubleshoot why this is bouncing on the date, it could be you do not have the columns in the correct order that you have selected for the Import Template. Do you have a blank space in the columns before the date? I noticed the Vendor Name is not a selection on the Sage Purchase Import, so you would have to select that show box to include that column on the import if your data includes the Vendor Name. Could be the number of distributions (which doesn't have any reference to your date error) but may throw off the import. The definition of number of distributions means how many lines are associated with 1 purchase invoice. So, if you have 3 lines that all belong to 1 purchase, all 3 lines must have a 3 in the Number of distributions column. 
 You can send me your csv file if you can't figure it out. Perhaps I can pinpoint the problem. 
 kimclement@sbcglobal.net

Sage 50 US

import

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING