Best Of
Re: Item Demand Plan CSV import Error
Hello @Elychelle Gulen-Oracle
Thank you for help. It turns out you cannot directly edit the csv file with dates (as the format gets reset to m/d/yyyy.
After few troubleshooting, figured out that all data needs to be created in Excel with correct date formatting. Once done, save the final file to .csv for import.
Issue resolved !!
Re: Set up a 100% non deductible input VAT in France
Hi @Yasmine BELAOUCH, from SuiteAnswer: 24324 were you able to create both of these?
- To create a nondeductible portion of the VAT
- Creating a Tax Code for the Reclaimable Portion of the VAT
As per SAID 30566, To apply nondeductible tax on a transaction:
Add items or expenses with nondeductible tax by using a tax code that represents the reclaimable portion of the VAT.
Here are the nondeductible and reclaimable portion of the VAT i created for testing purposes:
Nondeductible:
Reclaimable VAT:
- In the Nondeductible Rate Derived From field, select the tax code that represents the nondeductible portion. For example, in the previous procedure, the tax code for the nondeductible portion of the VAT is called Austria 20% ND.
- In the Nondeductible Expense Account field, select the expense account that the nondeductible tax should be posted to, for example Miscellaneous Expense. The selected expense account is the default value for the expense account column on the transaction.
Here's a transaction I created:
Here's the GL Impact:
As you can see the nondeductible portion of the VAT is now posted on the Miscellaneous expense account.
Hope this helps! :)
Re: Reports for emails and messages
Hey @tech work,
If you build a "Sent Email" Saved Search, it would show all messages sent to/from NetSuite.
Are you also sending Text Messages from NetSuite? If yes, are you using a third-party solution for that?
Re: How to get value customform field in Advanced PDF/HTML templates?
Yes, this workaround of setting a custom field to hold the Custom Form value using a Workflow is working for me.
Re: How add the 'Item Last Purchase Date' to the Saved Search
Hey @Ivan Babiichuk,
You might be able to do this via Item Saved Search and Transaction join. Here is an example:
Re: FAM Depreciation Entries Approval Process
I believe this has been resolved. Thank you for your time.
NetSuite Admin Tips | Custom Fields: Workflow Dependencies
Custom Fields are key elements in various NetSuite records and transactions used to display specific information specific to a company’s business needs.
In this article we are going to learn how to check if Custom Fields are being used in Workflows. This helps you know if there are dependencies on your Custom Fields before deleting or making any changes.
Here are the steps on how to check the dependencies of the Custom Fields:
Note: On this example, we are using a Transaction Body field.
1. Navigate to Customization > Lists, Records, & Fields > Transaction body fields
2. Click on the Custom Field you wanted to check (In this case, we are using NSC Test Body Field)
3. On the Transaction Body Field page, hover onto the Action field and select either Check Delete Dependencies or Check Inactivate Dependencies
4. Once clicked, you will be redirected in the Dependent Records for NSC Test Body Field with the details below:
On this page, we have useful information like Workflow Name, Workflow State, Workflow Action, and if the field is being used as a Condition. With this, it should help us determine if we could delete/change the custom field we are viewing.
Try this and let us know how it goes by posting your comments. If you have other tips on how to check custom field dependencies, share them in the comment section as well.
Re: Item Demand Plan CSV import Error
@User_7NK3Q Please ensure that the date format in your system preferences matches the format in the CSV file, such as MM/DD/YYYY.
Re: Display which subsidiary user is working with
Users can natively switch between subsidiaries if the role is set to multiple subsidiaries, and the user sets the subsidiary they are working in by going to Home>Set Preferences>Restrict view - and choose the subsidiary that the user wants to work in.
Your question was about showing the user what subsidiary they are working in at any given time, and the answer to that is - No. Natively, there is no indication of the subsidiary the users are working in at and given time. The only way to tell this using your script or the native 'Restrict View' is to see what subsidiary is available on the transactions they are creating.
~angela
