Re: Production Receipts -- BPCS-L

Thanks for something else for us to explore. However (a) Because of past history of JIT600 posting problems, we list the contents of file FLT member WORK every nite to see if there are any unposted batches, and there are none at present. (B) I ran a report that lists totals of opening balances by facility warehouse item type item class and determined that there has been a significant change there Grand Total Opening Balance for the month since End Month has gone down by 2 million quantity out of 30 million This reduction is fairly evenly divided over 3/4 of our facilities I now know it is not just Production Receipts but other kinds of transactions that are having problems

I found the JIT600 transactions in FLT (labor tickets posted) and ITH (inventory history posted) but the IIM IWI ILI just have opening balance ... all zero in receipts, issues, etc. other transaction fields for the month,

A long time ago we discovered that if transactions are posted using a date prior to that of the current fiscal, that BPCS posts the transactions as if they had gone in in that prior fiscal ... and it looks like that is what is happening for the first week of September, except that the dates keyed are correct, our GL Fiscal is correct

Hmm ... perhaps I shall check the other BPCS Calendars next

you wrote:

Go to JIT600 and check if there is a "P" in the Status
column.

If there is not, means the tickets were not posted and
that is the problem.

To post them, since they might have been entered at
different terminals, enter action "9" in the Act
column, hit <Enter> and follow the instructions.

Regards,

Ruben.

--- Alister Wm Macintyre wrote:

> We are on BPCS version 405 CD which has been
> modified.
> We operate by facility.
>
> There is a report I run, end each week that shows
> total Production Receipts
> for the month so far for a particular item class
> times a particular cost
> bucket.  I thought it peculiar this EOW that there
> were zero hits, but my
> priority was getting the Inventory History problem
> wrapped up.  But now
> that is resolved (ITH/IIM fixed ... nothing yet done
> with EOM software), I
> looked into this other thing.
>
> I find that we have been reporting lots of PR
> transactions via JIT600 for
> the first week of September since EOM but all the
> files that track Receipts
> are zero for the month so far.
> IIM.IRCT IWI.WRCT ILI.LRCT are all zero
>
> Thus this is both by facility and global.
>
> This is most peculiar and seriously wrong.
>
> I have checked INV355 to make sure PR is still to
> affect receipts.
> I will be checking all transactions there that
> affect receipts to see if we
> have had any negative activity.
>
> I will be checking to see if shop orders were
> correctly updated for the PR
> transactions posted for month so far.
>
> There were some reports we ran at EOM that showed
> total inventory based on
> Opening Balance for the Month ... I plan to run them
> again, and compare, to
> see if Opening Balance for the Month has changed
> significantly, which is
> what we would expect to happen if BPCS posted
> activity but thought it
> applied to a prior historical fiscal period.
>
> I checked GL fiscal period date range correct ...
> last week was in September.
> I checked dates of PR transactions to verify they
> were posted with valid
> last week dates.
>
> I will be checking IWM to make sure the warehouses
> are still in the right
> facilities.
>
> I have not touched the software that updates the
> inventory in eons, and I
> will be checking the external dates on our software
> to make sure no one
> else has either.
>
> What else makes sense to check?
>
> -
> Al Macintyre  http://www.ryze.com/go/Al9Mac

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