Re: 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