Re: Facility wise Stock -- BPCS-L

On this list it is sometimes helpful to identify what version of BPCS youare on, since what is doable varies by version. For example, I am onversion 405 CD mixed mode 400 V5R1.

If you are only interested in one item in one facility as of end of fiscalmonth, then look it up in INV300 summary screen, before any newtransactions for the month, set the facility filter, and then print thescreen ... that is your report.

if you find out a few days after new month transactions entered that youneed to know what the on-hand was as of end month, then INV300 F21 andadjust the filters to reconstruct that.

If you look on the INV menus, there are already a mountain of reports thatcome with BPCS. I suggest you run one of each, then print a few pages, notthe whole thing. You may find that the report you need already exists.

We have constructed reports that we run at the time of end fiscal monththat have this data computed for every combination of facility item typeclass warehouse, on-hand, cost extended, so if a question comes up at oursite, we just look at the report that was generated during the relevant endfiscal.

The Opening Balance is what the on-hand was the end of the fiscal month, soif what you want is the closing balance for last month, just use openingbalance that is there now, and ignore issues receipts adjustments..

If I misunderstood your question, and what you are interested in is theon-hand right now, here's the formula:


   ON_HAND = opening bal + receipts - issues + adj
   ON_HAND - allocations = available inventory

You may need to include NON NETTABLE in your math.

For example, we have a warehouse for problem items that QC has to dealwith, and until they are resolved, the MRP is not allowed to assume theycan be consumed in production.

The issues in IIM ILI IWI ILN are the grand total of the ITH issues (notjust transaction type I ... check out the rules in file ITE) for thecurrent fiscal month, since the Opening Balance was recomputed. Similarlyreceipts and adjustments. For example, most of our issues are viatransaction type CI (components issued to factory orders thanks to laborreporting causing backflushing of multiple issues what was needed tomanufacture what we reported we made) also some RJ (what was consumed inthe process of reported scrap)


But for your site you need to
* See what rules are setup in ITE file (transaction effects)

* get counts of which of those are being used in ITH (there may be rules inITE that you are not using)

There are transactions that go into ITH that have no effect on inventoryon-hand, such as those that change $ values.

Every time there is a transaction in BPCS that the ITE rules say needs toaffect either Opening Balance (e.g. a transaction back dated into priormonth after the month got closed), Issues, receipts, or adjustments, thenBPCS adds detail record to ITH, and updates the running totals in IIM IWIILI ILN whatever's relevant to your implementation.

So if what you want is the grand total as of the end of a fiscal month, youhave no need to go into the individual detail ITH transactions. The answeris right there in the Opening Balance.

Now you had said you only want the total for a particular facility, not thecomplete corporate total.


The IWI file may be simpler to work with than the ILI file.
ILI is combination item-warehouse-location

IWI is combination item-warehouse inventory detail in which you need tolink to IWM to get the facility for that warehouse, for the purpose of onlyincluding the data on the facility you want.

If for some reason, not stated in your question, you do need to link ILIand ITH then it is inaccurate to link only on item. You also need to linkon warehouse and location. If you are netting ITH activity, you probablyneed to do some date range that agrees with your fiscal month, as spelledout in the General Ledger, which can be a pain to access for a number ofreasons ... the way the calendar is structured, and for security reasonssome people are locked out of General Ledger.

Any program or query that accesses ITH file needs to be run on JOBQ notinteractive, because ITH is probably one of your largest files ... ours has2 million records. Depending on how the software accesses that file,interactive access can be extremely disruptive to overall 400 performance.

Hi all, I am new to this mailing list. I have a query in my mind. Ineed to take a report about the closing balance of the Items belonging toparticular Facility. I checked with ILI file for the particular itemand can fetch the opening balance , reciepts, issues andadjusments. Here in the issues I need to cosolidate the total on thebasis of transaction type ( I type) , and adjustments (A type)and issues tp Production(J transaction) How can I achieve this? If Ilink ILI and ITH (based on Item) It is giving large number of datas and Iam not able to locate the Particular transaction. Can any one help meout in this? Thanks Muthu India