Re: INVTXN question...

[LeLeux@xxxxxxxxxxxx]

   If you're in Califronia you should not be eating Albondigas from a can! 
   :)
    
    
   -----mapics-l-bounces@xxxxxxxxxxxx wrote: -----

     To: "MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx>
     From: "Lloyd Degnon" <ldegnon@xxxxxxxxx>
     Sent by: mapics-l-bounces@xxxxxxxxxxxx
     Date: 06/07/2007 09:14AM
     Subject: Re: [MAPICS-L] INVTXN question...

     Invtxn has all of that information.  You could create a query on that
     file for Transaction Type, Date, Item Charge Amount Offset amount, Unit
     and Nature for Charge, Unit and Nature for Offset, Unit and Nature for
     Variance.

     If you have questions call me at 408.360.4365.  I will help you for a
     can of your delicious Albondigas soup! (just kidding!) Feel free to
     call...

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

     -----Original Message-----
     From: mapics-l-bounces+ldegnon=ampro.com@xxxxxxxxxxxx
     [mailto:mapics-l-bounces+ldegnon=ampro.com@xxxxxxxxxxxx] On Behalf Of
     Olga Gunther
     Sent: Thursday, June 07, 2007 8:58 AM
     To: MAPICS ERP System Discussion
     Subject: Re: [MAPICS-L] INVTXN question...

     Lloyd, our standard cost in the Item Balance file is 0.
     This problem has been a thorn in my side for almost 4 months now...I
     can't believe that MAPICS does not have any option that allows inquiry
     on inventory transactions (IMHIST information) with the general ledger
     entry record that was created.
     I have been trying to do this manually but I have been working on it for
     5 days and I don't have the time to do it...

     Olga

     -----Original Message-----
     From: mapics-l-bounces@xxxxxxxxxxxx
     [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Lloyd Degnon
     Sent: Thursday, June 07, 2007 8:52 AM
     To: MAPICS ERP System Discussion
     Subject: Re: [MAPICS-L] INVTXN question...

     What is the Standard cost in the Item Balance File?  We just
     'Discovered' that the Cost in the Item Balance file is check first,
     then, if blank, uses unit cost default in the Item master File for the
     Transaction amount.  We had been trying to figure out where all of these
     'strange' amounts were coming from, then we discovered that we had
     hundreds of items with standard costs in the item balance file.

     -----Original Message-----
     From: mapics-l-bounces@xxxxxxxxxxxx
     [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Olga Gunther
     Sent: Thursday, June 07, 2007 8:42 AM
     To: MAPICS ERP System Discussion
     Subject: [MAPICS-L] INVTXN question...

     Hello!
     Does anyone know why the GLI interface file for IM transactions, INVTXN,
     does not capture the charge, offset & variance GL account numbers in the
     INVTXN record even though the amounts are there?
     Specifically, what I am looking for, is a way to reconcile and track
     inventory transactions with the ledger entries. Our accounting staff
     spends days trying to reconcile the inventory with the general ledger
     and always come up short on the inventory side. Any ideas?

     Sincerely,
     Olga Gunther
     AS 400 Ops - Programmer/Mgr
     Juanita's Foods
     Wilmington, CA

     _______________________________________________
     This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post
     a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
     change list options,
     visit: http://lists.midrange.com/mailman/listinfo/mapics-l
     or email: MAPICS-L-request@xxxxxxxxxxxx
     Before posting, please take a moment to review the archives at
     http://archive.midrange.com/mapics-l.

     _______________________________________________
     This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post
     a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
     change list options,
     visit: http://lists.midrange.com/mailman/listinfo/mapics-l
     or email: MAPICS-L-request@xxxxxxxxxxxx
     Before posting, please take a moment to review the archives at
     http://archive.midrange.com/mapics-l.

     _______________________________________________
     This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post
     a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
     change list options,
     visit: http://lists.midrange.com/mailman/listinfo/mapics-l
     or email: MAPICS-L-request@xxxxxxxxxxxx
     Before posting, please take a moment to review the archives at
     http://archive.midrange.com/mapics-l.

     _______________________________________________
     This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
     To post a message email: MAPICS-L@xxxxxxxxxxxx
     To subscribe, unsubscribe, or change list options,
     visit: http://lists.midrange.com/mailman/listinfo/mapics-l
     or email: MAPICS-L-request@xxxxxxxxxxxx
     Before posting, please take a moment to review the archives
     at http://archive.midrange.com/mapics-l.