Skip to main content

Hi,

i would like to check in below scenario, what is the best way to record the transaction.

 

The original purchase cost for product A is $100, we purchased 50 pieces, did purchase receipt and posted vendor bill. and we sold 40 pieces by end of the month.

 

On the last day of the month, vendor will review our sales and give us a rebate for Product A, lets say is $20 per piece for all 50 pieces. so our cost for product A become $80.

 

The problem is we already posted the purchase receipt and the cost of $100 is used as COGS, our sales person commmission is calculated by profit, so is there a way to adjust the vendor bill and re-calculate the profit for sales transactions already posted.

 

Thank you

in the real situation, the rebate is not only for one product, and involve multipe purchase receipt, so manually adjust the purchase receipt is not a solution we can afford 


Hi @jay13 

There is no option available to recalculate the profit on invoice once released, or adjust the COGs of item which was received (Receipt released) and sold (Invoice released). You may have to explore an option to manually adjust the rebate amount for commission calculation. 

Regards,


@jay13

You have a bigger fish to fry than being concerned about the commission. The way you explained, your purchase prices are subject to change, and based on your explanation apparently it happens a lot. Aside from sales commission, your accounting COGS and Profit are also impacted accordingly and constantly. To be clear, how would you expect Acumatica or any given ERP treats this considering lots of underlying financial reporting that you have and probably it will flow through different financial periods that some of which may have already been closed and financials are prepared? Can you please clarify?


Reply