My Stuff
Review our AI Community Guidelines before posting AI-generated or AI-assisted content. Verify accuracy and include the appropriate AI disclaimer.
Action Required: Review and submit pending reconciliation matches before the NetSuite upgrade to avoid rework. After 26.2, unsubmitted matches will be unmatched. For more details, see SuiteAnswers 1047397
Comments
-
Votes still climbing, hope NS actions it soon!
-
and I know you asked for a search but this will get the job done. Otherwise your search will involve a complex formula in each column to capture only the select data As Carl said, it is hard, but can be done, I have before This Year Field: Formula(Numeric) Formula: DECODE(TO_CHAR(ADD_MONTHS({trandate},3),'YYYY'),…
-
thanks, appreciate that it was a simple fix!
-
Thx all, have got it to work and also managed for it to be sorted in the correct month order. My FY goes from Oct-Sept, so need to order logically Formula used was:…
-
Try: Field=Date; Summary Type: Blank; Function= Month; Formula=Blank This will give the month of date in YYYY-MM format. For example : If the transaction date is 1st July 2014 (07/01/2014) the result will be 2014-07. Thank You! Hi Amar, This wont work as I need to remove the YY and just group the month together. So need…
-
I looked into changing the subs and did a lot of testing in Sandbox. The issue that we always came across was relating to the currency and the consolidated FX rates. When we did the move testing in Sandbox all the historic consolidated rates changed and ended up changing the consolidated P&L and Balance Sheet. To qualify,…
-
Has anyone got a solution to this problem? I have setup as per the documentation from NetSuite and tested the connection before going to Excel and all is fine, however, when in Excel and trying to connect I still get errors. Errors are: Test Connection (within the Data Link Properties) = Test Connect Fail because of an…