Tuesday, April 30, 2019

Sales Analysis by Invoice Report Adding Salesman Name in new field

Created new method in CustInvoiceJour Table ...and calling to query in ssrs

//BP Deviation Documented
[SysClientCacheDataMethodAttribute(true)] // added by kavin on march 25th 2019  for bring salesman name against the sales order
server display Name nameSalesman()
{
    SalesTable   salesTable;
    Name         _name;
    ;

     select salesTable
           where salesTable.SalesId == this.SalesId;
    {
        _name   = salesTable.SalesGroup;
    }

    return _name;
}

----------
in ssrs report using AOT query

CustSalesAnalysisByInvoice_NA

.. in ssrs report properties selecting the query and what are the display methods avialble in table it will bring the query . then assign that field in report design directly


In Standard form Bring New number Seq with Customized Field without clicking any button

PurchParmTable -- table -- created new number seq method

------------------------------
client server static NumberSequenceReference numLEC_ProductNumber()
{
     return NumberSeqReference::findReference(extendedTypeNum(LEC_ProductNumber));
}
------------------------------

PurchEditLines -- Form -- Created one new method

public void generateLECGRNNumber(ParmId  _parmId)// added by kavin on march 29th 2019 for bring number seq in form PurchEditLines field name LEC_GRnumber
{
    PurchParmTable      _PurchParmTable;
    NumberSeq           numberSeq;
    LEC_ProductNumber   num;

    select forUpdate _PurchParmTable
        where _PurchParmTable.ParmId == _parmId;

    if(_PurchParmTable)
    {
        numberSeq = NumberSeq::newGetNum(PurchParmTable::numLEC_ProductNumber());
        num = numberSeq.num();

        ttsBegin;
        _PurchParmTable.LEC_GRN = num;
        _PurchParmTable.update();
        ttsCommit;
    }

}

--------------------------

receiving argument from init ()

  element.generateLECGRNNumber(parmId); // added by kavin for bring parmid to get recid for table on march 29th 2019