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
Tuesday, April 30, 2019
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
------------------------------
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
Subscribe to:
Posts (Atom)
