Inventory cost price using sales order credit note

(0) Share

Report

Posted on by Tahj

I created several Credit Notes using the Credit Note function from the Sales Order top pane. I marked the originating s/o. Before I invoiced the Credit Note I looked at the line details, Return Cost Price which I believe is the current price of the item different from the original Sales Order. That Return Cost Price shouldn't matter right since the Recalculate Price checkbox was uncheck in the Create Credit Note Form. I would expect since I marked the original Sales Order in creating the Credit Note the cost posted in the Credit Note would match the original s/o. How can I assure the cost will reverse the original cost? Also on the same Sales Order a rebill sales line was added correcting the error that prompted us to create a Credit Note. And that rebill (positive line) has a different inventory cost as well. Any thoughts?

Just in case you're wondering....

-we're using date weighted average

-negative financial is checked

-costing inventory at site level

-Include physical value is not checked

-Direct Delivery order was created

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

The return order posts an inventory receipt, right?

For receipts you actually define the price and AX calculates the issue price.

Where and how did you make the marking exactly? In the SO lines?

The return price that you see, is that the cost price that you see in the cost section of your item master, i.e. the released products form or is that a different price?

Have you tried whether a recalculation of the inventory value makes any difference?

Best regards,

Ludwig

Was this reply helpful? Yes No
Tahj 17 on at

Like (0)

Report

Yes, the Credit Note did post a receipt back into inventory at the cost of the PO marked. While the invoiced Sales Order at the top I clicked Credit Note. Once the Create Credit Note form opened I select the Sales Order # from the top portion of the form and the lines portion is automatically marked because there is only one line. And post. The Return Cost Price that I see is located in the Sales Order Line Details fast tab under the Setup tab below. In the Release Product there is a price of 0.00 in the Purchase fast tab under Prices, Price of 0.00 in Sell fast tab, and Price of 100.20 in the Manage Cost fast tab under Prices which does not match the Return Cost Price that I see in the Sales Order Line Details fast tab under the Setup tab below from the Sales Order. I haven't been able to do a recalculate because the test environment has lots of problems. And the client is comfortable doing it in Prod until they understand the behavior. Should COGS/COS on the Credit Note be returned at the same dollar amount as the original sales order? Why would it be different?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Tahj,

It seems really interesting that the return cost price taken is different from the released product form and the related sales order.

Do you make use of sales agreements where this price is possibly setup for this customer and taken from there?

If you cannot find something in AX then have a look at LCS to ensure that the behavior you see is not related to a system bug.

Best regards,

Ludwig

Was this reply helpful? Yes No
Tahj 17 on at

Like (0)

Report

Yes, there is a sales agreement which is copied correctly in the Sales Order line. So, I added screenshots because maybe something catches you eye that I may have overlooked… Thank you.

Release Product master showing values

Original direct delivery inventory transaction, sales order line with sales agreement details on the line reflected correct. (Price per gallon 1.94 x 4400 = 8536), and voucher.

Sales Order Credit Note inventory transaction and voucher.

Was this reply helpful? Yes No