Data Archiving

[Former Member]

Hi Expert,

I had a very old company which have business since July 2011~June 2012 (few months operations) and have been stopped since July 2012~Jun 2013. Now I need to use back this company data, however wish to archive/clear all the old transactions and leaving master unchanged. 

I run the period-end closing for July'11~Jun12 (financial period 2011) sucessfully with period closed.  However, what is the reason when I run Data Archive Wizard (Start New Data Archive Run), there is no drop down which allows me to choose the period code for archiving? 

I did perform the backup before running the data archive and we want to archive old S/O, P/O etc. to avoid mixing old data to the transactions after 1 year stop, is there a way to do so? 

Alternately, is there a tools to clear all transactions but leaving all master data in the same company?  

We are using: SAPB1 8.80 pl:19

Thank you very much.

Regards,

Joan.

[kothandaraman_nagarajan · Accepted solution]

Hi Lisa Covarrubias,

Please check with SAP notes:

1693450 - Data Archiving Wizard allows to archive only periods
at least 2 years older than the current date

Hope helpful.

Thanks & Regards,

Nagarajan

[kothandaraman_nagarajan]

Hi Lisa,

To clear all transactions, you can use  Master data cleanup  wizard in 8.82 version.

FYI:

In SAP Business One 8.82, master data cleanup provides

administrators and power users an easy way to remove or

deactivate master data that is not required anymore for the

operations of the company. It provides also a log for the batch

removal and deactivation process. With this enhancement, users

are able to clear a range of high-volume used master data,

including items, business partners, G/L accounts, projects, profit

centers, and distribution rules, either by physically removing the

master data or by deactivating it, without compromising the

business logic integrity.

Hope helpful.

Thanks & Regards,

Nagarajan

[KennedyT21]

Hi Joan...

You Can Upgarde the Db to SAP 9 pl 04 and use the Master data clean up..

Hope Helpful

Regards

Kennedy

[Johan_H]

Hi Joan,

If your really only need the master data, you should probably look into using the Data Transfer Workbench.

I would suggest that you create a brand new company database, and use the DTW to port all master data from your old database to your new one.

If you do also need account balances from the old database, you can just enter them as opening balances in the new one.

This  solution will make for a little more work (checking and copying any settings and such), but it will prevent the risk of misunderstandings, mistakes, and incorrect data in reports and queries.

Regards,

Johan