Price list for Vendors /Suppliers and a separate Price list for Customers

Is there a price list I can enter in the cost of purchasing items from my vendors, who provide me with an annual price list.  The price would pop up on the purchase order - this would eliminate the purchasing person entering the incorrect price and it matches the invoice when received.  Sometime the prices are ok other times they are not.  The person entering payables always have to check when different.

Then is there another set of price list I can use for my Customers when I sell the goods.  

  • 0

    Hi Bobcaygeon,

    There is price list for inventory module but not for the vendor and customer. 

    For purchase, Sage 50 keeps the last price you used to purchase the item by an invoice in memory.  Please keep in mind that changing the price in an order or quote will not affect the last price used in an invoice as there is no entry created by posting an order or quote.

    In Sage 50 Quantum only, there is a setting of purchase price.  You will have to go to individual inventory record, Vendors tab, click on Open Vendor List, choose the vendor and enter a price under the Price column.  This setting will override the last price used in a purchase invoice, but it is only available in Sage 50 Quantum.   

    For sales, the price of the item is based on the Pricing tab of the inventory record.  If you setup your customer using regular price under Options tab of Price List box in the customer record, for whatever inventory item you choose in the sales invoice, it will automatically use the regular price of the item.

    In conclusion, you can setup the sales price by going to Pricing tab of individual inventory record.  However, you will not have option to setup purchase price if you are not using Quantum. 

    Hope this helps

  • 0 in reply to Keith L

    If you are using 'Premium' or higher, it might be worthwhile to set up a sales price list for your main vendors (i.e. zWholesaler1)  (and assign that price to yourself).  

    Two benefits I've found to doing that:

    - It can be a handy, quick way of checking your rough cost on a quote, or

    - quickly checking up the PO cost of an item while in the middle of entering an invoice / sales order / quote.

    To add to what Keith mentioned about Quantum:

    The vendor cost comparison report shows any vendor quoted dollar amounts that you've manually entered, and if you have set it to do so, it will keep track of your most recent purchases of each item, from any vendors you buy it from, and you can pull that information up in a purchasing report.