ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Suggestions for Updates >> options for UT-K-E
http://www.istechforum.com/YaBB.pl?num=1221865091

Message started by Lenette on 09/19/08 at 15:58:11

Title: options for UT-K-E
Post by Lenette on 09/19/08 at 15:58:11

I would like to have options in UT-K-E to consolidate specific parts into specific locations.

In other words, our metals are housed offsite at a LOC and would like to remove them from my "main" LOC reports.

Title: Re: options for UT-K-E
Post by Lynn_Pantic on 09/21/08 at 07:49:22

IN-L-B can do that. You can delete the Location records for a given Location for a range of parts so long as there is no on hand or on order quantity for those parts at that Location.

Title: Re: options for UT-K-E
Post by Lenette on 09/22/08 at 07:12:30

Lynn,

I have used that in the past HOWEVER seems when I run SM-J-C because there are transaction files in the system SM-J-C recreates them. Now I haven't tried it since the last update. I will let you know if it does it again.

Lenette

Title: Re: options for UT-K-E
Post by GasGiant on 09/22/08 at 07:43:41

I've been dealing with that a long time, deleting locations that I deleted in the past, but that SM-J-C recreates. However, Lynn mentioned that they are working on a utility that would clean up the stragglers. Perhaps in the next update?

Title: Re: options for UT-K-E
Post by Lynn_Pantic on 09/24/08 at 10:23:58

Utility is done, will be available for the next update or you can email me and request an advance copy. However, it does not do exactly what Lenette wants. It does clean up the stragglers and bogus Location entries. It first displays the list of your existing Locations and you can tag the one(s) you want to keep. It will no longer allow a blank Location so if you have blank, you can't keep it. It then prompts for the Location to move all the records to that do not match the Locations you have chosen to keep. This can be a completely new Location or one of the pre-existing ones. If it is new, then you also need to indicate which existing Location to use the GL Posting in the CLASS file from. It then runs through all the files (including the transaction file) and any entries with a Location value not on the designated "keeper" list is replaced with the new value. Thus, it will correct ALL invalid entries.

There is the possibility when cleaning up multiple no longer needed locations to end up with some cleanup needed in the LOT, SERIAL and BIN files so we are working on utilities and exception reports for those files as well but they are not yet finished.