Best Of

Hello @Elina Kourouzidou

Unfortunately, the reporting requirement can only be achieved by customizing the report to add additional Amount columns and select the Accounting Period for each.

Enhancement 130536: "One World: Please allow to run Consolidated Balance Sheet by Accounting Period, Quarter, Week, and etc (to show the as of balances)" has been logged to request this functionality.

You may consider doing the following:

1. Set the Report's As Of Date = Dec 2025
2. Click Customize and under the Edit Columns tab, add additional Amount columns for each Accounting Period from the Current Year.
3. Use the Alternate Period Range Type = Relative to today's date
4. Set the Alternate Period Range = Custom and select the Periods as needed. (One Amount column for each Accounting Periods from Dec 2024 until Nov 2025)
5. Save the report.

If you will use the same custom Balance Sheet report for a different year (say 2023 or 2026), you will have to customize the report again and manually select the accounting periods.

If you haven't already, I recommend that you submit a support case so it can be attached to the enhancement.

Let me know if you have questions.

@BM136

Apologies, I missed the last question -

What is the worst case that can happen? There is a 'delete all data' button that once clicked, and all confirmations are complete - truly does delete all of the data! (I tried it once in a sandbox account). I can think of a lot of things that someone could come up with - but there's no reason to ratchet up anxiety.

What really matters here is YOUR perspective. If you have an administrator running amok in your account your best option is to find a trustworthy consultant who will comb through your account with the steps I outlined above - and then they can create the searches to monitor the configuration tasks. If the person has already been locked out, and your employees are able to perform their jobs, I recommend that you go talk with the accounting department. If they are not concerned about weird changes in their financial statements around the time the admin was running amok, then you can review your deleted records log.

Like I said, there are some things that can be done = but all of them include vetting any administrator in your account. Do your homework and don't rush. After all, it's someone you're trusting your ERP system with.

Good Luck. Let me know if there's anything else I can help with.

If it helps anyone, I was able to successfully submit a payment after turning on the Check box in
Setup → Company → Enable Features → Transactions
✔ Payment Instruments

This allows you to submit the customerPayments.paymentOption field. But it does not correctly assign the configured PaymentMethods to the payment. it assigns a different name value than the submitted InternalId

Hello @Andrii Siryi,

Good day!

Following up on this thread in case you missed my previous comment.

Hi @Andrii Siryi,

Good day! Sending a follow up on this in case you haven't read our previous reply.

Thanks!

You will have to write a script on customer payment and link Invoice and JE via suitescript.

Thank you for sharing your insight, @Miguel Ariza - Sol4IT

Hi,

Did the solution resolved your concern?

Let us know your thoughts 😊

Hi,

I would like to follow up on this thread. Please let us know if you need further assistance.

Thank you!

Hi,

I would like to follow up on this thread. Please let us know if you need further assistance.

Thank you!