Stock changes
Move history helps you understand how the same item or lot reached its present place and stage. It brings together the included moves and stage changes, showing what was entered for each event and the details that came before it.
Use Current Stock when you need the present position. Use this history when you want the route or sequence that explains that position.
In the search cell near the top (B4), type a stock number or the number of a particular change. Read the matching rows with their dates and times, comparing what came before with the new place or stage. Delete the text in the search cell to show all included moves again.
The sheet fills this history from Move or change stage. Enter new events there rather than typing into the history. If a move is missing, check its original row: Entry check must say Ready and Include change must be ticked. Earlier entries remain editable in this preview, so changing one can also change the later history shown here.
This history shows changes whose original rows pass Entry check and have Include change ticked. Unfinished or unchecked rows are left out. If you expected a move here, find its number on Move or change stage and read the message there. You do not add moves or tick boxes in this history.
This identifies the individual move or stage event. Use it to locate the same row on Move or change stage when you need to check its original details. Several different change numbers can belong to one stock number because the same item or lot may move or progress many times.
This is the number of the item or lot that changed place or stage. It stays the same throughout its moves, keeping notes and production history together. Use that number to review another part of the stock’s history or find it in Current Stock.
This is the entered date of the actual change, which can be earlier than the day it was typed into the workbook. Read it with Time happened when following the stock’s sequence. Opening the history today does not make an earlier row a description of where the stock is today.
Read the time with Happened on when several changes took place on the same day. The workbook uses its chosen timezone for these times. If the order looks wrong, check the original event dates and times rather than rearranging the rows in this history.
This shows the destination recorded for that event. If it is blank, the row did not change the location; it may have recorded only a stage change. Compare it with Previous location to see the move, and use Current Stock when you want the latest recorded place.
This is the stage reached on that event. A blank means the row left the stage unchanged, as a location-only move may do. Compare the new stage with Previous process : stage to understand the progress recorded then. A later event may have advanced the stock further.
This is the person or team named on the original entry. It gives you someone to ask if a move needs explanation. The name was supplied by the recorder rather than filled automatically from the Google account.
Read this for the explanation added to the move or stage event. It can help you understand why that particular change happened. Separate observations are found through Notes & history, where they retain their own dates and context.
To investigate a missing or disputed move, return to its row on Move or change stage and read Entry check. This view fills itself from the included entries; leave its displayed cells unchanged so that it continues to show their results.
This shows where the stock was just before the event. Read it beside New location to see the route taken. It describes the starting place of that move, which may be different from where the stock is now.
The spreadsheet works this out from the starting location and earlier included moves. If an earlier entry is changed, this earlier-place information can change too.
This is the stage before the event. Comparing it with New process : stage shows what progress was recorded, or helps you recognise a move that left the stage unchanged.
The spreadsheet uses earlier included entries to work this out. Changing one of those entries can therefore change the previous stage shown beside a later event.