Sales Price Worksheet - Update prices for all customers?

Alisha

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:)

tinoruijs

Can't you use "All Customers" for "Sales Type" on tab Options?

Alisha

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

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.

Alisha

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

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?

Alisha

Yes, that's my error.

I just don't understand why Navision has created this limitation on this process...

AdamRoue

It is not a limitation it is a bug It is listed on partnersource with the code changes required to fix it.

Alisha

Thanks!!

But I've been looking in the Partnersource website and I can't find it.. could you please copy the link?

AdamRoue

From your description this is where it is:
https://mbs.microsoft.com/knowledgebase ... QTQRZWNQMR

Alisha

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

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.