AX utilizes SQL Indexes in order to speed up queries to the database. It is important that any index created is analyzed for its usage pattern; for example, will the query only be made once per day, or thousands of…
AX utilizes SQL Indexes in order to speed up queries to the database. It is important that any index created is analyzed for its usage pattern; for example, will the query only be made once per day, or thousands of…
AxLedgerJournalTable header = new AxLedgerJournalTable(); AxLedgerJournalTrans trans = new AxLedgerJournalTrans(); container ledgerDimensions, offsetDimensions; header.parmJournalName(“GenJrn”); header.save(); trans.parmAccountType(LedgerJournalACType::Ledger); trans.parmJournalNum(header.ledgerJournalTable().JournalNum); ledgerDimensions = [“131100-USA”,”131100″, 1, “COUNTRY”,”USA”]; trans.parmLedgerDimension(AxdDimensionUtil::getLedgerAccountId(ledgerDimensions)); trans.parmAmountCurDebit(230); offsetDimensions = [“0103-USA”,”0103″, 1, “COUNTRY”, “USA”]; trans.parmOffsetLedgerDimension(AxdDimensionUtil::getLedgerAccountId(offsetDimensions)); trans.save();