Re: Looking for Comments files

Interpreting the contents of this file can be a royal pain.

Suppose you have notes on an order, and the order gets closed.
You would think the notes should go away with the order, but BPCS is a little buggy.
You can have notes on orders, etc. that are long gone from the system.
You can have inventory history on items that have been deleted.

So you can be looking at the control #s of notes & you can't figure out what they are referring to, because they are for RMA or something that don't exist any more.

To fix this kind of thing, you can write your own programs to clean out BPCS of these various kinds of remnants, or get Locksmith from UPI which has already got it figured out, what all those areas are that may need some occasional clean up.

When you are in orders, or the various other places, there is a command key to get to the order notes. There is a letter code to designate what kind of order note it is.

There's a field that contains the customer # if it is a note on the customer.
The same identical field contains the order # if it is a note on an order.
The code letter for type of note ... that tells BPCS to interpet the contents of field as being order, or customer.
Since the field has this dual purpose, figuring out what is in there can be confusing, since BPCS labels the field with one purpose & populates it with another.

Your starting point for analysis should be
* what are all those codes for types of notes
* which do we have & how do the patterns of population vary with the types of codes

This is like inventory history ... depending on the type of transaction, different fields are populated, and the data in there is not consistent with data on other kinds of transactions.

Okay, Found the ESN but for the life of me I can't see how a comment entered
for a specific order or for a specific line item can be located in the file
- there isn't any indicative information for order and/or line item number.

What am I missing.

Roy Luce
Systems Plus - Midwest

Direct: 847-540-9635
800-913-PLUS (7587)
Cell: 847-910-0884
Email: rluce@xxxxxxxxxxxxxxxxxxx

-----Original Message-----
From: bpcs-l-bounces+lwl=ix.netcom.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+lwl=ix.netcom.com@xxxxxxxxxxxx] On Behalf Of Dan
Sweeney
Sent: Monday, March 17, 2008 4:09 PM
To: 'BPCS ERP System'
Subject: Re: [BPCS-L] Looking for Comments files

The primary notes (comments) file is the ESN file.

Within it are notes for customer's, vendor's, purchase order header and
detail lines and sales order header and detail.


-----Original Message-----
From: bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx] On Behalf Of
lwl
Sent: Monday, March 17, 2008 4:57 PM
To: bpcs-l@xxxxxxxxxxxx
Subject: [BPCS-L] Looking for Comments files

Can anyone identify the files used to for sales order header comments?
Sales order line comments?



TIA



Roy Luce

Systems Plus - Midwest



Direct: 847-540-9635

800-913-PLUS (7587)

Cell: 847-910-0884

Email: rluce@xxxxxxxxxxxxxxxxxxx



--
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: dsweeney@xxxxxxxxxxxxxxxx


--
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: lwl@xxxxxxxxxxxxx

--
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