Import sales invoice to SAGE50

Question

Dear, 
 I trying to import sale/invoice to SAGE50, but I getting warning message each row, but all row still success import. 
 The reference number "TP24-0304C" is available, but getting warning. 
 
 The data CSV below: 
 
 anyone know the problem?

termerins · Answer

First, your third column is incorrectly formatted; the Date needs to be MM/DD/YYYY. Second, your fourth column is incorrectly formatted; the Date Due needs to be MM/DD/YYYY. Third, your Amount column doesn't total back to column 6, Accounts Receivable Amount ; this must total back since you've indicated that you only have 1 line of distribution for the Invoice. I can only assume that the difference between the Amount column and the Accounts Receivable Amount is Sales Tax, but you have to include that within your import file - Sage 50 won't automatically calculate it after you import. 
 Tammi M. Ermerins ( tammi@pcosupport.com ) 
 Certified Sage 50/Peachtree Accounting & Crystal Reports Consultant & Trainer 
 800-780-0700 / 954-961-0600, Visit Us on the Web at https://pcosupport.com

Sage 50 US

Import sales invoice to SAGE50

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING