Tigran Shahnazaryan · CEO @ Novelance · Gold Crown

Hey @Mike F Blend, Natively, it appears that we can identify 'Journals created from Memorized Transactions' only via Analytics Workbooks. Saved Search doesn't appear to have access to that information, so we can't use it in Workflows. Perhaps there is a workaround, other than a customization, to stamp 'Memorized' on JEs…

Hey @Daniel Katzman, What you have is a bad practice and not scalable. You need to have one Item shared across all subsidiaries. The BOMs should be updated to reflect that. Doing it any other way will keep causing all sorts of operational and reporting issues.

Most probably, the 'Transaction Line Distribution SuiteApp' scripts were designed to trigger only when the Vendor Bill is created by a user via UI. When the Vendor Bill is created by the system via Bill Capture, the 'Transaction Line Distribution SuiteApp' doesn't trigger. You can open a support case with NetSuite and ask…

Hey @Elizabeth Vance, When you enter a filter, you interfere with the 'MAX' logic, which is why it stops working.

Hey @User_V5KBL, Does everything work as you expect when you create the Vendor Bill manually?

Hey @User_XXTWN, Could you share screenshots to help with understanding your challenge? Thanks.

Hey @Maria Gabriela Barbosa-Oracle, That's a great question. Such a feature would have been very helpful. There isn't anything available that can do that. In practice, it would be extremely hard to achieve and would be possible only if NetSuite builds a tool to do so, as even with scripting, it will be hard, if not…

I know it can be done via scripting, but I don't have step-by-step guidance. I recommend working with an experienced NetSuite Consultant to build this customization.

Hey @Fartleby, When approving Purchase Requests via Employee Center, are you using the Approval Routing Feature? Thanks.

Hey @JingShien, The automation via scripting is the best option. We built similar automations and could even set the required frequency (e.g., run every 3 hours, daily, weekly, etc) or other criteria (e.g., only run for transactions with the following departments, amounts, etc).

Hey @Mark Gildea-Oracle, Could you provide more details, with screenshots, to understand what you are trying to achieve and what doesn't work. Thank you.

The installed bundle has it, but you need a custom version. Check with NetSuite Support if you can customize the PDF that comes with the bundle. If yes, that would be the best. Otherwise, the SuiteLet would be the other best option. You can't print custom Advanced PDF via Workflow.

Got it. If you need to create a completely custom Advanced PDF, you can do that via Custom Button + SuiteLet that prints a custom Advanced PDF.

Hey @User_S6FVQ, Please follow all the steps in the following guide and let me know if you still have any issues: https://suiteanswers.custhelp.com/app/answers/detail/a_id/1019536/loc/en_US

Thanks for checking. Can you ask the user to try another browser to confirm the issue isn't browser- or extension-related? Another thing to try for the user is logging in using VPN or another internet connection to confirm the issue isn't IP-related. If your and the user's subsidiaries or departments differ, some…

Hey @David B Aus, Do you know when your account was upgraded to 26.1? Some of my customers started having permission and access issues after the upgrade, which ended up being defects that NetSuite helped to resolve. The best is to open a Support Case with NetSuite and ask them to investigate.

Hey @User_HM9P7, Do you know when your account was upgraded to 26.1? I have seen various issues caused by the upgrade. The best is to open a Support Case with NetSuite and ask them to resolve the issue ASAP.

Every matched transaction can be unmatched, and it appears this was done intentionally. You have to match them again with the related Bank Statement entries.

Hey @User_BRU1F, You won't be able to do it via the native report, as canned reports have limited customization capabilities. You should be able to build the report you need via Saved Search or Analytics Workbook.

Hey @David Achkar, The 'Bulk Processing' is a context and doesn't necessarily mean it was done by the system. Can you check with the user specified under 'Set By' to see if they might have multiple unmatched records at once (via a bulk process)?

By default, these are set to 'No' on Customer records, and flow to Sales Orders and invoices: You can hide these fields (or the Preferences tab) from Transaction forms so they can't be modified. You can also build a workflow to set these fields to 'No' + 'Inline or Disabled' on Transactions.

I suspect that you may have scripts or workflows in your system that impact that. What you are experiencing isn't something I have seen. Per native functionality, the date you specify is what is posted on the generated invoice. I just retested it: Perhaps the best is to open a Support Case with NetSuite and ask them to…

Hey @Michalis_Kyriacou, We noticed that the 26.1 upgrade caused issues with various features, roles, and reports. Please open a Support Case with NetSuite and ask them to resolve this potential defect.

Hey @MrRon, There is a chance some of the scripts within the bundle didn't get updated correctly. That's a system issue. Removing and reinstalling the bundles should resolve the issue. However, with this method, you would need to manually add the original configurations and customizations you made. The best is to open a…

Got it. The Date that you enter in the 'Invoice Date' field is what you will see on the generated invoices:

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…