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
0 answers
56 views

How to set only one active price book per record type ( I have two record types)?

I need to automate that only one pricebook should be active for record type of product. I have two record types. And i think that, when the new price book is check to active, the previous one should ...
0 votes
1 answer
92 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
141 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
0 answers
203 views

Error while upserting PricebookEntry

Issue I am getting this error while upserting pricebookentry on an external ID Batch_RDM_PriceBookEntries_Update:execute:errorMessage : The following error has occurred....
  • 1
0 votes
1 answer
132 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
38 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
48 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
387 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
506 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
183 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
275 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 ...
  • 79
0 votes
0 answers
456 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 ...
  • 1
0 votes
0 answers
17 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
379 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 ...
  • 11
1 vote
1 answer
266 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 ...
  • 301
0 votes
2 answers
479 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 ...
  • 145
0 votes
0 answers
141 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,...
0 votes
1 answer
123 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 ...
  • 185
0 votes
2 answers
243 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 = ...
  • 185
0 votes
1 answer
254 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 ...
  • 1
5 votes
1 answer
5k 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(...
0 votes
1 answer
736 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 ...
  • 73
-1 votes
1 answer
59 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
56 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
199 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[...
  • 145
3 votes
2 answers
433 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 ...
  • 1,869
0 votes
1 answer
131 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 ...
  • 1
0 votes
1 answer
258 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
221 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
237 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
799 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
2k 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 ...
1 vote
2 answers
4k 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 ...
0 votes
0 answers
615 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
164 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
823 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 ...
  • 229
0 votes
1 answer
243 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,290
1 vote
2 answers
2k 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: ...
  • 31
1 vote
1 answer
140 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 ...
  • 909
0 votes
1 answer
670 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
810 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 ...
  • 1,084
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 ...
  • 347
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 ...
0 votes
1 answer
617 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 ...
1 vote
1 answer
3k 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 ...
1 vote
1 answer
765 views

Make Price Book Entry object's Product Code field Read/Write

I'd like to automatically create Standard Price Book entries for new products using dataloader.io. I am successfully creating the new products, using the Product Code as the ID. But when I go to ...
1 vote
1 answer
927 views

Can I show the standard price on the product layout page?

I know I can click the Related Tab and drill into the Standard Price Book to see it, but it would sure be nice to just show it on the product page. Is this possible?
1 vote
2 answers
2k views

FIELD_INTEGRITY_EXCEPTION, This price definition already exists in this price book

My requirement is to take any pricebook entry made in the standard pricebook and replicate/update it in a second price book. With the code below I keep getting the error FIELD_INTEGRITY_EXCEPTION, ...