Customer Pricing

[mrstnturner]

Does anyone know how to pull the customer's prices into a crystal report or print them directly from MAS 200. We want a report that shows us the prices that have been entered through customer maintenance - items- pricing. Can this field be pulled in a report or be printed on its own?? Many of our customer have had prices entered in "price override", I know that a form of this field can be pulled into a crystal report, but that field gives you a Y or N and not the actual $ price entered. If anyone has done this please let me know how. Thank you.

 

[vtsmike]

There is a table in MAS90 (IMB_PriceCode) that holds all the discount codes and price overrides for items. You can add that table to your report (probably have to use subreport) and report items with the same customer code with the price stored there.

Also, you may consider if you can use the MAS90 built in report under Inventory/reports/Inventory Price List.... you can specify customer and it will print all the special prices for that customer.

-Good luck.