Questions tagged [pricebookentry]

Represents a product entry (an association between a Pricebook2 and Product2) in a price book.

Filter by
Sorted by
Tagged with
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!
0 votes
1 answer
104 views

Bulk Api 2.0 max 2 retries instead of 10

I recently started huge PricebookEntry bulk update, around 40 mln records in one of sandboxes where locks are unavoidable. I am relying on the documentation that 10 retries are guaranteed per batch: ...
2 votes
2 answers
10k views

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

i am trying to solve this error but not able to solve, can anyone plz help me out. i have already set the standard pricebook. Error---- System.DmlException: Insert failed. First exception on row ...
3 votes
2 answers
625 views

Change the label of a standard field of PriceBookEntry object

Is it possible to change the label of a field (in my case I'd like to change the label of the UnitPrice field) of the PriceBookEntry standard object ? In the setup -> tabs and labels, I don't see ...
0 votes
1 answer
348 views

Troubles Updating a Currency Field on Quote Through Create Triggered Flow

Hi Im going to try to illustrate what I want to achieve through this flow: Using Quotes I have a Currency Field named AgencyFee__c on Quote And I have a Cross Object Currency Formula named BankFee__c ...
1 vote
2 answers
248 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 ...
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
0 votes
1 answer
82 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 ...
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 ...
1 vote
0 answers
616 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 ...
0 votes
0 answers
834 views

Field Integrity Exception: Unknown when updating a price in sandbox

In sandbox, I am trying to update a price for a product in the standard price book through the UI. When I change the List Price and click save, I get the following error. These are referencing ...
0 votes
0 answers
297 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 ...
0 votes
0 answers
395 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 ...
0 votes
0 answers
696 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 ...
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....
1 vote
0 answers
528 views

DataLoader batch job failing with PricebookEntry upsert

I have an issue with our PRICE BOOK ENTRY Upsert using the DataLoader batch bulk job. We have External IDs in our PRICE BOOK and PRODUCT objects that we use when Upserting to our PRICE BOOK ENTRY ...
5 votes
1 answer
7k views

Get custom Picklist value in LWC without Record Type

I have created a custom Picklist in PricebookEntry and trying to get the Picklist values in LWC. All the solutions I found needs to pass the RecordTypeId to get the list. @wire(...
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 ...
1 vote
2 answers
3k views

FIELD_INTEGRITY_EXCEPTION when creating Price Book Entry from flow

I have created a flow that creates a pricebook entry for new products (based on a custom field on the Product object), however when I debug the flow it comes up with the following quite generic error: ...
0 votes
2 answers
702 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 ...
1 vote
2 answers
9k views

Pricebook entry currency code does not match opportunity currency code

I have a Visualforce page which create a product record, a priceBookEntry record and a opportunityLineItem record. I don't understand why in only one case, I get this error : In my code, I first ...
0 votes
0 answers
164 views

Creating opportunity line from SalesforceSharp

I am using SalesforceSharp to create an Opportunity. The header is working OK, I have ensured that the CurrencyIsoCode and PriceBook2Id fields are set. When trying to create the Opportunity Line Item,...
4 votes
3 answers
10k views

How to find out relationships for SOQL queries?

I want to construct a SOQL query displaying all Opportunities that are sorted by the Products that are associated to it. I however have a problem finding out how Opportunities and Opportunity ...
0 votes
1 answer
183 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 ...
0 votes
2 answers
314 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 = ...
0 votes
1 answer
384 views

Are Pricebook and Pricebookentries available in Service cloud? [closed]

Please let me know if these objects are available in service cloud.
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 ...
2 votes
1 answer
383 views

Unable to add PriceBookEntry with APEX

i want to add product price into PricebookEntry object with help of following APEX code: PricebookEntry pBook = new PricebookEntry(UnitPrice = price, ...
0 votes
1 answer
933 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 ...
-1 votes
1 answer
66 views

string.isempty doesn't appear to work when trying to retrieve price list Name

it appears my if statement with String.isEmpty doesn't seem to be working. What i want it to do is check if a price list entry doesn't exist it creates a new one, and if it does it updates that one. ...
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 ...
0 votes
0 answers
361 views

Use Database.upsert with external id field is not working on PricebookEntry object

I need help to do a DML operation with external id field. I am using the below syntax, but it is throwing an error Schema.SObjectField f = PricebookEntry.Fields.Product_Code__c; Database.UpsertResult[...
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 ...
0 votes
1 answer
357 views

How to restore or undelete PricebookEntry records

Is it possible to undelete/restore a deleted PricebookEntry record? I am not referring to restoring a Price Book or Product record but hitting the delete button on an entry record itself, then ...
0 votes
1 answer
290 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 ...
1 vote
1 answer
285 views

Error when I try to create OrderItem records Insert failed. INVALID_CROSS_REFERENCE_KEY

I'm trying to create a visualforce page where a user can create multiple OrderItem records at the same time. The error that I get is OrderItem records Insert failed. First exception on row 0; ...
-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 ...
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 ...
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 ...
2 votes
1 answer
3k views

REQUIRED_FIELD_MISSING & FIELD_INTEGRITY_EXCEPTION on PricebookEntry Insert

I want to use standard price for the Pricebook entry. PricebookEntry pbe = new PricebookEntry(Pricebook2Id='01sN00000002OTsIAM', IsActive=true, Product2Id='01tN0000004JGeuIAG', ...
0 votes
0 answers
851 views

Pricebook2Id not populating in opportunity when default price book is already present

I have applied a default pricebook to a set of users. When I try to add products to that opportunity the pricebook already shows that it is selected at the product selection screen but still ...
0 votes
1 answer
183 views

I am unable to query pricebook entry. (Internal Salesforce Error)

I am making a lightning component for a user to create a quote + line items quick and easy. However the apex function that is meant to query the pricebook entry and its Id for each line item is ...
1 vote
0 answers
968 views

Selecting the Opportunity Price Book

I'm still fairly new to Salesforce Apex and trying to figure out how to select a price book from the opportunity. The reason being I have a trigger which adds in a product when the opportunity is ...
1 vote
1 answer
1k views

Is it possible to update Order Product on Draft Order?

We are trying to utilize the Order object, but we're finding that if we create an Order Product, we are unable to change the product (i.e. essentially the Pricebook entry), even if we're in a Draft ...
0 votes
1 answer
301 views

PricebookEntry Conflict Error not matching existing products

I am getting an error message on a trigger that was working until recently. The issue arises on a trigger that inserts an OpportunityLineItem on an Opportunity. Here is the error: Insert failed. ...
1 vote
1 answer
163 views

Failure when inserting records via dataloader, however anonymous apex inserts fine

I'm getting the following error when running dataloader (inserting new quotelineitems), however an identifcal anonymous apex works fine - any thoughts? Error: The price book entry is in a different ...
2 votes
1 answer
3k views

can i maintain 5 prices for a product with the same currency based on its volume?

The current status of out business is such that , they maintain different prices for different cities in the same country. Also, they maintain different prices for different volumes. Example : ...
0 votes
1 answer
1k views

How to prefill UnitPrice on Order Products

I want my Order Product price to prefill based on the price defined on the Pricebook Entry. I swear I've seen this work in the past, but I can't figure out why this time I keep getting an empty field ...
5 votes
1 answer
2k views

In which sequence should I be creating/inserting order/orderItem/pricebookEntry/product2?

I'm on the advanced apex super badge step 7, and before this I thought I had a good understanding of order/orderItem/pricebookEntry/product2/pricebook2 objects. However, upon creating my own ...
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 ...