Questions tagged [pricebookentry]

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

31 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2 votes
0 answers
74 views

Timeout Error when cloning a pricebook

I am getting a timeout error when cloning my Standard pricebook. Any known limits (as to the number of product or pricebook entry records)?
NikitaChe's user avatar
2 votes
0 answers
1k views

Get a pricebookEntryId for a custom object(having product2id field)

I have a custom object SapLine which is like opportunityLine, i.e has a product2 lookup field. The hierarchy is Opportunity-->OpportunityLineItem, SapOrder-->SapLine. I created a PricebookId field on ...
Alan Abishev's user avatar
2 votes
0 answers
959 views

Trigger on PricebookEntry

I want a field on Custom PriceBookEntry to be updated from Standard PriceBookEntry when it is created. However, Salesforce doesn't allow writing a trigger on PricebookEntry. What are the options I am ...
RajeshShah's user avatar
  • 1,754
1 vote
0 answers
545 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
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 ...
VinceD's user avatar
  • 11
1 vote
0 answers
936 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 ...
Will May's user avatar
1 vote
1 answer
648 views

Scheduled Process to Update Price Book Entries

I need to write a process to handle the following: Retrieve all price book entries for the standard price book Retrieve all price book entries for non-standard price books that have a matching ...
AndrewG's user avatar
  • 11
1 vote
0 answers
643 views

The StandardPrice field appears in the PriceBookEntry object, but I can't include it in a query

This query works: select name, UnitPrice, ProductCode, UseStandardPrice from PriceBookEntry But this query fails with the complaint "No such column StandardPrice": select name, UnitPrice, ...
user2171796's user avatar
1 vote
0 answers
108 views

Logic for adding OLI

I have the following code for adding a OLI to an Opp. It is passed an Opp ID and will grab a few Pricebook Entires based on the already set Pricebook and the Product i have set. It will then only add ...
JamesM's user avatar
  • 11
0 votes
0 answers
160 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 ...
Marko Polo's user avatar
0 votes
1 answer
279 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 ...
Samuel L's user avatar
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
user115072's user avatar
0 votes
1 answer
60 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
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 ...
Ryan Miles's user avatar
0 votes
0 answers
745 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 ...
salesforceheather's user avatar
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 ...
user1669296's user avatar
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 ...
klnavi's user avatar
  • 79
0 votes
0 answers
628 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
2 answers
636 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
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,...
Dominic Cotton's user avatar
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 ...
CPS's user avatar
  • 305
0 votes
0 answers
334 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[...
jsmith's user avatar
  • 155
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 ...
Jahnvi Jasani's user avatar
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 ...
user74804's user avatar
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 ...
Alexander Atkinsoon's user avatar
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. ...
jaw999's user avatar
  • 1,296
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!
Adam Lawrence's user avatar
0 votes
0 answers
1k views

Inserting PricebookEntry from apex throwing error

I have Written a trigger to insert a pricebookentry based on creation of product. I am using custom pricebooks in my org. But I couldn't able to insert pricebookentry and apex is throwing following ...
Srujan's user avatar
  • 133
0 votes
0 answers
783 views

OpportunityLineItem:- Field Integrity Error

I am trying to automate the following functionality: When an opportunity stage becomes 'Pending Payment', insert 2 'OpportunityLineItems' using 2 predefined Products. This is my current code. I am ...
Marc Zaharescu's user avatar
0 votes
1 answer
114 views

calling PriceBookEntry from Javascript

After reading tons of links, posts and many documents, I decided to ask for help here, hopping some guru can help me with this issue: <!-- Visualforce Remote object component for Products --> &...
Yelmox's user avatar
  • 23
-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. ...
Shaan Khokhar's user avatar