Tigran Shahnazaryan · CEO @ Novelance · Gold Crown

Hey @Username.Taken, The 'Bill Date' filter is used to determine which Charges or Billing Schedules are included or excluded. Here are some screenshots of this native functionality:

Hey @Mel H, As you group the results by Period, you can show the Fulfillment Date in the drill-down. The formula for the "Current Month" will look something like: CASE WHEN MONTHS_BETWEEN (LAST_DAY({today}), LAST_DAY({trandate})) = 0 THEN {quantity} ELSE 0 END

Landed Cost Per Item can be assigned via the related checkbox: On this thread, the request was to match the Landed Cost from Item Receipts with Item Fulfillments, which could be done with drop-ship POs. Without drop-ship POs, we need to customize NetSuite to link the SO and PO to facilitate the reporting.

Hey @Elizabeth Vance, Yes, scrolling is the only navigational option for Analytics Pivot Table Workbooks. The reason is that the cells in the Pivot Table are essentially rendered as an Image/PDF and aren't individually selectable objects.

You can use Backflash & WIP together. The GL impacts you are seeing are most likely caused by using Backflush, which consumes all components up front, regardless of the number of assemblies completed. If you use Non-backflush WO Completions and instead Issue Components that match the to-be-completed Assemblies, you…

Hey @Maria Gabriela Barbosa-Oracle , Are those drop-ship POs? If yes, you might be able to create a line-level transaction search showing those details in one Saved Search. Previously, I connected Bills with Invoices via drop-ship SO and PO, so it should be possible to also connect Item Receipts and Item Fulfillments. Here…

Hey @User_68KLQ, Those are good questions, and it would have been great if NetSuite tracked those important changes. Currently, it is a limitation, and we can't get that data natively.

Thank you. Could you also advise if you use "Backflush"? With backflush, all components are consumed upfront and independent of the number of assemblies completed.

Hey @User_56FCN, Do you create the Work Order Close for all affected Work Orders before the month-end close? Also, what is the "Average Cost Completion Unit Cost" setting under Manufacturing Preferences?

Hey @User_BCKYD, It is available on all "Payment" transactions (i.e., Crediting Bank/Cash/Credit Card). The main such transactions are: - Bill Payment - Check - Customer Deposit - Customer Refund - Deposit - Journal - Payment - Transfer - Vendor Prepayment You can also use the Records Catalog for additional research:

Hey @Jet Zhang, That's a known limitation, and you need a script for that. Here is the related article: https://suiteanswers.custhelp.com/app/answers/detail/a_id/79644/loc/en_US

Hey @User_WQ5VV, You are right, it is hard to do that natively. For one of our CRM customers, we built an automation that selects one Quote as "Primary" based on various criteria. We then take the Opportunity "Projected Total", and compare it to the linked "Primary Quote" (i.e., where there are multiple attached Quotes),…

Hey @Glaced99991, You are correct - NetSuite doesn't have a native feature to restrict the maximum quantity per Customer and SKU combination. The scripting is the best option. The NetSuite CPQ can do that, too, but it will be more expensive.

Hey @User_3ANIA, That is the list of transactions that were "matched" and are ready for reconciliation. If you click on the "Review" tab that is beside the "Reconcile", you will have an option to "Unmatch" the ones that weren't done correctly:

Hey @kees.netsuiteadmin, I assume you are using HubSpot's pre-built connector. It has various limitations, and sometimes, HubSpot support can find a workaround. Did you open a case with them on this? In some cases, we need to build a custom integration if the pre-built connector causes too many issues.

I have seen this issue many times and often found ways to optimize it. At the same time, I don't know exactly what causes the slowness, your system configuration, and everything else that impacts the allocation, I won't be able to recommend a solution.

Thanks for checking. Yes, it seems the Outsourced POs don't follow any of the NetSuite tools and features designed for the Purchasing Module, which is an oversight. It seems that you need a customization to generate non-consolidated Outsourced POs for Work Orders in Bulk.

Can you try the "Order Items" option and see if that works for your configuration?

Hey @User_QZRZD, Yes, you can do that. NetSuite uses Advanced PDF for invoices, and the template can be customized to present the required details in the desired format.

Hey @User_Q3A12, NetSuite has the ACH Prenote functionality in SuitePeople to ensure the employee's banking information is accurate. ACH Prenote isn't available for Vendor Payments within the Electronic Payments functionality.

Can you please check what the Accounting Preference → Order Management is set for "Maximum Purchase Lines to Consolidate"? If you set the value to "1", the POs shouldn't get consolidated.

Hey @TEN, Most probably, it is a defect with the bundle. There is a chance that some of the data within the bundle got corrupted. Or, the 26.1 upgrade impacted its functionality. The best is to open a Support Case with NetSuite and ask them to investigate the issue and provide a resolution/fix. Thank you.

Hey @Deano_M, Do you have a Journal that was applied to an open invoice to clear the AR? Please share some more details or screenshots to help with troubleshooting. Thank you.

Hey @Angel mariya T. P., If the vendor is shared, you still want the POs to be separate for each Work Order?

Hey @User_Z9PD8, You can create Pricing Groups and attach Items to those Groups. You can also create Price Levels to assign to Price Groups on Customer records. For example, Item A = Tier 1 and Item B = Tier 2 Price Level 1 = 10% Discount and Price Level 2 = 15% Discount. Customer ABC can have Tier 1 at Price Level 1,…

Hey @Pallavi1903, NetSuite expects that the number of records will gradually increase, and in most cases, those records aren't being deleted. In some cases, customers are advised to move to a higher-performance tier when their database size becomes too large. Billing Schedules are lightweight and don't have a noticeable…

If the field is checked to show on the form but is still hidden from the UI, it means NetSuite is hiding via native/back-end scripts. That's per design. Most probably, it hides it under specific circumstances. You might be able to show it via a custom field.

I see what you mean. Workflows typically have a minimal performance impact. Did you check the APM logs to see which scripts or workflows take up the most time?

I am glad it worked!

Please ask the team that receiving those items into inventory to enter the Bin/Inventory details during the receipt step.