I am trying to import the sales invoices into Peachtree, showing that they are applied to specific sales orders. As soon as the Apply to Sales Order field is set to TRUE, I get an error:"An error occurred importing the file SALES.CSVThis happened on:Line Number: 3Field Name: Apply to Sales OrderPress OK to skip record and continue..."If I set this field to FALSE, the invoice is imported, but the distribution is shown under Apply to Sales tab instead of Apply to Sales Order tab.I need to be able to apply the imported invoices to existing sales orders.
What does the TRUE FALSE stand for? Usually it asks if the Item is inactive. In this case, the answer False would be correct. I would suggest adding titles to the columns.
I do have have titles on the first line of the CSV file. Just to see how the data should look, I exported a list of invoices first, and this field had TRUE on the lines with the items listed on the sales order, and FALSE on the sales tax and shipping lines. So I did the same.
That is great. So what is True? What is False? They stand for something.
The Help file says:
Boolean - If distribution is applied to sales order, then TRUE, otherwise FALSE.
So, if there are multiple distribution lines, only lines with items from sales order are shown as TRUE.
Sometimes the import fails because of the field before the one reported.
Also do you have the exact number of fields being imported as were exported? Are they in the correct order?
Yes, the fields in the CSV file are in the same order as in the Import selection window. Could it have a problem with the sales order number? Although the SO number in the CSV file does match the existing number in Peachtree.
There are so many fields here. Without seeing the file it is really hard to help you. Yes, the apply to sales order MUST be true if you are going to hit the sales order.
© 2015, Sage Software, Inc. All Rights Reserved. Sage provides small and medium sized organizations and mid-market companies with a range of easy-to-use, secure and efficient
business management software and services - from accounting, HR and payroll, to payments, enterprise resource planning and customer relationship management.
Community Terms of Service | Community Guidelines | Blog List | Community Help