Regarding of transaction deletion for current database, following are the impact to be considered:
1. All transactions history will be deleted
2. Document Numbering to be decided: continue previous number or restart all document number
3. For Inventory module:
a. Inventory Stock will be 0
b. Lot Number to be decided: continue previous number or restart the lot number .
c. Lot number has to be assigned manually (after import invt. beg. Balance, if using previous database lot number)
4. Input/import beginning balance:
a. Inventory (based on last stock opname) with information of quantity, cost, and lot number. Should consider the latest item cost.
b. Outstanding Purchase Order
c. Outstanding Sales Order
d. Outstanding Production Order
e. Outstanding AP
f. Outstanding AR
g. Beg. Balance of Cash and Bank
h. Beg. Balance of Fixed Asset
i. Beg. Balance of General Ledger
5. Please backup first before do data cleaning
6. Recommend to restore current database into different (new) database, after succeeded then do data cleaning
7. Current database still will be used as live database
Posts
