Questions tagged [pricebook]
Represents a price book that contains the list of products that your org sells. Price books are represented by Pricebook2 objects.
0
votes
1answer
29 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 ...
0
votes
1answer
23 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!
1
vote
1answer
50 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 ...
1
vote
1answer
121 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
1answer
116 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
1answer
325 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 ...
2
votes
1answer
51 views
In Pricebook Entry validation rule I am not able to access the Pricebook fields
I am trying to create validation rule under Pricebook entry object.
In that I am not able to access the Pricebook field, we have standard lookup "Pricebook" field in Pricebook Entry.
1
vote
1answer
102 views
Share Pricebook record to the current user using Apex trigger or class or Flow
If there any Option to share the newly created Pricebook using Apex class to Current user.
We have separate object(Opportunity Share) for Opportunity sharing like that do we have any object to share ...
0
votes
2answers
219 views
Test Classes failing due to default custom pricebook
Our admins developed and activated a process builder in Production to set a default custom pricebook on opportunity during the opportunity creation process. Due to this, several of our test classes ...
1
vote
0answers
23 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)?
0
votes
2answers
293 views
FIELD_INTEGRITY_EXCEPTION, The price book entry is Inactive
I'm a bit stumped. Everything was working fine for a few months and then errors like this started popping up, any idea how to fix it?
Here's the trigger :
trigger RenewalOppTrigger on Opportunity (...
2
votes
1answer
429 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
1answer
156 views
Unable to set pricebook Id in orderitems
I am writing trigger "On Insert Of Order(Sales order) copy opportunityLineitems to order line items" I have done everything fine upto my knowledge but when I am inserting order it is showing pricebook ...
1
vote
1answer
138 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:
...
1
vote
1answer
84 views
When does Salesforce remove Pricebook2Id on currency changes?
We have multi-currency enabled and custom pricebooks. I have a before insert class that automatically sets the pricebook when an Opportunity is created that works well. When a user changes the ...
-2
votes
1answer
125 views
Getting Pricebook entry Error
Hello I want to automatically add a secondary product when a user adds a product to an Opportunity. I have a trigger that feeds the lineitem to a class.
My class then looks for the product but ...
1
vote
0answers
227 views
How to change the record type of existing opportunities to another record type?
There are around 800 opportunities for which I want to change the record type of that opportunities.
These 800 opportunities are related to different product books. when I change the opportunities ...
3
votes
1answer
472 views
Standard vs Standard Price Book
What is the difference between Standard and Standard Price Book? I am quite confused why there are two price books by default.
1
vote
1answer
73 views
No Products Populate in Pricebook to add to Opp
There is so much info online about this already and I have already checked off the following which I am told would be causing an empty product list when trying to add products to my opp in the UI. Am ...
0
votes
1answer
59 views
Updating Product B value once Product A is edited in the product section of an Opportunity
The goal of the trigger is to automatically add "Product B" to the opportunity once "Product A" has been added manually by the Technical Writer. The code works really well, but I need Product B to ...
1
vote
1answer
1k views
Apex class getting the product fields from pricebookentry where pricebook name ='Test' [duplicate]
We are having Product , Pricebookentry and pricebook in SFDC as a standard object. here pricebookentery is having look up to product and pricebook.
so i want to get all the prodcuct fields which is ...
1
vote
1answer
284 views
auto-add product to opportunity based on product that has been added manually
Code:
trigger Attempt1 on OpportunityLineItem (after insert)
{
List<OpportunityLineItem> oliList = new List<OpportunityLineItem>();
List<String> lstProductNames = new ...
1
vote
1answer
102 views
How to load Opportunity Product using Test.loadData?
Is it doable for Opportunity Product to be load using Test.loadData while Standard Price is not accessible in Test class?
I try to automate the data population make it easy for user to define ...
2
votes
2answers
3k views
FIELD_INTEGRITY_EXCEPTION, field integrity exception: PricebookEntryId (pricebook entry is inactive): [PricebookEntryId]
Can't wrap my head around this error. Any ideas?
@isTest
public class RemoveProductFamilyTriggerTest{
static testMethod void RemoveProductFamilyTriggerTestmethod()
{
Date cd = date.parse('10/10/...
2
votes
0answers
286 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 ...
0
votes
1answer
194 views
How to filter the products that can be added to an Order?
Begining to look at Orders and Products and I have a very basic question:
How can you filter the Products that are available on an Order?
All of our accounts can create an order, we have various ...
0
votes
1answer
133 views
Error while cloning opportunities with products
I'm getting this error message:
An attempt was made to modify the opportunity price book as the opportunity was being cloned.This is not allowed for an opportunity with associated products.
0
votes
1answer
607 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....
1
vote
1answer
329 views
Pricebooks and Exchange Rate Fluctuation
Do you know if Salesforce can maintain and adjusts prices in the pricebook based on exchange rate fluctuation? And is also possible to view both currencies in the pricebook (USD and BRL) or Salesforce ...
1
vote
0answers
295 views
Display Product related to PriceBook in visualforce page
I have a custom object Product Quantity and it has lookup to Product2, I've created a Visualforce Page for Quote Creation (Quote standard object), and the Quote object has lookup field to Price Book.
...
0
votes
0answers
488 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 ...
2
votes
1answer
200 views
Why don't I see the Pricebook2Id field as available in formula field on PricebookEntry?
I want to create a formula field on PriceBookEntry using the Pricebook2Id field, but it's not available, yet in the fields like it has it as a reference/lookup field. Product2Id is there. Any idea why ...
0
votes
1answer
25 views
Add multiple new produtcs to Org pricebooks
I'm coding a tringger which takes all the new products and inserts them automatically in the Org's pricebooks. Now:
-newProd is a list of new Products
-notStandardPB is the list of Org's pricebooks
...
0
votes
1answer
117 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).
...
2
votes
1answer
789 views
Price book entry is in a different pricebook than the one assigned to the opportunity
I am facing the issue while deploying the test class in production. The test class is working fine in sandbox but failing in production
System.DmlException: Insert failed. First exception on row 0; ...
1
vote
2answers
198 views
How do I add prices to Products report?
A colleague wants a list of all products in his area and their prices. I can list the products but cannot seem to create a report that includes the prices listed / the price book. Is there no Price ...
2
votes
1answer
45 views
How to give SalesReps access to PriceBook “X” Only on specific Opportunity
I have multiple (PB) price books, A, B, C, D.
I want to give full access to PB C & D to all Sales Reps for all opportunities, and only give access to PB A & D if the Manager selected either of ...
0
votes
1answer
1k views
Can I add multiple currency prices to a product in one data upload?
I am using the data uploader to add prices to a bunch of products I just created.
We work in GBP, EUR & USD; Can I use one spreadsheet to upload all currencies in one hit (standard Price) or ...
2
votes
3answers
430 views
Is that possible to see the list of Price Book Entries?
Is that possible to see the list of Price Book Entries? Does Salesforce have any standard functionality to display it? I tried to find a one but I ended with PriceBook and Products. Any thoughts ...
3
votes
2answers
1k views
Is it possible to upsert PriceBookEntry
I have tried upserting PriceBookEntry
PricebookEntry p = new PricebookEntry();
List<PricebookEntry> lstp = new List<PricebookEntry> {};
Pricebook2 pb = [select Id, IsActive from ...
0
votes
1answer
231 views
Data upload Product , Price book and quote
User has given an excel with Product code, Product Name, Product Description and Product family to upload data into Products, Product Pricebook and New Quote.
Can anyone tell me how to upload give ...
2
votes
1answer
363 views
Price Book Record Types
Is it possible to have Price Books associated to different record types and assign these record types to specific profiles in order to have a refined list of price books available to only certain ...
2
votes
1answer
339 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
vote
1answer
194 views
Pricebook object not available whilce creating sandbox template
I am trying to create a sandbox template to setup a partial sandbox, I want to include data from Pricebook and product objects but I don't see them listed in the objects list.
Am I missing something?
-1
votes
1answer
97 views
Apex error - Pricebook error [closed]
//Please help me with error 'field integrity exception: PricebookEntryId (pricebook entry is in a different pricebook than the one assigned to the opportunity)'
// Below is the code. It is giving ...
4
votes
2answers
897 views
Junction object in Salesforce
What kind of relation should a junction object have with it's parent objects?
What I know from Salesforce documentation:
The junction object should have master-detail relationships with the parent ...
5
votes
1answer
10k views
Get Standard PricebookId in Apex Class
I have a situation where I was querying standard pricebook with SeeAlldata=true in test class.
Pricebook2 pb2 = [select Id, Name, IsActive from PriceBook2 where IsStandard=True LIMIT 1];
Later I ...
1
vote
1answer
184 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 ...
2
votes
1answer
1k 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
...
0
votes
2answers
647 views
How to check is Price Book added in the Opportunity or not in, Apex class, Salesforce?
Description : I am overriding the functionality of Add Product button through code (which is present in related list of Opportunity, in Opportunity Line Item.)...i need to check is Price Book added ...
