Re: GL Inventory Balances <> Inventory Module Balances -- AFI

Mike,

If it's Inventory module transactions only that you're dealing with (not
Manufacturing transactions where MSP records are involved), AFI should work
perfectly in a rollforward situation.

In addition to some of the other suggestions, run a query over INP95 for
your company and for the time period involved to see which transaction
types are being generated.  Compare that to your AFI Journal conditions to
ensure you have mutual exclusivity.

If you're dealing with Manufacturing AFI's, there are many procedures to
which you must adhere in order to keep costs in sync from manufacturing to
inventory.  In that case, AFI

John Leopard, CPA
Manager, Business Consulting
Information Alternatives, Inc.
9850 Redhill Drive
Cincinnati, Ohio  45242
513.793.2929, ext. 305
513.936.4040 fax
jleopard@infoalt.com


                                                                                
 
                    "Mike Von Stein"                                            
 
                    <vonstein@wcoil.com        To:     
<jbausers-L@midrange.com> 
                    >                          cc:     (bcc: John               
 
                    Sent by:                   Leopard/CIN/IAI)                 
 
                    owner-jbausers-l@mi        Subject:     GL Inventory        
 
                    drange.com                 Balances <> Inventory Module     
 
                                               Balances -- AFI                  
 
                                                                                
 
                    10/20/00 08:31 PM                                           
 
                    Please respond to                                           
 
                    JBAUSERS-L                                                  
 
                                                                                
 
                                                                                
 





Has anyone experienced this problem before?

We have had a problem ever since go-live where the  inventory balances in
our General Ledger account do not match those in the  inventory module.
We went live on System 21 early this  summer.    We had an outside
consultant set up our AFI and,  so far, they have been *no* help in getting
this problem resolved.

Every day we have been running a report to check the balances  after AFI
has pulled.    We compare both the difference between  the two balances and
also the change in the difference from the previous  day.   Some days we
see fluctuations and other days not.    We have not been able to find any
pattern.  Also, most of the differences  seem to be in our Finished Goods
inventory.

I am wondering if in the Financial Modules there is a file  that
corresponds to INP96.   That way we could match each transaction  and see
what is missing/additional.  So far, we have not been able to find
anything like this.

Any feedback or ideas you could provide would be greatly  appreciated.

Thanks,
Mike Von Stein



+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---