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

Inventory "Only" will NOT work perfectly due to unrecorded changes in Raw
Material costs.  AFI does not reflect these issues.  

Also, be advised that your Unmatched (AFI Inventory Accrual) Inventory
account will also be adversely impacted by a standard change ($-IN $-OUT).
Finally, your PPV report 51/PMR AND Accrual Report 82/PMR will also change.
  


-----Original Message-----
From: John Leopard [mailto:jleopard@infoalt.com]
Sent: Monday, October 23, 2000 11:00 AM
To: JBAUSERS-L@midrange.com
Subject: 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.
+---
+---
| 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.
+---