Simple Export of Customer Pricing?

Before I go and try to make a complex Crystal Report..... Does anyone have a simple way to export a specific customers pricing that will incorporate any contract pricing?

Throughout the year, I will get salespeople coming to me to create a spreadsheet for customer ABC which means I need to find out their price list code, export that price list, then also export any contract pricing and combine them together before presenting to the salesperson.

Just trying to save myself some time and frustration.

Parents
  • 0

    Hi Mike - I didn't see this question so you might have already answered it.  In short - there isn't way.  Customer pricing business is very complex - more than what a Crystal Report can handle by itself because of the non-linear logic.

    There are some ways to get around this but they require some VBA coding to make work.

  • 0 in reply to Django

    No I haven't found a better answer.  We only use pricing set on volume discounts and only use 3 levels.  I've used crystal to spit out what the pricing would be for each item in the price list that the customer is set to.  Then I just incorporated any contract pricing as well using an outer join.  I was just hoping that their would be something within Accpac itself.  I'm sure I'm not the only one who has a customer saying "hey, we need our 2014 pricing for our system"

Reply
  • 0 in reply to Django

    No I haven't found a better answer.  We only use pricing set on volume discounts and only use 3 levels.  I've used crystal to spit out what the pricing would be for each item in the price list that the customer is set to.  Then I just incorporated any contract pricing as well using an outer join.  I was just hoping that their would be something within Accpac itself.  I'm sure I'm not the only one who has a customer saying "hey, we need our 2014 pricing for our system"

Children
No Data