Announcements
No record found.
Hello,
How to make the system capture the average cost while posting sales return if it is not against Return Lot ID.
Thx
*This post is locked for comments
That's how it works?
Which average cost - I assume the current value?
Invoice a customer.
The customer returns the delivered products.
You return the products to stock.
In this case, when you credit the customer for the returned products, the cost of those products is calculated by using the current cost of the products.
When you use the Return lot ID field, the cost of the returned products is calculated by using the cost on the invoice of the original sale to the customer.
By default, when you add items to a return order, the items are returned to inventory at the current cost price. To specify a different return cost price: .
Click Sales and marketing > Common > Return orders > All return orders.
On the Action Pane, in the New group, click Return order.
In the Create return order form, select a customer account, and then click OK.
In the Return order - RMA number: %1, %2 form, select an item, and then enter a negative quantity in the Quantity field.
Click the Line details FastTab.
On the General tab, enter a value in the Return cost price field. This value is used when the goods are returned to inventory. If you do not enter a value, then the current cost price is used when the goods are returned to inventory.
Hi,
If i didn't enter a value, The current cost price is not used used when the goods are returned to inventory, any setup is required??
At the time of the return did you have any stock on hand? Zero stock will not have any current value.
In addition to what magic1949 already mentioned; if you create the SO return by selecting / referring to the original SO, the price that was used when issuing the item will be taken as the return price meaning that the issue and receipt price will be the same.
Best regards,
Ludwig
[quote user="Hossam Fathy"]How to make the system capture the average cost while posting sales return if it is not against Return Lot ID.[/quote]
Could you highlight about the business requirement in detail , as we need to understand that why client doesn't want to use return lot id ,if that is the case how can client track actual cost of the material returned ?
HI,
This is integrated Sales Orders, so in same Sales order maybe the items 2 times ( sales and sales return ) so the cost showing zero after posting.
I created new item and purchase it then sales then sales return without putting cost and cost posted zero.
Hello any reply Microsoft.
Any Answer Microsoft???????????
You would need to raise a support ticket with Microsoft to get a Microsoft answer. This is a community run by volunteers of the community, it is not Microsoft run.
You would need to show the transactions, but what you are doing is possible, it is just that there are other processes, so your return sales order if created from the original it insists on the cost price, which is of course valid from an inventory perspective, also you can choose to bring this in at zero if you desire.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CP04-islander 26
imran ul haq 8
André Arnaud de Cal... 4 Super User 2026 Season 1
