Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Clear Accumulators
- Thread starter katididdy
- Start date
crystalreporting
Instructor
I'm going to assume Progression.
The clear AR accumulators function affects accumulators in customers, salespeople, tax codes and service codes (assuming they're being used). In most cases the AR accumulators are just reference information so you probably need to weigh the value of this information versus the work to recover/rebuild it.
The most thorough solution is to restore Progression completely though this may not be feasible depending on how much work has been done in the interim.
Most of the YTD accumulators get copied to corresponding LYTD fields so another option is to use queries or other tools to update the YTD values from the LYTD values. LYTD values would still be incorrect but these are less critical and could also be rebuilt from a backup copy of the tables if need be.
Another option is to restore the affected tables to another database the use queries or other tools to update the live tables from the restored tables.
Finally - you could potentially rebuild the affected fields from the detailed sales information contained in your posted invoices files (OEHDRHST and OELINHST). You would need to develop reports to calculate the required values and/or use queries to update them.
Document # 00.891.396 on the customer portal provides an explanation of all of the areas affected by the AR clear accumulators function.
Peter Shirley
Macola Consultant, PA and surrounding states.
The clear AR accumulators function affects accumulators in customers, salespeople, tax codes and service codes (assuming they're being used). In most cases the AR accumulators are just reference information so you probably need to weigh the value of this information versus the work to recover/rebuild it.
The most thorough solution is to restore Progression completely though this may not be feasible depending on how much work has been done in the interim.
Most of the YTD accumulators get copied to corresponding LYTD fields so another option is to use queries or other tools to update the YTD values from the LYTD values. LYTD values would still be incorrect but these are less critical and could also be rebuilt from a backup copy of the tables if need be.
Another option is to restore the affected tables to another database the use queries or other tools to update the live tables from the restored tables.
Finally - you could potentially rebuild the affected fields from the detailed sales information contained in your posted invoices files (OEHDRHST and OELINHST). You would need to develop reports to calculate the required values and/or use queries to update them.
Document # 00.891.396 on the customer portal provides an explanation of all of the areas affected by the AR clear accumulators function.
Peter Shirley
Macola Consultant, PA and surrounding states.
Alembic in Tempe AZ sells a utility to reset these bases on the database if I am not mistaken.
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
"What version of URGENT!!! are you using?
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
"What version of URGENT!!! are you using?
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question