Dynamics Community Forum Thread Details

How to generate voucher number based on balance in data entity

Hi Everyone,

I have created a new custom entity to import records for all legal entity leder details (Global ledger import).

I am facing issue in voucher number generation. Now voucher number is generating for each line, but it should generate based on balance.

I have written code in copyCustomStagingToTarget method. I saw some blog in that they have used LedgerJournalEngine class. But i dont know how to use this class while updating created data.

public static container copyCustomStagingToTarget(DMFDefinitionGroupExecution _dmfDefinitionGroupExecution)
  {
LedgerJournalEntityStagingCrossCompany staging, stagingUpd;
DataAreaId curCompany = curExt();
LedgerJournalName ledgerjournalname;
LedgerJournalTable ledgerJournalTable;
LedgerJournalTrans _ledgerJournalTrans;
LedgerJournalEngine engine = new LedgerJournalEngine();

while select staging
where staging.DefinitionGroup == _dmfDefinitionGroupExecution.DefinitionGroup
&& staging.ExecutionId == _dmfDefinitionGroupExecution.ExecutionId
&& staging.TransferStatus == DMFTransferStatus::NotStarted
{
changecompany (staging.Company)
{
ttsbegin;
while select forupdate stagingUpd
where stagingUpd.DefinitionGroup == _dmfDefinitionGroupExecution.DefinitionGroup
&& stagingUpd.ExecutionId == _dmfDefinitionGroupExecution.ExecutionId
&& stagingUpd.TransferStatus == DMFTransferStatus::NotStarted
&& stagingUpd.Company == staging.Company
{
changecompany (stagingUpd.Company)
{
select crosscompany ledgerjournalname
where ledgerjournalname.JournalName == stagingUpd.JournalName
&& ledgerjournalname.DataAreaId == stagingUpd.Company;
NumberSeq numberSeq = NumberSeq::newGetVoucherFromId((ledgerjournalname.NumberSequenceTable));
stagingUpd.Voucher = numberSeq.voucher();
stagingUpd.update();
}
}
ttscommit;
}
}
}

Can anyone please suggest me how to write code to generate voucher based on balance and where i need to write code in data entity.

Thanks in advance

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL