Post Details

What is the process for assigning a new Number Sequence (Voucher) based on Debit/Credit on LedgerJournalTrans in D365FO using X++?

To assign a new Number Sequence (Voucher) based on Debit/Credit on LedgerJournalTrans in D365FO using X++, you can follow these steps: 1. Create a new class in the Application Object Tree (AOT) with the necessary methods to generate the new Number Sequence: ```java class MyNumberSequenceClass { public static Common generateVoucherBasedOnDebitCredit(GeneralJournalAccountEntry _ledgerJournalTrans) { NumberSeqModuleNumberSequenceController numberSeqModuleController; NumberSequence numberSequence; str voucher; // Get the Number Sequence Controller for the desired Number Sequence numberSeqModuleController = NumberSeqModuleNumberSequenceController::find(new NumberSeqModuleNum(NumberSeqModule::LedgerJournalTransaction, NumberSequenceReference::create('Voucher'))); // Generate the new Voucher number based on Debit/Credit if (_ledgerJournalTrans.AmountMST > 0) { // Debit numberSequence = numberSeqModuleController.numberSequence().select(); voucher = numberSeqModuleController.numberSequence().createNumberSequenceVoucher(); } else if (_ledgerJournalTrans.AmountMST < 0) { // Credit numberSequence = numberSeqModuleController.numberSequence().select(); voucher = numberSeqModuleController.numberSequence().createNumberSequenceVoucher(); } return voucher; } } ``` 2. Call the generateVoucherBasedOnDebitCredit method from your X++ code where you create or update LedgerJournalTrans records: ```java class LedgerJournalTransExtension { public void createOrUpdateJournalTransaction() { GeneralJournalAccountEntry ledgerJournalTrans; str voucher; // Instantiate and populate the ledgerJournalTrans object // ... // Generate a new Voucher based on Debit/Credit voucher = MyNumberSequenceClass::generateVoucherBasedOnDebitCredit(ledgerJournalTrans); // Set the Voucher field on the ledgerJournalTrans object ledgerJournalTrans.Voucher = voucher; // Save the ledgerJournalTrans record ledgerJournalTrans.insert(); } } ``` By following these steps, you can assign a new Number Sequence (Voucher) based on Debit/Credit on LedgerJournalTrans in D365FO using X++.




Leave A Reply


Name*

E-mail*