Re: Struggling with a report definition

Lloyd,

Are you capturing the charge detail in IFM? In the transaction inquiry,
does it include the item details? If so, you could use the UARNCPP file.

If not, I believe the YAARREP file has the order number in the narrative
which you may be able to extract to look up the order info and IMHIST
records. Are you passing only total dollars to IFM?

In IWP, you can build Key macros to extract the order type and order number
from the narrative, and convert the order type (CO/CM) to use as the key
value (1/4) to the COM or IMHIST files. Takes a little RPG knowledge, I can
provide the details if you are interested.

Regards,
-Greg



-----Original Message-----
From: Richard McCracken [mailto:RMcCracken@xxxxxxxxxxxxxxxxxxxxxxxxxx]
Sent: Wednesday, August 01, 2007 9:08 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] Struggling with a report definition

If your UAQNCPP does not have SA records, technically, they are probably
turned off in the Inventory Management General Ledger Interface. From a
practical standpoint, you must be using the Cost transactions (all those
starting with a "C" in the COM GLI transaction types) to debit Cost Of Sales
and credit your inventory. The "C" transactions (CILI, etc.) go directly
into IFM without any detail in UAQNCPP.

If you want the SA detail, they need to be turned on in the IM GLI.
This means using both SA's and the "C" transactions. The proper accounting
would be for the SA's to debit a balance sheet clearing account with a name
such as "Shipped, Not Invoiced" and credit Inventory. The "C" 's should
debit Cost of Sales and credit the Shipped, Not Invoiced account. The
account shipped, not Invoiced will have a balance only between the shipment
and invoicing. This is proper accounting, since there technically is a time
difference between the shipment and the invoicing in COM. This would also
help identify if there is any shipment that has not been invoiced in COM.

Rich McCracken
LeTourneau Technologies, Inc.

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Lloyd Degnon
Sent: Tuesday, July 31, 2007 5:17 PM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] Struggling with a report definition

Yes, my UAQNCPP does not have SA info in it...Any ideas on how to get this
data?

Thanks for responding...

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Richard McCracken
Sent: Tuesday, July 31, 2007 3:12 PM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] Struggling with a report definition

If you are posting SA transactions to the General Ledger through IM, the
same logic applies. The detail will be in UAQNCPP.
This concept applies if you are posting SA's to reduce inventory, with the
credit going to a clearing account such as Shipped, Not Invoiced.
The Cost "C" type transactions from COM would post debits to Cost of Sales
and a credit to Shipped, Not Invoiced. If you only post the COM
transactions for Cost of Sales, you may not have the SA detail in the G/L
that you described.

Rich McCracken
LeTourneau Technologies, Inc.

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Lloyd Degnon
Sent: Tuesday, July 31, 2007 4:36 PM
To: MAPICS ERP System Discussion
Subject: [MAPICS-L] Struggling with a report definition

All of you out there helped me with a report definition last week, I am
hoping that you can do it again for me...

I linked YAARREP to UAQNCPP using Transaction ID, then UAQNCPP to IMHIST
using Item, Warehouse, Update and Time, and Token.

Works great! Now I am trying to do something similar for SA Transactions so
that I can show Period Date, Item Number, Unit, Nature, Quantity, and Dollar
Amount. Any Ideas?

Could I do this in FRx, Query, IWP?

Thanks for your help...


Lloyd H. Degnon
I.S. Manager
Ampro Computers, Inc.
5215 Hellyer Ave. Bldg 110
San Jose, CA 95138
408.360.4365
www.ampro.com