Stock Count for Empty locations

SOLVED

Hello,

I am trying to include empty locations in my location count but it doesn't seem to work. I have tried using a 'Locations' count formula of "[F:STC]OCPCOD = 1" but it still doesn't work. Is there a way to include empty locations in an annual stock count?

Regards,

Dave

Top Replies

  • +1
    verified answer

    Hi  

    I am trying to include empty locations in my location count but it doesn't seem to work

    When I test a stock count per location (without any selection criteria) on 2023R2 SEED folder, I only get locationon which the stock exists. So I don't think adding selecting criteria that will only narrow down the results will work.

    Can't you just change the report, so the physical count will ensure these locations are empty without confirming there are no stock on them in sage X3?

    The problem is the count is done per product, so to confirm there are no stock on a specific location you would need to enter zero for each product which would be extraordinary time consumming.

  • 0 in reply to Julien Patureau

    Thanks Julien,

    Unfortunately, since this is an annual inventory, we need to count ALL locations. I will have to develop a separate manual count sheet for the empty locations I guess. I appreciate the response.

    Regards,

    Dave