Can sage 300 handle items on consignments?

If sage 300 does handle items on consignment, how to set it up? Thanks in advance

Parents Reply
  • 0 in reply to Jay Converse Acumen
    First, create new account for consignor as new vendor. Then create new location? Can I use the same location and create a new category for all consignment items? Under the category option tab, Allow the Commision tab will be checked and put whatever amount or percentage of the sale for the item. Is that work? What about the cost of item set up? Assign 0?
Children
  • 0 in reply to SV2016
    Use a different location.
    Do you have consignment and non consignment items using the same item number?
    Search the forum, someone posted a reply to the same question recently.
  • 0 in reply to SV2016

    Quoted from another reply:

    Where it is consignment stock from a supplier on the client's site we normally create a separate account set where we set the Stock Control and Receipt Clearing account to be the same account, a consignment control account.
    This means that when you receive stock it will have no influence on the GL balance.
    As you now use (or sell) stock in the month, a credit will be generated to the consignment control account, which at the end of the month must balance back to the total of consignment stock used or sold. This is also then the amount that your supplier must invoice you for stock, but this invoice is done in AP to the Consignment control account.
    When the supplier replenishes stock it is done through IC receipts, from the setup above it has no influence on the GL balance.
    Obviously when you print your month-end reports to balance IC to GL the consignment stock must be excluded from your IC valuation reports. Use a separate IC location for consignment inventory so that it can be excluded from the item valuation report.

  • 0 in reply to 49153
    Thanks so much 49153. I get the clear idea of it now.