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]));
}
}
