private void showSummary(InvoiceDataset.VendorInvoiceTableRow invoice)
{
//Set named range summary values
Detail detail = global::Argix.Finance.Globals.Detail;
//Remit To
detail.RemitToName.Value = invoice.RemitToName.Trim() + " " + invoice.RemitToAddressLine1.Trim() + " " + invoice.RemitToCity.Trim() + ", " + invoice.RemitToState.Trim() + " " + invoice.RemitToZip.Trim() + "-" + invoice.RemitToZip4.Trim();
//detail.RemitToName.Value = invoice.RemitToName.Trim();
//detail.RemitToAddressLine1.Value = invoice.RemitToAddressLine1.Trim();
//// detail.RemitToAddressLine2.Value = invoice.RemitToAddressLine2.Trim();
//detail.RemitToCityStateZip.Value = invoice.RemitToCity.Trim() + ", " + invoice.RemitToState.Trim() + " " + invoice.RemitToZip.Trim();
detail.Telephone.Value = (invoice.IsTelephoneNull() ? "" : invoice.Telephone.ToString());
//Bill To
detail.ClientNumberDiv.Value = invoice.ClientNumber.Trim() + ' ' + invoice.ClientDivision.Trim();
detail.BillToName.Value = invoice.BillToName.Trim();
detail.BillToAddressLine1.Value = invoice.BillToAddressline1.Trim();
detail.BillToAddressLine2.Value = invoice.BillToAddressline2.Trim();
detail.BillToCityStateZip.Value = invoice.BillToCity.Trim() + ", " + invoice.BillToState.Trim() + " " + invoice.BillToZip.Trim() + "-" + invoice.BillToZIP4.Trim();
//Account
detail.InvoiceNumber.Value = invoice.InvoiceNumber.Trim();
detail.InvoiceDate.Value = invoice.InvoiceDate;
//summary.Terms1.Value = invoice.Terms;
}
private void createDetailFooter(InvoiceDataset.VendorInvoiceTableRow invoice)
{
//
Detail detail = global::Argix.Finance.Globals.Detail;
detail.Reference.Value2 = "PLEASE REFERENCE INVOICE# " + invoice.InvoiceNumber + " WHEN REMITING PAYMENT. I.C.C. REGULATIONS REQUIRE THAT THIS BILL BE PAID WITHIN " + invoice.PaymentDays + " DAYS";
}
private void createDetailHeader(InvoiceDataset.VendorInvoiceTableRow invoice)
{
//Create header of detail worksheet
Detail detail = global::Argix.Finance.Globals.Detail;
//Remit To
detail.VendorNumber.Value = invoice.IsVendorNumberNull() ? "" : invoice.VendorNumber.Trim();
detail.RemitToName.Value = invoice.RemitToName.Trim() + " " + invoice.RemitToAddressLine1.Trim() + " " + invoice.RemitToCity.Trim() + ", " + invoice.RemitToState.Trim() + " " + invoice.RemitToZip.Trim();
//detail.RemitToName.Value = invoice.RemitToName.Trim();
//detail.RemitToAddressLine1.Value = invoice.RemitToAddressLine1.Trim();
//detail.RemitToAddressLine2.Value = invoice.IsRemitToAddressLine2Null() ? "" : invoice.RemitToAddressLine2.Trim();
//detail.RemitToCityStateZip.Value = invoice.RemitToCity.Trim() + ", " + invoice.RemitToState.Trim() + " " + invoice.RemitToZip.Trim();
detail.Telephone.Value = (invoice.IsTelephoneNull() ? "" : invoice.Telephone.ToString());
//Bill To
detail.BillToName.Value = invoice.BillToName.Trim();
detail.BillToAddressLine1.Value = invoice.BillToAddressline1.Trim();
detail.BillToAddressLine2.Value = invoice.IsBillToAddressline2Null() ? "" : invoice.BillToAddressline2.Trim();
detail.BillToCityStateZip.Value = invoice.BillToCity.Trim() + ", " + invoice.BillToState.Trim() + " " + invoice.BillToZip.Trim() + "-" + invoice.BillToZIP4.Trim();
//Account
detail.InvoiceNumber.Value = invoice.InvoiceNumber.Trim();
detail.InvoiceDate.Value = invoice.InvoiceDate;
}