public void GetXmlTest()
{
string expected = @"<?xml version=""1.0"" encoding=""utf-8""?>
<function controlid=""unittest"">
<create>
<GLBATCH>
<JOURNAL />
<BATCH_DATE />
<BATCH_TITLE />
<ENTRIES>
<GLENTRY>
<ACCOUNTNO />
<TR_TYPE>1</TR_TYPE>
<TRX_AMOUNT />
</GLENTRY>
</ENTRIES>
</GLBATCH>
</create>
</function>";
StatisticalJournalEntryCreate record = new StatisticalJournalEntryCreate("unittest");
StatisticalJournalEntryLineCreate line1 = new StatisticalJournalEntryLineCreate();
record.Lines.Add(line1);
this.CompareXml(expected, record);
}
public void CreditAmountTest()
{
string expected = @"<?xml version=""1.0"" encoding=""utf-8""?>
<GLENTRY>
<ACCOUNTNO />
<TR_TYPE>-1</TR_TYPE>
<TRX_AMOUNT>100.01</TRX_AMOUNT>
</GLENTRY>";
Stream stream = new MemoryStream();
XmlWriterSettings xmlSettings = new XmlWriterSettings();
xmlSettings.Encoding = Encoding.UTF8;
xmlSettings.Indent = true;
xmlSettings.IndentChars = " ";
IaXmlWriter xml = new IaXmlWriter(stream, xmlSettings);
StatisticalJournalEntryLineCreate record = new StatisticalJournalEntryLineCreate();
record.Amount = -100.01M;
record.WriteXml(ref xml);
xml.Flush();
stream.Position = 0;
StreamReader reader = new StreamReader(stream);
Diff xmlDiff = DiffBuilder.Compare(expected).WithTest(reader.ReadToEnd())
.WithDifferenceEvaluator(DifferenceEvaluators.Default)
.Build();
Assert.IsFalse(xmlDiff.HasDifferences(), xmlDiff.ToString());
}
public void CustomAllocationTest()
{
string expected = @"<?xml version=""1.0"" encoding=""utf-8""?>
<GLENTRY>
<ACCOUNTNO>9000</ACCOUNTNO>
<TR_TYPE>1</TR_TYPE>
<TRX_AMOUNT>1000.00</TRX_AMOUNT>
<ALLOCATION>Custom</ALLOCATION>
<SPLIT>
<AMOUNT>600.00</AMOUNT>
</SPLIT>
<SPLIT>
<AMOUNT>400.00</AMOUNT>
</SPLIT>
</GLENTRY>";
Stream stream = new MemoryStream();
XmlWriterSettings xmlSettings = new XmlWriterSettings();
xmlSettings.Encoding = Encoding.UTF8;
xmlSettings.Indent = true;
xmlSettings.IndentChars = " ";
IaXmlWriter xml = new IaXmlWriter(stream, xmlSettings);
StatisticalJournalEntryLineCreate record = new StatisticalJournalEntryLineCreate()
{
StatAccountNumber = "9000",
Amount = 1000.00M,
AllocationId = "Custom",
};
CustomAllocationSplit split1 = new CustomAllocationSplit()
{
Amount = 600.00M,
};
CustomAllocationSplit split2 = new CustomAllocationSplit()
{
Amount = 400.00M,
};
record.CustomAllocationSplits.Add(split1);
record.CustomAllocationSplits.Add(split2);
record.WriteXml(ref xml);
xml.Flush();
stream.Position = 0;
StreamReader reader = new StreamReader(stream);
Diff xmlDiff = DiffBuilder.Compare(expected).WithTest(reader.ReadToEnd())
.WithDifferenceEvaluator(DifferenceEvaluators.Default)
.Build();
Assert.IsFalse(xmlDiff.HasDifferences(), xmlDiff.ToString());
}
public void GetXmlTest()
{
string expected = @"<?xml version=""1.0"" encoding=""utf-8""?>
<GLENTRY>
<ACCOUNTNO />
<TR_TYPE>1</TR_TYPE>
<TRX_AMOUNT />
</GLENTRY>";
StatisticalJournalEntryLineCreate record = new StatisticalJournalEntryLineCreate();
this.CompareXml(expected, record);
}
/// <summary>
/// Sends a Hours Journal to the Intacct STATISTIC System
/// </summary>
/// <param name="client"></param>
/// <param name="Org"></param>
/// <param name="lines"></param>
/// <param name="PostingDate"></param>
/// <param name="ReferenceNumber"></param>
/// <param name="JournalSymbol"></param>
/// <param name="Description"></param>
/// <param name="HistoryComment"></param>
/// <param name="AsDraft"></param>
/// <returns></returns>
private async Task SendStatHoursJournalCmd(OnlineClient client, int Org, IEnumerable <IntacctStatHours> lines, DateTime PostingDate, string ReferenceNumber, string JournalSymbol, string Description, string HistoryComment, bool AsDraft)
{
StatisticalJournalEntryCreate create = new StatisticalJournalEntryCreate();
create.JournalSymbol = JournalSymbol;
create.ReferenceNumber = ReferenceNumber;
create.PostingDate = PostingDate;
create.Description = Description;
create.HistoryComment = HistoryComment;
if (AsDraft)
{
create.CustomFields.Add("STATE", "Draft");
}
foreach (var item in lines)
{
StatisticalJournalEntryLineCreate line = new StatisticalJournalEntryLineCreate
{
StatAccountNumber = item.Account,
Amount = decimal.Parse(item.Hours.ToString("F2")),
Memo = $"Part of Practice Engine Batch #{item.BatchID}"
};
if (!String.IsNullOrWhiteSpace(item.EmployeeID))
{
line.EmployeeId = item.EmployeeID;
}
if (!String.IsNullOrWhiteSpace(item.ProjectID))
{
line.ProjectId = item.ProjectID;
}
if (!String.IsNullOrWhiteSpace(item.IntacctCustomerID))
{
line.CustomerId = item.IntacctCustomerID;
}
if (!String.IsNullOrWhiteSpace(item.IntacctDepartment))
{
line.DepartmentId = item.IntacctDepartment;
}
if (!String.IsNullOrWhiteSpace(item.IntacctLocation))
{
line.LocationId = item.IntacctLocation;
}
create.Lines.Add(line);
}
OnlineResponse onlineResponse = await client.Execute(create);
foreach (var result in onlineResponse.Results)
{
result.EnsureStatusSuccess();
}
}
public void GetAllXmlTest()
{
string expected = @"<?xml version=""1.0"" encoding=""utf-8""?>
<function controlid=""unittest"">
<create>
<GLBATCH>
<JOURNAL>SJ</JOURNAL>
<BATCH_DATE>06/30/2016</BATCH_DATE>
<REVERSEDATE>07/01/2016</REVERSEDATE>
<BATCH_TITLE>My desc</BATCH_TITLE>
<HISTORY_COMMENT>comment!</HISTORY_COMMENT>
<REFERENCENO>123</REFERENCENO>
<SUPDOCID>AT001</SUPDOCID>
<STATE>Posted</STATE>
<CUSTOMFIELD01>test01</CUSTOMFIELD01>
<ENTRIES>
<GLENTRY>
<ACCOUNTNO />
<TR_TYPE>1</TR_TYPE>
<TRX_AMOUNT />
</GLENTRY>
</ENTRIES>
</GLBATCH>
</create>
</function>";
StatisticalJournalEntryCreate record = new StatisticalJournalEntryCreate("unittest")
{
JournalSymbol = "SJ",
PostingDate = new DateTime(2016, 06, 30),
ReverseDate = new DateTime(2016, 07, 01),
Description = "My desc",
HistoryComment = "comment!",
ReferenceNumber = "123",
AttachmentsId = "AT001",
Action = "Posted",
CustomFields = new Dictionary <string, dynamic>
{
{ "CUSTOMFIELD01", "test01" }
},
};
StatisticalJournalEntryLineCreate line1 = new StatisticalJournalEntryLineCreate();
record.Lines.Add(line1);
this.CompareXml(expected, record);
}
public void CreditAmountTest()
{
string expected = @"<?xml version=""1.0"" encoding=""utf-8""?>
<GLENTRY>
<ACCOUNTNO />
<TR_TYPE>-1</TR_TYPE>
<TRX_AMOUNT>100.01</TRX_AMOUNT>
</GLENTRY>";
StatisticalJournalEntryLineCreate record = new StatisticalJournalEntryLineCreate
{
Amount = -100.01M
};
this.CompareXml(expected, record);
}
public void GetXmlTest()
{
string expected = @"<?xml version=""1.0"" encoding=""utf-8""?>
<function controlid=""unittest"">
<create>
<GLBATCH>
<JOURNAL />
<BATCH_DATE />
<BATCH_TITLE />
<ENTRIES>
<GLENTRY>
<ACCOUNTNO />
<TR_TYPE>1</TR_TYPE>
<TRX_AMOUNT />
</GLENTRY>
</ENTRIES>
</GLBATCH>
</create>
</function>";
Stream stream = new MemoryStream();
XmlWriterSettings xmlSettings = new XmlWriterSettings();
xmlSettings.Encoding = Encoding.UTF8;
xmlSettings.Indent = true;
xmlSettings.IndentChars = " ";
IaXmlWriter xml = new IaXmlWriter(stream, xmlSettings);
StatisticalJournalEntryCreate record = new StatisticalJournalEntryCreate("unittest");
StatisticalJournalEntryLineCreate line1 = new StatisticalJournalEntryLineCreate();
record.Lines.Add(line1);
record.WriteXml(ref xml);
xml.Flush();
stream.Position = 0;
StreamReader reader = new StreamReader(stream);
Diff xmlDiff = DiffBuilder.Compare(expected).WithTest(reader.ReadToEnd())
.WithDifferenceEvaluator(DifferenceEvaluators.Default)
.Build();
Assert.IsFalse(xmlDiff.HasDifferences(), xmlDiff.ToString());
}
public void GetAllXmlTest()
{
string expected = @"<?xml version=""1.0"" encoding=""utf-8""?>
<GLENTRY>
<DOCUMENT>212</DOCUMENT>
<ACCOUNTNO>9000</ACCOUNTNO>
<TR_TYPE>1</TR_TYPE>
<TRX_AMOUNT>1456.54</TRX_AMOUNT>
<LOCATION>100</LOCATION>
<DEPARTMENT>ADM</DEPARTMENT>
<PROJECTID>P100</PROJECTID>
<CUSTOMERID>C100</CUSTOMERID>
<VENDORID>V100</VENDORID>
<EMPLOYEEID>E100</EMPLOYEEID>
<ITEMID>I100</ITEMID>
<CLASSID>C200</CLASSID>
<CONTRACTID>C300</CONTRACTID>
<WAREHOUSEID>W100</WAREHOUSEID>
<DESCRIPTION>my memo</DESCRIPTION>
<CUSTOM01>123</CUSTOM01>
</GLENTRY>";
StatisticalJournalEntryLineCreate record = new StatisticalJournalEntryLineCreate()
{
DocumentNumber = "212",
StatAccountNumber = "9000",
Amount = 1456.54M,
Memo = "my memo",
LocationId = "100",
DepartmentId = "ADM",
ProjectId = "P100",
CustomerId = "C100",
VendorId = "V100",
EmployeeId = "E100",
ItemId = "I100",
ClassId = "C200",
ContractId = "C300",
WarehouseId = "W100",
CustomFields = new Dictionary <string, dynamic>
{
{ "CUSTOM01", "123" }
}
};
this.CompareXml(expected, record);
}
public void AllocationTest()
{
string expected = @"<?xml version=""1.0"" encoding=""utf-8""?>
<GLENTRY>
<ACCOUNTNO>9000</ACCOUNTNO>
<TR_TYPE>1</TR_TYPE>
<TRX_AMOUNT>1456.54</TRX_AMOUNT>
<ALLOCATION>60-40</ALLOCATION>
</GLENTRY>";
StatisticalJournalEntryLineCreate record = new StatisticalJournalEntryLineCreate()
{
StatAccountNumber = "9000",
Amount = 1456.54M,
AllocationId = "60-40",
};
this.CompareXml(expected, record);
}
public void CustomAllocationTest()
{
string expected = @"<?xml version=""1.0"" encoding=""utf-8""?>
<GLENTRY>
<ACCOUNTNO>9000</ACCOUNTNO>
<TR_TYPE>1</TR_TYPE>
<TRX_AMOUNT>1000.00</TRX_AMOUNT>
<ALLOCATION>Custom</ALLOCATION>
<SPLIT>
<AMOUNT>600.00</AMOUNT>
</SPLIT>
<SPLIT>
<AMOUNT>400.00</AMOUNT>
</SPLIT>
</GLENTRY>";
StatisticalJournalEntryLineCreate record = new StatisticalJournalEntryLineCreate()
{
StatAccountNumber = "9000",
Amount = 1000.00M,
AllocationId = "Custom",
};
CustomAllocationSplit split1 = new CustomAllocationSplit()
{
Amount = 600.00M,
};
CustomAllocationSplit split2 = new CustomAllocationSplit()
{
Amount = 400.00M,
};
record.CustomAllocationSplits.Add(split1);
record.CustomAllocationSplits.Add(split2);
this.CompareXml(expected, record);
}
public void GetAllXmlTest()
{
string expected = @"<?xml version=""1.0"" encoding=""utf-8""?>
<function controlid=""unittest"">
<create>
<GLBATCH>
<JOURNAL>SJ</JOURNAL>
<BATCH_DATE>06/30/2016</BATCH_DATE>
<REVERSEDATE>07/01/2016</REVERSEDATE>
<BATCH_TITLE>My desc</BATCH_TITLE>
<HISTORY_COMMENT>comment!</HISTORY_COMMENT>
<REFERENCENO>123</REFERENCENO>
<SUPDOCID>AT001</SUPDOCID>
<STATE>Posted</STATE>
<CUSTOMFIELD01>test01</CUSTOMFIELD01>
<ENTRIES>
<GLENTRY>
<ACCOUNTNO />
<TR_TYPE>1</TR_TYPE>
<TRX_AMOUNT />
</GLENTRY>
</ENTRIES>
</GLBATCH>
</create>
</function>";
Stream stream = new MemoryStream();
XmlWriterSettings xmlSettings = new XmlWriterSettings();
xmlSettings.Encoding = Encoding.UTF8;
xmlSettings.Indent = true;
xmlSettings.IndentChars = " ";
IaXmlWriter xml = new IaXmlWriter(stream, xmlSettings);
StatisticalJournalEntryCreate record = new StatisticalJournalEntryCreate("unittest")
{
JournalSymbol = "SJ",
PostingDate = new DateTime(2016, 06, 30),
ReverseDate = new DateTime(2016, 07, 01),
Description = "My desc",
HistoryComment = "comment!",
ReferenceNumber = "123",
AttachmentsId = "AT001",
Action = "Posted",
CustomFields = new Dictionary <string, dynamic>
{
{ "CUSTOMFIELD01", "test01" }
},
};
StatisticalJournalEntryLineCreate line1 = new StatisticalJournalEntryLineCreate();
record.Lines.Add(line1);
record.WriteXml(ref xml);
xml.Flush();
stream.Position = 0;
StreamReader reader = new StreamReader(stream);
Diff xmlDiff = DiffBuilder.Compare(expected).WithTest(reader.ReadToEnd())
.WithDifferenceEvaluator(DifferenceEvaluators.Default)
.Build();
Assert.IsFalse(xmlDiff.HasDifferences(), xmlDiff.ToString());
}
public void GetAllXmlTest()
{
string expected = @"<?xml version=""1.0"" encoding=""utf-8""?>
<GLENTRY>
<DOCUMENT>212</DOCUMENT>
<ACCOUNTNO>9000</ACCOUNTNO>
<TR_TYPE>1</TR_TYPE>
<TRX_AMOUNT>1456.54</TRX_AMOUNT>
<LOCATION>100</LOCATION>
<DEPARTMENT>ADM</DEPARTMENT>
<PROJECTID>P100</PROJECTID>
<CUSTOMERID>C100</CUSTOMERID>
<VENDORID>V100</VENDORID>
<EMPLOYEEID>E100</EMPLOYEEID>
<ITEMID>I100</ITEMID>
<CLASSID>C200</CLASSID>
<CONTRACTID>C300</CONTRACTID>
<WAREHOUSEID>W100</WAREHOUSEID>
<DESCRIPTION>my memo</DESCRIPTION>
<CUSTOM01>123</CUSTOM01>
</GLENTRY>";
Stream stream = new MemoryStream();
XmlWriterSettings xmlSettings = new XmlWriterSettings();
xmlSettings.Encoding = Encoding.UTF8;
xmlSettings.Indent = true;
xmlSettings.IndentChars = " ";
IaXmlWriter xml = new IaXmlWriter(stream, xmlSettings);
StatisticalJournalEntryLineCreate record = new StatisticalJournalEntryLineCreate()
{
DocumentNumber = "212",
StatAccountNumber = "9000",
Amount = 1456.54M,
Memo = "my memo",
LocationId = "100",
DepartmentId = "ADM",
ProjectId = "P100",
CustomerId = "C100",
VendorId = "V100",
EmployeeId = "E100",
ItemId = "I100",
ClassId = "C200",
ContractId = "C300",
WarehouseId = "W100",
CustomFields = new Dictionary <string, dynamic>
{
{ "CUSTOM01", "123" }
}
};
record.WriteXml(ref xml);
xml.Flush();
stream.Position = 0;
StreamReader reader = new StreamReader(stream);
Diff xmlDiff = DiffBuilder.Compare(expected).WithTest(reader.ReadToEnd())
.WithDifferenceEvaluator(DifferenceEvaluators.Default)
.Build();
Assert.IsFalse(xmlDiff.HasDifferences(), xmlDiff.ToString());
}
