Sage 100

Hi All, Need object reference & table name for Item Maintenance --> More --> Item Pricing Maintenance --> Customer Price Schedule --> Pricing Method --> Price Discount Amount to pull the discounted price by running the script. I right clicked on the…

So we are doing a massive overhaul of our system, and one big thing we have to do is change customers pricing method. We have about 2300 customers in our system, but not have custom saved pricing. We are moving from Price Discount % to Price Override…

I am currently on v2014 v5.1 MAS100 Standard ,using CR 2011 for Sage. I am using CI_ITEM and IM_PriceCode Tables. in IM_PriceCode we have price overrides that we use driven off of item# and Customer number. so i want to write a report that will…

I am implementing landed cost in my system. I am wondering what others have found works best for them. I know I have to have goods and invoice received together for landed cost to function, however more times than not, I do not receive invoices until…

I have a crystal report built in 4.3 that showed the price of an item based on the Price Code within the item. The following is the formula. IF {IMB_PriceCode.Method} = "P" THEN {CI_Item.StandardUnitPrice} - {IMB_PriceCode.DiscountMarkupPriceRate1}…