Re: Sales order type -- BPCS-L

I have several suggestions and ideas in here.

Look at sales person number ... instead of having ONE # per person, like
100 Tom
200 Richard
300 Harriet
500 Wayne
etc.

consider
100 Tom Miscelaneous (default) sales
101 Tom sales of product type 1
102 Tom sales of product type 2
etc.
with same kinds of # for others
302 Harriet sales of product type 2

so at time of order entry you enter for sales person #
the base person with the last digit being the product type

Sales Person # is 6 digits so you can use more consecutive digits to applythis principle. Warning, this will impact your sales history files whichbreaks up the data by sales person # used.

There is a place in BPCS customer orders to have the General Ledger ProfitCenter. In our case it is tied to the facility ship from warehouse, whichmeans we cannot have orders that ship from more than one facility and havethe GL come out right. Your accounting setup might be different from ours,such that it would be valid to have different general ledger cost centersavailable for the people who key in the customer orders to assign whicheverat order creation time.

Note that in BPCS there is a place to assign reason codes ... you can havemore than one reason code for various actions

* WHY was this scrapped?
* What kind of special adjustment is this?
* Why are we substituting this other component?
* For what reason was this material returned from the customer?
Then you end up with some report showing total activity by reason code.

We find the notes more useful, that spell out explanations ... we can lookat notes on multiple incidents to see if there are recurring patterns.

We are on BPCS version 405 CD ... it may be that what you can do on yourversion is different from us. We recently used Customer Order Type for amodification. You might be able to utilize what we did, for some otherpurpose. You might want to use Customer Order Type to designate variouskinds of product lines.


Our situation ...
* we have more than one sales person handling contact with customers

* we have customer service personnel (customer order maintenance) who eachhandle a cluster of customers* we have production control people (shop order management) who handle thework consequences of different clusters of customers

* we have assembly inspectors who specialize in sub-groups of the customers
* we have engineers who specialize in different groups of customers

All these people are looking at reports that list ALL our customerbusiness, all orders for next few weeks, all shipments history, etc. Wewanted to split those reports to only show data relevant to the variouspeople, and be able to move customers assignments between people as newcustomers came in, and the volume shifted.

So we used Customer Type, which is a field in customer master RCM accessedby ACR100, not used by our version of BPCS, there as a reference code forour use. Customer Types have to be setup in ACR170. This gets copied tovarious other files during life of customer orders, but you not want to gothere, if we going to be changing the codes, or accessing business prior toinstituting this.


In Query you can use RCM.CTYPE LIKE '%W%'

this means include if the letter "W" (for Wayne) is ANYWHERE within thecustomer type ... we not care what letters in front of or after the letter W

In RPG you can use SCAN op code to scan a field for having some characterwithin ... you can also get where it is sideways but I not care about thatin this scenario


Customer Type is only 4 characters wide, but that is all we needed.

It now has a cluster of letters to show the people involved in managingthis customer's business through our company.

Instead of people getting humongous reports listing all of a type ofactivity, or having to key into Query a long chain of customer #s thatneeds to be tweaked periodically, now they just have LIKE their letter andit gets them the data on their customers.


-
Al Macintyre  http://www.ryze.com/go/Al9Mac

Find BPCS Documentation Suppliershttp://radio.weblogs.com/0107846/stories/2002/11/08/bpcsDocSources.html

BPCS/400 Computer Janitor at http://www.globalwiretechnologies.com/

Replacement company web site (same company, newdomain) http://www.globalwti.com/Part time may get commission from some BPCS vendors for helping them ... Iwill now say in a post if the product I commenting on is also onepotentially involved with this ... not that I have made anything from this yet.