Hello There,
I am posting a inventory transaction adjustment entry to reduce the inventory on Returned bucket. But when I go to Item Transaction entry there is no way to select this, its always comes from quantity on Hand. I wanted remove the qty on returned can anyone give help on this.
*This post is locked for comments
Hi Frank & Vaidy,
Thanks for kind reply. Yes I can do the cost adjustment which I forgot completely :-)
I was about reply exactly that. Totally depends on how item got received. Adjust Costs may probably be the last resort.
How were the 5 units returned? Returns Management or SOP Return? If via Returns Mgmt., then the cost of the items will be dependent on when the item were originally received prior to their sale and where that original receipt falls in the existing FIFO layer stack. If via SOP Return, then the oldest receipt layer left in inventory is where the cost will be picked up from. If necessary, you can always manipulate your receipt layer cost using Adjust Costs utility in Inventory to get the desired result.
Hi Frank,
Yes I can do that but then what FIFO layer will be applied. i.e. If I have qty on hand = 10 with cost of $ 100 and Returned has qty 5 with cost price of $ 80. When I transfer and go and my adjustment entry which qty will be picked up I wanted the 5 with price $ 80 should get reduced.
There is one way to achieve this.
Pass an Inventory Transfer by selecting the "Quantity Type" as "Returned" to "On Hand" and then take them out of "On Hand" by passing Inventory Adjustment.
Babu, you need to transfer the Item from 'Returned' to 'On Hand' quantity type using Item Transfer Transaction.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (