You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Hi all, does anyone know how to calculate the prior fiscal year to date using bi publisher data mode

in General Ledger & Intercompany 1 comment

Summary:


Content (please ensure you mask any confidential information):

I am aware the I can use FRS, but I am being pushed to use BI publisher. My question is, do you guys know how to get the prior FYTD from GL_BALANCES tables based on the period_name that a user chooses?

For example, our fiscal year starts July 1st, so if I were to choose the period name: 'Feb-2024', the prior FYTD, should be the amount from 'July-2022' to 'Feb-2023'. Does anyone know how to calculate that?

Any help would be great, thanks!

Version (include the version you are using, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!