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
0
votes
0answers
26 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 ...
1
vote
1answer
474 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 ...
0
votes
0answers
29 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
0answers
21 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
1answer
617 views

FIELD_INTEGRITY_EXCEPTION, Price Book Entry ID: id value of incorrect type: [PricebookEntryId]

Hi all I have a test method which it creates data (makeData) for the following test methods. But I'm getting this message over and over again. System.DmlException: Insert failed. First exception on ...
2
votes
1answer
1k views

PriceBookEntry required field missing when creating QuoteLineItems

I am kind of new to CPQ and have been trying to create a Quote Line Item with no success. Opportunity OpportunityOne = [SELECT Id, PriceBook2Id FROM Opportunity WHERE Id='...
0
votes
0answers
33 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 ...
1
vote
1answer
900 views

How to give access to all price books for a cerain user?

I need to give our Finance user, access to all price books (as he needs to edit old opptys) Is it possible to do that automatically? and not by manually going to each price book, and update the ...
0
votes
1answer
22 views

unable to insert OpportunityLineItem.PricebookEntry

This is the code - Apex code - public static void createnewOrderBillingItem (OpportunityLineItem ChildOpptyLines,Id OrderId,Integer Qty){ if(((ChildOpptyLines.NRC__c > 0) && (...
0
votes
0answers
16 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
1answer
65 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 ...
0
votes
2answers
145 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
2answers
6k 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
1answer
125 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 ...
0
votes
0answers
25 views

SFDX. Import PricebookEntry2 to standard Pricebook2

I want to import price book entries and relate them to standard price book on scratch org. I'm using sfdx force:data:tree:import. But I can't relate my new price book entries with the already existing ...
0
votes
0answers
14 views

Add Products to Opportunity on the basis of Manufacturing Plant

The scenario is If suppose there are two products "A" and "B". Product "A" is manufactured in Plants X, Y, and Z, and the product "B" is manufactured in Plants ...
-1
votes
1answer
33 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 ...
0
votes
1answer
48 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
2answers
96 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
0answers
56 views

Trigger after Insert Order Item - PriceBook Entry

I have a trigger After insert on OrderItem. This Trigger should insert automatically dependents product in the order . My Problem is that I don't understand how I can efficiently set the ...
0
votes
0answers
66 views

Query on Pricebook-Manual Sharing [duplicate]

I would like to know if there's a way to export all Manual Sahrings that have been done on Pricebook records. I would like to know, for each pricebook record, with which user/role/public group has ...
0
votes
1answer
21 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?
18
votes
4answers
8k views

SeeAllData=false and Pricebooks

When writing test cases with SeeAllData=false, you cannot access or insert Pricebooks. Effectively this means that you cannot use SeeAllData=false when working with any test case involving products. ...
0
votes
2answers
587 views

Avoid exclusive access to the standard pricebook

I have been building more code that touch products and as such am referring to the standard pricebook with my test classes (I create products and pricebook entries related to the standard pricebook). ...
0
votes
1answer
444 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
vote
0answers
64 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 ...
0
votes
1answer
244 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 ...
0
votes
1answer
706 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 ...
0
votes
1answer
45 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
0answers
459 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 ...
0
votes
1answer
102 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
1answer
137 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
1answer
3k 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 ...
3
votes
1answer
2k views

Using multiple pricebooks in an opportunity

When adding products to an opportunity I can only use one pricebook. In my case I need products from multiple pricebooks. How can that be done?
2
votes
1answer
699 views

Multiple pricebooks on one opportunity

I've seen this question a few times, but there never seems to be a resolution. How can I make it possible to link multiple pricebooks to an opportunity? We're trying to implement something in our org ...
-1
votes
1answer
527 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 ...
3
votes
2answers
3k views

Cannot find product to add to Opportunity

I have crated few products. Now I cannot find them when I am trying to add them to the Opportunity. Products are active. They are added to a Price Book. Price Book is also active. Any idea what is ...
0
votes
1answer
937 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 ...
0
votes
2answers
1k 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
1answer
359 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 ...
2
votes
1answer
3k views

How to use Test.getStandardPricebookId for classes that automaticaly sync quotes

I was hopping to be able to remove the @seeAllData annotation from my tests by using Summer'14's addition - Test.getStandardPricebookId() but the test are failing with this error: System....
0
votes
2answers
1k 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 ...
1
vote
1answer
79 views

Free Applications

I have a simple question but I could not find the answer to it yet. I want to develop a Application for the Salesforce AppExchange but want to charge no price for it (Free App). So what costs do you I ...
0
votes
1answer
104 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 ...
1
vote
1answer
509 views

Problems using standard pricebook in unit tests

We are running into problems with our unit tests which use the standard pricebook. When they are run separately they work fine, but as soon as we do a "run all" several tests fail with message: ...
10
votes
2answers
5k views

Why there is no OWD settings for Product Object

I was wondering why there is no OWD settings for Product Object. And as it was said that PriceBookEntry is a junction object for Products & ProductPortfolio then why there a OWD settings option ...
0
votes
1answer
384 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!
2
votes
1answer
2k 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 : ...
3
votes
3answers
5k views

Where is PricebookEntry Object

i am following this link http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_erd_products.htm .In this ER diagram there is Pricebook2Id field on Opportunity Object but i can't see any ...
1
vote
1answer
338 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 ...