We are in the Go-Live phase of implementing MS Dynamics GP 10.0 with the manufacturing module and are facing the following problem:
The problem is in the Financial Activity that is generated by teh system itself during the manufacturing process.
Once the MO is released and the material issued (component trx entry) the following Financial activity is generated by the system:
Raw material inventory is debited, and Work in process is credited
(The amounts for this entry are correctly being calculated by the system in 100% of the MOs created)
At the time of the MO receipt however the financial activity which takes place contains erroneous and random amounts
The following financial activity is generated by the system whe Finishd Good is received (MO Receipt)
Work in process is credited, Finished Goods inventory is debited, and Rounding difference account is either debited or credited depending on the balance of the above two amounts.
What is happening in this transaction is that the amount being debited to the finished goods inventory is correct. But the the amount being credited to the work in process account is incorrect and unfamiliar, mostly two or three time higher than the actual amount. As a result the difference is put into the Rounding difference account.
This has resulted in a huge debit balance in our rounding difference account and the same (erroneous) amount has been credited to our Work in process account.
Basically the problem is with the amount which is credited from Work in Process accounts.
Now the funny thing is that this not happening in all the MOs. The financial activity for a lot of MOs is 100% correct. It is just happening randomly but with almost 30 - 40 % of the MOs. We have not been able to identify any pattern of similarity among these MOs with wrong financial activity. So at best I can say the it is just happening randomly and we have not been able to identify any reason behind this.
Kindly help
Thanks,
Taimur
*This post is locked for comments