Bill Quinn Red Ribbon

https://community.oracle.com/netsuite/english/discussion/comment/16910755#Comment_16910755 @Ramu Komireddy_9891 Did you review my reply before asking this? No, I am not satisfied with your answer. I read the documentation 19 years ago.

@Ramu Komireddy_9891 Thank you for your reply. Yes, I agree with you that the "Official NetSuite help" says what you describe. It has been that way since 2007 when I first started using NetSuite. I thought this was the behavior for 19 years. I never tested it until this week! Have you personally tested this functionality?…

https://community.oracle.com/netsuite/english/discussion/comment/16910693#Comment_16910693 @Shiela Marie Villaluz-Oracle Thank you for your reply. Have you personally tested this functionality? From my testing, the documentation your provided https://suiteanswers.custhelp.com/app/answers/detail/a_id/95392/kw/95392 is close…

The solutions we've discussed both rely on SuiteScript. Create a FedEx Ground No Label. On DSPO IF's the script changes shipping method from FedEx Ground to No Label. On DSPO IF's the script unchecks the Integrated Shipping Label field and sets the package weight to 1 We are going with #2 as changing the shipping method…

@Tigran Shahnazaryan Thank you for the reply. We decided to create a custom field on the SO that is a foreign key to the payment token "table."

@JoshPNW There is no standard functionality on this. We ended up scripting the solution. If I were to do it again today, I would likely use a combination of scripting and either a restlet or SuiteCommerce My Account. Please feel free to DM me if you would like to discuss.

The question is SuiteQL > How to detect a transactionline is deleted? There is no reasonable method to detect via SuiteQL

Sorry, I was not clear. When editing the Customer Center role, only custom records can be added to permissions. We are trying to understand when this happened. We do not think it was this way before 2023.2 but we are unsure.

https://community.oracle.com/netsuite/english/discussion/comment/16858578#Comment_16858578 Netsuite does not support stored procedures.

@CDuf Thanks for the idea. What you describe would work. What we are trying to do is be as performant as possible. We don't want to request all lines on a transaction unless we know for certain one line has been deleted.

@Michelle Jabanes-Oracle Are you getting any error messages? No error message Are you logged in as the administrator in NetSuite and try to edit the custom role; is that correct? Yes and Yes Have you tried clearing your browser's cache? Yes How about using a different browser and incognito? Yes How many users are affected…

Always check to see if the employee has scheduled saved searches, scheduled reports, or integrations under their email. Removing employee access will cause the schedule to stop and if other users rely on those searches/reports, they will be inconvenienced. Integrations will shut off.

Suggestions Edit Bill Payment and confirm the form is the same Confirm you do not have any permissions assigned to your employee record

Richard, There is no failure in the SOAP response. When the VB is inserted, the links to the PO show on the VB form. The link to the VB is shown on the PO form. When the VB is updated, there are no failures or errors. I get the same xml response as the insert. The issue is the PO no longer shows on the VB form and on the…

Ivy, Thank you for the idea. We need the Inventory Status on this report. Would you know the join we would need to make this happen?

BUMP - Has anyone worked with this? Our plan is to create a custom field ItemReceipt.Line.ClassTemp. Then write a user event script which will fire on update to move the ClassTemp to Class. Rather slow but straight forward. Thanks in advance!

In summary, I created a saved search with type=sales order to get the Line ID from the SO then using Applying Transaction to get the Item Fulfillment.Internal ID. I was then able to export this to CSV and use it as the basis for the SuiteTalk SOAP. The SO.Line ID is what was needed in the SOAP IF.orderLine to do the…

Just when you think you have a good understanding, NetSuite humbles you. 😀 Itemfulfillment.Line.Orderline is the LineID from the Sales Order. I can see this using SuiteQL. I can use NetSuite REST to pull the data via SuiteQL but I would really rather use a saved search but I cannot figure out how to have a saved search…

Howdy, I'm the originator of this post. The solution on your sales order is to update the COST ESTIMATE TYPE on the Sales Order to be Purchase Order Rate. If you always drop ship, then set this on the item and it will default to the SO. If you stock and drop ship, then write a bit of code to update the field when a drop…

This is resolved. This is the solution. Find the "AVA_TaxLibrary.js" and download it. Serach for the 'AVA_TransactionSublistChangedEvent' method Within this method look for below code if(context.sublistId == 'item' && cRecord.getValue('custpage_ava_context') == 'WEBSTORE'){ AVA_CalculateTaxOnDemand(cRecord, new Date()); }…

This is NetSuite case 4616050 

@Mikko De La Fuente-Oracle Yes, two different questions about the same process.

I am testing this and will let you know what I find. Should be done on Friday at the latest.

Joahnna, Thank you for the reply. The issue is we want to use <b> and <br/> which according to the documentation should work. Can we use HTML in field level help? Thanks in advance, Bill

This issue is solved, and it is applied only in the shopping segment of the site. The solution was to make a request to the NetSuite backend every 5 minutes while the user is logged in, this refreshes the session's timeout and avoids the forced log out after 20 minutes.

-Cali, Yes, this question is in regard to items which have transactions. If we cannot disable on the item, is there a way to disable the rule? The process right now is this: 1) Sales order created 2) Cash sale created 3) Item shipped 4) #2 creates the Deferred Revenue credit 5) #2 create the Deferred Revenue debit If we…

I've sent a message with all requested information.

I use Firefox as well.

Assumption - If Backorder is > 0 then Available cannot be > 0 If you want "PREFERRED STOCK LEVEL (37) plus BACK ORDERED (50) minus ON ORDER (96) " to return 0 then how about this? CASE WHEN…

I agree. I don't think this is possible. I thought about using an Analytics Data Set but I cannot figure out how it could handle all of the variables of credit memos, partial payments, etc. "Customer is required by their credit rating agency to submit a report showing the highest running balance of theirs customers within…