Best Of
Re: Deletion of Transaction Records
Hello @User_XQ321
all related records should be unlinked first. This is done by editing the related records and unapply the Customer Refund under Items tab> Apply subtab then try to delete the record again.
If a Customer refund is created from a credit memo, Pls check the SuiteAnswer Id 24570
Re: Trend Graph Time Duration
Hello @User_HPB3I
Currently adding a specific date range on Trend Graphs is under enhancement vide # 72177.
Alternative solution: Create a custom KPI and set the date range based on your requirement.
Re: Intercompany Transfers
Hi @GLL,
What was the failure mode of the CSV attempt; large number of records or errors?
I routinely transfer material between locations within the same subsidiary via CSV, but it does requires two transactions; one for reducing the inventory in the FROM location and another increasing the inventory in the TO location. These are Inventory Adjust transactions utilizing the same CSV file. With the proper set up, one adjustment transaction is created for each location and is easily deleted, prior to subsequent transactions, in the unlikely event the transactions do not match.
John
Re: Need inventory snapshot report
Hi @User_NC62U,
I suspect the large number of results is a factor of Locations, BINs, and Lot or Serial Numbers based upon the Criteria and Results set up. I have not tried to recreate your exact search, but my first thought is to try using Summary Type = GROUP in the Results.
For example a BIN On Hand search I use is set up as shown below:
Please try this approach to see if your results are closer to the desired results.
John
Re: SuiteAnalytics column negative scale issue
Hi @Mikko De La Fuente-Oracle ,
but In Oracle documentation, scale has the minimum value -84 which is more than -127,
nor did I see intermediate values, either -127 or 0+
after data analysis, also didn't find any logic, these values are not so big to round to 127 digits:
it looks more like a bug or some default or undefined, and I'm interested in what value I need to use in this case
Re: Vendor Bills - Payment Hold - cannot edit
@Sara Gregorsson If logging is not turned on it will be harder work.
On the Bill, under System Information, and then Workflow History, is there anything obvious to check first?
Also, if you go to Customization -> Scripting -> Scripted Records, scroll down to "Vendor Bill"
there is a tab for all the Workflows that are used on the Vendor Bill record. Hopefully you see something there.
2 other things to try...
1) If you open a Blank vendor bill, does it allow you to check the Payment Hold box?
2) Try switching the the original NetSuite form "Standard Vendor Bill"
Re: Vendor Bills - Payment Hold - cannot edit
My guess is one of 2 things are happening.
1) On the form, the field is defined as Inline Text or Disabled
2) There is an active workflow that is setting the field as Inline Text or Disabled
Re: SuiteScript 2.1 Get Text from Dropdown list selection
I was able to get help from tech support. The solution is that you have to do a lookup to find the text associated with the id in the list item.
When saving any record, you use the record.getValue({fieldId:theid}); function to get the system id of the chosen list item, but you cannot easily get the text.
The solution is below. The "search.type" will depend on the list type that you're looking for. The below is looking for an employee name, whereas if you're looking for a value from something like an accounting list you have to use that list name
var salesRepLookup = search.lookupFields({type: search.Type.EMPLOYEE,
id: salesRep,
columns: ['entityid']
});
var salesRepName=salesRepLookup.entityid;
Re: WATCH: Unable to Use Inline Editing Even When Feature Is Enabled
I just ran across this issue and none of those were the solution. It turns out that I had "Run Unrestricted" checked on the search, and that prevented the "Edit" toggle from appearing on the record's list page.
LissaM
Re: Cash 360 - anybody else using it?
Hello everyone,
It seems like this functionality is still not available in NetSuite. However, an enhancement has already been filed for this. It'll be great if we can vote for it and encourage others to vote for it as well. This way, it can be considered for future implementation. Here's the enhancement: 675795 Cash 360: Ability to have an Option to Show Cash 360 Tiles in other Subsidiary Other Than Employee's Subsidiary..
We apologize for the current system limitation.




