Check if Invoice Date is in current Ledger Period using X++



public boolean AS_isInvoiceInCurrentLedgerPeriod(TransDate _transDate, TransDate _oldDate)
{
    FiscalCalendarPeriod         oldPeriod;
    FiscalCalendarPeriod         newPeriod;
    FiscalCalendarRecId          fiscalCalendarRecId = CompanyInfo::fiscalCalendarRecId();
    LedgerFiscalCalendarPeriod   ledgerFiscalCalendarPeriod;

    if (!FiscalCalendars::findYearEndClosingPeriodByDate(fiscalCalendarRecId, _transDate).RecId)
    {
        // The transaction date is not in a valid period.
        return checkFailed("@GLS54501");
    }

    oldPeriod = FiscalCalendars::findPeriodByPeriodCodeDate(fiscalCalendarRecId, _oldDate);
    newPeriod = FiscalCalendars::findPeriodByPeriodCodeDate(fiscalCalendarRecId, _transDate);

    if (!newPeriod.RecId)
    {
        // The transaction date is not in a valid period.
        return checkFailed("@GLS54501");
    }

    select firstonly Status from ledgerFiscalCalendarPeriod
        where ledgerFiscalCalendarPeriod.FiscalCalendarPeriod == newPeriod.RecId
            && ledgerFiscalCalendarPeriod.Ledger == Ledger::current();

    if (ledgerFiscalCalendarPeriod.Status == FiscalPeriodStatus::Open)
    {
        if ( newPeriod.StartDate != oldPeriod.StartDate) //!isSimpleMethod           &&
        {
            return false;
        }
        return true;
    }
    else
    {
        // The period of this date is closed or stopped
        return checkFailed("@GLS54751");
    }
}

Comments

  1. RubenMarch 22, 2021 at 11:25 AM

    Is there an equivalent in D365 for FiscalCalendars::findPeriodByPeriodCodeDate()?

    ReplyDelete

Post a Comment

Popular posts from this blog

Sales order invoice posting using X++ with custom SalesParmLine fields

private boolean postSOInvoice(SalesTable salesTable) {     SalesFormLetter     letter      = SalesFormLetter::construct(DocumentStatus::Invoice);     CustInvoiceTrans    custInvoiceTransFrom;     SalesParmLine       salesParmLine;     SalesParmUpdate     salesParmUpdate;     SalesLine           salesLineLocal;          boolean             ret = true;         letter.salesTable(salesTable);         letter.initParmDefault();         letter.transDate          (systemDateGet());         letter.specQty            (SalesUpdate::All);         letter.proforma           (false);       ...
Read more

Create a custom lookup with multiple data sources on form using X++

Open the form on which you want to create a custom lookup. Go the data source - fields, select field and override the lookup method. Following code will help you in creating custom lookup using SysTableLookup with multiple data sources.  public void lookup(FormControl _formControl, str _filterStr) {      SysTableLookup            sysTableLookup;      Query                          query;      QueryBuildDataSource  qbds1, qbds2;      ;      sysTableLookup = SysTableLookup::newParameters(tablenum(table1),_formcontrol);      query = new Query();      qbds1 = query.addDataSource(tablenum(table1));    ...
Read more

SalesTable2Line custom field update prompt on Sales order in AX 2012

Image
 Dynamics AX has standard functionality to show a prompt for any common fields on Sales Header & Lines are being updated on header. This prompt is based on the setup done on the AR Parameters form -> Updates -> Update order lines button If we want to have our custom field to behave in same manner, then we need to do following steps. 1. Create your new field on the SalesTable & SalesLine tables. Here for I am going to use field as "AS_TitleTransfer" 2. Add the  AS_TitleTransfer field to SalesTable field group HeaderToLineUpdate. 3. Add the new field on the Header & Lines section on SalesTable form like on General Tab. 4. In the AxSalesTable class add parm & set methods for new field. public <<your EDT>> parmAS_TitleTransfer( <<your EDT>>  _Id = '') {     if (!prmisDefault(_Id))     {         this.setField(fieldNum(SalesTable, AS_Ti...
Read more