My Stuff
Comments
-
You should have a "Schedule" field on the Journal Line where you can choose the required Amortization Schedule. Here is a reference screenshot:
-
Typically, the "Vendor Name" field on the Purchase Order line displays the "Vendor Code" if the Purchase Order is for the Vendor that is selected as a Preferred Vendor on the Item Record. NetSuite populates this value and can't be modified. I suspect the "Vendor Number" field in the screenshot is custom. You can create a…
-
You can do that via Saved Search. Depending on your configuration, you would need to use specific criteria and results, and potentially, some formulas. Here are some reference screenshots to help with the Saved Search:
-
Thanks for the clarification. The Assembly in your example may have a Quantity Available of 200. Is that what you want to show, or only up to the maximum of "Available to Unbuild"? If you want this to be visible primarily on the Form UI, you can achieve that via a custom field and a linked Saved Search. Here is an article…
-
It might be related to the missing DKIM setup or another step. You would need to go through this in detail and ensure all applicable steps are completed: https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/chapter_162516600357.html#subsect_162517444872
-
Hey @Lee Ann R, Are you referring to Component's "On Hand Quantity" or something else?
-
Hey @User_ZTPD3, I suspect the "Vendor Code" that you have is a custom field. Can you check that? Also, is it on the Purchase Order header or the line? Please share a few screenshots from your Item and PO records to facilitate the troubleshooting.
-
Hey @User_14Q68, Yes, you can do that. One option is to create Amortization Journals for each Vendor Bill, with the required amounts, and reference the Bill # in the memo. The JE will reverse the Expense and move the amount to the defined Deferral Account, and post to the Expense every month. You can also do it via actual…
-
Thanks for checking. Do you have the related profile populated as an "Associated Payment Processing Profile" for applicable "Payment Methods"?
-
Typically, you create it via Setup > Accounting → Payment Processing Profiles → New: Note that your specific configuration might require something different.
-
Hey @Valdi, Although you won't me able to dynamically update the MRP Workbench messaging, you can use these filters to filter out the alerts you don't want to see:
-
Hey @Valdi, NetSuite reports such as "Inventory Valuation", "Inventory Activity Detail", or "Stock Ledger" should give you what you need. In some cases, you may need to customize a report to add a required filter or a formula column.
-
Hey @KR Mike, Sounds like a NetSuite defect. Do you have a Shipping that is $0? If yes, can you try entering $0.01 and see if that resolves the issue? You can also try entering $0.00 vs. $0, which may work.
-
Hey @User_2CE7R, Did you associate the applicable Payment Methods with a "Payment Processing Profile"?
-
Thanks for the clarification. Could you confirm everything works correctly except when the Expense Report is created via Employee Center?
-
Hey @MTL_MIA, Yes, this is unusual. I have a few questions to try to troubleshoot this. Are you checking the IF via the Admin role? I want to ensure the items aren't restricted from your Role/Subsidiary. Are you using the Default/Primary IF From? Could you confirm you don't have any scripts or workflows on the IF record…
-
Hey @JingShien, Could you advise what "Subsidiary Setting" you are referring to?
-
Hey @Rizkygaus, I agree that it would have been better to display those items separately. However, that's done per current design probably to save development time, and we won't be able to customize the report to achieve the required result.
-
Hey @User_BNAZ6, The Manufacturing Cost Template impacts not only the Work Order Close, but also Work Order Issue and Work Order Completion transactions. Here is an example of the GL Impacts for each: https://suiteanswers.custhelp.com/app/answers/detail/a_id/27941
-
We didn't specifically build a script that you need. We built many scripts that regularly run on Project Tasks and Projects to make field updates and various calculations. In some cases, the script can be triggered when the user clicks something, saves the record, etc. In other cases, the field values are updated by NS…
-
Hey @User_WSIPL, I recommend referring to the following SuiteAnswers article to get you started: https://suiteanswers.custhelp.com/app/answers/detail/a_id/91460/loc/en_US
-
Hey @Gert Van Damme, You can build a scheduled script to run every 30 minutes. We sometimes create two deployments and schedule them to run in such a way that records are being updated every 15 minutes. Ensure to test all of that in the Sandbox first to ensure the run time doesn't overlap and cause concurrency issues.
-
Hey @PaulRipley, I haven't used it myself, but heard from my network that it is not that good, and an ad-hoc built Approval Workflow works better. Overall, I rarely hear anything positive, if ever, about Zone and its products.
-
If you have WIP, the best practice is to use the Average Costing. Creating new Items to replace the FIFO versions might be the best option. The change would impact the reporting and prcesses in the short term, but is the best option overall if you will continue using WIP in the long term.
-
If the "Hold" shows up in the System Notes, you should be able to filter the Saved Search based on it. If it is empty for other records, you would need to incorporate other field values in the CASE statement. Not having access to your system, it is hard for me to pinpoint what exactly is missing in your Saved Search.
-
The Tax Engine for Canadian Sales Tax is fundamentally different from the Tax Engine for VAT. For Canada, you can't directly change the Tax Rate on the Transaction Line, as it is based on the related Tax Codes, Tax Groups, Tax Control Accounts, and related preferences. There is a "Print Tax Code Summary on Sales Forms"…
-
Hey @Elizabeth Vance, There are a few ways to return TO1234 instead of TransferOrder#TO1234. Try SUBSTR({tranid}, INSTR({tranid}, '#') + 1) or REGEXP_REPLACE({tranid}, '^.*#', '') Without seeing your configuration, it is hard to troubleshoot the issue you have with the filtering. Did you try to use a "Location" instead of…
-
Hey @STrackwell, When NetSuite says the FIFO is incompatible with WIP, it means that the system won't be able to calculate the COGS reliably. You may be able to process the transactions, but the component consumption won't follow the FIFO costing. The best option is to use Average Costing if you have WIP.
-
Hey @Brian Finlay, The formula itself appears to be correct. When you use a reference to System Notes in the results, you get duplicated lines, unless you enter particular criteria to limit the results. In some cases, you need to Group/Max the results to avoid duplicated lines. You can probably enter a System Note criteria…
-
Hey @Thom62, You are correct - NetSuite natively hides the Tax Fields for Canadian Subsidiary Transactions. You should be able to get the tax breakdown for Canadian Transactions via reporting. If there aren't native reports that do that the way you want, you should be able to do that via Saved Searches and formulas,…