Technical and Installation Discussions

[craigp]

I have read the post by BigLouie on pass through queries, and been able to create the link. This, combined with my limited knowledge of Access has allowed me to create additional queries, forms and thus custom reports not available in MAS.

Taking it a step further, I want the to pass data from Access into MAS 90. Can I use a pass through query to accomplish this?

[Heather]

No.

You can use Access to compile your data for import, but you would use VI to import it.

[BigLouie]

Not with queries but with BOI yes. It depends on the module. On modules in the Business Framework you can use BOI and write to MAS.  Glad my post were able to help you out.

[craigp]

thanks for the replies. may also help if i better explain what i'm trying to do.

utilizing different software to track inventory and create purchase orders.... i know i should be using MAS for this, and i own the modules. but i am a custom metal fabricator and the other software is pre-loaded with the thousands of steel shapes, including lengths, weights, etc.....

anyway, i want to transfer inventory values, new po's, relieved po's, etc... created in 'Fabsuite' into g\l and jobcost in MAS. not familiar with BOI.... is this another name for VI?

want to this as automated as possible. realtime link would be great. however, scheduled upload works too. what is best path?

[DFeller]

BOI = business objects interface.  Programming interfacing for accessing the COM objects of ProvideX.

VI = visual integrator, more structured import/export tool.

VI is easier, but BOI is "prettier" and more customizable.

Dawn

[BigLouie]

With the BOI someone like Dawn could use VB and write a program that writes the data to MAS from within your 'Fabsuite' application. 

[khmackall]

Your post mentions writing data to G/L and J/C in MAS 90.  You can use BOI for G/L because it is a Business Framework Module. Job Cost does not currently support BOI since it isn't a Business Framework Module.  V/I will import into J/C.

Thanks,

Kent

[craigp]

i know that VI is a separate module from MAS. is BOI a separate module as well? if so, would i need to purchase both in order to post to G/L and Job Cost?

[khmackall]

BOI is not a separate Module.  It is a way to access the Sage MAS 90 and MAS 200 Business Objects through COM.  It is built into the product.  To enable BOI access for a Company, select Enable External Access in Company Maintenance / Preferences.

Kent

[craigp]

after more thought, best path is probably to transfer PO's from 'Fabsuite' into PO module in MAS. 

I think this allows us to release PO to JobCost, but reserve putting PO into A/P until we receive invoice.... which is the ultimate goal of our endeavor.

so, next question.... is PO module on the Business Objects framework, or is it a Legacy module? I ask this b/c previous posts allow me to assume the answer will determine whether i use BOI or VI..... is this correct?