Mining Data for Report Master 1

[rjbinney]

Company has folded, and I am trying to scrounge out any and all info from MAS-90....

Trying to mine data from MAS-90 into something usable.

For instance,

ITEM NO. LAST COST LAST VENDOR

I can find Std. Cost in Report Master files, and PRIMARY Vendor...

When I look in Inventory Inquiry, under the Vendors tab, it shows me last cost, last receipt, last vendor... Is there a map somewhere of what the database field name is that matches up to what's on screen?

 

[Blorf]

Hi.

Are you using ODBC or VI export?

If ODBC, all the data you list can be found in table IM1_InventoryMasterfile, fields

ItemNumber
PrimaryVendorNumber
LastCost

For last vendor, you will have to review purchasing records in PO1 and PO2.

ChaZ

 

[rjbinney]

Thanks. Don't know if I'm using ODBC or not... Assume so... "Report Master" is a drop down option from the main MAS-90 screen.

I am trying to dump everything together - Item, Last Vendor, Last Cost, WITHOUT having to review each purchase record. There are 18,000 SKUs purchased in the last two years, and sorting through those POs is crazy... Particularly when "Primary Vendor" is in many instances who SAMPLED an raw material, but in fact the bulk was purchased from a different vendor.


rjb

 

[Blorf]

Hi.

Sounds like you need custom report. You have MS Access?

ChaZ

 

[rjbinney]

Yes. That's what I'm dumping into. But I would rather dump a list of items and LAST receipts instead of items and ALL receipts.... Since MAS-90 already has "Last Receipt" tagged SOMEWHERE in its system.

 

[Blorf]

I don't think you can. If you connect to mas through access using the ODBC driver, you can create your own queries though.

In access, if you select file, get external data, link tables, or import tables, data type ODBC, and choose SOTAMAS, it will bring your table list up and you can basicly sort or do what ever you need.

ChaZ