Topic Options
#35988 - 03/08/13 08:45 AM Inventory Adjustment Cost
MikeS Offline
Adagio Specialist

Registered: 10/25/10
Posts: 337
Loc: Concord, On
I have an item I wished to increase inventory for. It has both a standard and recent cost but there is no stock. When entering a quantity the extended cost is still 0.00 (Quantity and cost selected). Is this standard procedure or am I missing a switch somewhere? (I normally import all my adjustments)

Thanks
_________________________
Mike Smith
Viktorian Sheet Metal Mfg Inc

Top
#35990 - 03/08/13 08:57 AM Re: Inventory Adjustment Cost [Re: MikeS]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
If you're doing an adjustment, and you want the value of your inventory to go up (or down), then you must adjust both the quantity and the cost. If you just adjust the quantity, then this only affects the quantity on hand, not their total value.
_________________________
Andrew Bates

Top
#35993 - 03/08/13 09:34 AM Re: Inventory Adjustment Cost [Re: Retired_Guy]
MikeS Offline
Adagio Specialist

Registered: 10/25/10
Posts: 337
Loc: Concord, On
I know this. I select the 'Quantity and cost' option. Then 'Increase'. Then the quantity I want to increase. But if the item has a zero quantity in stock, no extended cost appears - even when the item has a recent and standard cost.
_________________________
Mike Smith
Viktorian Sheet Metal Mfg Inc

Top
#35995 - 03/08/13 09:47 AM Re: Inventory Adjustment Cost [Re: MikeS]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11570
Loc: Vancouver, BC Canada
Hi Mike,

After typing in the qty to increase, you need to tab out of (or otherwise click elsehwere) the quantity field. Then the Extended Cost will be calculated based on the Average Cost of the item. If there is no qty/cost on the item (such as for a new item), the calculated extended cost will be 0.00 as you have indicated. At the current time, the process does not attempt to fallback to the Most Recent or Standard Cost in order to perform this calculation.

For now, I'd suggest putting the Most Recent Cost field as a new column on the Item grid, so that when you select the item you can see the Most Recent Cost. Then use the F5 key on the extended cost field to load the calculator and do the Qty * MRC calculation for you.

How many items do you have to do this for, just this one or many? If multiple items, you can use the Physical Inventory process to add the qty and cost (which does use the Most Recent Cost when creating the adjustments to inventory). This process is likely overkill for a change to a single item.
_________________________
Regards,
Softrak Tech Support

Top


Moderator:  Softrak Support 
Who's Online
1 registered (1 invisible), 84 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14482 Topics
70726 Posts

Max Online: 432 @ 01/20/25 10:17 PM
May
Su M Tu W Th F Sa
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31