Settle Clearing Entries (Postdated Check) Status



Settle Clearing Entries (Postdated Check) Status



Recently I face the issue that after posting of payment journal status of a post-dated check was not changed from Open to Post. I have lots of R&D in this but no luck,

So I write a batch job where will change the status of custVendPosted check for me.






    LedgerJournalTable _ledgerJournalTable;
    LedgerJournalTrans _ledgerJournalTrans;
    CustVendPDCRegister custPDC;
    Counter             _counter=0;

    while select forUpdate custPDC
            where custPDC.PDCStatus==PostDatedCheckStatus::Open
            && custPDC.MaturityDate > systemDateGet()
          exists join _ledgerJournalTrans
            where custPDC.LedgerJournalTrans==_ledgerJournalTrans.RecId
          exists join _ledgerJournalTable
            where _ledgerJournalTrans.JournalNum==_ledgerJournalTable.JournalNum
            && _ledgerJournalTable.Posted==NoYes::Yes
    {
               _counter++;
               custPDC.PDCStatus=PostDatedCheckStatus::Posted;
               ttsBegin;
               custPDC.update();
               ttsCommit;

    }
        info(strFmt("Total Number %1 of records updated on %2.",_counter,today()));


Support Faryal's Cusine


Form Data Source Field Method Override D365FO


Form Data Source Field Method Override D365FO



In this demo, I will show to create an extension class of form data source Field class and override method through COC.

Here is the annotation code to create COC



[ExtensionOf(formDataFieldStr(FormName, DataSourceName,DataFieldName))]


In this demo, we are using the HcmWorker form and creating Extension of DirPerson Data source field Personal Title..

[ExtensionOf(formDataFieldStr(HcmWorker, DirPerson,PersonalTitle))]

In actual code, you can find the method in the Hcmworker form 


 [DataField]
        class PersonalTitle
        {
            public Common lookupReference(FormReferenceControl _formReferenceControl)
            {
                return DirUtility::buildAffixReferenceControlLookup(_formReferenceControl, DirNameAffixType::PersonalPrefix);
            }

        }


Here is the code through which we create extensions.

[ExtensionOf(formDataFieldStr(HcmWorker, DirPerson,PersonalTitle))]
final class Demo_Extension
{
}


Here is the code through this we override the method.


[ExtensionOf(formDataFieldStr(HcmWorker, DirPerson,PersonalTitle))]
final class Demo_Extension
{
    public Common lookupReference(FormReferenceControl _formReferenceControl)
    {
        next lookupReference(_formReferenceControl);
        return DirUtility::buildAffixReferenceControlLookup(_formReferenceControl, DirNameAffixType::PersonalPrefix);
    }

}

Now perform build in sync on your module. enjoy


Support Faryal's Cusine


Virtual Fields Vs Computed Fields

  Virtual Field: A virtual field in D365FO is a field that doesn't have a direct representation in the database. It's a field that y...