Monday, 28 July 2014

Ledger Dimension and General Journal Posting X++



Hi all,
From this post you can learn how to get the dimensions value for ledger journal posting

ledgerDimensions = ["Main account","101",2,"Costcenter","000101","Purpose","Training"];

here the main account, costcenter and purpose are the dimensions label files, 
101,000101,Traning are values for the dimensions,
2 -> here the trick its specifying the number of dimensions, suppose if you are having 5 dimensions u need to mentions 5 
eg :  ledgerDimensions = ["Main account",101,5,"Costcenter","000101","Purpose","Training","Estate","1",Division,"Div-1","Field","Field-1"];

trans.parmLedgerDimension(AxdDimensionUtil::getLedgerAccountId(ledgerDimensions));

Ledger journal posting code :
        header = new AxLedgerJournalTable();
        //header.parmName(Payrollheader.Headername);
        header.parmJournalName(LedgerParameters::find().HS_journame);
        header.parmJournalType( LedgerJournalType::Daily);
        currency                    = Ledger::accountingCurrency(CompanyInfo::current());
        header.parmCurrencyCode(currency);
        header.parmOriginalCompany(Payrolltmplines.Company);
        header.save();
                    trans = new AxLedgerJournalTrans();
        trans.parmAccountType(LedgerJournalACType::Ledger);
        trans.parmJournalNum(header.ledgerJournalTable().JournalNum);
        //accode = ledge.Linedescription;
        ledgDimension1 = Payrolltmplines.Accountnum;
      //  ledgDimension2 = substr(accode, 9, 3);
        ledgerDimensions = ["Main account",ledgDimension1];
        trans.parmLedgerDimension(AxdDimensionUtil::getLedgerAccountId(ledgerDimensions));
        trans.parmAmountCurDebit(Payrolltmplines.Amt);
        trans.parmTxt(Payrolltmplines.Linesdescription);
        trans.parmCompany(Payrolltmplines.Company);
        trans.save();
 

No comments:

Post a Comment