Sage 100

 View Only
  • 1.  I'm sure someone has tackled this question of cons

    Posted 04-25-2012 10:53
    I'm sure someone has tackled this question of consignment inventory. Any ways that you've found works best? I'd like to pick your brain on how to best handle a new line we are taking on. It will be a consignment line and we will keep inventory in our warehouse. * All inventory will be in MAS200. * Orders that are shipped in our territory will be entered into MAS200, billed and shipped by us. * Orders outside our territory will be entered in another sales order system outside of our building. We will ship from our warehouse and the vendor will invoice. My question: How do we handle the inventory on the sales orders that are not processed in MAS200, yet the inventory is being shipped from our warehouse? Do we just make a daily inventory adjustment? Or is there a better way to handle this?


  • 2.  RE: I'm sure someone has tackled this question of cons

    Posted 04-25-2012 10:56
    I would think you would want to be consistent. If they don't know the actual customer for the outside territory, how about a generic VENDOR customer and still do the invoicing to relieve inventory - at zero price. The generic VENDOR customer could have pricing setup for 100% discount if they have the Std Price filled in for these consignment items. This way if any cusom reports are created, it's all the same type of transaction.


  • 3.  RE: I'm sure someone has tackled this question of cons

    Posted 04-25-2012 10:59
    I'm thinking similarly. These types of questions are always loaded because guaranteed that in 6, 9, 12 months they want to know why a certain report cannot be run -- or why a quantity sold is/is not being reflected in a report. And of course they have no idea - and claim there's nothing important to consider - about any fo these things at the outset. But 6 months down the road they sure as heck figure it out and 9 times out of 10 ask us why we set it up that way....


  • 4.  RE: I'm sure someone has tackled this question of cons

    Posted 04-25-2012 14:05
    Use an additional company in MAS?


  • 5.  RE: I'm sure someone has tackled this question of cons

    Posted 04-25-2012 14:13
    My question is, if the vendor invoices why not just invoice the vendor and when they send you payment and I am assuming that you get paid you do a cash receipt. Your issue is that you still need to record items shipped on behalf of the vendor.