Re: Production Receipts

[Tom Jedrzejewicz <tomjedrz@xxxxxxxxx>]

On Mon, 06 Sep 2004 11:46:36 -0500, Alister Wm Macintyre
<macwheel99@xxxxxxxxxxx> 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 suspect that this is what happened.  I gather that your on-hand
quantities are correct.  You can also test this manually; post a
transaction and see what changes.

This is a side effect of the monthend problem.  I believe that the
inventory posting program compares the ZPA date with the transation
date.  If the transaction date is earlier than the post date, the
opening balance will be updated instead of the
issues/receipts/adjustment field.

If you can do RPG, a program to fix this is not difficult.  Read the
relevant ILI and

If not, then your options are more limited.  You need to get the
lowest level file correct; this is ILI unless you use pallets or
containers.  Then INV972 (the reset pgm) will roll it up for you.  One
thought:
- find in ILI from just before or just after monthend.
- use SQL or query to calc this month opening balance  for each lot
- use SQL or query to summarize issues, receipts, adjs for each lot in
this month
- use SQL to update ILI fields from those summaries.

Worst case . . . 
1. Manually reverse last weeks transactions
2. Fix the date in ZPA
3. Manually re-enter last weeks transactions

DO NOT FIX THE ZPA POST DATE UNTIL YOU KNOW HOW TO CORRECT THE DATA..

-- 
Tom Jedrzejewicz
tomjedrz@xxxxxxxxx