Method Community

 

Changing costs on purchase orders based on customer price level

Last post 11-16-2010 10:29 AM by Anonymous. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 11-09-2010 12:00 PM

    • jshumaker
    • Top 500 Contributor
    • Joined on 07-29-2010
    • Atlanta, GA
    • Posts 9

    Changing costs on purchase orders based on customer price level

     I have a client who is a distributor.  He has setup his items with base costs and prices.  Some customers receive a different price, thus he has also setup price levels on a per item basis.  However, for these customers who receive price discounts he also receives a cost discount from the manufacturer which he would like to be reflected on the purchase order.  Purchase orders cannot use discount items and price levels only apply to customer prices—not costs. 

    So is it possible to create a purchase order from a sales order (or estimate) that then applies a discount to the cost on the purchase order?    Programmatically, it would require looking at the price level on the sales order/estimate, then applying an associate discount to the appropriate items.  Sounds like a lot of tedious programming.

    Of course the client COULD duplicate his items lists with varying costs & prices, but that requires more overhead in maintaining the items list and still requires a manual process of ad hoc situations.

    Sincerely,

    Joan A. Shumaker, M.Ed., President
    Advanced Certified QuickBooks ProAdvisor®
    Certified QuickBooks Enterprise Solutions ProAdvisor®
    Method Certified Consultant
    Microsoft Office Specialist Master Instructor
    Sleeter Group Certified QuickBooks Consultant
    Member of The National Advisor Network
    Founding Sponsor, Dunwoody Chamber of Commerce

    Computer Training Resources Inc.
    The Small Business Specialist Since 1989
    http://ctr-atlanta.com
    770-551-0571
  • 11-16-2010 8:54 AM In reply to

    Re: Changing costs on purchase orders based on customer price level

    Hi Joan,

    Thank you for your post. We are looking into what would be the best option for doing this. We will get back to you shortly with an answer.

    Regards,
    Denis

  • 11-16-2010 10:29 AM In reply to

    Re: Changing costs on purchase orders based on customer price level

    Answer

    Hi Joan,

    Because we are limited by what the Quickbooks SDK supports, we cannot directly access the costs and sales orders in Quickbooks through Method (i.e. closing out sales orders). You can, as you suggested, duplicate this process in Method by creating separate tables with a series of actions that replicate the desired calculations, however those would reside only inside Method, outside of QB, and would have to be maintained manually.

    Regards,
    Denis

Page 1 of 1 (3 items)