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

100 Tom Miscelaneous (default) sales
101 Tom sales of product type 1
102 Tom sales of product type 2
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 apply this principle. Warning, this will impact your sales history files which breaks up the data by sales person # used.

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

Note that in BPCS there is a place to assign reason codes ... you can have more 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 look at 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 your version is different from us. We recently used Customer Order Type for a modification. You might be able to utilize what we did, for some other purpose. You might want to use Customer Order Type to designate various kinds 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 each handle a cluster of customers * we have production control people (shop order management) who handle the work 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 customer business, all orders for next few weeks, all shipments history, etc. We wanted to split those reports to only show data relevant to the various people, and be able to move customers assignments between people as new customers came in, and the volume shifted.

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

In Query you can use RCM.CTYPE LIKE '%W%'
this means include if the letter "W" (for Wayne) is ANYWHERE within the customer 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 character within ... you can also get where it is sideways but I not care about that in 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 managing this customer's business through our company.

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

Al Macintyre  http://www.ryze.com/go/Al9Mac
Find BPCS Documentation Suppliers http://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, new domain) http://www.globalwti.com/ Part time may get commission from some BPCS vendors for helping them ... I will now say in a post if the product I commenting on is also one potentially involved with this ... not that I have made anything from this yet.

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.