Questions tagged [pricebook]

Represents a price book that contains the list of products that your org sells. Price books are represented by Pricebook2 objects.

Filter by
Sorted by
Tagged with
-1 votes
0 answers
22 views

Adding a Product to Opportunity - Flow based on Field

I am aware we have products in two places on the opportunity, this is currently how the business needs it for reporting needs across 12 different BU's Thank you!! I want to create a flow that ...
M.M.19's user avatar
  • 1
0 votes
0 answers
65 views

Scheduled-Trigger Flow only updating first record

I am having an issue with a simple Scheduled Trigger Flow. It is my understanding that a flow of this type should be able to update a batch of records at once without requiring a loop to facilitate ...
CDutko's user avatar
  • 15
-1 votes
1 answer
83 views

Opportunity Object - Price Book Lookup is always blank

When an opportunity has a new quote created, and a product (quote line item) is added to that quote, there is a dialog box that pops up and asks you to select a price book: After selecting this price ...
CDutko's user avatar
  • 15
0 votes
1 answer
54 views

EU discount product regulation - Omnibus

I have to update pricing information display: For any promotional activation, when a promotional pricing is available, pricing from the last 30 days should be displayed. Is there an existing cartridge ...
Federico's user avatar
0 votes
0 answers
28 views

Subscription Management: relation between list pricebook and candidate pricebooks?

We are assessing whether Subscription Management is a good fit for our company. Looking at the Pricing API documentation we see that two types of pricebooks are used in the calculation of prices: ...
Sander de Jong's user avatar
1 vote
0 answers
206 views

Internal server error,While querying data on UserFieldAccess Object to fetch the field accessibility of PriceBook2 or Product object only from LWC

I have an Apex class with a single apex method, where I am querying on UserFieldAccess object to get the field accessibility of Opportunity.PriceBook2 field for a particular user. Apex class - public ...
Sahid's user avatar
  • 23
1 vote
2 answers
247 views

How can you import a standard price book catalog in a scratch org with the data import command?

When a scratch org is created its default price book is already created in the org. The JSON files with the dummy data in the repository, however, do not contain the ID of the price book record, or it ...
Renato Oliveira's user avatar
1 vote
0 answers
59 views

The price book entry is in a different price book than the one assigned to the Work Order, [closed]

hi i'm trying to test a class with price book entry and work order and Product Consumed but i got this error when i insert a product consumed: FIELD_INTEGRITY_EXCEPTION, The price book entry is in a ...
Laye's user avatar
  • 11
0 votes
1 answer
506 views

Price Rules in Salesforce CPQ

I am trying to learn Salesforce CPQ Price rules. I am trying to create something like the following: If the Add on product added is more than 10 then the primary product quote line will have an ...
Madhurima's user avatar
  • 1,265
0 votes
1 answer
396 views

Percent of Total field in Salesforce CPQ

I am trying to learn Salesforce CPQ where I have two questions. I have tried to create a Percent of Total product. I have two questions here : I will have to add the Percent of Total product in the ...
Madhurima's user avatar
  • 1,265
0 votes
1 answer
203 views

Historical price list for Products?

Historical price list for Products? Hi, I'm trying to find historical price list for Products? It that possible? All I'm able to find are current prices. Thank you
user115072's user avatar
0 votes
1 answer
80 views

ListPrice does not fill automatically on Order Products Selection layout

Whenever I add Order Products to an Order, they appear with empty ListPrices on the layout. Meaning that the field shows up but it is always blank. The Parent PriceBook and its entries are activated ...
ViniVan's user avatar
0 votes
1 answer
56 views

Set two price book prices equal to each other

Our company has two price books. The standard price book, and an intercompany price book. For the time being, we would like the prices on the intercompany price book to equal those on the standard ...
Ryan Miles's user avatar
1 vote
0 answers
612 views

I can't create quote line items with community user

From a community, I need users to be able to create quotes and their quote line items. With the community user, I create the opportunity, then I create the quote. Then when trying to create a ...
Chandlerbeen's user avatar
0 votes
0 answers
295 views

OpportunityLineItem shows UnitPrice with 3 places after decimal

I have an opportunity that has 3 products and each product has a list price of $600 and sales price (UnitPrice) of $400. The amount field on the opportunity is showing $1,199.99 instead of $1200 as ...
user1669296's user avatar
0 votes
0 answers
394 views

Clone with related -- PricebookEntryId (pricebook entry is in a different pricebook than the one assigned to the opportunity): [PricebookEntryId]

I am getting this issue PricebookEntryId (pricebook entry is in a different pricebook than the one assigned to the opportunity): [PricebookEntryId] when ever I tried to clone an opportunity with ...
klnavi's user avatar
  • 79
0 votes
0 answers
695 views

Price Book Entry History Report

Is there no report capability to see the Price Book Entry History? I need to be able to report on what date a certain Product changed price in a certain Price Book and what it changed FROM/TO. I also ...
rcg917's user avatar
  • 1
0 votes
1 answer
470 views

unable to insert OpportunityLineItem.PricebookEntry

This is the code - Apex code - public static void createnewOrderItem (OpportunityLineItem ChildOpptyLines,Id OrderId,Integer Qty){ if(((ChildOpptyLines.NC__c > 0) && (...
Kushi tin's user avatar
0 votes
0 answers
18 views

Price Book with 2 prices for same Product [duplicate]

The following query returns 2 rows for me SELECT CurrencyIsoCode,Id,IsActive,IsArchived,IsDeleted,Name,Pricebook2Id,Product2Id,ProductCode,UnitPrice,UseStandardPrice FROM PricebookEntry where product2....
SFDC Dev 27's user avatar
1 vote
1 answer
341 views

BulkAPI 2.0 Import PricebookEntries via Postman getting this error:STANDARD_PRICE_NOT_DEFINED:Before creating a custom price, create a standard price

I have setup the Postman requests to talk to the salesforce BulkAPI 2.0 because the dataLoader doesn't work (MacBook M1). The import of the pricebookentries fail at a point because when I import the ...
AMMA's user avatar
  • 311
0 votes
0 answers
182 views

Why would the Pricebook2Id standard field be on Contract in some orgs but not another?

Our QA and Production orgs have a Pricebook2Id standard field on Contract but our DEV org does not. Field Service has been installed in our QA and Production orgs and not our DEV org, but looking at ...
Swisher Sweet's user avatar
0 votes
2 answers
696 views

Using Custom Price Book Entry Object

I am developing the custom aura component for adding products to the opportunity for achieving client requirements. For this, I have created a custom price book entry object but while creating the ...
jsmith's user avatar
  • 155
0 votes
2 answers
802 views

Salesforce Products and Tiered Product Pricing Structure

I am converting our organization to use the Salesforce Products and Price Books features. I've been searching for articles and guidance on best practices and have a basic knowledge of how all of that ...
Zigrivers's user avatar
  • 349
-1 votes
1 answer
40 views

Adding MultiplePricebooks to an Opportunity [closed]

We have three different set of Prices for an Product . Lets say (Type A, Type B, Type C) and each type has three set of prices (List Price,Sales Price and Landing Price). We have a requirement to add ...
Anonymous123's user avatar
0 votes
1 answer
182 views

STANDARD_PRICE_NOT_DEFINED, No standard price defined for this product

I checked the other answers about this topic but I have no clear result. I think Id pricebookId = Test.getStandardPricebookId(); is use to get a standardPrice before insertion of PricebookEntry in a ...
CPS's user avatar
  • 335
0 votes
2 answers
313 views

Update both Pricebook2 and PricebookEntry objects using just one for loop

Having the next code: for (WrapperTest pb : pbs_lst) { Pricebook2 newPB2 = new Pricebook2(); PricebookEntry newPBE = ...
CPS's user avatar
  • 335
0 votes
1 answer
362 views

Report on opportunities that do not have a pricebook assigned

We just introduced products and pricebooks into our org. I am looking to update all historical data as well. I want to see, which opptys do not have a pricebook attached to them, is it possible?
Saariko's user avatar
  • 5,581
0 votes
1 answer
1k views

Insert PriceBookEntry using Product2 External Id field

I am developing an external application which will insert & update products and their pricebook entries into Salesforce system. In order to avoid maintaining the Salesforce ProductId in my ...
ronnie's user avatar
  • 1
1 vote
0 answers
300 views

pricebook sharing

We have two active pricebooks. OWD is set to "No access" on pricebook and we have extended sharing to "All internal users" on PB1 with "use". But no sharing on PB2. When ...
Priya's user avatar
  • 105
0 votes
1 answer
929 views

How to display Product fields and it's pricebookentries in a single datatable?

I need to dynamically put products and the products' pricebookentries in a single row in a datatable. If I add a pricebook, a new column and it's prices should also be displayed. I could do this for ...
Santosh's user avatar
  • 73
1 vote
1 answer
3k views

How to query products from pricebook

I have a pricebook set up with several products in it. I would like to query these products and display them on my React app. I am a little confused on how to go about this as I am a newbie to ...
Kisho's user avatar
  • 113
0 votes
1 answer
64 views

Not Able To Update Price Entries

I am trying to insert products, then those products then create price entries if they don't already exist but if they do exist they update the previous price entry based on the name of the product ...
Shaan Khokhar's user avatar
0 votes
1 answer
140 views

Load PricebookEntry in empty Scratchorg with Cumulusci

When generating a .yml file with generate_dataset_mapping with cumulusci it resolves in following code(sample): Insert Product2: sf_object: Product2 table: Product2 fields: Id: sf_id ...
Ammar's user avatar
  • 1
2 votes
1 answer
6k views

What does "Use" mean in Organization-Wide Defaults of Pricebook object?

I was looking for OWD Settings for Product2 object and found that OWD for Product2 is managed by Pricebook object. On checking the defaults in Pricebook object, it is set at Use unlike others which ...
shashankj's user avatar
0 votes
1 answer
289 views

Order Pricebook2Id to manage with multiple Order Product Pricebooks

Scenario: There are multiple Order Products with different Pricebook(Year wise Pricebook) to be added on Order Object. But, on Order Object we can only set a single Pricebook Id. Can anyone please ...
Jahnvi Jasani's user avatar
-1 votes
1 answer
891 views

Add a picklist value to Global Value Set in test class

I am working on test class that inserts an Opportunity with the opportunity products using the correct price book/price book entry. The OpportunityLineItem has a ProductSelected__c picklist field. We ...
Balaji Pooruli's user avatar
0 votes
1 answer
3k views

Different currencies in PricebookEntry throwing exception FIELD_INTEGRITY_EXCEPTION, PricebookEntryId (must have the same currency as the order)

I wrote a trigger which converts a Quote to Order on changing Status to a particular value. This Quote has QuoteLineItems, hence, they should converted to corresponding OrderItems. Now when the ...
Nilang Pandey's user avatar
2 votes
2 answers
7k views

Pricebook and PricebookEntries with different currencies

Can Pricebook and its PricebookEntries have different currencies? So, if I create a Pricebook with currency USD and its PricebookEntries with multiple currency like USD, GBP, AUD, etc., is this ...
Nilang Pandey's user avatar
0 votes
1 answer
896 views

How to know which Pricebook being chosen for an Order

I am planning to write a lightning web component to check which Pricebook is being used. However my problem is that from the Order, I can trace back to the Contract and from Contract I can have the ...
Minh's user avatar
  • 25
0 votes
0 answers
1k views

Pricebook field auto population in Quote Record Salesforcec CPQ

Pricebook field (Pricebook2Id)is auto populated on opportunity record by a visual workflow that looks up the right pricebook record from pricebook object based on an account field in the opportunity ...
gopal1007's user avatar
1 vote
1 answer
1k views

Net total of a quote line item is changing upon calculation

I have a product set to $5000. The product option is set to $5000. When the product is added to the bundle and it is saved, it jumps to $9000. The standard price of the product is set to 5000, it is ...
adam's user avatar
  • 35
0 votes
2 answers
2k views

Salesforce CPQ: Contracted Pricing is Not Overriding Pricing Rule Price

If a product has only a list price and contracted pricing for the product and particular account is setup, whenever the user is adding that product to the Quote under that particular account, the ...
mohammed azarudeen's user avatar
0 votes
1 answer
179 views

pricebook lookup field is not autopopulating

I have a opportunity object and a pricebook lookup field on that object. I have a create order button on opportunity object when I clicked the button the detail page should be open and pricbook lookup ...
amit's user avatar
  • 1
0 votes
1 answer
771 views

Trying to do an SOQL Query for all product names and their Price books

I Have a Salesforce Org where there are almost 1000 products and 51 Price books, I want to know a query where I can get each product and the price books they belong to. Any help is much appreciated!
Adam Lawrence's user avatar
1 vote
1 answer
610 views

Disable Price Book Lookup

when an opportunity is created and saved, "Choose price book screen appears". I have inherited sales cloud environment where no documentation has been provided, now the business requirement is not to ...
Prashant Yadav's user avatar
3 votes
1 answer
3k views

Find all Product2 records that do NOT have a PricebookEntry in the Standard Price Book

We have come to find that we have a small amount of products that have Product2 records, but no PricebookEntry for them. I'm trying to query for just those products, but I am having trouble with the ...
AstroLovesCodey's user avatar
0 votes
1 answer
668 views

Deep Cloning a Product - Clone Standard Price and Custom Prices

I have created a Record Detail button to clone a Product's detail, a related list called Bill of Materials, and both the Standard PB Entry, and any Custom PB Entries. If I remove the Custom PB Entry ...
TheMikeyBoosh's user avatar
1 vote
1 answer
4k views

Automatically add a Standard Price Book Entry after creating product

I am successfully importing a CSV of products and creating Product objects in Salesforce. I'd like to be able to automatically (or even via CSV update) create Standard prices for those objects, but ...
Scott C Wilson's user avatar
3 votes
1 answer
417 views

In Pricebook Entry validation rule I am not able to access the Pricebook fields

I am trying to create validation rule under Pricebook entry object. In that I am not able to access the Pricebook field, we have standard lookup "Pricebook" field in Pricebook Entry.
Satheesh's user avatar
1 vote
2 answers
875 views

Share Pricebook record to the current user using Apex trigger or class or Flow

If there any Option to share the newly created Pricebook using Apex class to Current user. We have separate object(Opportunity Share) for Opportunity sharing like that do we have any object to share ...
Satheesh's user avatar