Consignment in Sage 50 Premium

SUGGESTED

I have a client that has a small shop onsite and utilizes the Inventory Module in Sage 50 CDN.  Now they are wanting to add in products on a consignment basis where members can supply products to the store and then they could receive a percentage of the profit on the sale.  Does anyone know how I should do this?  Inventory is not my strong point.

Thanks for you help in advance.

  • 0
    SUGGESTED

    Sage 50 can't automatically record all the transactions from a sale that would set up the payable to the consignor.

    If there are large numbers of identical items (or near enough to identical, and priced the same), it's probably easiest to set up the items as 'service items' and record a sales invoice, then (separately) record the payable to the consignor.

    Otherwise, you probably would just set up one 'Consignment Sale Service item, and type in the price on each line for each item sold.

    I would use something like:
    - pre-numbered paper tags on the items that are 2 part, and removable. (some stationary or shipping supply companies carry these, they used to be used by appliance repair stores, back when small appliances were repairable / worth repairing)

    The tag number and consignor is recorded at the time of consignment, (in a book, a binder, a spreadsheet, etc.) so that you can look up who to pay without writing it on the tag that stays with the item. (or you could use a code for each consignor, or it might just not matter whether the purchaser can see who made / consigned the item)

    The consignor gets one part of the tag, and the other part stays on the item until it's sold, or the consignor wants it back.

    I hope that helps, please post back.

  • 0
    using Randy's tag / service item thoughts

    you can create a PO for all the items received by a consignor
    order/backorder quantity = the number of items
    description = tag # and what the item is
    amount = what the consignor expects from the sale
    account = where you track consignment expenses

    when you sell items, just convert those items on the PO to an invoice and pay it
    if the consignor takes back the item, delete the PO

    the pending purchase order report shows who has consignment items and you can drill down to see what they are