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);
        letter.printFormLetter    (false);

        letter.initParameters(letter.salesParmUpdate(), PrintOut::Current);  // Printout
        letter.initLinesQuery();
        while select forUpdate salesParmLine where salesParmLine.ParmId == letter.parmId()
        {
            salesLineLocal = salesParmLine.salesLine();
            
            if(salesLineLocal.RemainSalesPhysical != 0)
            {
                salesParmLine.custom field1                      =<<customField1>>;

                // changed the Qty
                salesParmLine.DeliverNow                    = salesLineLocal.SalesQty;

                // the following is stollen from the SalesEditLines form (field modified method)
                salesParmLine.setQty(salesParmLine.salesParmTable().ordering, letter.SalesParmUpdate().creditRemaining);
                salesParmLine.setInventDeliverNow();
                salesParmLine.setLineAmount();

                if (salesParmLine.closed)
                {
                    salesParmLine.remainAfter = 0;
                    salesParmLine.setRemainAfterInvent();
                }
                salesParmLine.update();
            }
            else
            {
                checkFailed(strFmt("Sales order %1 does not have remainig qty to invoice", salesTable.SalesId));
            }
        }//end of while

        letter.run();
        custInvoiceJourNew = letter.getOutputContract().parmJournal();
    }
    info(strfmt("sales order posted with invoice Id %1", custInvoiceJourNew.InvoiceId));

    return ret;

}

Comments

Post a Comment

Popular posts from this blog

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