Rose Business Solutions Dynamics GP

Binary Stream offers the Vendor Contract Pricing & Rebates module that allows you to track rebates from your vendors. It allows you to track them as you sell items to your customers, and then periodically report on them to your vendors so you can collect the rebates. It also easily creates an accounts payable credit memo to make the request part of Dynamics GP accounting records to make sure you collect the rebates.

This is an example of the Contract Maintenance screen where vendor contracts are maintained:

You’ll notice that in this example I buy the item for $40, but sell it for $38. This is a money losing proposition unless I collect the $10 rebate from the vendor. This module helps me control this situation so I can easily account for the rebate and process a request to the vendor.

I also assign the contract to my clients to whom I sell this product. This allows GP to automatically detect that a vendor contract is associated with the sale, and will start tracking the rebate for this item and sale. Here is what a sales order looks like for this item:

Notice that the margin is recalculated and shown on this screen, assuming that the rebate is received from the vendor.

Periodically you will want to claim the rebates from your vendors for the  items sold. There is a screen that will display all rebates that should be requested and a direct load to Excel to provide reporting. When you process the rebates, a credit memo will be created in Payables Management for the amount of the request.

Done.

I created this short video showing this in action: http://youtu.be/wwWOFxKVqHA

2 Responses to “Rebate Tracking with Binary Stream”