I mistyped that ... I meant to write:

(a) BPCS documentation in file BPCSDOC member SSALOG00 (the logic manual)
which will give you the naming conventions of all the files

Most vanilla objects in BPCSDOC start with SSA prefix
Then RUN for the run manuals (one each application) then 2 digits unique
There is only one logic manual so it ends in zero zero

On command line key DSPFFD IIM to see layout of item master file, which
includes field ILDTE = date of last transaction of ANY kind, where the ITE
business rules say to update that field for that kind, and where some
software violates the business rules.

In other words, some types of transactions may be setup to be invisible to

Before changing any BPCS business rules, I suggest carefully reading the
documentation for implications, getting full consensus approval, and
documenting for your auditors what got changed when why.

Depending on how you define "transaction" there may be activity on your
system not found in the ITH Inventory History file. For example, not all
labor history FLT transactions generate a corresponding ITH inventory
history transaction, such as steps before final PR which do not consume any
CI or generate RJ. The date when a customer (or other kind of) order got
changed or entered, will not show up in last transaction date of files we
been discussing.

I suggest you create a query to get you a count of how many of each kind of
ITH transaction used on your system. Then look up ITE transaction effects
for what that is about. Date of last transaction can be in the minds of the
beholder, where many people are only interested in last sale, or last use in
production, not last transfer.

I suggest you dump ITE file to see which transaction types are currently
setup to update last transaction date on items. If you go into transaction
effect inquiry, select a transaction (near beginning or end of list is
best), glue your eyes to a particular area, then you can scroll through to
see which transactions are yes or no.

While the date shows up on our screens as MM/DD/YY because that is how we
have setup our system parameters (in file ZPA with lots of other stuff), the
data in the BPCS files is in the format CCYYMMDD or 20101020 today.

Thanks to some unfixed Y2K bug(s) in our version of BPCS, some dates which
should read 20101020 in fact read 101020.
Al Mac

-----Original Message-----
[] On Behalf Of Al
Sent: Wednesday, October 20, 2010 11:53 AM
To: 'BPCS ERP System'
Subject: Re: [BPCS-L] Last transaction date per item info - which file

I suggest you familiarize yourself with
(a) BPCS documentation in file BPCSDOC member BPCSLOG00 (the logic manual)
///////// SSALOG00
which will give you the naming conventions of all the files
(b) IBM OS command DSPFFD which will give you full layout of fields in all
BPCS files. Start with IIM item master.
(c) What modifications you have which update BPCS files, which might not
adhere to BPCS standards.
(d) Does your company maintain any kind of archives for older data?
(e) informing people in BPCS-L, when you post questions, what version you
are on, since not everything identical in all versions ... for example, I am
on BPCS version 405 CD (beyond release 02) on IBM OS V5R1 on an actual
AS/400 (inaccurate to call it an Iseries since it was manufactured before
that invented)

It varies with the file, and with your system parameters. Many files do NOT
have a date of last transaction. Some have one, but it is unreliable and

For example, we tried to turn off the physical inventory flags in ITE so
that they would NOT update last date of inventory change. We wanted to be
able to list items on-hand whose last date of inventory activity was before
the latest physical. We found a bug in BPCS. Physical inventory software
disregards the tailoring in ITE business rules.

We have had periodic debate what types of transactions ought to count as
relevant to last activity. For example, should a cycle count correction
update the last transaction date, or should we only have that happen for
item used in production, received or shipped? Different people interested
in different things, so some of our custom programs look for last date of
ITH transactions of particular types, and for aggregate activity in a date

Some query users need to be reminded that if they try a date range that is
older than the date range within ITH data content, they will find nothing,
but that will not be an accurate result.

Some of the sales analysis files have last transaction date for combination
of sales person, customer, item, facility, so we have to do combination
analysis to find most recent (highest) date for a particular item. Also, we
use a letter combination in sales person field to represent the customer
service person, engineer, QC etc. team in charge for that customer, which
periodically gets reshuffled. This is in support of various programs and
query which say to only include activity where the sales person field has a
particular letter embedded. Thus this loses activity on a customer or item
in a time frame when it was not assigned to that person. Take a look at SSD
and SSH files through the lens of DSPFFD.

There is a date of last transaction in the inventory records, but we
habitually remove IWI and ILI records when they go to zero activity, so any
date in there is only for still active items.

Several files have date of last update, which is updated by the vanilla BPCS
programs, but when we have custom updates, sometimes those programs to not
honor all the same fields as vanilla BPCS.

Suppose an item is a brand new item, just entered to the system, it might
not yet have any transaction date.

How long you keep transaction file data is a factor. Suppose you keep
invoices for one year, and the last invoice date is older than the last
actual shipment in the SIL invoice line item data?

Al Mac

-----Original Message-----
[] On Behalf Of
Sent: Wednesday, October 20, 2010 7:36 AM
To: bpcs-l@xxxxxxxxxxxx
Subject: [BPCS-L] Last transaction date per item info - which file and

For a certain file I have to find the last transaction date for a list of
Which field in which file should I use in a query to find this information?

Thank you very much!


David Antonisse
The NetherlandsPlease consider the environment before printing this e-mail.
----------------------------------------- Discover Impress on The information contained in this e-mail and any
attachments is strictly confidential and may be legally privileged.It is
intended solely for the use of the individual or entity to whom it is
addressed. If you are not the named addressee, you are hereby notified that
it is prohibited and may be unlawful to disclose, distribute, store, copy
the information in any medium or usage for another purpose.

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-2021 by 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.