Developer forum

Forum » Integration » Wrong prices from BC

Wrong prices from BC

Johan Ulff
Reply

Hi, we have products in BC with different sales prices depending on the amount ordered

I get the same results with both Quantity=1 and Quantity=100 in the request below, which should be different prices

We are using Dynamicweb plugin-unit 1.2.0.12.

<GetEcomData ExternalUserId="C00046" AccessUserCustomerNumber="C00018">
<tables>

<Products type="filter">

<Product>

<ProductId>2130936</ProductId>

<ProductVariantId />

<ProductNumber>2130936</ProductNumber>

<ProductIdentifier></ProductIdentifier>

<CurrencyCode>SEK</CurrencyCode>

<Quantity>1</Quantity>

</Product>

</Products>

</tables>

</GetEcomData>


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Johan,
What is your BC version? Is it cloud or on-premise? Are you using New prices feature available for BC18?
Can you show a screen with your sales prices setup for that product?
Regards, Dmitrij

 
Johan Ulff
Reply

We are running BC18 in cloud with the new pricing feature.

We are always getting the price 120:- for this product with the request above

 
Jannich Ariyanayagam
Jannich Ariyanayagam
Reply

Hi Dmitriy,

We experience the same, also after upgrading the codeunit to newest version.

Best regards Jannich

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Jannich,
have you tried on 1.2.0.14? Are you supplying correct values?

On the image above from Johan I can see that prices are set for specific unit of measure.
When looking for the item specific prices the item."Base Unit of Measure" value is used, so maybe
your item."Base Unit of Measure" value is different from the UOM value from the Sales Price list table?
Could you check when Unit of measure is empty in both places: item and Price list table?

Also check if you are sending the correct currency and if the dates are OK.

BR, Dmitrij

 
Johan Ulff
Reply

We are now using 1.2.0.14 plug-in unit, Base Unit of Measure on item is 'M', UOM for pricelist is 'M'. According to our BC expert it is not possible to have an article without UoM.

Currency in Request is "SEK", same as in pricelist and starting date is empy, ending date is 2021-12-31.

Price is still 120:-

 
Jannich Ariyanayagam
Jannich Ariyanayagam
Reply

Hi Dimitriy,

I just checked and it looks like the price is actually correct in our setup but the discount used for calculation is wrong which causes incorrect prices.

After upgrading to 1.2.0.14 it looks like the discount which is getting calculated is the wrong one.

Forexample i put 1 product in the cart and the discount used for the calculation is marked with a minimum quantity of 20 in BC (i get 51.50% discount not 50.00%). shouldnt i get 50% as i only have 1 quantity in the cart?


Could this be an issue in the Codeunit?

 
Johan Ulff
Reply

Jannich, please start your own thread if you have questions reqarding your issues. I want to get answers for my questions in this thread.

/Johan

 
Jannich Ariyanayagam
Jannich Ariyanayagam
Reply

Sorry about that will do :)

 
Jannich Ariyanayagam
Jannich Ariyanayagam
Reply

Sorry about that will do :)

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Johan,
this is a bug. We are trying to solve it asap. As a workaround until it is solved you can use this subscriber and publish it as the other extension.
The extension is attached here.
That should calculate the product price correctly now.

Let me know how it goes. We are also working to solve that for orders.
Best regards, Dmitrij

 
Johan Ulff
Reply

Hi, we have tried to install the extension, but apparently the Id of the extension i conflicting with som other extensions perhaps? Se attached picture

Regards,

Johan

 

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply
This post has been marked as an answer

Hi Johan,
it looks like you have other extension installed with the same object ids in Code units as our codeunits in the example app.
I have renamed ours code units so they start with 60000 and attached the app here.
BR, Dmitrij

Votes for this answer: 1
 
Johan Ulff
Reply

Hi, now its working fine. Thanks Dmitriy!

Regards,

Johan

 
Johan Ulff
Reply

Hi again. I can see a new release of the codeunit, 1.2.0.15. Is that the one that has the fix regarding the price bug?

 

Regards Johan

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Johan,
the new version of our Dynamicweb Plugin Unit Extension 1.2.0.16 that should solve all the new pricing issues is now available on App Source so you can try to install it and check.
Kind regards, Dmitrij

 
Johan Ulff
Reply

Dmitriy, it seems that there's something wrong with the product prices when there is no sales price list.

BC will use the unit price when there are no sales price, but the Dynamic web connector testtool gets a response with price=0. We should get a response with price=955:-

Request:

Response:

 

Article in BC:

 

No sales price lists:

 

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Johan,
yes, that is already been fixed. I can see in the response that you have 1.2.0.14 version of the app.
There is 1.2.0.16 released that had fixed that issue.
If you are using BC 18 Cloud then you can install 1.2.0.16 from the App source and try it.
Kind regards, Dmitrij

 
Johan Ulff
Reply

Thanks Dmitriy! Can we also get a copy of this version to download separately from the downloads section https://doc.dynamicweb.com/downloads/integration with runtime example extension?

 

Thanks

Johan

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply
This post has been marked as an answer

Hi Johan,
the runtime package of 1.2.0.16 is now available on this link.
The example extension was not changed so you should try to use the pevious one.
BR, Dmitrij

Votes for this answer: 1
 
Johan Ulff
Reply

Thanks Dmitriy, fast answer as always smiley

Regards Johan

 

You must be logged in to post in the forum