Questions tagged [pricebookentry]
Represents a product entry (an association between a Pricebook2 and Product2) in a price book.
94
questions
0
votes
0
answers
162
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 ...
- 43
0
votes
1
answer
281
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 ...
- 25
1
vote
2
answers
211
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 ...
- 12.3k
0
votes
1
answer
177
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
61
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 ...
- 3
0
votes
1
answer
50
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 ...
- 101
1
vote
0
answers
546
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 ...
- 71
0
votes
0
answers
748
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
258
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 ...
- 567
0
votes
0
answers
371
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
630
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
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....
- 577
1
vote
0
answers
499
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
328
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
637
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 ...
- 155
0
votes
0
answers
156
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,...
- 101
0
votes
1
answer
169
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 ...
- 305
0
votes
2
answers
304
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 = ...
- 305
0
votes
1
answer
365
views
Are Pricebook and Pricebookentries available in Service cloud? [closed]
Please let me know if these objects are available in service cloud.
- 47
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
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(...
- 117
0
votes
1
answer
893
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
64
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
335
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[...
- 155
3
votes
2
answers
575
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,899
0
votes
1
answer
136
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
327
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
271
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 ...
- 106
1
vote
1
answer
274
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; ...
- 71
-1
votes
1
answer
859
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 ...
- 537
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 ...
- 159
2
votes
2
answers
6k
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 ...
- 159
0
votes
0
answers
791
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
182
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
937
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 ...
- 11
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
293
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,296
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:
...
- 31
1
vote
1
answer
157
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 ...
- 948
0
votes
1
answer
747
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
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 ...
- 1,104
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 ...
- 145
0
votes
1
answer
657
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 ...
- 517
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 ...
- 273
1
vote
1
answer
876
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 ...
- 273
1
vote
1
answer
988
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?
- 273
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, ...
- 721
0
votes
2
answers
798
views
SOQL Query on PricebookEntry returning no rows
I'm trying to create a queueable apex class which will update the unit prices of all Products (on all Pricebooks) based on newly updated exchange rates.
I'm able to successfully query on ...
- 11