protected void AddLineItem(Models.ViewModels.Purchases.PurchaseHeaderViewModel model) { var item = _inventoryService.GetItemByNo(model.PurchaseLine.ItemNo); var newLine = new Models.ViewModels.Purchases.PurchaseLineItemViewModel() { ItemId = item.Id, ItemNo = item.No, ItemDescription = item.Description, Measurement = item.SellMeasurement.Description, Quantity = model.PurchaseLine.Quantity, Price = model.PurchaseLine.Price, }; model.PurchaseLine.PurchaseLineItems.Add(newLine); foreach (var line in model.PurchaseLine.PurchaseLineItems) { var taxes = _financialService.ComputeInputTax(model.VendorId.Value, line.ItemId, line.Quantity, line.Price, decimal.Zero); var taxVM = new Models.ViewModels.Purchases.PurchaseLineItemTaxViewModel(); //foreach (var tax in taxes) //{ // var t = _financialService.GetTaxes().Where(tx => tx.Id == int.Parse(tax.Key.ToString())).FirstOrDefault(); // taxVM.TaxId = int.Parse(tax.Key.ToString()); // taxVM.Amount = tax.Value; // taxVM.TaxRate = t.Rate; // taxVM.TaxName = t.TaxName; // model.PurchaseLine.PurchaseLineItemsTaxes.Add(taxVM); //} } }
public dynamic GenerateGLHeader(ICollection <PurchaseInvoiceLine> InvoiceLines, PurchaseInvoiceHeader purchaseIvoice) { var glHeader = _financialService.CreateGeneralLedgerHeader(DocumentTypes.PurchaseInvoice, purchaseIvoice.Date, purchaseIvoice.Description); decimal totalTaxAmount = 0, totalAmount = 0, totalDiscount = 0; var taxes = new List <KeyValuePair <int, decimal> >(); foreach (var line in InvoiceLines) { var lineTaxes = _financialService.ComputeInputTax(purchaseIvoice.VendorId.Value, line.ItemId, line.Quantity, line.Cost.Value, decimal.Zero); var lineAmount = line.Quantity * line.Cost; var totalLineAmount = lineAmount + lineTaxes.Sum(t => t.Value); totalAmount += (decimal)totalLineAmount; foreach (var t in lineTaxes) { taxes.Add(t); } } if (taxes != null && taxes.Count > 0) { var groupedTaxes = from t in taxes group t by t.Key into grouped select new { Key = grouped.Key, Value = grouped.Sum(t => t.Value) }; totalTaxAmount = taxes.Sum(t => t.Value); foreach (var tax in groupedTaxes) { var tx = _financialService.GetTaxes().Where(t => t.Id == tax.Key).FirstOrDefault(); var debitPurchaseTaxAccount = _financialService.CreateGeneralLedgerLine(DrOrCrSide.Dr, tx.PurchasingAccountId.Value, tax.Value); glHeader.GeneralLedgerLines.Add(debitPurchaseTaxAccount); } } if (totalDiscount > 0) { } Vendor vendor = _vendorRepo.GetById(purchaseIvoice.VendorId.Value); var creditVendorAccount = _financialService.CreateGeneralLedgerLine(DrOrCrSide.Cr, vendor.AccountsPayableAccountId.Value, totalAmount); glHeader.GeneralLedgerLines.Add(creditVendorAccount); var debitGRNClearingAccount = _financialService.CreateGeneralLedgerLine(DrOrCrSide.Dr, GetGeneralLedgerSetting().GoodsReceiptNoteClearingAccountId.Value, totalAmount - totalTaxAmount); glHeader.GeneralLedgerLines.Add(debitGRNClearingAccount); return(glHeader); }
public void AddPurchaseInvoice(PurchaseInvoiceHeader purchaseIvoice, int?purchaseOrderId) { #region Auto create purchase order if (!purchaseOrderId.HasValue) { var po = new PurchaseOrderHeader() { Date = purchaseIvoice.Date, No = GetNextNumber(SequenceNumberTypes.PurchaseOrder).ToString(), Vendor = purchaseIvoice.Vendor, VendorId = purchaseIvoice.VendorId.Value, Description = purchaseIvoice.Description, }; foreach (var line in purchaseIvoice.PurchaseInvoiceLines) { var item = _inventoryService.GetItemById(line.ItemId); po.PurchaseOrderLines.Add(new PurchaseOrderLine() { ItemId = item.Id, MeasurementId = line.MeasurementId, Quantity = line.Quantity, Cost = item.Cost.Value, Discount = line.Discount.HasValue ? line.Discount.Value : 0, Amount = line.Amount * line.Quantity, }); } purchaseIvoice.PurchaseOrders.Add(po); //var poReceipt = new PurchaseReceiptHeader() //{ // Date = DateTime.Now, // VendorId = po.VendorId.Value, // PurchaseOrderHeaderId = po.Id, //}; //foreach (var line in purchaseIvoice.PurchaseInvoiceLines) //{ // poReceipt.PurchaseReceiptLines.Add(new PurchaseReceiptLine() // { // ItemId = line.ItemId, // MeasurementId = line.MeasurementId, // Quantity = line.Quantity, // ReceivedQuantity = (line.ReceivedQuantity.HasValue ? line.ReceivedQuantity.Value : 0), // Cost = line.Cost.Value, // Amount = line.Cost.Value * (line.ReceivedQuantity.HasValue ? line.ReceivedQuantity.Value : 0), // }); //} //po.PurchaseReceipts.Add(poReceipt); //AddPurchaseOrderReceipt(poReceipt); } #endregion var glHeader = _financialService.CreateGeneralLedgerHeader(DocumentTypes.PurchaseInvoice, purchaseIvoice.Date, purchaseIvoice.Description); decimal totalTaxAmount = 0, totalAmount = 0, totalDiscount = 0; var taxes = new List <KeyValuePair <int, decimal> >(); foreach (var line in purchaseIvoice.PurchaseInvoiceLines) { var lineTaxes = _financialService.ComputeInputTax(purchaseIvoice.VendorId.GetValueOrDefault(), line.ItemId, line.Quantity, line.Amount, line.Discount.GetValueOrDefault()); var lineAmount = line.Quantity * line.Amount; var totalLineAmount = lineAmount + lineTaxes.Sum(t => t.Value); totalAmount += (decimal)totalLineAmount; foreach (var t in lineTaxes) { taxes.Add(t); } var item = _inventoryService.GetItemById(line.ItemId); decimal lineItemTotalAmountAfterTax = line.Amount - lineTaxes.Sum(t => t.Value); GeneralLedgerLine debitInventory = _financialService.CreateGeneralLedgerLine(DrOrCrSide.Dr, item.InventoryAccount.Id, lineItemTotalAmountAfterTax); glHeader.GeneralLedgerLines.Add(debitInventory); GeneralLedgerLine creditGRNClearingAccount = _financialService.CreateGeneralLedgerLine(DrOrCrSide.Cr, GetGeneralLedgerSetting().GoodsReceiptNoteClearingAccountId.Value, lineItemTotalAmountAfterTax); glHeader.GeneralLedgerLines.Add(creditGRNClearingAccount); line.InventoryControlJournal = _inventoryService.CreateInventoryControlJournal(line.ItemId, line.MeasurementId, DocumentTypes.PurchaseReceipt, line.Quantity, null, line.Quantity * item.Cost, null); } if (taxes != null && taxes.Count > 0) { var groupedTaxes = from t in taxes group t by t.Key into grouped select new { Key = grouped.Key, Value = grouped.Sum(t => t.Value) }; totalTaxAmount = taxes.Sum(t => t.Value); foreach (var tax in groupedTaxes) { var tx = _financialService.GetTaxes().Where(t => t.Id == tax.Key).FirstOrDefault(); var debitPurchaseTaxAccount = _financialService.CreateGeneralLedgerLine(DrOrCrSide.Dr, tx.PurchasingAccountId.Value, tax.Value); glHeader.GeneralLedgerLines.Add(debitPurchaseTaxAccount); } } if (totalDiscount > 0) { } Vendor vendor = GetVendorById(purchaseIvoice.VendorId.Value); var creditVendorAccount = _financialService.CreateGeneralLedgerLine(DrOrCrSide.Cr, vendor.AccountsPayableAccountId.Value, totalAmount); glHeader.GeneralLedgerLines.Add(creditVendorAccount); var debitGRNClearingAccount = _financialService.CreateGeneralLedgerLine(DrOrCrSide.Dr, GetGeneralLedgerSetting().GoodsReceiptNoteClearingAccountId.Value, totalAmount - totalTaxAmount); glHeader.GeneralLedgerLines.Add(debitGRNClearingAccount); if (_financialService.ValidateGeneralLedgerEntry(glHeader)) { purchaseIvoice.GeneralLedgerHeader = glHeader; purchaseIvoice.No = GetNextNumber(SequenceNumberTypes.PurchaseInvoice).ToString(); _purchaseInvoiceRepo.Insert(purchaseIvoice); if (purchaseOrderId.HasValue) { // TODO: Look for other way to update the purchase order's invoice header id field so that it shall be in a single transaction along with purchase invoice saving var purchOrder = GetPurchaseOrderById(purchaseOrderId.GetValueOrDefault()); //purchOrder.PurchaseInvoiceHeaderId = purchaseIvoice.Id; _purchaseOrderRepo.Update(purchOrder); } } }
public void AddPurchaseInvoice(PurchaseInvoiceHeader purchaseIvoice, int?purchaseOrderId) { #region Auto create purchase order if (!purchaseOrderId.HasValue) { var po = new PurchaseOrderHeader() { Date = purchaseIvoice.Date, //No = GetNextNumber(SequenceNumberTypes.PurchaseOrder).ToString(), Vendor = purchaseIvoice.Vendor, VendorId = purchaseIvoice.VendorId.Value, Description = purchaseIvoice.Description, }; foreach (var line in purchaseIvoice.PurchaseInvoiceLines) { var item = _itemRepo.GetById(line.ItemId); po.PurchaseOrderLines.Add(new PurchaseOrderLine() { ItemId = item.Id, MeasurementId = line.MeasurementId, Quantity = line.Quantity, Cost = item.Cost.Value, Discount = line.Discount.HasValue ? line.Discount.Value : 0, Amount = item.Cost.Value * line.Quantity, }); } purchaseIvoice.PurchaseOrders.Add(po); var poReceipt = new PurchaseReceiptHeader() { Date = DateTime.Now, Vendor = po.Vendor, VendorId = po.VendorId.Value, PurchaseOrderHeaderId = po.Id, }; foreach (var line in purchaseIvoice.PurchaseInvoiceLines) { poReceipt.PurchaseReceiptLines.Add(new PurchaseReceiptLine() { ItemId = line.ItemId, MeasurementId = line.MeasurementId, Quantity = line.Quantity, ReceivedQuantity = (line.ReceivedQuantity.HasValue ? line.ReceivedQuantity.Value : 0), Cost = line.Cost.Value, Amount = line.Cost.Value * (line.ReceivedQuantity.HasValue ? line.ReceivedQuantity.Value : 0), }); } po.PurchaseReceipts.Add(poReceipt); AddPurchaseOrderReceipt(poReceipt); } #endregion decimal totalTaxAmount = 0, totalAmount = 0, totalDiscount = 0; var taxes = new List <KeyValuePair <int, decimal> >(); foreach (var line in purchaseIvoice.PurchaseInvoiceLines) { var lineTaxes = _financialService.ComputeInputTax(purchaseIvoice.VendorId.Value, line.ItemId, line.Quantity, line.Cost.Value, decimal.Zero); var lineAmount = line.Quantity * line.Cost; var totalLineAmount = lineAmount + lineTaxes.Sum(t => t.Value); totalAmount += (decimal)totalLineAmount; foreach (var t in lineTaxes) { taxes.Add(t); } } if (taxes != null && taxes.Count > 0) { var groupedTaxes = from t in taxes group t by t.Key into grouped select new { Key = grouped.Key, Value = grouped.Sum(t => t.Value) }; totalTaxAmount = taxes.Sum(t => t.Value); //foreach (var tax in groupedTaxes) //{ // var tx = _financialService.GetTaxes().Where(t => t.Id == tax.Key).FirstOrDefault(); //} } if (totalDiscount > 0) { } Vendor vendor = _vendorRepo.GetById(purchaseIvoice.VendorId.Value); }
public void AddPurchaseInvoice(PurchaseInvoiceHeader purchaseIvoice, int?purchaseOrderId) { #region Auto create purchase order if (!purchaseOrderId.HasValue) { var po = new PurchaseOrderHeader() { Date = purchaseIvoice.Date, No = GetNextNumber(SequenceNumberTypes.PurchaseOrder).ToString(), Vendor = purchaseIvoice.Vendor, VendorId = purchaseIvoice.VendorId.Value, Description = purchaseIvoice.Description, CreatedBy = purchaseIvoice.CreatedBy, CreatedOn = purchaseIvoice.CreatedOn, ModifiedBy = purchaseIvoice.ModifiedBy, ModifiedOn = purchaseIvoice.ModifiedOn }; foreach (var line in purchaseIvoice.PurchaseInvoiceLines) { var item = _itemRepo.GetById(line.ItemId); po.PurchaseOrderLines.Add(new PurchaseOrderLine() { ItemId = item.Id, MeasurementId = line.MeasurementId, Quantity = line.Quantity, Cost = item.Cost.Value, Discount = line.Discount.HasValue ? line.Discount.Value : 0, Amount = item.Cost.Value * line.Quantity, CreatedBy = line.CreatedBy, CreatedOn = line.CreatedOn, ModifiedBy = line.ModifiedBy, ModifiedOn = line.ModifiedOn }); } purchaseIvoice.PurchaseOrders.Add(po); var poReceipt = new PurchaseReceiptHeader() { Date = DateTime.Now, Vendor = po.Vendor, VendorId = po.VendorId, PurchaseOrderHeaderId = po.Id, CreatedBy = po.CreatedBy, CreatedOn = DateTime.Now, ModifiedBy = po.ModifiedBy, ModifiedOn = DateTime.Now }; foreach (var line in purchaseIvoice.PurchaseInvoiceLines) { poReceipt.PurchaseReceiptLines.Add(new PurchaseReceiptLine() { ItemId = line.ItemId, MeasurementId = line.MeasurementId, Quantity = line.Quantity, ReceivedQuantity = (line.ReceivedQuantity.HasValue ? line.ReceivedQuantity.Value : 0), Cost = line.Cost.Value, Amount = line.Cost.Value * (line.ReceivedQuantity.HasValue ? line.ReceivedQuantity.Value : 0), CreatedBy = po.CreatedBy, CreatedOn = DateTime.Now, ModifiedBy = po.ModifiedBy, ModifiedOn = DateTime.Now }); } po.PurchaseReceipts.Add(poReceipt); AddPurchaseOrderReceipt(poReceipt); } #endregion var glHeader = _financialService.CreateGeneralLedgerHeader(DocumentTypes.PurchaseInvoice, purchaseIvoice.Date, purchaseIvoice.Description); decimal taxAmount = 0; var taxes = new List <KeyValuePair <int, decimal> >(); foreach (var line in purchaseIvoice.PurchaseInvoiceLines) { var lineAmount = line.Quantity * line.Cost; //var item = _inventoryService.GetItemById(line.ItemId); //foreach (var tax in item.ItemTaxGroup.ItemTaxGroupTax) //{ // if(!tax.IsExempt) // { // var lineTaxAmount = (tax.Tax.Rate / 100) * lineAmount; // taxAmount += lineTaxAmount.Value; // taxes.Add(new KeyValuePair<int, decimal>(tax.Tax.PurchasingAccountId.Value, lineTaxAmount.Value)); // } //} var lineTaxes = _financialService.ComputeInputTax(line.ItemId, line.Quantity, line.Cost.Value); foreach (var t in lineTaxes) { taxes.Add(t); } } decimal totalAmount = purchaseIvoice.PurchaseInvoiceLines.Sum(d => d.Amount); decimal totalDiscount = 0; Vendor vendor = _vendorRepo.GetById(purchaseIvoice.VendorId.Value); var creditVendorAccount = _financialService.CreateGeneralLedgerLine(TransactionTypes.Cr, vendor.AccountsPayableAccountId.Value, totalAmount + taxAmount); glHeader.GeneralLedgerLines.Add(creditVendorAccount); var creditGRNClearingAccount = _financialService.CreateGeneralLedgerLine(TransactionTypes.Dr, GetGeneralLedgerSetting().GoodsReceiptNoteClearingAccountId.Value, totalAmount); glHeader.GeneralLedgerLines.Add(creditGRNClearingAccount); if (taxAmount > 0) { var groupedTaxes = from t in taxes group t by t.Key into grouped select new { Key = grouped.Key, Value = grouped.Sum(t => t.Value) }; foreach (var tax in groupedTaxes) { var tx = _financialService.GetTaxes().Where(t => t.Id == tax.Key).FirstOrDefault(); var debitPurchaseTaxAccount = _financialService.CreateGeneralLedgerLine(TransactionTypes.Dr, tx.SalesAccountId.Value, tax.Value); glHeader.GeneralLedgerLines.Add(debitPurchaseTaxAccount); } } if (totalDiscount > 0) { } if (_financialService.ValidateGeneralLedgerEntry(glHeader)) { purchaseIvoice.GeneralLedgerHeader = glHeader; purchaseIvoice.No = GetNextNumber(SequenceNumberTypes.PurchaseInvoice).ToString(); _purchaseInvoiceRepo.Insert(purchaseIvoice); // TODO: Look for another way to update the purchase order's invoice header id field so that it shall be in a single transaction along with purchase invoice saving var purchOrder = _purchaseOrderRepo.GetById(purchaseOrderId.Value); purchOrder.PurchaseInvoiceHeaderId = purchaseIvoice.Id; purchOrder.ModifiedBy = purchaseIvoice.ModifiedBy; purchOrder.ModifiedOn = purchaseIvoice.ModifiedOn; _purchaseOrderRepo.Update(purchOrder); } }