Hi Everyone,

I’m trying to build a Gridview that will allow me, using GridviewRW, to change the cost of a particular line of products in SalesAnalysis. Let me preface this with why I want to do this. One of our largest suppliers defines the pricing for our customers. We then buy the product and typically sell it for a loss to our customers at their contract price. At the beginning of each month we submit a rebate report to our Vendor and they rebate us the difference between the cost and sell price, and a brokerage fee which is our profit. We then pump this rebate back into our cost of goods sold (as a reduction) to true up the margin on the Income Statement. That process works just fine as far as we are concerned. The problem is that our margin is skewed (negatively), on a customer account basis, because we are selling below cost. That’s where we came up with the idea to use GridviewRW to adjust the cost of these sales after we submit our rebate report to get a true gross margin. We cannot change the cost up front because we will buy one product at one cost, and sell it to multiple customers at varying prices below cost.

My question is what tables in sales analysis do I need to hit. I have tried adjusting the cost on the S/R Transaction 9.0A Master but it doesn’t seem to be a comprehensive change, or rather it doesn’t change the cost across the board in S/A.

Maybe there is a better way to achieve this without using GridViewRW, and if so I’m open to it.

We are using Sales Analysis 9.1A (131009)


Thanks
-Clint