General Consultant Discussion

There isn't a MAS 500 category, so I'm posting this here. Has anyone ever imported sales orders into MAS 500 where the unit price needed to be updated from the pricing rules in 500 rather than importing the price? Is there a trick to getting this working?

From one of our MAS500 experts: ""I've never tried it with data import manager but have with data porter."" If you need to talk to him, send me an email and I'll put you in touch.

So far what I've found is that there's a stored procedure called spIMIMSItemsGetItemPrice where we might be able to get the price for an item/warehouse/customer/shipto/UOM/company/date combination. Then we can put that into the file that data import manager uses to import. I would have thought this was just built-in. In Sage 100, when you import a sales order, you just need to specify the item and qty and it figures out the price for you.

That's because MAS90 is actually now technologically ahead of MAS500. Since it's moved to a somewhat of a 'service oriented architecture' (not true one, but far better than hard coded mas500, VI is able to import data as if its keyed in. Not so much with MAS500 which means, even with API's there is no guarantee you'll get the same result as keying it in since its a different code base and different bugs.

@DawnAnastasi could you use a staging table in SQL to build your import file in? If so, you could use the stored proc you referenced to update the prices in the staging table prior to running the DIM routine. I believe you can use the staging table as your source object in DIM as well. We don't have a lot of exerience with DIM but have done a lot with the api's (effectively just stored procedures) developed by SagePSG to load AP and AR invoices. We do all our own pre-processing outside MAS prior to loading so we have more control over exactly what is imported. Another alternative is to use the web parts developed by RKL eSolutions. They have imports for every component exposed in their eSuite which includes Sales Order entry. I believe it enforces pricing controls established in MAS 500. Cheers.