Skip to main content
Solved

Update new vendor price from template to variant

  • 2 February 2022
  • 8 replies
  • 203 views

After setting new prices for template items in the vendor price worksheet, the vendor price for the variants of the template item will not get updated. I can’t figure out if this is a bug or a feature.

8 replies

Kandy Beatty
Rank
Userlevel 7
Badge +16

Hi @marcelk 

I created this on my local instance.  This is for a template item also. 

  1. Create the Vendor Price worksheet, I did with this item highlighted. Gave it a Break QTY of 1 with a price of $6.50.

  2. I released the Price Worksheet and verified the pricing

  3. I created a Purchase Order for that item and added the QTY of 1. The price was $3.00 but was recalculated to $6.50. 

     

  4. Ensure you release the Vendor pricing. Check the Effective date as well. 
Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
M
Rank

Thank you @kbeatty21

I released the pricing. Effective date is today. Only works on the variant itself. But if I change the vendor price for the template nothing happens. This (template → variant) works for sales prices but not for vendor prices.

In your example the description for RES01K1 looks very specific. Is this a template item or a variant? 

Kandy Beatty
Rank
Userlevel 7
Badge +16

Hi @marcelk  It is for a Matrix (Variant) item. 

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
M
Rank

Thank you @kbeatty21 for your research.

Updating the price on the variant level work fine for me too.
What I wanted to achieve is updating the price on the template level (this works in sales prices worksheets). But this does not work here obviously. 

Kandy Beatty
Rank
Userlevel 7
Badge +16

@marcelk  It does not seem to work. I was also unable to create a purchase order for that template item. 

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
M
Rank

@kbeatty21 

No, I would like to update the vendor price for the template item.

In the purchase order I order the variant (matrix) item that is derived from the template item. But the vendor price of the variant does not follow the updated vendor price of the template item. 

The same works in a sales order. Update sales price for template item → add variant to SO → System pulls price from template item.

Chris Hackett
Rank
Userlevel 7
Badge

Hi @marcelk were you able to find a solution? Thank you!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
M
Rank

Hey @Chris Hackett, unfortunately you have to set the vendor price on every single variant. Even if it sound logical it is not possible to use the template item for that. 

Reply


Terms & ConditionsCookie settings