Best Of
Re: PDF Table Overlaps Page Header
Issue resolved.
It ended up being due to how the PDF header had been declared. After I made some changes to the header and to the body of the document that issue is no longer happening.
Basically, the height of the header was set as 10%, which was insufficient for the content of the header. The issue never manifested itself on the first page of the PDFs because there was an explicit <br> tag at the very beginning of the body.
Re: Doubts in Parent/Child Department on Reports
Thank you very much for your complete and detailed answer @Patrick Fresnosa.
Greetings and great week!😄
Re: Doubts in Parent/Child Department on Reports
Hi @Gustavo_VM,
To answer your questions:
1.) When making a report, the department filter always shows all departments in the system and not the departments of the selected subsidiary (is this normal Netsuite behavior?)
Upon checking this is normal behavior, despite restricting a department to a particular subsidiary:
Users (with Administrator and with view mode on that department) can still see and select the department in the report:
This is normal behavior. If you select a Subsidiary and an unmatched department, there will be no matched result since the condition in NetSuite report filter is AND meaning in this context: Department and Subsidiary.
2.) When viewing a report, after selecting a parent department, the report does not display any data. (Shouldn't it theoretically bring the balance of the child departments?)
The ability to roll up the Departments in reports to their Parent Departments is still an enhancement under 108496 Ability to roll up sub-departments/locations/class under their parents on Summary Reports (similar to Consolidated Subsidiary context), so you need to select its child one by one.
Apologies for this limitation.
Re: Closing (losing) an opportunity
Hi all,
This is why it was confusing, because it WAS changing the status from a Lead to Prospect when I was creating an opportunity, so I assumed it would change a Customer back to a Prospect if I lost the opportunity.
Tested and confirmed.
Confusing, but we got there in the end.
Thank you for all your help!
Re: Upload mid-life assets with Japan 200% Declining Balance
Re: How to add a NOTES field to a Saved Search setup screen
Thank you Patrick. As usual, you are able to find the SuiteIdea that I cannot.
That enhancement is just what I was asking for but was unable to find.
It sure would be fun to sit in with the decision makers who have ignored this enhancement for 10 years and try to understand their reasoning. The fix seems so simple and would help so many in small & big organizations.
Thank you again.
Re: Rest APIs - Please clarify if available for Custom Records and custom fields
Amazing! Thank you, Nicole Mendoza!
Re: Credit Card to pay employee expense reports
Hello there.
You can choose the Credit Card account on the Bill Payment record.
Re: Unable to reopen closed Sales order
Hi @User_USGXE ,
Yes it is possible to reopen the Closed Sales order
This seems more like a network issue , or please check any Workflow or Scripts triggering when changing the status of the sales order
Re: Item Demand Plan CSV import Error
Hello @Elychelle Gulen-Oracle
Thank you for help. It turns out you cannot directly edit the csv file with dates (as the format gets reset to m/d/yyyy.
After few troubleshooting, figured out that all data needs to be created in Excel with correct date formatting. Once done, save the final file to .csv for import.
Issue resolved !!






