MFG Pro expertise

MFG Pro expertise

Didn't find your answer?

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.

avatar
By AnonymousUser
10th Feb 2003 15:54

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]).

Thanks (0)
aw_logo_2019
By Accounting WEB
02nd Feb 2001 12:55

MFG/PRO history
have you tried menu options 3.6.15 or 3.6.16, both of which allow you to run a report of the inventory value at a date in the past.

Thanks (0)
aw_logo_2019
By Accounting WEB
26th Mar 2000 11:14

The raw data
I am not familiar with MFG Pro, but most accounting systems today are relational databases - where all the raw data is stored in a collection of simple tables. It sounds as if what you are missing are some physical reports extracted at various times - those that can be used and discarded, and not the source data in the tables.
The fastest and easiest way I know to reconcile ledger accounts is with Excel connecting directly to the tables, and using Pivot Tables to highlight items that do not match.

Thanks (0)
aw_logo_2019
By Accounting WEB
24th Mar 2000 11:05

MFGPRO Problem
I have implemented MFGPRO but I cannot help on this particlular problem.

You may want to try to contact Mike Taylor at QAD email [email protected] who I work ed with on the accounts system. He my be able to help, do you have a maintenance contract?

Thanks (0)