For more information, please refer to this announcement explaining best practices for getting answers to questions.
Balance Initialization in Mid Quarter
Summary:
Hello Experts,
Please let me know the implications and possible solution with the Mid Quarter Balance Initialization load with Quarter to date Balance Dimension. We are going live in mid of 2nd quarter and balance initialization would be done for:
a) 1st Quarter (01-Jan-2024 till 31-Mar-2024) with Quarter to Date Dimension
b) 2nd Quarter (01-April-2024 till 30-April-2024) with Quarter to Date Dimension
Below is the sample data:
BatchName|LegislativeDataGroupName|LineSequence|Value|UploadDate|PayrollRelationshipNumber|TermNumber|AssignmentNumber|DimensionName|BalanceName|LegalEmployerName|PayrollName|BalanceDate|TaxUnitName
Balance Initialization_Load|US Legislative Data Group|1|10|03/31/2024|100193|ET100193|E100193|Relationship Tax Unit Quarter to Date|Test Balance 1|Legal Employer for Cloud|Biweekly|03/31/2024|TRU for Cloud