Questions tagged [orderitem]
The orderitem tag has no usage guidance.
53
questions
1
vote
1
answer
61
views
Problem with a validation rule in Order Item
Hey everyone I'm kind of a newbie in my journey in salesforce. And I'm kind of struggling with this one validation rule I'm trying to write.
Now the thing is in Order Item there is the product code ...
- 13
1
vote
1
answer
225
views
Access Product2 lookup from OrderItem object
I'm trying to access fields of the Product2 parent from the OrderItem and running into a strange error, "No such column 'Product2Id' on entity 'OrderItem'". The following string of code ...
- 49
0
votes
1
answer
194
views
How can I add fields to the default order Item list view?
If I click the "hyperlinked related list title with count" on the Order Items related list on my Order page / layout,
Then it navigates to a default list of Order Items.
How can I add/remove ...
- 394
-3
votes
1
answer
571
views
How to ad order items to order [closed]
How do I create an order with orderitems.
The following code gives me error - Error CreateSummaryOrder Method does not exist or incorrect signature: void add(OrderItem) from the type Order (67:18)
I ...
- 37
0
votes
2
answers
350
views
How to only select orders, where orders contain orderitems
I have this query but it is returning orders where there a no orderitems present, how can i only select orders that have order items in them?
SELECT EffectiveDate, Description, id, (select order.id ...
- 37
1
vote
1
answer
286
views
What does "the order product has been reduced" mean?
We have been using Orders and Order Products for about a year in a really fundamental way, just to feed into a custom built Invoice object. It's recurring monthly Invoicing, so the values on the ...
- 318
0
votes
1
answer
260
views
duplicate alias: name error while grouping
We are using bundle products in salesforce and I am trying to display the Order products in a PDF document which I am creating using VF page.
In the Order detail page the Bundle products appear ...
- 265
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
230
views
how to add product to reductionOrder from apex test class?
I created a testClass that inserts an originalOrder with a product of a quantity : 4.
Then, i created a reduction order related to the OriginalOrder. Now, I tried to add product to the reductionOrder ...
- 1
0
votes
0
answers
1k
views
SOQL : Field not found but it exist
I am doing a simple query on orders but I get an error :
Query:
Select Id,(SELECT Id, OrderId, LineNumber from OrderItems) From Order
Error:
No such column 'LineNumber' on entity 'OrderItem'. If you ...
- 516
0
votes
1
answer
1k
views
The default value isn't getting selected in the picklist
I have a picklist field named Reporting type in the Quote Line Item object, for which I have set the default value as "Performance Reporting" at the field level.
And also, there are no ...
- 265
0
votes
1
answer
1k
views
Display record detail of child record in parent record's aura lightning component
I am designing a custom lightning component to display a list of OrderItem records in a tabular format on parent Order record detail page. The requirement is to display the record detail page of an ...
- 83
0
votes
1
answer
368
views
I want to copy Order Products to Contract Line Items using Apex
I have a requirement of creating Service Contracts when Order is Approved and add Order Products inside to Contract Line Items in Service Contract. Following is the code I am using to accomplish what ...
0
votes
1
answer
835
views
INSUFFICIENT_ACCESS_OR_READONLY Error on Order Items deletion, even though I am System Administrator
Even though I have a System Administrator profile assigned to me, and have the CRUD permissions on the Order Line Item Object, I am receiving the below error when I try to delete the Order Item ...
- 265
1
vote
1
answer
762
views
Check if "negative quantities" are enabled for Order Item using Apex
In Salesforce, there is a feature in Order Settings called 'Negative Quantities', which allows you to add OrderItems to an order with negative quantities. I am writing a script that syncs orders from ...
- 326
0
votes
1
answer
3k
views
Single SOQL query to list ALL Products with ALL Quote Line Items and ALL Order Products?
While both Quote Line Item and Order Product have a lookup fields to Product, no relationship name is shown in Workbench.
Further digging indicates a somewhat hidden PriceBookEntry object exists in ...
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
275
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
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
0
votes
1
answer
3k
views
Writing test class for order activate. Error: Required fields are missing: [PricebookEntryId]: [PricebookEntryId]
I've written a test class for order update, though I am stuck at some minor issue which I am unable to get through. My test class looks like:
@IsTest
public class TestCreateMyOrder {
static ...
- 133
1
vote
0
answers
51
views
Orderitems Javascript Button replacement for Lightning
Currently I have the following as a javascript list button that allows the user to selected records:
{!REQUIRESCRIPT('/soap/ajax/29.0/connection.js')}
var selectedRecords = {!GETRECORDIDS( $...
- 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
2
votes
1
answer
235
views
Override the OrderItem standard Edit page for some Order recordtypes without a controller extension
It is well-known that OrderItem doesn't support record types so you can't vary the page layout based on recordtype like you can for most other objects.
Given that OrderItem is a detail to Order, and ...
- 69.1k
1
vote
1
answer
2k
views
Custom (re)ordering of legend/bar segments in Einstein Analytics
Question:
Currently I can sort bar segments of a stacked column chart in asc/desc order or keep it unsorted. However I would like to sort them in a custom fashion like in the image. How to do it with ...
- 125
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
2
answers
3k
views
INSUFFICIENT_ACCESS_OR_READONLY, when deleting OrderItems in Apex
I am currently working on a lightning quick action which will update OrderItems on demand from a specified quote. If an OrderItem has no corresponding QuoteLineItem, the line item will be deleted. ...
- 51
0
votes
2
answers
906
views
Order Product Validation Rule
Is it possible to add a Validation Rule to Orders which checks a certain product name has been added to the order?
Basically the price book includes products a, b and c. If the user selects a ...
- 365
0
votes
3
answers
1k
views
Create Asset record from data on OrderItem and OpportunityLineItem records
Scenario:
When an Opportunity is closed/won, we are creating an Order record with the corresponding OrderItem records based on the OpportunityLineItems of the Opportunity. When the OrderItems are ...
- 63
2
votes
0
answers
586
views
OrderItem does not have ListPrice set in test, contrary to non-test
This is something I've run into and worked around, but it still annoys me because I have to write test specific things in my non-test code (and can't get to 100% coverage because of it).
I can find ...
- 383
1
vote
2
answers
1k
views
OrderItem doesn't have a recordtype, so how can use different page layouts depending on Order rectype?
I have different recordtypes for the Order object, and the line items (OrderItem) need to show different fields depending on the Order recordtype, yet I can't seem to do this. It allows me to create ...
- 1,703
0
votes
1
answer
86
views
OrderItem Creation via Enterprise wsdl call
I am trying to create via Enterprise WSDL create call an OrderItem record related to an order.
As per image below, inside my call i pass the OrderID, the PriceBook ID, Quantity and Line Description, ...
0
votes
0
answers
132
views
Products to opportunities, and the SortOrder field
While adding products to an opportunity in Salesforce, you can not specify the values for the 'SortOrder' field on Opportunity Line Items. That is very weird, and is a feature requested more than 7 ...
- 12.3k
1
vote
2
answers
3k
views
How can I provide a partner user access to a report with order product fields?
I have a report with Order and Order Product fields in it. The Partner Communities user has read permission to both Order and Order Product and no problem viewing them outside of reports (eg: in a ...
- 405
4
votes
0
answers
111
views
How to use Reduction Orders with decimal / non-integer quantities?
I'm considering using Reduction Orders to model the partial refund of an annual service. Example:
Create and Activate new Order A with one line, Quantity = 1, Price = $15000
Create and Activate ...
- 32.4k
0
votes
1
answer
724
views
Delete OrderItem Error
When I try to delete an OrderItem from an Order, I am getting a DML Mixed Exception. However, I am not updating any other object.
Am I missing something?
@istest
private class ...
- 47
1
vote
1
answer
146
views
Adding Field Set for Order Item
I am trying to add a field Set for OrderItem object but I can't see any way to do so. Is field Set not supported for Order Item? If not, then what could be the other way to have dynamic fields?
- 21
0
votes
1
answer
2k
views
ORDER BY a String which contains a number [duplicate]
I'm trying to 'ORDER BY' a String field which contains numbers. It orders like this:
1
10
2
3
...
I've tried whith LPAD, VALUE, *1, but nothing works.
THANKS all for ur help!
- 143
0
votes
1
answer
252
views
How to access OrderItems that are in a related list on Opportunity
The related list on opportunities contains records of order items which usually have an account name associated with them.
I have a requirement where if an opportunity's stage name is 'closed won', I ...
- 125
0
votes
1
answer
1k
views
Not able to access TotalPrice in OrderItem
Trying to write trigger on Order item .I have created new field called discount.I have to perform formula using trigger on TotalPrice(TotalPrice=Discount*TotalPrice).I am not able to access TotalPrice ...
3
votes
1
answer
630
views
Validation rule error messages not showing up on multiple entry Order Product page
I am working on Standard Order and Order Product objects. Here's the scenario:
Restrict users from entering more than 100 Order Product items in Quantity on an Order.
I've created a Rollup summary ...
2
votes
1
answer
478
views
Approval Process for OrderItem Object in Salesforce?
Does anyone know how to create a approval process for Object Order Product(orderitem) object in Salesforce?I can't find the names in the list of objects in the approval definition screen or find any ...
- 119
3
votes
2
answers
2k
views
Assign Product to OrderItem
I am trying to create an orderitem from visualforce page and I am getting an error
Attempt to de-reference a null object
while assigning pricebookentry.priduct2Id.Here is my part of code where it ...
- 13.6k
4
votes
2
answers
3k
views
INVALID_CROSS_REFERENCE_KEY, invalid cross reference id on Order Item Insert
I am getting the error "INVALID_CROSS_REFERENCE_KEY, invalid cross reference id:" while trying to insert an Order Item related to an order, by cloning the opportunity line item records using an Apex ...
- 41
1
vote
1
answer
539
views
What's the the apex:relatedlist 'list' parameter for Order Product History?
I'm trying to add the 'Order Product History' related list for an OrderItem (aka 'Order Product') to a Visualforce page that uses 'OrderItem' as the standardController:
<apex:page showHeader="true"...
- 694
2
votes
1
answer
842
views
The Ominous INVALID_CROSS_REFERENCE_KEY Error on OrderItem Insert
So in an attempt to convert an OpportunityLineItem into an OrderItem, I get the mysterious and vague INVALID_CROSS_REFERENCE_KEY Error on insert of an OrderItem list.
What's odd is my test class runs ...
- 2,815
1
vote
1
answer
550
views
Field is not writeable: Order.IsReductionOrder
I am trying to update Order.IsReductionOrder to true from a trigger but getting below error.
Field is not writeable: Order.IsReductionOrder
It looks like field is read only from Order ...
- 13.6k
8
votes
3
answers
8k
views
Product2 field in OrderItem Object
When I ran below query in workbench/developer console
SELECT product2 FROM OrderItem
am getting below error
No such column 'Product2' on entity 'OrderItem'. If you are attempting to use a custom ...
- 13.6k
2
votes
1
answer
3k
views
List controllers are not supported for Order Item
I am trying to create a custom EDIT ALL list button on OrderItem (Order Product) with content source as Visualforce page and am getting below error. I don't want to use standard EDIT ALL button as I ...
- 13.6k
1
vote
1
answer
711
views
List controllers are not supported for OrderItem
I am trying to do pagination for OrderItems using StandardSetController, however, when I am passing my query in setCon, I am getting following error.
List controllers are not supported for ...
- 13