Sales Price Worksheet - Update prices for all customers?

Alisha
Alisha Member Posts: 217
edited 2008-04-09 in NAV/Navision Classic Client
Hi,

I would like to run the "Suggest Sales Price on Wksh" report to update/create prices for all the customers in the database, but the code does not allow to do that, it has to be done one by one. Anyone knows why Navision has this limitation?

Thanks! O:)

Comments

  • tinoruijs
    tinoruijs Member Posts: 1,226
    Can't you use "All Customers" for "Sales Type" on tab Options?
    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • Alisha
    Alisha Member Posts: 217
    That option would create Sales Prices with type=All Customers, that's not what I want. What i want is to create/update sales prices with type=Customer.
  • AdamRoue
    AdamRoue Member Posts: 1,283
    The routine is basing it upon the prices already specified in the sales price table. If you have entries in there it will suggest new ones based upon the factors defined. You will have sales source codes set and can filter in this manner. If a customer is not listed in the sales price the price will be taken from the item card itself. This routine does not create customer specific pricing, it updates what is there.

    You can only create a price for all customers, if all your customers have a price defined in the sales price table.

    To adjust the item price used by all customers in the absence of pricing you run the Adjust Item/Cost price routine.
    The art of teaching is clarity and the art of learning is to listen
  • Alisha
    Alisha Member Posts: 217
    Thanks for your answer, but i still don't understand why the routine does not allow to update the prices for all the customers that have specific prices, for example to increment all by a 10%.

    I've commented out the lines of the code that don't allow this, and the routine seems to work fine, but I don't understand why it was not designed like this from the beginning, and there is some reason it might not work properly now.
  • AdamRoue
    AdamRoue Member Posts: 1,283
    I think I have stumbled across your issue.

    In the sales source you specify customer, this will reference every customer specific price in the sales price table. You then define customer in the copy to sales price worksheet and you will receive a message telling you customer " does not exist. In this manner the system is seemingly telling you that you need to copy across the customer price changes individually.

    Is this your error?
    The art of teaching is clarity and the art of learning is to listen
  • Alisha
    Alisha Member Posts: 217
    Yes, that's my error.

    I just don't understand why Navision has created this limitation on this process...
  • AdamRoue
    AdamRoue Member Posts: 1,283
    It is not a limitation it is a bug :D It is listed on partnersource with the code changes required to fix it.
    The art of teaching is clarity and the art of learning is to listen
  • Alisha
    Alisha Member Posts: 217
    Thanks!!

    But I've been looking in the Partnersource website and I can't find it.. could you please copy the link?
  • AdamRoue
    AdamRoue Member Posts: 1,283
    From your description this is where it is:
    https://mbs.microsoft.com/knowledgebase ... QTQRZWNQMR
    The art of teaching is clarity and the art of learning is to listen
  • Alisha
    Alisha Member Posts: 217
    Thanks again, but that's not what i'm looking for. That bug is corrected and works fine in V5.

    The problem i have is this code on report 7052 Suggest Sales price on Wksh:

    IF (ToSalesCode = '') AND (ToSalesType <> ToSalesType::"All Customers") THEN
    ERROR(Text002,"Sales Type");

    Text002 = Sales Code must be specified when copying from %1 to All Customers.

    The error message does not make any sense, since ToSalesType is NOT All customers.. it is "Customer", and ToSalesCode is blank because i want to update all customers..but it won't allow me, I just want to understand why... or report it if it is a bug.
  • AdamRoue
    AdamRoue Member Posts: 1,283
    I would report it.

    I would argue if you select "Customer" it should update all customers if the code is blank by the criteria set, you should not be forced to update each individual customer record one by one! I would say they "fixed" this error message but did not "solve" the issue. :D
    The art of teaching is clarity and the art of learning is to listen

Categories