Implementing journal 'copy' functionality

(0) Share

Report

Posted on by VV-22040800-0

Hi,

I've a customized journal form and trying to incorporate the 'Copy' functionality,I've created the class with the following 'copy' code

Public void journalCopy(LedgerJournalTable _ledgerJournalTable)
{
LedgerJournalTable ledgerJournalTableinsert;
LedgerJournalTrans ledgerJournalTransOrig,ledgerJournalTransNew;
;

ttsBegin;
ledgerJournalTableinsert.data(_ledgerJournalTable);
ledgerJournalTableinsert.JournalNum = JournalTableData::newTable(LedgerJournalTable).nextJournalId();
ledgerJournalTableinsert.Posted = NoYes::No;
ledgerJournalTableinsert.insert();

while select ledgerJournalTransOrig
where ledgerJournalTransOrig.JournalNum == _ledgerJournalTable.JournalNum

{

ledgerJournalTransNew.data(ledgerJournalTransOrig);
ledgerJournalTransNew.JournalNum = ledgerJournalTableinsert.JournalNum;
ledgerJournalTransNew.insert();

}
info("");
ttsCommit;

}
on executing the above code the header details is getting copied but the line details does not,the line details form having the multiple ds like LedgerJournalTrans_Project,VendTransCashDisc etc.
so can anyone guide me on how to copy the line details ?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can take a look at the journals in the project module that have an out of the box copy functionality.

Best regards

Ludwig

Was this reply helpful? Yes No
VV-22040800-0 12 on at

Like (0)

Report
Copy link

Link copied!

hi crispin ,how to re-write the code and which specific methods we've to call from AxLedgerJournalTrans to ' write' and copy the Ledgerjournaltrans lines ?

Was this reply helpful? Yes No
VV-22040800-0 12 on at

Like (0)

Report
Copy link

Link copied!

hi, using both the codes(code i've posted & link you've provided) the data's are getting inserted at back end-table level but it's not getting reflected in form level.so what we've to do in form level ?

Was this reply helpful? Yes No
Suggested answer

Rustem Galiamov 8,072 on at

Like (0)

Report
Copy link

Link copied!
Hi!

I've create a job just to check. And journal's header and lines was created successful.

static void Job175(Args _args) { LedgerJournalTable ledgerJournalTableinsert; LedgerJournalTrans ledgerJournalTransOrig,ledgerJournalTransNew; LedgerJournalTable _ledgerJournalTable = LedgerJournalTable::find('UNC-054212'); ; ttsBegin; ledgerJournalTableinsert.data(_ledgerJournalTable); ledgerJournalTableinsert.JournalNum = JournalTableData::newTable(ledgerJournalTableinsert).nextJournalId(); ledgerJournalTableinsert.Posted = NoYes::No; ledgerJournalTableinsert.insert(); while select ledgerJournalTransOrig where ledgerJournalTransOrig.JournalNum == _ledgerJournalTable.JournalNum { ledgerJournalTransNew.data(ledgerJournalTransOrig); ledgerJournalTransNew.JournalNum = ledgerJournalTableinsert.JournalNum; ledgerJournalTransNew.insert(); } info(""); ttsCommit; }

Did you have any customisation of journal lines form?

Was this reply helpful? Yes No
VV-22040800-0 12 on at

Like (0)

Report
Copy link

Link copied!

Yes it is a customised journal lines form with multiple data sources like LedgerJournalTrans_Project,VendTransCashDisc etc.Fields used in line details are from multiple tables,so how to copy the entire line details ?

Was this reply helpful? Yes No
Suggested answer

Rustem Galiamov 8,072 on at

Like (0)

Report
Copy link

Link copied!

You need to know which data created in this tables while you create journal lines manually and then do the same steps in your code.

Was this reply helpful? Yes No