Is there a way to Export Past Due Orders into Excel and Update the Date and Import back to Sage to auto-update?


Currently, we are exporting the past due orders into excel, then manually updating each and every one of their dates in Version: Sage 50 Accounting

This takes a large chunk of time to do manually. Does anyone know a way to speed this process up?

  • 0

    You cannot import a transaction that already exists in Sage 50, so manually adjusting those entries is your only option unless you have a custom programmer create some type of DDE Link/Function that would allow your Excel spreadsheet and Sage 50 to communicate. If you need a referral to custom programmers, please reach out to us.

    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