Posts

Showing posts from June, 2015
Interaction Class public class _UnitReservationListPageInteraction extends ListPageInteraction { } public void selectionChanged() {     UnitReservation        _unitReservation = this.listPage().activeRecord(queryDataSourceStr(KPMG_UnitReservationHeader, UnitReservation_1));     super();     if( _unitReservation.FlatStatus == KPMG_UnitFlatStatus::Cancelled)     {         this.listPage().actionPaneControlEnabled(formControlStr(KPMG_UnitReservation_ListPage, Cancel), false);         this.listPage().actionPaneControlEnabled(formControlStr(KPMG_UnitReservation_ListPage, Transfer), false);     }  }

Default Dimension Value

static void DefaultDiemsion(Args _args) {     DefaultDimensionView        ddv;         select NAME,DISPLAYVALUE from ddv             where ddv.DefaultDimension == 5637151332 // defaultdimension is the dimensionid                     && ddv.Name == 'Department';   /// cost code is the default dimension  as Department, costcenter     {         info(ddv.DisplayValue);     } }

Find Method

public static _PropertyTable find(_PropertyId _propertyId, boolean _forUpdate = false) {     _PropertyTable  propertyTable = null;     propertyTable.selectForUpdate(_forUpdate);     if (_propertyId)     {         select firstonly propertyTable where propertyTable.PropertyId == _propertyId;     }     return propertyTable; } static _BuildingUnitDetailsDim findPropertyDescFlat(_PropertyId      PropertyId,                                           Description          Description,                                           _FlatNumber       FlatNumber,                     ...

Create Transfer Journal through X++

static void CreateTransferJournal(Args _args) {     InventJournalTable      inventJournalTable;     InventJournalTrans      inventJournalTrans;     InventJournalCheckPost  inventJournalCheckPost;     JournalCheckPost        journalCheckPost;     NumberSeq num;     boolean _throwserror=true;     boolean _showinforesult=true;     InventDim frominventDim,ToinventDim;     ;     ttsbegin;         inventJournalTable.clear();         num = new NumberSeq();         num = NumberSeq::newGetNum         (InventParameters::numRefTransferId());         inventJournalTable.initFromInventJournalName(InventJournalName::find(InventParameters::find().TransferJournalNameId));         inventJournalTable.Description = 'In...

Create PO

static void CreatePO(Args _args) {     NumberSeq numberSeq;     Purchtable Purchtable;     PurchLine PurchLine;     PurchFormLetter purchFormLetter;     PurchReqLine        purchReqLine,purchReqLine1;     InventDim inventDim;     str newPurchId;     ;     ttsbegin;         numberSeq = NumberSeq::newGetNum(purchParameters::numRefPurchId());         numberSeq.used();         //newPurchId = numberSeq.num();         // Initialize Purchase order values         Purchtable.initValue();         Purchtable.PurchId = numberSeq.num();         Purchtable.OrderAccount = 'AAHCO00336';         Purchtable.initFromVendTable();         if (!Purchtable.validateWrite())         { ...

Create RFQ through X++

static void CreateRFQ(Args _args) {     AxPurchRFQCaseTable         axPurchRFQCaseTable;     AxPurchRFQCaseLine          axPurchRFQCaseLine;     PurchRFQCaseTable           purchRFQCaseTable;     PurchRFQCaseLine            purchRFQCaseLine;     str         RFQCaseId;     NumberSeq numberSeq;     ;     numberSeq = NumberSeq::newGetNum(purchParameters::numRefPurchRFQCaseId());     numberSeq.used();     RFQCaseId = numberSeq.num();     axPurchRFQCaseTable = new AxPurchRFQCaseTable();     axPurchRFQCaseTable.parmRFQCaseId(RFQCaseId);     axPurchRFQCaseTable.parmBidType(PurchRFQBidType::Open);     axPurchRFQCaseTable.parmCurrencyCode('INR');     axPurchRFQCaseTable.save();     axPurchRFQCaseLine =...

Jump Ref

public void jumpRef() {     Args args = new Args();     FormRun formRun;     super();     args = new Args(formStr(AssetTable));     args.lookupField(fieldNum(AssetTable,AssetId));     args.lookupValue(any2str( ));//EquipmentAllocation.EquipmentId --  Table name where we need to see view details));     args.parm(EquipmentAllocation.EquipmentId);     formRun = ClassFactory::formRunClassOnClient(args);     formRun.init();     formRun.run();     formRun.detach(); }

Date and Time validations

fromDateTime = DateTimeUtil::applyTimeZoneOffset(KPMG_EquipmentAllocation1.FromDateTime,DateTimeUtil::getUserPreferredTimeZone());         toDateTime  = DateTimeUtil::applyTimeZoneOffset(KPMG_EquipmentAllocation1.ToDateTime,DateTimeUtil::getUserPreferredTimeZone());         startdate   = EquipmentAllocation_FromDateTime.dateTimeValue();         enddate     = EquipmentAllocation_ToDateTime.dateTimeValue();         if((startdate>fromDateTime)&&(startdate<toDateTime) && ((enddate>fromDateTime)&&(enddate<toDateTime)))         {             throw error("start date time and end date time is between fromdatetime and todatetime ");         }         else if((startdate<fromDateTime) && ((enddate>fromDateTime)&&(enddate<toDateTime))) ...

Project Id through X++ code

void clicked() {     ProjTable                   projTable;     ProjInvoiceTable            projInvoiceTable;     ProjFundingSource           projFundingSource;     ProjFundingRule             projFundingRule;     ProjFundingRuleAllocation   projFundingRuleAllocation;     NumberSeq                   numberSeq,numberSeqInv;     NumberSequenceFormat        _numberSequenceMask;     ProjParameters      projParameters  = ProjParameters::find();     super();     ttsBegin;     numberSeq = NumberSeq::newGetNum(ProjParameters::numRefProjId());     numberSeqInv = NumberSeq::newGetNum(ProjParameters::numRefProjInvoiceProjId());     proj...

How to create Project Contract Id and Sub Project Id

void clicked() {     ProjTable                   projTable;     ProjInvoiceTable            projInvoiceTable;     ProjFundingSource           projFundingSource;     ProjFundingRule             projFundingRule;     ProjFundingRuleAllocation   projFundingRuleAllocation;     NumberSeq                   numberSeq,numberSeqInv;     // Sub project creation     ProjTableType projTableType;     NumberSeq projNumberSeq;     ProjId projIdLastSon, projectId;     ProjId projMask;     Integer sonNum;     str     a,b;     ProjType _projType = ProjType::FixedPrice;     ProjParentId _projParentId = UnitReservation_ProjId.valueStr(); // // project id h...

How to open the details form while we create the new record from the listpage

Image
In New form Form Level Methods: public class FormRun extends ObjectRun {     QueryBuildDataSource qbd;     Query                q;     SysTableLookup       systablelookup;     FormRun                 callerform; } public void close() {     super();     callerform.dataSource().research();     callerform.dataSource().reread(); } public void init() {     callerform = element.args().caller();     super(); } public void closeOk() {       Args args = new Args();       ;     super(); } In OK button Clicked Method : void clicked() {       MenuFunction                            mf;     args             ...