public static void CreateJournal(Resources context)
{
//JournalTable journaltable = new JournalTable();
GeneralLedgerCustInvoiceJournalLine generalJournalLine = new GeneralLedgerCustInvoiceJournalLine();
GeneralLedgerCustInvoiceJournalLine generalJournalLine2 = new GeneralLedgerCustInvoiceJournalLine();
DataServiceCollection <GeneralLedgerCustInvoiceJournalLine> generalJournalLineCollection = new DataServiceCollection <GeneralLedgerCustInvoiceJournalLine>(context);
generalJournalLineCollection.Add(generalJournalLine);
generalJournalLineCollection.Add(generalJournalLine2);
string Account = "000018748";
generalJournalLine.DocumentDate = DateTime.Now;
generalJournalLine.AccountType = LedgerJournalACType.Cust;
generalJournalLine.CustomerAccountDisplayValue = Account;
generalJournalLine.JournalBatchNumber = "JV-000002";
generalJournalLine.Company = "KSC";
generalJournalLine.DebitAmount = 505;
generalJournalLine.OffsetAccountType = LedgerJournalACType.Ledger;
generalJournalLine.OffsetAccountDisplayValue = "----";
generalJournalLine.OffsetCompany = "KSC";
generalJournalLine.Currency = "SAR";
generalJournalLine.DataAreaId = "ksc";
//generalJournalLine2.InvoiceDate = new System.DateTime();
generalJournalLine2.InvoiceDate = DateTime.Now;
generalJournalLine2.AccountType = LedgerJournalACType.Cust;
generalJournalLine2.CustomerAccountDisplayValue = Account;
generalJournalLine2.JournalBatchNumber = "JV-000002";
//generalJournalLine2.Voucher = "2";
generalJournalLine2.Company = "KSC";
generalJournalLine2.CreditAmount = 505;
generalJournalLine2.OffsetAccountType = LedgerJournalACType.Cust;
generalJournalLine2.OffsetAccountDisplayValue = "----";
generalJournalLine2.OffsetCompany = "KSC";
//generalJournalLine2.InvoiceId = "afeafe";
generalJournalLine2.Currency = "SAR";
generalJournalLine2.DataAreaId = "ksc";
//generalJournalLine2.Voucher = "123";
//DimensionCombination objdim = new DimensionCombination();
//objdim.dimens
//objdim.DimensionName = "ksc_Campus";
//objdim.DimensionValueMask = "Boys Campus";
//DimensionSet dset = new DimensionSet();
//dset.dime
//DimensionAttribute objdim = new DimensionAttribute();
//objdim.DimensionName = "ksc_Campus";
//objdim.DimensionValueMask = "Boys Campus";
//generalJournalLine2.Defau
//generalJournalLine2.DefaultDimensionDisplayValue = "BIM";//|Boys Campus";//|G10";
//generalJournalLine2.DefaultDimensionDisplayValue = "000018748|BIM|Boys Campus|G10";
// generalJournalLine2.DefaultDimensionDisplayValue = "10000000|BIM";// "BIM|Boys Campus|G10";
string dim = "10000000-Boys Campus-BIM-G10";//|BIM|Boys Campus|G10"; //"5637150540";
generalJournalLine2.DefaultDimensionDisplayValue = dim;
generalJournalLine.DefaultDimensionDisplayValue = dim;
DataServiceResponse response = null;
try
{
response = context.SaveChanges(SaveChangesOptions.PostOnlySetProperties | SaveChangesOptions.BatchWithSingleChangeset);
Console.WriteLine("created ok");
}
catch (Exception ex)
{
Console.WriteLine(ex.Message + ex.InnerException);
}
}
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]));
}
}
