If I understood well, you have one file for P&L and BS? or are they different files?
If you source data is PERIODIC for both P&L and BS, you can configure FDM to import/export to PERIODIC Data View instead of YTD (which is the default value), HFM will calculate YTD automatically.
Would it solve your issue?
actually the above would not solve the issue. What i had to do is configure FDM to Periodic and then retrieve information from the previous period for the BS (from the TdataSeg) to create a closing balance. a little tricky but it works.
thank you in any case.
How do i close a thread?
You can do it so by using event script BefImport/AftImport to ensure your previous data is also mapped.
You can close the thread by marking as correct/helpful.