I am currently working for a company which uses this system called MFG Pro. Apparently the previous finance manager (who just resigned) did not print out many subsidiary ledgers, especially the inventory control ledger. The practice adopted by this manager was to overwrite, over the previous month's copy. We were thinking of retrieving the backup copies, but the MIS experts have advised us that it is extremely difficult to do so. My current manager, having just taken over this position, is also not very familiar with MFG Pro.
The subsidiary ledgers (represented by inventory control listing) are missing for 2 months. We are trying our best to reconcile GL to sub ledger, but as you can see, it is an uphill task. It appears that he may even have deleted some month-end transactions. Could you advise me on any possible way we can reconstruct the subsidiary ledger, through the other components of the MFG Pro system, eg using excel macros perhaps? Would be very grateful if you could do so.
Thank you.
Yours sincerely,
Jennifer Su-mien Lim
jennifer S.M. Lim
Replies (4)
Please login or register to join the discussion.
Subsidiary Ledger Reconciliation
As you will have experienced, MFG/PRO is a good, efficient but complex system. The nature of your question indicates an on site review of the data would be more likely to result in a solution. It would also provide an opportunity for developing procedures to eliminate the chance of this happening in the future. Brian (who I have worked with before)mentioned Mike Taylor who is an excellent financial consultant although his support from QAD might prove costly. I really believe you need someone on site to assist with this problem and as a temporaray freelance MFG/PRO consultant I may be able to offer a cost effective solution ([email protected]).