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?
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?
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 ([email protected])
Certified Sage 50/Peachtree Accounting & Crystal Reports Consultant & Trainer
800-780-0700 / 954-961-0600, Visit Us on the Web at https://pcosupport.com
*Community Hub is the new name for Sage City