This may sound like a really basic question, but I thought i would ask it anyway.
We use works orders with BOM's and raise / allocate / issue these in the normal manner. The proportion of the components are large items and these are picked into each of the kits by Stores personnel and the stock is downgraded when the works orders are allocated and issued. A similar proportion of the components are small "consumable" items, such as bolts, plastic caps, etc and these are detailed on the BOM's, but set as "bulk issue" lines. These are issued from stock in bulk to the production line and downgraded from stock using the stock-take function. (previously, i used a version of Sicon Sage 200 and this allowed you to issue and return goods as part of Stock control, so getting used to adjusting the stock in a manual way as stock take did take some getting used to.)
We now have a lot of GRN lines for each item with 0 stock showing, so when we want to downgrade consumable stocks it is time consuming to scroll up and down through the list to adjust the stock quantities.
Can anyone advise on the following.....
1. Given that we do not want to pick the consumable parts into kits and issue them through works orders, is there a better way of downgrading the stock?
2. is there a way of removing the GRN lines with 0 stock?
Any thoughts would be appreciated.
In answer to question 1:
Set the stock as a Service Item or Non-Stock Item in Accounts - that way it will not require stock transactions.
Set the Product information record as a Non-Stock Item in Manufacturing.
Tick Bulk-issue Item on the Component Line on the BOM. The works order will inherit an unticked Update Stock option on the component line.
When allocating and issuing the works order you will still need to specify the quantity you are allocating or issuing, as these figures are used for costing purposes, but no activity is recorded against the product record in accounts.
In answer to question 2:
Use the Period End tasks in Manufacturing to remove old used up GRNs to the Traceability archive.
Tools > Period End > Tick Archive all fully used GRNs up to Set Date
Kind regards, David.
Thanks David! The GRN clear-down has worked perfectly!