Question with MFG/Pro eB

[stingray]

I am a BI solution consultant and have a potential customer that uses MFG/Pro as one of their data source. However, none of us have experience with MFG/Pro before.

Would like to know if there is any source that we can look into the table structure (or ER model) of MFG/Pro eB. I would assume the table structure are the same in Oracle or Progress.

Also, my customer have issue when consolidating GL accounts. Right now they are extracting data nightly from various overseas systems to construct a datamart. However, there is problem if there are consolidated accounts as the amounts will be duplicated. Are there any field that will be updated when accounts are consolidated that I can checked before merging the data?

Your help is greatly appreciated!

 

[dunwin]

Would like to know if there is any source that we can look into the table structure (or ER model) of MFG/Pro eB. I would assume the table structure are the same in Oracle or Progress.

QAD's Documents on CD has this. Your client will have received this with their product.

Also, my customer have issue when consolidating GL accounts. Right now they are extracting data nightly from various overseas systems to construct a datamart. However, there is problem if there are consolidated accounts as the amounts will be duplicated. Are there any field that will be updated when accounts are consolidated that I can checked before merging the data?

You need to provide a it more information on the process being followed by the client. Can you say which menu item they are using to perform the consolidation?