Best Of
Re: save search - item availability today formulas help
Hello Gabriel,
You can use the the second formula (Using Partition by) explained in the below post
https://community.oracle.com/netsuite/discussion/4476066/add-running-balance-column-in-saved-search
But first, I suggest to create a custom body field (Formula) to help you flag the transactions that need to be included in the formula.
To summarize,
- Create a transaction body field (Non Store) and make a formula using CASE WHEN to flag the sales orders with QTY committed ZERO.
- Create a formula column in the saved search (Over Function using partition by, as explained in the mentioned post).
I hope this would help!
Ibraam
Re: Price difference between Purchase Order and Item Receipt
Hello @Dirk Nieuwkamp,
Per my understanding, you want the rate on the Item Receipt to be sourced from the Last Purchase Price on the Item record and not from the rate on the Purchase Order.
Upon checking, the expected behavior is possible via Workflow. Kindly reach out to your in-house developers for the creation of one as Support team cannot assist on creation of a Workflow from scratch.
I hope this helps. Thank you. 😊
Re: Analysis of profit and loss
Can you check the "Comparative Income Statement" standard report.
Re: Can you create a budget to a custom segment?
Hi Everyone,
I already found the answer. The custom segment should have the "Show in List" ticked.
Re: Client Script Line Validation - trigger when Sales Order created from Estimate
@Mikko De La Fuente-Oracle - no I don't think that will work. The problem is that the information is 'missing' from the Estimate, but needs to be 'required' on the Sales Order.
I can't make the fields mandatory on the Estimate (because initially the data will not be available), but it should be available before converting to a Sales Order. I just need to ensure that this information is present on the Estimate before the Estimate is converted to a Sales Order (because the Sales Order then generates a Purchase Order, and it is critical that the information is on the Purchase Order).
I think I'll work on preventing the Estimate being converted if the information is not present.
Re: How to make an opportunity line field mandatory
hi HertsChris
you can deploy a script to make the field mandatory at line level if only needed at opportunity.
You can also create a field and expose it only to opportunity form instead of other sales transaction like invoice, sales order.
Re: how to print setup
Hi MA User_576EZ,
you can do a full page print but doesnt reflect the checkbox checked.
Try exploring chrome extension GO FULL PAGE to print the entire page print.
Re: How do I update our logo on our customer invoice templates?
Hi ,
1) There are 2 ways You can update logo One directly update in Company information as mentioned in Above answer Which Is recommended.
2) Need Separate logo for invoice based on requirement we can also upload in Documents -> File Cabinet-> In any folder which you prefer (images) .
Open the advanced pdf find the <img src="${companyInformation.logoUrl}"
replace the ${companyInformation.logoUrl} with url of your image which you uploaded in file cabinet and set the height and width using style.
e.g: <img src="logoUrl" style="width: 200px; height:100px;"
Thanks
Re: How to make an opportunity line field mandatory
Use LineInit Client Script function :
var tranRec = context.currentRecord;
var sublistObj = tranRec.getSublist({
sublistId: item,
});
sublistObj.getColumn({
fieldId: "YOUR FIELD ID",
}).isMandatory = true;
Re: Invoice Sales Order > Error: Invalid location reference key for Subsidiary
Hi @LLG,
Thank you for sending the screenshots. 😊
Upon checking, the Location (internal ID: 2) is not associated with Subsidiaries (internal ID: 2 and 6). It is the Subsidiaries that are associated with the Location's Subsidiary which is not the same.
The Location (internal ID: 2) is only available for the Subsidiary selected in the Subsidiary field.
According to Subsidiary Field Help, if you have purchased the OneWorld upgrade for your NetSuite account, you can associate this location with one or more subsidiaries.
- If the Inventory feature is not enabled, a location can be associated with none, one, some, or all subsidiaries. To select multiple subsidiaries, press and hold the Ctrl key while selecting each subsidiary.
- If the Inventory feature is enabled, a location can be associated with only one subsidiary.
It seems that the Inventory feature is enabled on your end and only one subsidiary is available for the Location (internal ID: 2).
To be able to invoice the Sales Orders without the error, either you change the subsidiary of the Sales Orders based on Location (internal ID: 2) or change the Location of the Sales Orders applicable to Subsidiaries (internal ID: 2 and 6).
I hope this clarifies your concern! 😊
=======================
If you find this reply to your question as helpful, others with the same question might find it helpful as well. By marking “Yes” on the “Did this answer your question?”, you’ll be able to aid the community to find the solution much easier and faster without the need to read through all the replies, and you will also get closer to earning your next Answer Accepter badge.



