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

How can I use a Smart List member to generate a target Period and Year?

Accepted answer


To try to dynamically create a mapping generic months to a Period and Year for each of the different Entities.

Content (required):


I have a requirement to move data stored against generic months (Month 1, Month 2, etc) to target periods and years based of of a period year selection.

For example, for Month 1 there is calculated data that needs to be copied into Jul->FY23, where both Jul and FY23 have been populated using a Smart List. The DATACOPY code would look like the below:

DATACOPY "M001"->"Begbalance"->"FY22" TO "No Month"->"Jul"->"FY23".

Month 2 would be as per the below:

Howdy, Stranger!

Log In

To view full details, sign in.


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