1 Reply Latest reply on Feb 27, 2013 9:37 AM by philmodjunk

    Locations Table

    PeterMontague

      Title

      Locations Table

      Post

           I set up a locations table. It is related to the inventory like this inventory::sku -----< child sku::location >-----< location::location.

           The layout contains the location number; a portal containing child sku::sku child; inventory::sku; inventory::title; inventory::item _condtion.

           I want to include quantity in the portal. I have various options to add a quantity field. I could let this quantity be equal to the number that is added in the transactions table as items are added. Is, the related field, transactions::in the correct option? 

           The locations table layout is a good stock checking layout. I want to be able to add and take away from the quantities here as I check the box for errors. Is transactions::in the correct option for this? Or would this end up adding extra to the inventory in error?

      locations.jpg