Hi @Patrick Fresnosa-Oracle I've verified that I am the only user this is happening to, regardless of role. The CTA and RE are still showing on any version of the report that I pull, custom or standard, but they are not showing the accurate amounts. Looking for an end result in which I can access the standard report and…

Hi @Patrick Fresnosa-Oracle - Thank you for the follow up. It looks like we're unfortunately stuck with the bad penny on this one, due to both potential solutions having other impacts that are less desirable than the penny. Thank you for your time and expertise helping work through the options on this one. Have a great day!

Good Day @Patrick Fresnosa-Oracle I have cleared cache for the last 24 hours, the last 7 days, and the last 4 weeks. I have tried using a different browser (MS Edge vice Chrome). I have tried incognito mode. I have tried powered all the way down and back up. All attempts still end with my numbers for RE and CTA reflecting…

Hi @Patrick Fresnosa-Oracle I am using primarily the standard Administrator role. I have tested this issue in several custom roles as well, and against colleagues using the same custom role. The screenshot examples are from that testing. I was in the same custom user role that my end user was, and the difference still…

Hi @Patrick Fresnosa-Oracle - I floated the question to the Revenue Team, I'm waiting to hear back.

C. Conditions

Thanks @User_YYHE9, following as I have this same issue/question.

Hi @Patrick Fresnosa-Oracle Yes please! That's what we're trying to land here, since NetSuite's ARM doesn't run SSP Midpoint % natively, we have a custom field that we use FVP, High and Low, and runs by Item Rev Category to arrive as close as possible at an SSP Midpoint in the system. Right now our Revenue team also has an…

Hi @Patrick Fresnosa-Oracle - Thanks again for your response and follow up. I'm checking with the AR Team re : Your two clarification questions. When I hear from them I'll circle back. ***Edited : In the meantime, I drafted a saved search following your steps above, and the result from the Formula is a flat '1' in every…

Hi @Patrick Fresnosa-Oracle Thank you for your follow up, my apologies for delay in response. I want to be sure I understand clearly - The only two solutions to resolve the penny issue is as follows : A JE entry that incurs a manual transaction against the CTA account, which is not ideal due to the unavoidable and…

Hi @Patrick Fresnosa-Oracle Thank you for your response. The open balance is carrying in our AP Aging. The ER was entered in Feb 2024, and the payment was also in Feb 2024. Both transactions are in the USD Subsidiary, processed in SAR. Expense Report Payment Currency Revaluation Transactions Attempted Correcting Journal…

I made my CTA step match your CTA step Yours : Mine :

Hi @Patrick Fresnosa-Oracle - Finally had a chance to walk through your recommended steps above, and my outcome is as follows : Our Retained Earnings drops from ($420,028,363.54) on the Standard Balance Sheet report to ($392,977,819.04) on the altered report. Would you be able to verify for me once more - Does the Retained…

Hi @Patrick Fresnosa-Oracle - Thank you for following up. I've been tied up with month end closing (and for my company, quarter end closing as well) and haven't had a chance to try this option, but will this week and will let you know outcome.

Thank you Lyka @Angelica Mae Segador-Oracle 🙂

@User_DU7YV Thank you, that worked! Have a great day!

Thanks all - Was able to piece-meal something together and make it work. All input much appreciated.

Hello @Jagdish_Chamat and @Vajrala Madhu Reddy, thank you both so much for your responses. I should have mentioned in the initial post, I am not a developer and don't speak code 😕 I've worked with the advance html/pdf templates in NetSuite long enough to know my way around them fairly well, but not well enough to free-hand…

Hi @Patrick Fresnosa-Oracle - Looks like that works! Thank you so much!

Thank you for your response @Wee Ming - I'm a little confused as to what may have occurred on this end, because there have been no amortization JEs posted against this schedule, but its showing as 'Completed' status - Any thoughts on what may have caused this and how to resolve? **I suspect it may at least be partly due to…

Hi @Pierre_Plourde, thank you for the response. A conundrum : The 'Restrictions' for the user roles for folks creating our Vendor Bills are all set to 'None - No Default' - This should then mean that the Main Line/Header 'Department' should be blank, yes? (Only 'Employee Restrictions' are populated, the Restrictions subtab…

Hi @Micah Timbol-Oracle - Thank you so much for your response. I will share this information with the end-users involved in the process and let them determine if we can leverage this option. Thanks again!

I found great resources on Quizlet and Udemy, in particular Quizlet really helped prepare me. YouTube has some great videos too. In all sources, I just searched for NetSuite Administrator Certification Exam Prep or NetSuite SuiteFoundations Certification Exam Prep. ETA : I haven't pursued SuiteBuilder certification yet, so…

Thanks @Jeremy Guimaras-Oracle - I kind of figured this was the overall answer, but now can carry it back to my team as definitive. Appreciate your time!

Hi @Micah Timbol-Oracle … Any further insight on this one?

Hi @Jeremy Guimaras-Oracle, thanks for your response and the detailed information about the potential options. (Apologies, I was out of office on Friday) Curious, if I were to create a custom line numbering field, if it were cross-referenced in the csv file/csv field mapping, would that then allow the fields to present in…

Hello @Kristoffer Viray-Oracle Could I get some guidance on using the if condition on the advanced pdf template when the scenario is as follows : We have a custom field checkbox indicator of 'Netherlands Shipment?' on our Invoice form. We need a separate custom field 'Customer VAT Tax ID' to print on the Invoice if and…

Hi @Micah Timbol-Oracle Here is an example record :

ADVANCED FINANCIALS

Hi @Clarisa De Torres-Oracle, thank you for your response, this helps confirm expected behavior. Have a great day!