inventory

I am in need of help with keeping track of my inventory. We keep the inventory on shelves numbered for example 100A, 100A1, 100A2,  1000A3,  etc. originally I started using locations thinking that meant different locations within my store but have come to find out that this is incorrect and means different locations (Stores).  Can anyone guide me in the right direction for keeping track of the inventory when it comes in and goes out of the system. I am using  sage 50 premium Canadian . 

Parents
  • 0

    Hi Patty,

    Since you are using Sage 50 CA, I'm going to move your post to that Support Group so that other users of this software will see it and can offer their thoughts and insight.

    Thanks,

    Derek

  • 0 in reply to Derek Vink

    Sage 50 does not, (and can not) track bin locations in the 'QuickBooks Advanced Inventory' sense of keeping track of how many widgets are on each particular shelf in a warehouse location.

    As you discovered 'Locations' are 'warehouses' or 'store locations' as in the Winnipeg store and the Saskatoon store locations.

    As a kind of work-around hack, you can assign one of the 'additional' fields for each inventory item so that you could print it on reports like the Inventory List:

    PartCode   Field1             Asset

    Widget A   Row A5-35     1520

    And you could, for instance, print 'Row A5-35' on a Sales Order to use as a pick sheet.  

    And with a bit of Excel Vlookup magic, you can assemble info like this into any inventory report.

    There are other things you could do with using different item codes for the same item in different location. 

    It depends on 

    - what sort of inventory you are keeping track of,

     - the quantity of different items,

     - the number of locations that items of one type could be stored in,

     - whether those locations are relatively constant - i.e. the 1/4" pipe fittings are always in bin A5-35, or whether they are binned wherever there is room

     - whether the items list is relatively static - i.e. you store 1/4" pipe fittings all the time vs. you bring in 1,000 to build a job lot of cappuccino makers, then never again.

    **********************************************************************************************************************

    If Sage wanted to add true bin locations, they could insert the needed fields, or add a table and reference a couple of new fields for each FIFO cost pool, add the logic to split pools to multiple bins if needed, add fields to the screens and reports, and we'd be there.  But they haven't.

    You can send Sage your comments from Help | Give us your Feedback.

  • 0 in reply to RandyW

    I wonder if you could use the bin number as the inventory item code. It's hard to visualize how this would work with purchase and sales invoices without knowing the nature of the product.

  • 0 in reply to TedR

    you could use the item code then use the description as the item#/description. I have seen this type of inventory tracking before.

Reply Children
No Data