Topic Options
#31937 - 05/23/12 07:31 AM Delete OE Old/Obsolete Invoices
Samuel Kopstick Offline
Adagio Maestro

Registered: 06/15/07
Posts: 920
Loc: GTA & North America (Remote Su...
In OE we can Purge History based on Date.

My client has a need to purge Invoices based on a range of Invoice #’s.

(They have about 40 Invoices that were issued two years ago, with numbers in the form of 12345XXX, while all their other Invoice #’s are simply in the form 12345. We use “Reverse order of order list”, so that these 40 invoices always appear on the top of the list when we view the Invoices.

I know that we can use filters to exclude these Invoices, but then I am disabling the FIND button.
I also know that we can invest in the Toolkit for Adagio & renumber the Invoices, but the client really wants to just delete these Invoices.)

If this feature is unavailable in the current version, can this be added as a request for the next OE release?
_________________________
Samuel Kopstick
S Kopstick & Associates Inc
Toronto, ON

Top
#31938 - 05/23/12 07:49 AM Re: Delete OE Old/Obsolete Invoices [Re: Samuel Kopstick]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Why do you have 2 year old invoices in Current? There's no need to keep more than 90 days or so in that file. Everything is in the History, and you can delete them from there.
_________________________
Andrew Bates

Top
#31940 - 05/23/12 08:12 AM Re: Delete OE Old/Obsolete Invoices [Re: Retired_Guy]
Samuel Kopstick Offline
Adagio Maestro

Registered: 06/15/07
Posts: 920
Loc: GTA & North America (Remote Su...
Thanks Andrew for the quick response.

Their Day-End has “Purge invoices & credit notes older than 9999 days” (although the Orders are being purged after 190 days).

On a copy of the client’s data,. I changed the value to 90 days as you suggest, and it worked exactly as you claim.

And as well, we can still run all their Crystal/GridView custom reports & views from the History.
_________________________
Samuel Kopstick
S Kopstick & Associates Inc
Toronto, ON

Top
#31941 - 05/23/12 08:27 AM Re: Delete OE Old/Obsolete Invoices [Re: Samuel Kopstick]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
That's the plan.

Current should only have documents that you are getting questions on throughout the day. GridView Views and Reports should be run on the History.

Unlike "that other product", Adagio places documents in History as soon as day end is run, and the profile options just control automatic clearing of the documents.
_________________________
Andrew Bates

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 56 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14474 Topics
70689 Posts

Max Online: 432 @ 01/20/25 10:17 PM
May
Su M Tu W Th F Sa
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31