Hi @Wildtype, i think another way to do this is to change the Date Format on the Home > Set Preferences page so it will reflect on the report. Please note that anything you set on the Set Preferences page will only affect the user's account. Can you try changing it to MM/DD/YYYY? 😊

Hi @Varonis inc. do you still need assistance on this concern? Kindly provide us addtional information mentioned on previous comment above. Thank you!  😊 

Hi @User_US7FA, do you still need assistance on this concern? Kindly provide us addtional information mentioned on previous comment above. Thank you! 😊

Hi @Wildtype, per checking you may set the date format to MMDDYYYY on saved search by adding the formula below: Field = Formula (Text) | Formula = TO_CHAR({trandate}, 'MM/DD/YYYY') Hope this helps! 😊

Hi @User_G9KXL, Welcome to NetSuite Support Community! Our Gurus will review your question and conduct an initial investigation. We'll reach out to you if we have any updates. In the meantime, we invite other users to join the discussion. Thank you! 😊

Hi @User_SLI6X, Welcome to NetSuite Support Community! We're glad to have you here. Thank you for creating this thread. Our guru/s will look into your concern and reply to this thread for any updates. To other members who may have insights regarding this topic, feel free to add your comments by replying to this thread.

Hi @User_US7FA, upon checking, revaluations for open currency balances apply exchange rates as of the last day of the accounting period to calculate unrealized gain or loss. If you generate revaluations from the menu prior to the end of the period, the exchange rate for the current date is used. This is also documented…

Hi @Varonis inc., can you check under Customization > Forms > Transaction Forms and see under Type column, what type of form is this? Can you also check if the item used on the transaction has a taxable tax schedule assigned on it? 😊

Hi @User_MWO46, Glad to have you with us today! Thanks for posting your concern here. Kindly allow us to review your concern and we'll provide updates in this thread. To our members, please feel free to share your thoughts as well.

Hi @User_HWW8S, Thank you for posting here in NS Support Community and for being with us today. Our guru/s will look into your concern and reply to this thread for any updates. To other members who may have insights regarding this topic, feel free to add your comments by replying to this thread.

Hi @User_HTKPF, Welcome to NetSuite Support Community! Kindly allow us to review your concern and we'll be keeping you updated on the results. To other members of the community, feel free to share your thoughts.

¡Se acabó el tiempo! ✨ La respuesta correcta y su explicación figuran a continuación: Respuesta correcta: C Explicación: C es correcto El campo Moneda de las facturas de proveedor con Órdenes de Compra vinculadas ya no se puede cambiar. El campo Moneda de factura de proveedor proviene de su Orden de Compra relacionado. A…

Time's up, everyone! ✨ Kindly see details below for the correct answer and its explanation: Correct Answer: C Explanation: C is correct The Currency field of Vendor Bills with linked Purchase Orders can no longer be changed. The Vendor Bill Currency field is sourced from its related Purchase Order. A is incorrect You can…

Hi @Varonis inc., can you tell us more about which transaction record type is the finance charge form used? What is the navigational path in recording this? You may also provide screenshot of sample transaction where the tax code is not showing on the line item. Kindly cover any confidential information. Hope to hear from…

Hi @User_US7FA, For NetSuite OneWorld, there are types of exchange rates on accounts used to value financials: General Rate Type is used to translate amounts for accounts in the income statement, balance sheet, and other general purposes. Cash Flow Rate Type is used to translate amounts for accounts in the cash flow…

Hi @Kedalene, unfortunately, upon checking you can only unmark or mark all on the accounts from the revalue open balance page. The ability to exclude certain accounts from the page is a system limitation logged under Enhancement #298007 Have the ability to uncheck the "Revalue Open Balance for Foreign Currency…

Hi @User_SLDIG, were you able to check our comment above? Please let us know if you need further assistance. 😊

Hi @User_FZNHI, I would like to follow up on this thread. Please let us know if you need further assistance. Thank you! 😊

Hi @User_2LMHR, thank you for your response. Upon checking the system notes saved search, the User Notes... joint field is not available on the results tab and thus the reason it's not showing on the result of the saved search. This is because the user notes tab is not under or included in the System Notes tab of the…

Hi @User_FL4CK, We're glad to have you here. Thank you for creating this thread. Our guru/s will look into your concern and reply to this thread for any updates. To other members and users who also have insights that may help, feel free to join this thread!

Hi @User_SLDIG, thank you for your response. Can you check if the discount item is a non-posting one? You can view the discount item record on edit mode and under Accounting tab you can see if it's marked as non-posting. If it's yes then, it's a standard behavior of the system. Here's an example SO with non posting…

Hi @Kedalene, this is the email i've found on their website: support@xignite.com. You may explore the Xignite Website if you have further questions - https://www.xignite.com/contact-us 😊

Hi @Kedalene, since these are all created prior to enabling the intergration feature, it is the standard behavior that these existing ones do not get included in the update. This is a system limitation logged under Enhancement #150796 Once Currency Exchange Rate Integration is turned on for a newly created currency,…

Hi @Kedalene, per checking, NetSuite just follows the one that's currently available on Xignite at that time. Since you are using Xignite, this means that you are using the Currency Exchange Rate Integration. The Currency Exchange Rate Integration feature automatically updates currency exchange rates by the specified…

Hi @Kedalene, this can be found under Lists > Accounting > Currency Exchange Rates page 😊

Hi @Kedalene, thanks for the update. Have you checked the effective date of these existing exchange rates? As mentioned, 3rd party integration of currency exchange rates could not back-fill the exchange rates prior to the date of integration. Exchange rate update will apply prospectively only. Existing currency exchange…

Thank you for sharing your insights, @GauravAgrawal! 😊 Hi @Kedalene, were you able to check Gaurav's comment above? You may check the currency record under Lists > Accounting > Currencies if the Automatic Update checkbox is marked: Moreover, Exchange rate update will apply prospectively only. Existing currency exchange…

Hi @User_FZNHI, we would like to clarify if the cash sales report you were referring to is the cash basis of income statement report? May we know if you use the Cash Basis Reporting preference at Setup > Accounting > Accounting Preferences on the General Ledger subtab? Enabling this preference causes all standard reports…

Hi @Vernita, upon checking, unfortunately, the feature to update the department for amortization schedule is currently a system limitation lodged under enhancement #116233 Amortization Schedules: allow option to define a different department / location / class for the debit and credit amortization journal entry that is…

Hi @User_3BTXC, were you able to check the information above? kindly let us know if you still need further assistance on this. Thank you! 😊