SourceDocumentLine.SourceDocumentHeader = SourceDocumentHeader_loc.RecId SourceDocumentLine.AccountingStatus = SourceDocumentLineAccountingStatus::Draft Select SourceDocumentHeader_loc order by SourceDocumentHeader_loc.RecId desc SourceDocumentHeader.TypeEnumName = "SourceDocument_CustomerInvoice" SourceDocumentHeader.SourceRelationType =1209 SourceDocumentHeader.AccountingStatus = SourceDocumentAccountingStatus::InProcess Select CustInvoiceTable_recId order by CustInvoiceTable_recId.createdDateTime desc // where CustInvoiceTable_recId.SourceDocumentHeader = custInvoiceTable.SourceDocumentHeader ĬustInvoiceline_loc.ParentRecId = CustInvoiceTable_recId.RecId SourceDocumentLine_loc.recid = SourceDocumentLine_loc.recid - 1 custInvoiceTable.SourceDocumentLine = SourceDocumentLine_upd.recid custInvoiceTable.SourceDocumentHeader = SourceDocumentHeader_loc.RecId custInvoiceTable.modifiedField(fieldNum(CustInvoiceTable, OrderAccount)) select SourceDocumentLine_upd where SourceDocumentLine_upd.recid = SourceDocumentLine_loc.recid ĬustInvoiceTable.OrderAccount = CustomerAccount ĬustInvoiceTable.InvoiceDate = InvoiceDate ĬustInvoiceTable.InvoiceAccount = InvoiceAccount SourceDocumentLine_loc.recid = SourceDocumentLine_loc.recid IdentificationNumber = int2str(em(row, 10).value().double())
IdentificationNumber= em(row, 10).value().bStr() Quantity = em(row, 11).value().double() Īmount = em(row, 6).value().double() InvoiceAccount = int2str(em(row, 5).value().double()) InvoiceAccount = em(row, 5).value().bStr() Select SourceDocumentHeader_loc order by SourceDocumentHeader_loc.recid desc ĬustomerAccount= em(row, 1).value().bStr() // comment thisĬustomerAccount = int2str(em(row, 1).value().double()) select SourceDocumentLine_loc order by SourceDocumentLine_loc.recid desc where SourceDocumentLine_loc.SourceRelationType = 1209 "E:\\WA-DataMigration\\WADataImports\\ResourceRequirementTemplate.xlsx" Str CustomerAccount,PersonalTitle,Personalsuffix ĭirNameAffix DirNameAffix,DirNameAffix_loc Īpplication = SysExcelApplication::construct() įilename = "C:\\Users\\UmeshP\\Desktop\\oct 14\\FreeTaxInvoiceJobTemplate.xlsx" RecId PersonalTitleRecid,PersonalSuffixRecid HcmPersonIdentificationNumber HcmPersonIdentificationNumber Hcmi9DocumentList Hcmi9DocumentList,Hcmi9DocumentList_loc SourceDocumentLine SourceDocumentLine,SourceDocumentLine_loc,SourceDocumentLine_upd SourceDocumentHeader SourceDocumentHeader,SourceDocumentHeader_loc Name name,titlename,IdentificationNumber ĬustInvoiceTable CustInvoiceTable,CustInvoiceTable_recId ĬustInvoiceline CustInvoiceline,CustInvoiceline_loc Static void CopyOfInvoiceText(Args _args)
0 kommentar(er)
