The first 6 columns are from the NetSuite search. I've then added my notes as to what each line refers to, and then what value I need to import pricing. If you open this in Excel, beware that the value 1-9 will get converted to a date.

I also cannot understand why this is a valid Formula (Numeric): CASE WHEN {pricing.quantityrange} = '1-0' THEN 0 END and so is this: ( SUBSTR({pricing.quantityrange},0,(CASE WHEN INSTR({pricing.quantityrange},'+') = 0 THEN INSTR({pricing.quantityrange},'-') ELSE INSTR({pricing.quantityrange},'+') END)-1) ) But combining…

@Patrick Fresnosa-Oracle based on research of articles in the NetSuite help systems I have created a second Payment Type for the new bank account. I am hoping that this will mean that auto created payments will have a valid Payment Type (based on the bank account) and then there should be no need to change this field when…

The sample script linked (re: flat rate shipping) could be useful - we will be investigating this in more detail.

@Richard James Uri-Oracle We are familiar with 'fieldchanged' SuiteScript, but we cannot find a trigger for when the total amount of a transaction changes (whilst in create / edit mode)

Thanks @Elychelle Gulen-Oracle That is useful to know this is the 'expected' behaviour. We will look to script changes to adjust the transaction lines to follow the Item's department.

Thanks, I've voted for that

@Niks Blando-Oracle My test item is set as follows: Customers on the first 3 pricing levels should be able to buy boxes of 10 at £99.99, and the higher 3 levels at £69.95 The pricing works correctly if they buy 10, 20 or 30 items, but if they buy 13 items then all 13 are charged at 9.99 each = 129.87 (when in theory they…

@Paul Reading - did you ever find a good solution for this? I am looking at exactly the same problem

My developer has created a workflow action script that will update the Location field based on the Adjustments sublist.

I can't be sure, but in most of the cases I've looked at, the 'wrong' units of measure on the inventory count appears to be the same as the one above it? This was in a location that doesn't use bin locations - so all items are in the same bin. But we have seen the same problem on counts where the item is the only item in…

It would appear the CSV imports are working OK now - it failed on some closed periods, but all Inventory Adjustments that were accessible seemed to update correctly. I then re-opened the closed periods and all transactions were updated as expected. I am still working on a solution to set this field on new transactions. I…

Transaction Import for Inventory Adjustment - using Standard Form CSV: Transaction before: And would you believe it - it has worked this time!!! 🤔 I'll try a larger import later - hopefully my previous problem was a random anomaly..... 🤞

Yes, the fix was issued yesterday and the problem appears to be resolved.

Thanks @Clarisa De Torres-Oracle - I have raised a New Case # 5628930

@Clarisa De Torres-Oracle - the first does not have 'Show Only Open Transactions' unchecked. I am aware of the problem with 'part payments' and our customised template deals with the 'Applied Transactions' column. I only unchecked that box in the example above to try and show what the Jan statement would look like if we…

Also worth noting that NetSuite's definition of the 'Termination Date' is the day after their last day at work. If you set it to their last day at work, then they can't access NetSuite on that day....

We only have basic support, and even if they accept this case, they will only tell me to disable all my workflows and scripts 1 by 1 to see which one is causing the delays. I will have to schedule some weekend working to look at this and see if I can identify 1 script/workflow that is causing significant delays, but I…

Thanks - that is very useful to finally see a screenshot of what it might look like....

FYI - My account manager has confirmed grid order is a 'paid for' SuiteApp - allegedly it is 'not expensive' but I'm waiting for a quote to see. I am still unable to find any screenshots or videos of the functionality, so I have no idea if this is even relevant / applicable to our issue?

I have Sandbox, but I don't have access to the SuiteApp. I'll contact my account manager to see if this can be enabled in SandBox. If anyone else has this enabled and can send me a couple of screenshots that would be really helpful to allow me to see if it is potentially useful?

Thanks both. Yes I do have workflows and scripts working on these transactions. The ones that may be causing issues would be 'field changed' actions (as they happen after the form has loaded, when data is changed). This means they won't appear in any of the standard performance monitoring (either the SuiteApp, or the…

For anyone else who comes across this problem, here is the response from my implementation consultant: The time off request import using the HR Data Import Tool is not new functionality, It is meant for go live purposes only. Unfortunately, we had issues testing this feature out and the support team suggest not to use it.…

@Angelica Mae Segador-Oracle - thanks - I did find one of those articles and create a saved search alert - it's a reasonable 'workaround', but I really do think this should be something that could be enforced by the system.....

@Michelle Jabanes-Oracle I have checked the role in live and sandbox (which is approx 9 months old) and the roles are identical. It does have the Perform Search permission set correctly. I can run the search and print the PDF in the Accounting Manager role for transactions in Feb in Sandbox without error - but if I try to…

Yes you can view the customer mapping rules, but there are no options to export, import, copy or anything useful that can assist with this transition.

Thanks Lyka. I'm happy to leave for now as the Subtab is working and we have a workaround for the other. If any other questions come up on this subject i would be glad to hear about them!

Yes, the Record is Parent box is ticked. Interestingly, I have since made a Subtab of all Parent Records and added it as a Subtab on a Customer Record. I filtered the search I created to Customer Name and got this same filter dropdown. It worried me somewhat, but the Subtab on the Customer shows the correct list of records!

Hello Lyka Below is a screenshot of the (child) field I need to filter on - it is sourced from the parent field which in turn sources from the Customer list. I'll add a screenshot of that field too: Parent:

Thanks.... I have worked out some of these: Yes, the end of year adjustment automatically recalculates if an employee books more leave this year The employees with apparently 'random' changes at the end of the year are caused by the initial Time Off Change applied when they started work this year being applied before their…