Re: Checking GUI CEA

[TRMiller@xxxxxxxxxxxx]

In order of the questions:

1. In GUI CEA, how do I find what account numbers a  transaction should
hit?
   You will need to trace the transaction type (ITH field TTYPE) and reason
   code (TRES) used in the receipt transactions back through the
   subsystem/event/model/alias setup in CEA:
     In Subsystem Processes (the chain icon), open program INV920.  There
     should be a list of reasons associated with events; the reasons are
     the combined TTYPE and TRES fields.  For example, our PO receipts use
     the 'U 01' reason which is associated with the event 'PO RECEIPT'
     In Events (the camera icon), open the event that your specified reason
     is associated with.  The model associated with the event will be
     shown.  Following the example for our organization, the model is 'PO
     RECPT2'
     In Models (the Tinkertoy icon), open the model that your event is
     associated with.  The model will show the journal entry lines which
     will hit the ledger when the transaction is posted.  You will either
     have hard-coded account numbers to which the entry will post, or
     macros which may reference aliases.  If macros, you will need to check
     the detail behind the line to ensure that aliases are in use.  Put the
     cursor on the cell with the macro in it and click on Builder; if the
     Advanced box is checked, then the macro is pulling the account
     information from an alias.  If not, it is pulling from the macro
     set-up.  In our model, we have hard-coded the ACCNT segment to a
     liability account for the credit entry, and have a macro in place for
     the same segment on the debit side.  The macro is IP01TCINV, and the
     Advanced box is checked.
     If the Advanced box is not checked, go to Macros (the cogs/wheels
     icon) and open the macro noted from your model.  The Source will show
     the file and field the macro pulls from to populate that segment of
     the account string.
     If the Advanced box is checked, do the above, noting the file and
     field, and then go to Aliases (the mask icon) to View all aliases for
     that particular macro.  Select any of the aliases and open it to see
     the resolution of the accounting code.  In our case, the macro
     IP01TCINV goes to file ZIP01M (ATP Inventory Processing) and looks at
     field IP01TC (Item Type Code), and then resolves the account segment
     by looking at the alias which matches the item type for the
     transaction.  We therefore have aliases for each item type, with the
     desired account code entered in the alias details.

2. What files/fields in GUI CEA do I check?
   Not sure what exactly you're asking for here, but I'll answer by saying
   that you can get at most of the above info by querying the files
   involved if you prefer querying:  GED (Event Determination), GAM
   (Available Macros), GAH (Aliases), and so on.

3. Typical example problem: 5 PO receipts were done  today. I can use ITH
to calculate what value should hit the GL. Where do I go in  GUI CEA to see
that value hitting the GL??
   If you have determined what accounts a PO receipt transaction affects,
   using Account Inquiry (the open book with magnifying glass icon) is
   often the simplest way to get at the GL information.  I have a
   step-by-step process for how to do this, but it's kind of long & I've
   gone on quite a bit already.  I can send it separately if you have
   problems creating an Inquiry.



From: "Artprc1" <artprc1@home.com>@midrange.com on 05/11/2001 09:17 AM AST

Please respond to BPCS-L@midrange.com

Sent by:  owner-bpcs-l@midrange.com


To:   <bpcs-l@midrange.com>
cc:
Subject:  Checking GUI CEA


Hello all, hoping for some advice:

We're on 6.04 with GUI CEA.

Our accountants want to verify that the  transactions hitting the ITH file
tie with what is hitting the GUI GL. I have  experience with the old BPCS
(2.1), where you check GJW, but on the green screen  side there's no more
GJW.

1. In GUI CEA, how do I find what account numbers a  transaction should
hit?

2. What files/fields in GUI CEA do I check?

3. Typical example problem: 5 PO receipts were done  today. I can use ITH
to calculate what value should hit the GL. Where do I go in  GUI CEA to see
that value hitting the GL??

Thanks in advance,
Art Price
Programmer/Analyst
B.C. Grommins, Inc.








+---
| 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
+---