Opening Balances & Late Labor Tickets

from Al Macintyre 405 CD on 400 mixed mode

this is not a question but an observation - something we recently discovered 
- perhaps other BPCS users were not aware of this - perhaps there are other 
implications we still need to learn.

We found that during the month the Opening Balance fluctuates in ILI & IWI 
file.

Previously we had believed that the Opening Balance was cast in concrete as 
of the end of fiscal month, representing the aggregate On Hand from end of 
month, sometimes updated by Physical Inventory.

Initially I had suspected reorg ... if we have IIM IWI out of sync with ILI 
at time of EOM then do a reorg later, that might explain delayed correction 
of Opening Balance.

We found that what causes this is, if a labor ticket that should have been 
posted in last fiscal month, gets posted in this fiscal month via JIT600 
labor & inventory, using the date of when the labor was actually done, that 
there is a system assumption that this data does not belong in the issues / 
receipts of the current month, but is added to the Opening Balance of last 
month.

I looked through a lot of documentation but did not see this spelled out any 
place.

Most of our Opening Balance disruption was because during the last end month 
fiscal, one factory worked that Saturday, then the labor tickets were keyed 
in on Monday, using the Saturday date as when the work was done, but in the 
mean time the fiscal month end had been done.

On discussing the implications of this, I was pointed out that we had had a 
continuing problem with General Ledger batches being discovered unposted from 
fiscal months that were closed.  I now suspect that when Accounting thinks we 
are done with a month, they close it, and no one is telling them that there 
are labor tickets trickling in with prior month dates.  We have not had a 
factory working Saturday for a while, so Accounting probably oblivious to the 
implications of one working the Saturday of Fiscal month end.

We also have a lot of people who run labor efficiency & scrap percentage & 
other reports off FLT & ITH labor & inventory history based on date range of 
last week, who will be missing the transactions that arrived late.

Previously we had a corporate rule ... try to get labor tickets posted 
promptly, but if any delayed going in for any reason, date transactions into 
the computer on the actual date the transaction really occurred.

Due to this discovery, we have changed the rule ...  try to get labor tickets 
posted promptly, but if any delayed going in for any reason, date 
transactions into the computer on the date the transaction are being keyed 
in.  Use today date regardless.

MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)
AS/400 Data Manager & Programmer for BPCS 405 CD Rel-02 mixed mode (twinax 
interactive & batch) @ http://www.cen-elec.com Central Industries of 
Indiana--->Quality manufacturer of wire harnesses and electrical 
sub-assemblies - fax # 812-424-6838

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---