Re: [External] Re: OLM file clean up.

Infor has an OLM purge "under development" but I have not heard when it will be available so any purge/cleanup is on the customer to do.
If there are any audit concerns you may want to create history files to store purged records to or do a soft delete(update record ID).   I just delete them since we have archival backups available.
Primary key for OLM files are warehouse + load number.   Be sure to include the ZPD table in your OLM purge routine.

-----Original Message-----
From: BPCS-L <[email protected]> On Behalf Of Rob Berendt
Sent: Wednesday, April 17, 2019 7:17 AM
To: BPCS ERP System <[email protected]>
Subject: [External] Re: [BPCS-L] OLM file clean up.

I think what Bob is looking for is:  "Why are the old load records still there?"  Basically asking if there is some purge program he should be running at month end or some such thing.  And I believe he is hoping for a user oriented option to do so and not a "use SQL or write a program to purge these records" type of solution.

If I'm wrong Bob can correct me.

I'm more of a sysadmin guy and others here handle our LX stuff.

-----Original Message-----
From: BPCS-L <[email protected]> On Behalf Of Doc Waikato
Sent: Wednesday, April 17, 2019 2:43 AM
To: BPCS ERP System <[email protected]>
Subject: Re: [BPCS-L] OLM file clean up.

Bob,
Depends on how far back you wish to havehistory of Loads.
Any load records older than your order entry orders have no value and can be removed.
Regards
Doc



On Thu, Apr 11, 2019 at 9:24 AM Bob Kohlndorfer <[email protected]>
wrote:

> Can anyone tell me if there is a native way to clean up the OLM files?
> LLH/ LLM/LLL etc. files are getting pretty large and would like to
> clean them up a bit.
>
>
>
> Thanks,
>
> Bob Kohlndorfer
>
> --
> This is the BPCS ERP System (BPCS-L) mailing list To post a message
> email: [email protected] To subscribe, unsubscribe, or change
> list options,
> visit: https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fbpcs-l&amp;data=02%7C01%7Cchris.wynn%40abmauri.com%7Cfcc661ef64fb486d29d308d6c32e9a49%7C39c5be5d25104eee9ca0197a6e89e482%7C0%7C0%7C636911002255255401&amp;sdata=j8%2F%2BOhnaNRnxfpiyGz0RObPO%2F5Tof1DQeBRzsVDeSzE%3D&amp;reserved=0
> or email: [email protected] Before posting, please
> take a moment to review the archives at
> https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fbpcs-l&amp;data=02%7C01%7Cchris.wynn%40abmauri.com%7Cfcc661ef64fb486d29d308d6c32e9a49%7C39c5be5d25104eee9ca0197a6e89e482%7C0%7C0%7C636911002255255401&amp;sdata=G8zVdwdQP3O%2F%2BPvje1IgjFiwFM67j0lR1CzP%2Fha3cZA%3D&amp;reserved=0.
>
>
--
This is the BPCS ERP System (BPCS-L) mailing list To post a message email: [email protected] To subscribe, unsubscribe, or change list options,
visit: https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fbpcs-l&amp;data=02%7C01%7Cchris.wynn%40abmauri.com%7Cfcc661ef64fb486d29d308d6c32e9a49%7C39c5be5d25104eee9ca0197a6e89e482%7C0%7C0%7C636911002255255401&amp;sdata=j8%2F%2BOhnaNRnxfpiyGz0RObPO%2F5Tof1DQeBRzsVDeSzE%3D&amp;reserved=0
or email: [email protected] Before posting, please take a moment to review the archives at https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fbpcs-l&amp;data=02%7C01%7Cchris.wynn%40abmauri.com%7Cfcc661ef64fb486d29d308d6c32e9a49%7C39c5be5d25104eee9ca0197a6e89e482%7C0%7C0%7C636911002255255401&amp;sdata=G8zVdwdQP3O%2F%2BPvje1IgjFiwFM67j0lR1CzP%2Fha3cZA%3D&amp;reserved=0.

--
This is the BPCS ERP System (BPCS-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fbpcs-l&amp;data=02%7C01%7Cchris.wynn%40abmauri.com%7Cfcc661ef64fb486d29d308d6c32e9a49%7C39c5be5d25104eee9ca0197a6e89e482%7C0%7C0%7C636911002255255401&amp;sdata=j8%2F%2BOhnaNRnxfpiyGz0RObPO%2F5Tof1DQeBRzsVDeSzE%3D&amp;reserved=0
or email: [email protected]
Before posting, please take a moment to review the archives
at https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fbpcs-l&amp;data=02%7C01%7Cchris.wynn%40abmauri.com%7Cfcc661ef64fb486d29d308d6c32e9a49%7C39c5be5d25104eee9ca0197a6e89e482%7C0%7C0%7C636911002255255401&amp;sdata=G8zVdwdQP3O%2F%2BPvje1IgjFiwFM67j0lR1CzP%2Fha3cZA%3D&amp;reserved=0.

________________________________

The views expressed in this e-mail are the views of the individual and may not reflect the views of the organisation. Associated British Foods accepts no liability for any losses or damages arising from reliance on the information contained in this e-mail. The information contained in this e-mail is confidential, may be legally privileged and is intended solely for use by the individual or organisation to whom it is addressed. E-mail information is subject to copyright and must not be used, disseminated, copied or disclosed to third parties without the written consent of Associated British Foods. If you are not the intended recipient you should delete this e-mail, destroy all copies and inform the administrator: [email protected] Copyright Associated British Foods plc. All Rights Reserved
 .

Registered Office: Weston Centre, 10 Grosvenor Street, London, W1K 4QY. A limited company registered in England 293262
-- 
This is the BPCS ERP System (BPCS-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/bpcs-l
or email: [email protected]
Before posting, please take a moment to review the archives
at https://archive.midrange.com/bpcs-l.