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

Question

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?

termerins · Answer

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 ( 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

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

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING