Thanks to answers from Colin & Steve.
This topic is still an issue, but we are in a transition with multiple fires blazing.

My employer is one of several bought out by a parent company, which is taking over much accounting.

We do our supply chain thing, send them particulars, then are to delete some of the accounting on what we sent them (keep some files, delete contents of others, that are after some cut-off date), carrying on our accounting books only that which happened before their accounting transition implementation.

ie. AP & AR invoices from before the transition, that have not yet been paid off, remain on our books until paid off.

One of the smoldering fires is me to figure out how we were using the "to be deleted data", for purposes other than the accounting that another company ERP is now to handle.

For example, we have query/400 ... some of those probably exclusively for accounting we no longer need ... some of them might involve RAR but same results might be extractable from other files, such as "customer paying based on delivery ticket, not invoice, what invoice(s) associated with that delivery ticket #?"

405 CD does support some order types that
... $ bill customer but don't update inventory, and other combinations.
We want the RAR that comes from invoicing, because we need the ACR520 report with the invoices, to send the parent company, and to do some other analysis, THEN we need to delete the input to RAR.

For example, the other analysis includes identification of some problems in the data stream that did not get caught earlier, or did get noticed but not acted on.

This probably won't work for 405 cd. But. .

For 6.x you could use a sales history correction order type and then
this will NOT feed A/R but will keep sales history up to date. This
would get you out of deleting A/R.

In terms of deleting, 6.x does not have referential integrity for
anything we use. Seems like A/R is a deadend file. All of our reporting
comes from sales history.

Bottom line: I would not be uncomfortable with this solution - If I was
made to do it. If you have input, keep A/R on BPCS and buy a bolt on for
A/R. There are a ton of good ones and it "revitalizes" the BPCS A/R
system to the point where the users are convinced they have a shiny new
one!

Good luck.

-----Original Message-----
From: bpcs-l-bounces+ssegerstrom=intermatic.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+ssegerstrom=intermatic.com@xxxxxxxxxxxx] On
Behalf Of Al Mac Wheel
Sent: Sunday, August 10, 2008 10:04 AM
To: BPCS ERP Discussion List
Subject: [BPCS-L] RAR Downstream

We're 405 CD on V5R1 long gone off OSG.

We have BPCS tech support, but management not authorize call them unless

emergency. Instead I get string of challenges to figure out.

Latest: A/R to be handled by another system outside of BPCS to get its
info
from BPCS billing process, such as A/R invoice register, then invoice
input
to RAR file, after cut-off date, to be deleted. Invoices prior to
cut-off
date to be processed old way. SIL invoice file remain intact, since it
used in massive followup to support customer service inquiry, and price
increase analysis.

I can write program to mass delete RAR on invoices after cut-off date.
My
concern is unintended consequences downstream, so that I can have
alternative arrangements in place before they needed, instead of
end-fiscal
time discovering mountains of problems. Other than invoices awaiting
customer payments, and where we apply credit debit memos, where else
does
BPCS use RAR file data? I don't use XRF because in 405 CD its security
corrupts.

For example, do ACR230 customer ranking and SAL300 sales history get
info
from RCM customer master, which in turn from summarization of RAR?
Where
in shipping billing cycle are SSH SSD history totals populated with
latest
sales?

I desire to know what else will be zapped due to RAR mass deletions,
because it relies on RAR content, so we can evaluate which of that we
can
live without, and which needs some replacement system.
-
Al Macintyre
Never Knowing enough about BPCS


--
This is the BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.

Delivered-To: SSegerstrom@xxxxxxxxxxxxxx
--
This is the BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.

Delivered-To: macwheel99@xxxxxxxxxx



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.