Thanks to all for your responses but I still have issues with this.

I am able to get the correct account string translated when I use an alias
for the Plant segment and then another alias keyed off of the Item Class
for the remainder of that string. When I run a standard order that is not
manufactured in multiple plants and is always credited to the
manufacturing plant regardless of which plant ships it, I get errors. We
ship products produced at various locations on one order from any of our
plants. Here is an example.

Present Process
Plant A manufacturers. Product is then shipped to Plant B to combine the
product with another shipment from Plant B. The order is entered against
Plant B. Based on the item class Plant A would still get credit for the
sale.

Intended Process:
Plant A manufactures part and ships it. Based on where the order shipped
that plant would get credit for the Sale.
Plant B manufactures the same part and ships it. Plant B would also get
credit based on where it shipped from.
We also need to have it still work for the "Present Process" mentioned
above.

I don't believe I can use an alias in an alias which would basically give
me the option of an "If"/"Then" type of setup which is what I'm really
hoping to accomplish some how. Either that or use the allocation process
to redistribute based on some criteria.

Due to the complexity of CEA I have responded with my phone number should
anyone which to continue this off forum.

Thanks,

Robert A. Brown
ISI, Inc
Ph 315-592-8136
email: rabrown@xxxxxxxxxxxx



message: 1
date: Tue, 24 Mar 2009 13:49:17 -0400
from: Robert A Brown <rabrown@xxxxxxxxxxxx>
subject: [BPCS-L] CEA Changes

We are on 6.04 and have setup our CEA to focus on the item class for
determining account segments. We are now considering running the same part

in multiple plants but this causes another issue in CEA. Since we can only

have one item class per part, is there a way to redirect the transaction
based on additional criteria? I was thinking of the Account rules but have

had little success. I have created new macros and aliases but it only
works correctly for that item that is produced in multiple plants. In our
original setup we are using ILCLASREVA in the plant segment, then the
alias directs to the appropriate segment values. In the setup below I have

created the macro ILWHS2 and ILCLAS2 that is looking at the warehouse of
the transaction and then places the appropriate Plant value based on the
warehouse, and then the item class that is then resolved to the correct
Oper, Acct, and Cls. Can I use an Account Rule in some manner to achieve
the same thing?

Here is our model setup:

Line Company Plant Oper Acct Cls Debit
Credit
20 =CI01CO =DTPEACIC 0000 10101 000 DTDSCIDRL
DTDSCICRL
30 =CI01CO =SCITYP 0000 10101 000 DTDSCIDRH
DTDSCICRH
60 =CI01CO 65 0000 21201 000 SITOTDR
SITOTCR
110 =CI01CO 65 0000 21320 000 RTXTXTCCO
RTXTXTDO
130 =CI01CO =ILWHS2 =ILCLAS2 CI01FC CI01FC
135 =CI01CO =ILWHS2 =ILCLAS2 ILREVDR ILREVCR
140 =CI01CO 65 0000 21320 000 RTXTXTCDR
RTXTXTCDO


Robert A. Brown
ISI, Inc
email: rabrown@xxxxxxxxxxxx


------------------------------

message: 2
date: Tue, 24 Mar 2009 14:25:06 -0500
from: "Al" <macwheel99@xxxxxxxxxx>
subject: Re: [BPCS-L] CEA Changes

We are on an earlier version of BPCS.

For us, it is not true that you can only have one item class per item. It
may seem that way if you are only looking at IIM item master file.
We can have a different item class per item per facility, using the CIC
file. However, we have largely abandoned that feature of BPCS, since some
areas involved more maintenance overhead than the benefits justified.

We have a different set of profit cost centers for each facility.

So for example, all activity with a part:

in warehouse 21 in facility 20 ends up in profit center 200 series;

in warehouse 51 in facility 50 ends up in profit center 500 series.

We have also developed some programs that show consolidated picture all
facilities.

We use item classes of 2 letters for the type of product.
We use item classes of 2 digits for the type of customer order activity,
such as reason for credit memo.

-
Al Mac


message: 3
date: Tue, 24 Mar 2009 20:36:16 +0100
from: Sajben@xxxxxxxxxxx
subject: Re: [BPCS-L] CEA Changes


Robert,

Account rules are not designed for this. They have role in validation
allowed segment values and possible account strings during journal entry
or
journal creation in subsystem posting. The approach you used and
described
in your mail is the right thing to do.

Klara




As an Amazon Associate we earn from qualifying purchases.

This thread ...


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.