× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Thanks for this.

From what I gathered, ITE.TEGLW and ITE.GLW, although present in the ITE
file definition are no longer being used in BPCS v6.1.02. For one thing, post to GL flags are no longer maintainable from the Inventory Transaction Maintenanece program (INV150D1) like in BPCS 405 CD.

We are looking at receiving direct to stock instead if we do not get this to work. We may have to modify some procedures, however. Receiving Direct To Stock has financial and costing implications that we have to deal with and come up with workarounds and won't be as clean if we get the N and P transactions to work as designed.

BG

date: Wed, 07 Jul 2004 04:04:39 -0500
from: Alister Wm Macintyre <macwheel99@xxxxxxxxxxx>
subject: RE: P (Receipt from Inspection to Stock) Transaction not
        posting to GL

BG

We are on BPCS 405 CD Mixed Mode so some of our stuff might not be
applicable to your reality.

Here is a BPCS "gotcha."
A lot of stuff comes out of the box when you get BPCS without all the
settings the company might need, so there is a process of setting up your
business rules, so that they work right for you.  Then a few years go by,
and there are a different set of employees than those associated with the
original setup, and the business needs have evolved, and you need to start
using some transaction effect, or tailoring setting, or program, that the
company had not previously needed to use, and it is neccessary to review
the instructions for setting up aspects of BPCS for the first time, and
where are those instructions???  How many people even know about this?
For example, we had a flow chart for the sequence to populate files, but I
have no idea where that got to.

The rules for ITH are carried in file ITE whose contents can be reviewed
via INV355 on INV menu SSAI01 ... select the first transaction effect and
note the bottom of the screen where it has the rules for GL for this
transaction.  Glue your eyeballs to that part of the screen.  Now do a
rapid scroll through all the different transaction effects to see that many
transactions get posted to GL and many do not.  You might want to create
your own report (we use query/400) charting which transaction effects are
which way with respect to the kinds of activity that currently interests
you, such as
    * ITE.TEGLP = Post to GL?
    * ITE.TPO = must use a valid PO#
    * ITE.TASC = Affect Standard Cost
    * ITE.TACST = Affect Actual Cost
    * ITE.TAPC = Affect Purchase Order Cost

These rules are not cast in concrete ... you can change them, but first you
need to review the instructions, and I suggest that if you going to change
rules, you do it at the beginning of a fiscal month, so you have some hope
of tracking the impact of the changes.

See if you can find the FILE = BPCSDOC
This is like a source code file in which there are many members, each being
a BPCS "manual" poorly indexed and a pain to data mine / search.
Find member SSARUN03 = Inventory Management Run Instructions
Search for INV150 which is the program used to change the ITE file.
After an explanation of each field of ITE is collection of illustrations of
settings out of the box.

The front door to this is menu DOC which is a subset of SYS security.
The back door to this is PDM or SEU.
Be careful if you use the back door to add additional documents - you need
to use the front door to redo the index of all the documents.

You need to read the accompanying explanations.
What we get are SAMPLES in which during BPCS setup at your company, you
supposed to populate them ... well we not using P or N so we not populated
ours different than what came out of the box, and looks like you in the
same boat.
You have to figure out WHERE you want P and N transactions to end up in your GL
then populate the rules for P and N transactions accordingly
including setting the flag so that they will go from ITH to GL via INV920


We receive inventory directly into stock.
We have contracts with most of our vendors in which if they send us any
defective parts, they are in big trouble.  It is the nature of our business
that this is also true for us with most of our customers.
We have one outside vendor in which we need to inspect 100% of what comes
from that vendor.
During production inspection points, if some parts are identified as
quality suspicious, they go to location RA01 (Rejects Area) for QC to
decide if they are repairable or have to be scrapped.
RMAs (customer returns) are also received there, until QC decides what to
do about them.
Location RA01 is non-nettable non-allocatable etc. ... on-hand not
available until QC releases it into general inventory.

We also have a query/400 that gives us a count of how many of which
transaction effect got used each month ... this identifies odd ball stuff
that perhaps not supposed to be happening.

-
Al Macintyre  http://www.ryze.com/go/Al9Mac
Find BPCS Documentation Suppliers
http://radio.weblogs.com/0107846/stories/2002/11/08/bpcsDocSources.html
BPCS/400 Computer Janitor at http://www.globalwiretechnologies.com/

Kusman Lim wrote:
>Beegee;
>
>You may check the subsystem event determination in the Inventory
>Processing then find the P reason code. Does it by pass journal entry ?
>
>
>Does the Period in CEA have open for all event ?
>
>Does the Event has defined ?
>
>Please check the Allow posting on Error.
>
>Good luck.
>
>Regards
>
>Kusman Lim
>PT Takeda Indonesia
>
>
>-----Original Message-----
>From: Beegee Galang
>To: BPCS-L@xxxxxxxxxxxx
>Subject: P (Receipt from Inspection to Stock) Transactoin not posting to
>GL
>
>Hi All:
>
>Environment: BPCS v6.1.02 (Full C/S) on AS/400
>
>We are planning on using the N and P transaction for our receipt
>inspection process.  The problem we are having is that the P transaction
>does not get posted to the GL.  The reason for this is that the ITH
>record created for P transaction has ITH.TSTAT defaulted to 'Y'.  So
>when we run the Inventory Post to GL (INV920) Program, the P records are
>bypassed because of this flag and as a result, they do not get posted to
>the GL.
>
>Has anyone run into this issue?  Any ideas on how to make this work?
>
>Thank you very much in advance for your help.
>
>BG

_________________________________________________________________
MSN Life Events gives you the tips and tools to handle the turning points in your life. http://lifeevents.msn.com



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-2024 by midrange.com 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.