Tigran Shahnazaryan · CEO @ Novelance · Gold Crown

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.

In your Bank Details, you are using a "Custom View", so if you click on "Customize View", you can see where the Bank Detail is coming from: Most probably, it comes from the Bank Details record, where you most probably associated the linked Payment File Template ACH - CCD/PPD with your bank: Note that in some…

Hey @User_5FWNK, Did you specify a "Lag Type" or select the "Auto-calculate Lag"? Without that, the Operations would overlap even if you have the "Finish-to-start" as a Connection Type.

Hey @jitendrapratap, Typically, when an item is "received into inventory" via Item Receipt, the Inventory Details are entered at that time. It appears that items aren't received correctly, which is why you are receiving the error message when invoicing them.

Hey @Preethi Kondur, If you have tens or hundreds of thousands of items and transactions, the allocation schedules may take hours to run. When you are creating the schedules, ensure you define the criteria as specifically as possible to ensure the allocation applies only to specific transactions and runs faster. If you…