The Delete All Cost and Posting process, located in the Performance Analysis -> Costing menu, is available starting v14.11 and can be used to delete all the costs and accounting transactions registered within a period and for all the corresponding products. The period is determined by the Start Date parameter and the current date.
Before running the process you need to go through the following steps:
Stop the Accounting Processor
Open the corresponding Accounting Calendar Periods
Open and delete all the corresponding Tax Declarations, which will have to be re-generated after the cost correction operation
Void all the Capitalization documents registered within the selected period, which will also have to be re-generated;
Limitations
the process cannot be run if the accounting processor is running;
the process cannot be run if the corresponding calendar periods are not open;
the process cannot be run if cost adjustments have been applied within the period;
the process cannot be run if average invoice costs are used;
the process cannot be run if tax declarations exist for the process period (can be deleted and re-generated);
the process cannot be run if the stock has been reevaluated using a credit note;
the process cannot be run if capitalization documents exist for the process period;
Before attempting to delete any costs or accounting transactions, the process will always check if the conditions described above are met.
Note: The process is time consuming and it's execution time is directly proportional to the process period length!
The process will execute the following operation, chronologically, starting with the current date and ending with the start date:
deletes all the accounting transactions for documents that affect stock (un-posts primary documents);
Material Receipt
Order- Invoice/Receipt Associations
Receipt-Invoice Associations
Shipments
Production
Internal Material Movements
Issue to Projects
Vendor Invoices
Return Material Authorizations
Material In/Out
Internal Use Inventory
Internal Material Receipt
Physical Inventory
deletes all cost details
recalculates queue costs for the details left
the process will stop if negative quantity cost quest result. In such cases the costs need to be either manually adjusted or the period for which the process is run needs to be increased!
sets the the accounting processor to run using the "Chronological Processing" option, after which it will run a Server+Client Cache Reset!
starts the accounting server and post all the documents that affect stocks, chronologically, according to the accounting processor definition;
the process will stop when encountering a document with posting errors - in such cases the error need to be addressed manually so that the the costs can be correctly obtained;
after correcting the errors there are two options available:
start the process again, using Start Date = Document Date of the error generating document;
the accounting processor can be manually run
if other error occur, follow the steps described above, until all the documents are posted and all cost are correctly obtained;
Once the process has been successfully completed or after the errors have been manually corrected, the accounting processor can be restarted.
We recommend running the Update Accounting Balance for all the accounting schemas and balance aggregation after running the process
Recommended verifications:
all the reports available in the Performance Analysis -> Costing -> Verify/Correct menu must not display any lines, which means that no differences exist between cost records;
the amounts on the Storage Balance report and Trial balance report for stocks and locations must be equal.
After running the process you need to do the following:
re-generate and complete the declarations
re-generate and complete capitalization documents
close the accounting calendar periods that are not in use;