Menu Close

Month: April 2019

Job To Cancel Reminder Qty of Purchase Orders from CSV File

static void PO_CancelReminder(Args _args) {     PurchLine       _PurchLine;     Qty             _qty;     PurchId         _PurchId;     Dialog          dialog;     Filename        filenameWarehouse,filenameItem;     DialogField     dialogFilename;     container       conFilter = [“Comma Seperated Value .txt “, “*.csv”];     FilenameOpen    filename;     Container       record;     #File     IO  iO;     boolean first = true;     dialog = new dialog();     dialog.caption(“Select…

How to select aggregate fields using query?

Query query;QueryBuildDataSource qbds;QueryBuildRange qbr;QueryRun queryrun;date fromDate = systemDateGet();date toDate = (systemDateGet() + 25);query = new Query();qbds = query.addDataSource(tableNum(MyTable));qbds.addGroupByField(fieldNum(MyTable, DateField));qbds.addGroupByField(fieldNum(MyTable, CurrencyNameField));qbds.addSelectionField(fieldNum(MyTable, DateField));qbds.addSelectionField(fieldNum(MyTable, CurrencyNameField));qbds.addSelectionField(fieldNum(MyTable, EURAmountField), SelectionField::Sum);qbds.addSelectionField(fieldNum(MyTable, USDAmountField),…

AX 2012 Split Default Dimension to get Department

Public display Description Department(){ Name dimensionAttributeName; RecId DepartmentAttribute; DefaultDimensionView dimensionView; DimensionAttribute dimensionAttribute; DimensionAttribute dimAttribute; dimensionAttributeName = “Department”; DepartmentAttribute = DimensionAttribute::findByName(‘Department’).RecId; select firstOnly dimensionView where dimensionView.DefaultDimension…