Hello,
This is going to be lengthy, so please stick with me.
We have a rebate agreement with one of our manufacturers. A customer will receive special price as well as a special cost. The special cost cannot flow through at the transaction level; it must be the cost in the warehouse that ships the product.
We are being told our custom process does not work when the Costing Method on an item record is set to Average, but it works when the Costing Method is set to Lot Numbered. I would like to know if it is true, based on the process I will outline below.
This is our process:
A customer and item combination receives a custom price and custom cost.
At sales order entry, the special price is pulled in, and we have a custom column field titled Pricing Reason Code at the line level. The pricing reason code states the program name.
When the order gets fulfilled and a line item(s) have the program name, upon the item fulfillment being marked Shipped an inventory adjustment is kicked off with one line to remove the item/lot combination and another line to add back in the item but slightly changing the lot. Here is an example of an inventory adjustment:
Item123 Adjust Qty By (5,000) with Est. Unit cost of .113118 Lot Number 123456
Item123 Adjust Qty By 5,000 with special cost of .0995 Lot Number 123456_xx
This produces an Estimated Total Value of (68.09) on the inventory adjustment. This is what the GL Impact looks like:
Rebates account has a Debit of $68.09
Inventories have a Debit of $497.50
Inventories have a Credit of 565.59
I am being told that the cost reflected in commissions works properly when the Costing Method of the item is Lot Numbered but not when it is Average. Can someone confirm this?
Thank you!
Gina