Fixed Asset Creation and Posting

 

AxLedgerJournalTa             journalTable;

AxLedgerJournalTrans        journalTrans;

LedgerJournalTrans             ledgerJournalTrans;

LedgerJournalTable             ledgerJournalTable;

ledgerJournalCheckPost      ledgerJournalCheckPost;

NumberSeq                          NumberSeq;

LedgerJournalTrans_Asset ledgerJournalTrans_Asset;

AssetTable                          assetTable;

AssetBook                          assetBook;

AssetLedgerAccounts        assetLedgerAccounts;

DimensionDefault              offsetLedgerRecid;

LedgerDimensionDefaultAccount defaultAccount;

str AssetId = "DIPL-Mac000002";

journalTable = new AxLedgerJournalTable();

journalTrans = new AxLedgerJournalTrans();

journalTable.parmJournalName("FA17-18");

journalTable.parmJournalType(LedgerJournalType::Assets);

journalTable.save();

journalTrans.parmJournalNum(journalTable.ledgerJournalTable().JournalNum);

journalTrans.parmTransDate(today());

journalTrans.parmTxt("hihjda");

journalTrans.parmCurrencyCode("INR");

journalTrans.parmAmountCurDebit(770);

journalTrans.parmAccountType(LedgerJournalACType::FixedAssets);

journalTrans.parmDefaultDimension(AssetTable::find(AssetId).defaultDimension(AssetId));

journalTrans.parmLedgerDimension(DimensionStorage::getDynamicAccount(AssetId,LedgerJournalACType::FixedAssets));

offsetLedgerRecid = AssetLedgerAccounts::assetOffsetLedgerDimension("DIPL-Mac000002",'SL',AssetTransType::Acquisition,"ALL",true); 

journalTrans.parmOffsetLedgerDimension(journalTrans.ledgerJournalTrans().getOffsetLedgerDimensionForLedgerType(offsetLedgerRecid,journalTrans.ledgerJournalTrans().getOffsetCompany())); 

journalTrans.parmOffsetAccountType(LedgerJournalACType::Ledger);

NumberSeq =NumberSeq::newGetNumFromCode(LedgerParameters::numRefLedgerJournalizeNum().numberSequenceTable().NumberSequence);

journalTrans.parmVoucher(NumberSeq.num());

journalTrans.save();

if (journalTrans.ledgerJournalTrans().isFixedAssetsTransaction())

{

ledgerJournalTrans_Asset.clear();

ledgerJournalTrans_Asset.initValue();

ledgerJournalTrans_Asset.RefRecId = journalTrans.ledgerJournalTrans().RecId;

ledgerJournalTrans_Asset.AssetId = journalTrans.ledgerJournalTrans().getAssetId();

ledgerJournalTrans_Asset.Company = journalTrans.ledgerJournalTrans().getAssetCompany();

ledgerJournalTrans_Asset.TransType = AssetTransTypeJournal::Acquisition;

select BookId from AssetBook where AssetBook.AssetId == "DIPL-Mac000002";

ledgerJournalTrans_Asset.BookId = AssetBook.BookId; //'SL';

ledgerJournalTrans_Asset.insert();

}

info('Insert');

//Posting

ledgerJournalCheckPost = ledgerJournalCheckPost::newLedgerJournalTable(journalTable.ledgerJournalTable(),NoYes::Yes);

ledgerJournalCheckPost.run();

}