Inventory Adjustment.

  • 1
  • Question
  • Updated 6 months ago
  • Answered
Inventory Adjustment. We have 10 of thousand of item codes. How can we adjust just a single item quantity without having to scroll through the list of all the item code.
Photo of Vincent Byrne

Vincent Byrne

  • 70 Points

Posted 1 year ago

  • 1
Photo of Graham Boast

Graham Boast, Accredited Partner

  • 11,704 Points 10k badge 2x thumb
Hi Vincent

This is an interesting and common question, so I have set out some processes and alternatives on my website help pages.  I hope you find it an interesting and useful post.

http://reckonhelp.com.au/articles/reckon-accounts-business/adjusting-inventory-in-reckon-accounts-bu...


Graham Boast 0409317366
Reckon Accredited Consultant
graham@reckonhelp.com.au
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 52,272 Points 50k badge 2x thumb
Graeme how do I adjust inventory quantities in bulk? I have six thousand items and I need to update them for stock take.
(Edited)
Photo of Graham Boast

Graham Boast, Accredited Partner

  • 11,704 Points 10k badge 2x thumb
Hi Kevin.

I can do this with a spreadsheet containing the item in one field and the stock count in another.

My preference is for the item to be the reckon item full name ("Doors:2 Panel Door"), but I can often reverse engineer this in excel from either the item name without the "sunbitem of" detail ("2 Panel Door") or the Manufacturers Part Number (MPN) or the Barcode - as long as its a unique match for the reckon full name..

From this data, I compare the count with the stock on hand at 30/6/18, and from this I create an iif file to record the stock adjustment in Reckon.

The process takes me between 5 and 8 hours depending on complexity, but has the advantage of being accurate and fast.


Graham
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 52,272 Points 50k badge 2x thumb
Do you have the record layout?  I don't have any existing stock quantities. It's the initial uptake so it should be fairly simple. 
(Edited)
Photo of Ashok Kumar

Ashok Kumar

  • 80 Points 75 badge 2x thumb
I have done inventory adjustment in Quickbooks Enterprise. Can I print the inventory adjustment report
Photo of Graham Boast

Graham Boast, Accredited Partner

  • 11,704 Points 10k badge 2x thumb
Hi Ashok.

Surprisingly difficult to achieve.  I did a Custom Transaction Detail Report and filtered for Transaction Type = Inventory Adjustment.  Also added Qty, Item & Item Description to Display Columns.

Graham 0409317366
graham@reckonhelp.com.au