Pages

Banner 468 x 60px

 

Thursday, June 23, 2022

Export Data AX to Excel

0 comments
 static void ExportDataGeneralJournal(Args _args){    SysExcelApplication     xlsApplication;    SysExcelWorkBooks       xlsWorkBookCollection;    SysExcelWorkBook        xlsWorkBook;    SysExcelWorkSheets      xlsWorkSheetCollection;    SysExcelWorkSheet       xlsWorkSheet;    SysExcelRange           xlsRange;    GeneralJournalEntry         jourEntry;    GeneralJournalAccountEntry ...
Read more...

Sunday, June 5, 2022

Create default from date 1 Month Ago in SSRS Expression

0 comments
 DateAdd("M", -1, Toda...
Read more...

Decrease Decimal in AX 2012

0 comments
 num2str0(amount, 0, 2, 1,0) // two decimalnum2str0(amount, 0, 0, 1,0) // without decimal&nb...
Read more...

Saturday, June 4, 2022

Get Invent Site from WareHouse and Item by Code X++

0 comments
static void OnHandOnDate(Args _args){    ItemId                      itemId;    InventDim                   inventDimCriteria;    InventDimParm               inventDimParm;    InventSumDatePhysicalDim    inventSumDateDim;    InventTable                 InventTable;    InventLocation              Inventlocation; ...
Read more...

A financial dimension value is based on the record and has been used on a transaction. You cannot delete the record

  SOLUTION delete in table DimensionAttributeLevelValue base on Bank Account  :  and Delete the Bank Account FINISH