Hi @JenSw! Thank you for sharing your workaround with me. Much appreciated. I will definitely try it and hopefully the client will be ok with it.

Thank you both again! On another note, are you aware of any other way to extract non monetary metrics? For example, for a hotel No. of Rooms sold or No. of Rooms available to be able to divide that Revenue or Income with this number and get the Revenue per Room or Income per Room?

Thank you @Angelica Mae Segador-Oracle! Indeed, the fields were used in Workflows! :)

Thank you both for your assistance @Tiru Chembeti and @Patrick Fresnosa-Oracle. The client does not have the Advanced Financials Add-on enabled.

Hello @Edo_Aroni! Thank you for reverting! I have enabled the Multiple Units of Measure as well! Any other ideas?

Hi @Micah Timbol-Oracle! Thank you for your input. I am still not getting what I desire. Now the column label changed to "Jan 2023 - Adjust 2023" I want to be able to see the period that I am selecting "Jan - Apr 2024" and for the YTD columns to see " Jan - May 2024". Any ideas on how I can achieve this?

Hi @Angela Bayliss and @Angelica Mae Segador-Oracle! Thank you both for your assistance. Best regards, Elina.

Hi @Angela Bayliss and @Angelica Mae Segador-Oracle! Thank you both for your input! @Angela Bayliss this is the approach I indeed followed for printing the invoice but I am also interested for an evidence of the prepayment that is not applied to a specific invoice and the printout is a bit odd:

Hi @Angelica Mae Segador-Oracle! I am afraid I don't know how to spot source code. The printing type that I am using is "Basic" and Layout is been customized as below:

Hi @Angelica Mae Segador-Oracle! Thank you for reverting on my issue. I am trying to imitate the "Payment Receipt" printout format, so as the information (Inv date, description, original amt, Amt Due and Prepayment amount) to be shown inside the table and not as "unapplied" amount.

Hi @Micah Timbol-Oracle ! Thank you for the steps provided! Are really helpfull!

Hi @Micah Timbol-Oracle! I don't have the ability to file for a case. It is considered of a low severity. Any other suggestions on how to approach this?

Hi @Patrick Fresnosa-Oracle! I know! What an issue!

Hi @Micah Timbol-Oracle! Thank you for your input!

Hi @Patrick Fresnosa-Oracle! The issue resolved by the support team! Thank you very much for your assistance.

Hi @Patrick Fresnosa-Oracle! Just I clarification; How can I follow up the above case??

Hi @Micah Timbol-Oracle! Thank you for reverting! Attaching a screenshot from the "Results" tab for this Saved Search for your reference:

Hi @Micah Timbol-Oracle ! Yes now it works thank you! So the depreciation column shows the Acc. Depreciation value? I also notice that a client where the depreciation history was not imported and depreciation was never runed yet, the report still shows wrong results:

Hi @Niks Blando-Oracle!!! I tried it yes! But now I get zero :/ I am also trying to take this saved search a step further and I was trying whether I can add each landed cost's cost category amount in the saved search. The client requested breakdown of the Average cost of the item that comprises from Purchase price and…

I think is now fixed!

@Niraj Tiwari we have the same issue. It seems that there is an issue with authenticator.

Hi @Clarisa De Torres-Oracle! Yes, I was able to review Angelas' response! Thanks a lot Angela Bayliss! We still have a frustrated client that complains about that, as she considers it unacceptable and that she can't provide to the auditor a GL analysis that contains opening balances in P&L accounts, as accounting wise…

Hi @Clarisa De Torres-Oracle! Yes, I am able to view the "Use subsidiary" and "Update" checkbox in Auto-generated numbering section. For on example on journals the "Update" button is greyed out.

Hi @Patrick Fresnosa-Oracle! Thank you very much for handling sensitive information! Yes the user is using the Administrator role and this is happening to all the users. I have also tried to print the VAT report in another environment and it worked perfectly fine. I can't understand why this client gets the above error.

Hi @Micah Timbol-Oracle Found it! Thanks a lot for your assistance!

Dear @Jervin Nicholas Teopengco-Oracle! Reaching you out again regarding custom segments on Budget vs. Actual report in columns filter. As the client is really frustrated is pushing for this, is there any workaround creating a custom report that the custom segments will be presented as columns, one next to the other?

@Vernita Hi! :) I am trying to add pre-fix per subsidiary and have separate numbering per subsidiary as well. I am wondering how I can enable the "Use Subsidiary" checkbox and update the existing created transactions.

Good morning @Micah Timbol-Oracle!! Attaching a full screenshot of the report: This is the standard report without any customizations.

Hi Elychelle! Yes it helped! Thank you!

Hi Herdi Rana-Oracle and @Niks Blando-Oracle, I have tried the build the proposed saved search but I am getting the below error on my formula: I changed the {account} name to "Landed Cost" which is the account set to cost categories of landed cost expenses, as advised but I am getting an error. Do you have any ideas how I…