FCCS Data management by default does not load zero balances

Summary

FCCS Data management by default does not load zero balances

Content

Hi Guys,

We have experience interesting fact on Data management load, DM default does not load 0 (zero ) balances. It loads when explicitly we provide NZP in Amount expression while defining import format.

If we do not setup NZP we gets below warning in DM log file :

ERROR_INVALID_PERIOD.............. Invalid period specified in the file.

[ZP] - [Amount=0] "Total","0000","Actual","CEIX Primary Ledger","0000000","0000","1040","20272","YTD","211225","0000","Ending Balance","000","USD",0.0
Is this obvious behavior or DM?

Thanks!

Sandeep