User_8FFLQ

We are using standard PDF templates. In order to work around, we use scripts to extract the USD/SGD exchange rate pairs and store it as a custom field. The PDF templates then use this custom field to calculate the equivalent values in SGD in the invoices.

in Exchange rate For GST/VAT Tax Reporting Comment by User_8FFLQ Jun 27, 2022 7:05AM

Got it to work!! An elegant workaround when buttons cannot be fully disabled. <#if record.approvalstatus=="Approved"> <macrolist> <macro id="nlheader"> <table class="header" style="width: 100%;"> <tr> <td style="height: 1px; width: 385px;"> </td> <td align="right" style="width: 398px; text-align: right;"><span…

in Purchase Order Approval Workflows Comment by User_8FFLQ May 21, 2021 9:35AM

Thanks to all for the comments so far. I think I may have found a perfect workaround to block printing/emailing of unapproved Purchase Orders. 1) Enable Advanced PDF/HTML for PO formats 2) Add an if-then-else to test the status of the PO. If status<>Approved, then print a PDF that says "Unapproved Purchase Order.... blah…

in Purchase Order Approval Workflows Comment by User_8FFLQ May 14, 2021 1:57AM

The user can add back the email button by re-personalization. So this is not a solution. Any way to remove "Create New" completely? Also is there a way to block emailing under "Commmunications"?

in Purchase Order Approval Workflows Comment by User_8FFLQ May 10, 2021 2:48AM

thanks for the valuable tips! Looks like there is no way to completely remove emailing under "Create New"? This will not meet our compliance requirements

in Purchase Order Approval Workflows Comment by User_8FFLQ May 7, 2021 1:30AM

thanks to the tip from Houdekb. It works!!

in Default Values In Custom Forms Comment by User_8FFLQ Oct 17, 2014 2:58AM

I can hide the field, but Netsuite will still use the sales rep as the owner of the record, preventing other reps from accessing the same record

in Default Values In Custom Forms Comment by User_8FFLQ Nov 8, 2013 1:39AM

The following is set in the role definition of our salesrep : Employee Restrictions own, subordinate, and unassigned Allow Viewing [Y] Department Restrictions none - no default Allow Viewing [N] Apply to Items [N] Class Restrictions none - no default Allow Viewing [N] Apply to Items [N] Location Restrictions none - no…

in Default Values In Custom Forms Comment by User_8FFLQ Oct 27, 2013 10:15PM

Hi, I used function TO_CHAR(value, '999,999.99') to force your output to 2 decimal places. This might help you as well. Good luck

in Quote PDF layout - displaying currency symbol and correct decimal places Comment by User_8FFLQ Dec 25, 2012 9:23PM

I have a scheduled report to show last month's Profit & Loss. In the report period I chose "Last Period". The result shows out on the screen correctly. However, when I schedule the report to email the results monthly, the results shows a period beginning of the year to last month. How do I get a scheduled report for just 1…

in Last Fiscal Month Comment by User_8FFLQ Jul 8, 2012 10:47PM

Thanks all. I did this and it works : On_Order (formula) = CASE WHEN {quantityonorder} IS NULL THEN 0 ELSE {quantityonorder} END To_Order (formula) = CASE WHEN {quantityonorder} IS NULL THEN {quantitybackordered} ELSE {quantitybackordered}-{quantityonorder} END

in Fields with Zero Shows Up as Blank Comment by User_8FFLQ Sep 5, 2011 4:54AM

We recently enabled Advanced Bin/Numbered Inventory Management because we needed to create kits that comprises members of individual serialized inventory. We were upgraded because of this requirement. Now I can't go back without Kits. And this new GUI is driving us up the wall. Netsuite should put the programmer to work in…

in New Ver of Netsuite is Killing us on Doing PO Receiving Comment by User_8FFLQ Feb 28, 2012 2:00AM

Thanks. After testing I found that printing of item # will not print out the ":" in the item name, unlike saved searches. So my mistake in posting this thread. Me bad.

in Printing Child Items on Packing Lists / Invoices without ":" Comment by User_8FFLQ Apr 16, 2015 6:50AM

It works!! Took me more than a day to figure out why I cannot find the field. Thanks for the great help!!

in Adding a Column "Parent Item" to Purchase Order Comment by User_8FFLQ Apr 16, 2015 10:04PM

I think this is the answer to my problem! Thanks!! My income account is wrongly assigned on the item record. Before I make the changes to the item record, I need to be sure of the implications of the change. How will it affect the reported numbers in the past month/years? If there are material changes, what should we do?

in Inaccurate Sales Order Report Comment by User_8FFLQ Nov 12, 2013 5:13AM

What's the phone number? I have always opened cases via the system, never had the need to call anyone until now.

in Inaccurate Sales Order Report Comment by User_8FFLQ Oct 28, 2013 8:58PM

We moved into our new FY in July, and wanted to reset auto-generated numbers after changing the document's prefix. I just realized it cannot be done, and an enhancement request 81339 was raised since 2008. I'm surprised this enhancement request has done been done for so long. Although we are not severely impacted by this,…

in Auto Numbering Comment by User_8FFLQ Jul 1, 2012 10:17PM

We have a similar issue. We just started using Netsuite since July 2011. We are Singapore based, and primarily sell in USD. Our Netsuite was setup with base currency in SGD, and have started to enter in the transactions. Our auditor requested us to report in USD instead of SGD, due to the fact that more > 90% of our…

in Chart of Account - Currency Change Solution Comment by User_8FFLQ Sep 6, 2011 6:51AM

We do not track the budgets/cost of the loan/demo gear. If you want to do that, I think you can do a sales order with the value of the loaner items. Put the PO ref# as your loan reference. Alternatively, you may want to put credit term for up to 60 days for this type of sales order, so that if items are not returned within…

in Samples/Demo Management Comment by User_8FFLQ May 2, 2012 2:24AM

Are these samples to be given away FOC? If so, a $0 sales order can be done. What we have done for demo that are on-loan is to do an inventory transfer to a separate location called "On-Loan". When the item is returned, we do another inventory transfer to the "for-sale" location.

in Samples/Demo Management Comment by User_8FFLQ Apr 29, 2012 11:34PM

User_8FFLQ Red Ribbon

Comments