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.
Posted 2 years ago
Graham Boast, Accredited Partner
-
11,704 Points
Kevin Russell, Accredited Partner
-
53,026 Points
Graham Boast, Accredited Partner
-
11,704 Points
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
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
Kevin Russell, Accredited Partner
-
52,966 Points
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)
-
80 Points
I have done inventory adjustment in Quickbooks Enterprise. Can I print the inventory adjustment report
Graham Boast, Accredited Partner
-
11,704 Points
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
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