Hi @Angela Bayliss , @Cherry Eunice B Licyayo-Oracle I thank you very much for your support, I will try to talk to the technical department for another solution, thank you and greetings.

hello @Cherry Eunice B Licyayo-Oracle good morning The report we need is to bring all the supplier movements with the outstanding balance from a previous date, example: Aging: The idea is to have a single report for all suppliers with their initial balance before the movements and that the balance closes with what they…

Hello @Cherry Eunice B Licyayo-Oracle Is there any way within Netsuite that allows me to bring all the movements and transactions of suppliers for a date range but entering the initial balance from a previous year? Thanks in advance. Kind regards!

Hi @Cherry Eunice B Licyayo-Oracle Good day! On the contrary, I need the report with the initial balance for each supplier, but when I update the report the balances come out wrong, it does not show me the real balance for each supplier together, it only does it right for me so I filter one by one

!Hello @Alex Joves -Oráculo! thank you very much! I really appreciate your help, you are a genius! Big hug!

I did the test and it works well in that role by placing the URL, the problem is in the task list that it does not show it to me to create the bill from there

i have this permissions full: but it doesn't work

Helo @Dext3r thank you very much for the prompt response, but when customizing it does not show me those Bill and purchase order options

Hi @Ayitah Tallada-Oracle Thank you, I greatly appreciate the information, much success! Kind regards

Ok, what I understand is that the one-to-many function or vice versa has not yet been developed within NetSuite, right? Or is it available within an account that must be paid by the client?

Hello @Ayitah Tallada-Oracle Thank you for your prompt response, in what type of account does this function come? Thanks in advance!

Hello @Clarisa De Torres-Oracle, nice to meet you. We've indeed uploaded case # 6265807 and look forward to your response. Best regards.

Hello @Jervin Nicholas Teopengco-Oracle, nice to meet you! Fortunately, Oracle notified us that they were making the adjustment for the "LONGTEXT" field we needed on our clients' electronic invoices, so the issue has now been resolved. Thank you very much for your feedback, and we consider the case closed. Best regards.

Hello @Clarisa De Torres-Oracle, nice to meet you! We configured it as you suggested: And this is the subsidiary we need to make the accounting entries for the annual closing. When running the process, we're getting the same error: As I mentioned at the beginning of the query, we only have two purchase orders pointing to…

Hi @Clarisa De Torres-Oracle, how are you? Yes, I'm trying it out. I'll let you know when I get the results. Thank you very much.

Thank you, I leave you the information on how the accounting accounts are configured: This is an error alert Thanks in advance!

Hello @Clarisa De Torres-Oracle, specifically in this one that I show you

Thanks Clarisa, I already voted, I am closing the topic.Kind regards

Thank you very much, I'm closing the topic, best regards

Hi, @Michelle Jabanes-Oracle Thank you very much for responding. Yes, it is an employee search, but what is the reason that the text type formula does not bring the data? Best regards!

Hello @Clarisa De Torres-Oracle Thank you for your reply, I was able to solve it by grouping the clients by their internal IDs and placing the created date filter, now it shows me the KPI correctly, best regards

Hello @Jam Amper-Oracle how are you! Thanks for you reply. Is there another way to clear the date in the report? But from the criteria or with a formula, by filter it is not so viable since I can have many dates and I only need the oldest one to appear. Thanks in advance, best regards!

Hello @Patrick Fresnosa-Oracle Thanks for you recomendations! Best Regards!

Hello @Patrick Fresnosa-Oracle how are you? If indeed I was able to solve it with that, now I have the problem that when it has decimals in 00 it adds the amount and does not subtract it this is the formula, I don't know about the cases of decimals in 00, it doesn't do the subtraction for me thanks!

Hi @Wee Ming Thanks for the recommendations, I will try to review it with what you suggest to me, best regards

Hello @Clarisa De Torres-Oracle, I hope you are well! In principle the search has 2500 results, it seems strange to me that when you enter that it does not contain Nov.2024 the search takes 9 minutes to load, but if it only has the one that does not contain Dec.2024 it only takes 1 minute to load In any case, I will follow…

Hello @Patrick Fresnosa-Oracle, I hope you are well, thank you for your prompt response. I show you the search criteria: At the same time, in the result I have the Expected Receipt Date field as a summary, but it does not filter the dates in the purchase orders Thanks!

Hello Patrick, how are you? Yes, in the search I had the option none and within the formula for each subsidiary the "Amount" field was selected, in this case I had to remove the filter to select each account individually and it would be imported into an excel for the analysis of the balances.Thank you for your help, I am…

Hello everyone, how are you? I was able to solve it with the following formula: in the criteria: Result: I close the topic, thank you very much for all the support, best regards!

Hi @Clarisa De Torres-Oracle Thank you very much for your prompt response, ok I grouped the results by group and the results were left in two lines I ask you, is there a way to place the names of Elio and Valeria on a single line? Since it is the same ID of the prospects from the Name column