Before & after data cleaning/transaction deletion

Posted by mELodYsEasons | 9:02 PM |

The steps to be done before and after data cleaning:

1. Backup current database

2. Create new database

3. Restore last database to new database, this database will be used for disaster recovery

4. After step no. 3 succeeded, do data cleaning will be done.

5. Change General Ledger setup for posting period

6. Setup currency rates

7. Prepare Inventory beg. Balance in Excel format

8. Import and validate Inventory Beginning Balance

9. Assign Item Lot Number based on stock opname data à Posting

10. Input Outstanding Purchase Order, Sales Order, and Production Order

è If using existing document number, number series must be set to manual first.

è If using new document number, must do mapping between old document number and new document number

11. Import Outstanding AP, AR

12. Import Beginning Balance of Cash and Bank, Fixed Asset, and General Ledger

13. Input current transactions