Import sales invoice to SAGE50

SUGGESTED

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?

  • 0
    SUGGESTED

    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