Tigran Shahnazaryan · CEO @ Novelance · Gold Crown

Hey @Carissa, Are you trying to create 100 Price Levels with default values, such as 1% discount, 2% discount, 3% discount, etc? Are you thinking of doing this as a one-off exercise so you can choose the correct "Price Level" on a Quote/Sales Order/Invoice to calculate the price based on the Item Base Price?

Thank you, Team!

Hey @Gia My "Mei" Luc. Let's say you have 3 Inventory Transfers, and each has 5 lines. Are you trying to build a report to show that you had 15 lines in total?

Hey @Andri2, You won't know for sure unless you test the direct CSV import vs doing it via M/R script using the file from the file cabinet. Most probably, the direct import will be faster. You can try assigning 3 threads to speed up the process and leave 2 available for others. The best would be to buy 1 or 2 SuiteCloud+…

Hey @Vasya_2 , If you edit the search above the Saved Search name, you will see "Saved *** Search". For example, if you have "Saved FAM Asset Type Search", then you created it on the "FAM Asset Type" record. You can go to the "New Saved Search" page and create a saved search on the same record type.

Then, it might be a system defect. Please open a support case and ask them to investigate.

Hey @Vajrala Madhu Reddy, It seems to be caused by a custom script running on the Lead Record. You can check the scripts deployed on the Lead Record via Customization -> Scripting -> Scripted Records -> Lead.

Hey @Ranjith Rana, You can do that by selecting the "Billable" checkbox on the Vendor Bill's applicable lines and selecting the Customer in the "Name" field. Once done, you can create the invoice via Transactions -> Customers -> Invoice Billable Customers. If you don't have the "Billable" checkbox on Vendor Bills, it might…

Hey @Adinath Bodakhe, The native "Audit Trail" Saved Search is non-editable and doesn't allow adding the user Role. You can build an "Analytics Audit Trail" search and include the User Role, to replicate some of the features of the native "Audit Trail" Saved Search.

Hey @Tessa, The native "Reversal Date" field appears to be inaccessible from the General Ledger report. You can create a custom "Reversal Date" field and populate the value via workflow to show it on the GL Report.

Hey @tech work, Based on the Saved Search criteria, there are two Manufacturing Tasks that match it for Work Order # 88275: This is why you see two lines for Work Order # 88275.

Hey @User_Q1DPO, Can you set this on the Custom Segment and try again?

Hey @kdeardorff, Yes, it can be done via customization. Here is a sample code: https://netsuite.smash-ict.com/learn-how-to-generate-meaningful-amortization-journal-entry-memo-lines/

Hey @Nickey, Try entering "Taxable = False" and "Tax Item = None/Empty" and see if that works. I don't have access to a Canadian subsidiary right now to test it. I recall something like this worked years ago for a Canadian customer who had a similar request.

Yes, when Advanced Receiving is turned off, the GL impact of a Vendor Bill is DR: Inventory | CR: Accounts Payable.

Hey @User_JJC0O, You would need a script to mark the field in the Vendor Subsisidary sublist as mandatory.

No worries, let me explain. Let's say the SO has 1 line with $0 and 12 quantity with a monthly Billing Schedule. When you generate the first invoice, you will have $0 on the "Line #1". You would copy that line and enter 1,200 and a Start / End Date on "Line #2". When you save, a new RA will be generated. The invoice will…

NetSuite can accommodate almost any ad-hoc business requirements via Customization.

Some companies don't need an Item Receipt, so they have the "Advanced Receiving" turned off, and need to enter only the Bill/Invoice.

Invoicing will be a separate transaction. When you receive a drop-ship PO, you will generate an Item Fulfillment linked to the Sales Order.

Hey @Yumiko Fourbs, You may have multiple invoices created from a source Sales Order. Do you expect to change the Start/End Date every time a new invoice is created? The RA is based on the Sales Order, which is why NetSuite ARM is using the related Start/End Dates. If you have a $0 Sales Order and are creating Invoices…

Hey @Chris Haygarth ISDM, You can create a custom field and link to a Saved Search showing the Sales Order with a "Minimum" date. If you want to see the results directly via Project Saved Search, something along these lines should work:

@Zeen , We resolved this via a script that would create a Custom Record for each Billing Schedule entry.

Hey @Nickey, Try using the "Tax Item" not equal to "PST Tax Codes" and see if that works. What is the Internal ID of this field? If the above doesn't work, you can try to use a formula with the field ID as a criteria, which sometimes works if the field isn't available for selection.

Hey @User_1VBIQ, If you are talking about drop-ship POs, then "receiving" the PO is going to generate "Item Fulfillment" from the SO. There will be one transaction created.

Hey @brocha , Did you try using the "Same As Previous" option on the form for the State -> Zip fields?

Hey @User_M9P24, I recommend using "Name (Internal)" instead of "Name". In a Saved Search, the "Name" filter represents the Item Name, Display Name, VendorName, etc. You may get inaccurate or duplicate results (e.g., if you have several vendors on an item) if you use the "Name" filter.

Hey @Cecilia.J, What Expense Report Approvals do you use? (e.g., Enable Features -> Employees -> Time & Expenses -> Approval Routing) 

Hey @User_15Q1A, Natively, you can only show Pie Charts using the "Report Snapshots" portlet that relies on standard reports, not Saved Searches. There are multiple ways to display the results of a Saved Search as a Pie Chart via customization. For example, you can export Saved Search results to Google Drive, generate a…

Hey @C M, I assume you are on the standard/shared Tier and have no extra SuiteCloud+ licenses. I would recommend getting an extra SuiteCloud+ license. You can also upgrade to a Premium Tier for an improved Integration Concurrency and more performance upgrade options. You can refer to these articles for more information:…