Sage 200 Stock Movement

SOLVED

Morning

I'm trying to get a better understanding of how the Movement Table Works. We are trying to report better on product valuation and aged stock. 

What does it mean when I have a line where the StockLevelIssued > 0 and the WO and SO in the Movement Reference have already been completed (all prices have been confirmed)? Shouldn't this line disappear?

Thank you

  • +1
    verified answer

    Hi

    In a very basic example, if there are no other stock movements in the system for a stock item, the cost for a stock item receipt has been confirmed and the same stock had been consumed then there should be no entries in the MovementBalance table.

    However, in the real-world thing aren’t always going to be that straightforward.

    There are three main movement types, two of these are movements in, Confirmed (Type 0) and Not Confirmed (Type 1) and then there are Shortfalls (Type 2) which relate to the consumption of Not Confirmed stock. Out of these MovementBalanceTypes only a Shortfall would have a StockLevelIssued which is greater than zero.

    When confirmed stock is consumed the system simply reduces the OpeningStockLevel of the relevant MovementBalance table, when the stock in fully consumed the Confirmed line will be removed.

    When Not Confirmed stock is consumed the system creates a related Shortfall entry for each movement out, these are markers to signify that the cost has not been confirmed. Each Shortfall is linked to other tables that need to be updated when the cost has been confirmed.  The Not Confirmed entry would not be amended in any way until the cost has been confirmed, at which point it would be removed, any related shortfalls would be dealt with, and any remaining stock would be accounted for on a new Confirmed stock entry.    

    If the stock item in question is not using actual costing the MovementBalance table works as a queue on a warehouse basis. Confirming a cost (i.e. invoicing a purchase order or closing a Works order) satisfies the oldest Not Confirmed entries and any related shortfalls in a particular warehouse – this is not necessarily the same stock that was brought in by the original receipt. To give a basic example of this you receive 2 purchase orders for the same item (with prices updated at invoice recorded) into the same warehouse, all the stock is then sold - if you were to invoice the second of these orders the system would deal with the oldest Not Confirmed entry and its related shortfalls first.

    You mention that the prices have been confirmed and the WO and SO in the Movement Reference have already been completed, I would recommend checking that the status of the works order is 'Closed' and not just 'Completed' as this signify that the cost had not been confirmed for the works order.

    If you haven’t already viewed them the following help page may prove useful in understanding stock valuation:

    desktophelp.sage.co.uk/.../Stock valuation.htm

    If you are unable to validate the data with the information provided above please contact your Sage support provider for further assistance.

    Regards

    Chris  

  • 0 in reply to christopher hall

    Hi Chris

    Much appreciated.