public static GeneralLedgerCustInvoiceJournalHeader CreateGeneralLedgerCustInvoiceJournalHeader(string dataAreaId, string journalBatchNumber) { GeneralLedgerCustInvoiceJournalHeader generalLedgerCustInvoiceJournalHeader = new GeneralLedgerCustInvoiceJournalHeader(); generalLedgerCustInvoiceJournalHeader.dataAreaId = dataAreaId; generalLedgerCustInvoiceJournalHeader.JournalBatchNumber = journalBatchNumber; return(generalLedgerCustInvoiceJournalHeader); }
public static void CreateGeneralJournal(List <string> accRecords, Resources context, StringBuilder logMsg) { for (int i = 1; i < accRecords.Count; i++) { ImportCommon.Writelog(logMsg, BusinessConst.LOG_INFO, "Line" + i + ":" + ImportCommon.TrimDoubleQuotationMarks(accRecords[i].Replace("\",\"", "\t"))); var wkLine = ImportCommon.TrimDoubleQuotationMarks(accRecords[i].Replace("\",\"", "\t")).Split('\t'); string str1 = wkLine[0]; //Operation string str2 = wkLine[1]; //Company ID string str3 = wkLine[2]; //Company Name string str4 = wkLine[3]; //Street string str5 = wkLine[4]; //Street2 string str6 = wkLine[5]; //Street3 //Import to AX DataServiceCollection <GeneralLedgerCustInvoiceJournalHeader> generalJournalCollection = new DataServiceCollection <GeneralLedgerCustInvoiceJournalHeader>(context); DataServiceCollection <GeneralLedgerCustInvoiceJournalLine> generalJournalLineCollection = new DataServiceCollection <GeneralLedgerCustInvoiceJournalLine>(context); //create General Journal GeneralLedgerCustInvoiceJournalHeader generalJournal = new GeneralLedgerCustInvoiceJournalHeader(); generalJournalCollection.Add(generalJournal); generalJournal.JournalName = "test jn2"; generalJournal.JournalBatchNumber = "11223"; generalJournal.Description = "test1"; generalJournal.DataAreaId = "USMF"; GeneralLedgerCustInvoiceJournalLine generalJournalLine = new GeneralLedgerCustInvoiceJournalLine(); GeneralLedgerCustInvoiceJournalLine generalJournalLine2 = new GeneralLedgerCustInvoiceJournalLine(); generalJournalLineCollection.Add(generalJournalLine); generalJournalLineCollection.Add(generalJournalLine2); generalJournalLine.InvoiceDate = new System.DateTime(); generalJournalLine.AccountType = LedgerJournalACType.Cust; generalJournalLine.CustomerAccountDisplayValue = "test0001"; generalJournalLine.JournalBatchNumber = "11223"; generalJournalLine.Company = "usmf"; generalJournalLine.DebitAmount = 100; generalJournalLine.OffsetAccountType = LedgerJournalACType.Ledger; generalJournalLine.OffsetAccountDisplayValue = "----"; generalJournalLine.MethodOfPayment = "CHECK"; generalJournalLine.OffsetCompany = "usmf"; generalJournalLine.InvoiceId = "test2"; generalJournalLine.Currency = "USD"; generalJournalLine.DataAreaId = "USMF"; generalJournalLine.ApprovedBy = "test"; generalJournalLine.Approved = NoYes.Yes; Console.WriteLine(string.Format("LedgerJournalACType.Vend {0} - !", (int)(LedgerJournalACType.Vend))); generalJournalLine2.InvoiceDate = new System.DateTime(); generalJournalLine2.AccountType = LedgerJournalACType.Vend; generalJournalLine2.CustomerAccountDisplayValue = "----"; generalJournalLine2.JournalBatchNumber = "11223"; generalJournalLine2.Company = "usmf"; generalJournalLine2.CreditAmount = 100; generalJournalLine2.OffsetAccountType = LedgerJournalACType.Ledger; generalJournalLine2.OffsetAccountDisplayValue = "----"; generalJournalLine2.OffsetCompany = "usmf"; //generalJournalLine2.InvoiceId = "afeafe"; generalJournalLine2.Currency = "USD"; generalJournalLine2.DataAreaId = "USMF"; context.SaveChanges(SaveChangesOptions.PostOnlySetProperties | SaveChangesOptions.BatchWithSingleChangeset); // Batch with Single Changeset ensure the saved changed runs in all-or-nothing mode. Console.WriteLine(string.Format("Invoice {0} - Saved !", wkLine[1])); } }