Mr. Developer

Create Inventory Adjustment Journal d365fo x++ Code: public void processOperation(JSInvADJJournalCreationContract _contract) { InventJournalTable inventJournalTable; InventJournalTrans inventJournalTrans; GroupType GroupType = _contract.paramGroupType(); InventLocationId Warehouse = _contract.paramInventLocationId(); // Create journal table inventJournalTable = JSInvADJJournalCreationService::createJournalTable(); if(inventJournalTable) { // Initialize journal trans inventJournalTrans = JSInvADJJournalCreationService::createLines(GroupType, Warehouse, inventJournalTable); info(strFmt("INV Adjustment JOURNAL CREATED %1", INVENTJOURNALTABLE.JournalId)); // Post Inventory journal JSInvADJJournalCreationService::postInventTableJournal(inventJournalTable); } } private static InventJournalTable createJournalTable() { INVENTJOURNALTABLE INVENTJOURNALTABLE; InventJournalNameId inventJourna...

  get invoice id on return SO d365fo x++ Code: [ExtensionOf(classStr(SalesCopying))] final class SalesCopying_Class_Extension { protected void copyLine(SalesLine _salesLine, SalesLineCopyFromSource _salesLineCopyFromSource) { next copyLine(_salesLine, _salesLineCopyFromSource); TmpFrmVirtual sourceline = _salesLineCopyFromSource.parmTmpFrmVirtualLine(); if (sourceline.TableNum == tableNum(CustInvoiceTrans) && _salesLine) { CustInvoiceTrans CustInvoiceTrans = CustInvoiceTrans::findRecId(sourceline.RecordNo); ttsbegin; _salesLine.selectForUpdate(true); _salesLine.DSAInvoiceId = CustInvoiceTrans.InvoiceId; _salesLine.update(); ttscommit; } } } [ExtensionOf(formStr(SalesCopying))] final class SalesCopying_Form_Extension { void writeTmpFrmVirtual( TmpFrmVirtual _tmpFrmVirtual, ...

Get prepayments of project Invoice in d365fo x++ Code: select newAccTrans.TRANSID, NewAcc.PROJINVOICEID, orginAccTrans.TRANSID, orginAcc.PROJINVOICEID, newAccTrans.PSARefRecId from ProjOnAccTrans newAccTrans join ProjInvoiceOnAcc NewAcc on NewAcc.TRANSID = newAccTrans.TRANSID join ProjOnAccTrans orginAccTrans on orginAccTrans.RECID = newAccTrans.PSARefRecId join ProjInvoiceOnAcc orginAcc on orginAcc.TRANSID = orginAccTrans.TRANSID where newAccTrans.TRANSID = '4040-000192'