Database size

samblue600

Hi Experts,

My client has 1200 Purchase orders, out of which they are using 400 only , I need to close the remaining 800 order but not delete for future reference.. so Is there a way of compressing the Purchase order as well as posted invoice , to reduce the database size.

Edward_Bloomfield

Hi,

Unfortunately, there isn't. If you want to "archive" the order so it is no longer in the Purchase Header and Purchase Line tables, you could use the Archiving granule (Order screen: Functions -> Archive Order) and then delete the order itself.

Otherwise the only way to keep database size would be to make sure you keep the tables Optimised, but there isn't a way to reduce the space that the data itself occupies. I would look into why the client wants to keep the old documents and see if there is a better way.

vijayanderson

There is a Date compression option available but it deletes the entries and also it can be done only for closed fiscal year entries.


Cheers
Vijay

kriki

And you have to be careful because of customizations. In reality I don't know 1 customer who uses it.
BTW: in the latest versions, you don't even find the menuitems to do it anymore...

David_Singleton

kriki wrote:

And you have to be careful because of customizations. In reality I don't know 1 customer who uses it.
BTW: in the latest versions, you don't even find the menuitems to do it anymore...

Hmm I know many clients that use this tool. I know them because they then call me to fix the disaster that was created by compression :whistle:

bbrown

Why is this even an issue? How much database space could 1200 open purchase orders be taking up? We have clients that produce and post that many sales orders in a single day.

hardik_shah

Its true...1200 is not a big number.