Introduction
In this article, we will learn how to create a purchase order in Quickbook Desktop using C#.
If you have not seen Quickbook Desktop Installation then I recommend to see that first. in that article here.
First of all Install the Interop.QBFC13 package in your project.
Install Package
Right click of your project and select Manage Nuget Packages.
After search Interop.QBFC13 and install it.
The code is as below.
Create Item
//create item IItemNonInventoryAdd newitem = requestSet.AppendItemNonInventoryAddRq(); newitem.Name.SetValue(itemName); newitem.ORSalesPurchase.SalesAndPurchase.Type.Equals("Non-inventory Part"); newitem.ORSalesPurchase.SalesAndPurchase.PurchaseDesc.SetValue(""); newitem.ORSalesPurchase.SalesAndPurchase.SalesDesc.SetValue(""); newitem.ORSalesPurchase.SalesAndPurchase.PurchaseCost.SetValue(itemAmount); newitem.ORSalesPurchase.SalesAndPurchase.SalesPrice.SetValue(itemAmount); newitem.ORSalesPurchase.SalesAndPurchase.IncomeAccountRef.FullName.SetValue("Payroll Liabilities"); newitem.ORSalesPurchase.SalesAndPurchase.ExpenseAccountRef.FullName.SetValue("Payroll Liabilities"); responseSet = sessionManager.DoRequests(requestSet); requestSet.ClearRequests();
Create Purchase Order
public void AddPurchaseOrder() { try { QBSessionManager sessionManager = new QBSessionManager(); sessionManager.OpenConnection(@"Your Company File Path", "POAdd C# sample"); sessionManager.BeginSession("", ENOpenMode.omDontCare); IMsgSetRequest requestSet = sessionManager.CreateMsgSetRequest("US", 13, 0); requestSet.Attributes.OnError = ENRqOnError.roeStop; IMsgSetResponse responseSet; IResponse response; responseSet = sessionManager.DoRequests(requestSet); DateTime duedate; duedate = DateTime.MinValue; string vendorName = "Sagar Rana"; //create vendor IVendorAdd newVendor = requestSet.AppendVendorAddRq(); newVendor.Name.SetValue(vendorName); responseSet = sessionManager.DoRequests(requestSet); requestSet.ClearRequests(); //create purchase order IPurchaseOrderAdd PurchaseOrderAdd = requestSet.AppendPurchaseOrderAddRq(); PurchaseOrderAdd.VendorRef.FullName.SetValue(vendorName); PurchaseOrderAdd.ORInventorySiteORShipToEntity.ShipToEntityRef.FullName.SetValue("sagar rana");//existing customer name PurchaseOrderAdd.TxnDate.SetValue(DateTime.Now); PurchaseOrderAdd.Other1.SetValue("31"); PurchaseOrderAdd.TemplateRef.FullName.SetValue("Custom Purchase Order"); //purchase order Item IORPurchaseOrderLineAdd PurchaseOrderLineAdd = PurchaseOrderAdd.ORPurchaseOrderLineAddList.Append(); PurchaseOrderLineAdd.PurchaseOrderLineAdd.Other1.SetValue(""); PurchaseOrderLineAdd.PurchaseOrderLineAdd.ItemRef.FullName.SetValue("Computer");//existing item name PurchaseOrderLineAdd.PurchaseOrderLineAdd.Quantity.SetValue(1); PurchaseOrderLineAdd.PurchaseOrderLineAdd.Desc.SetValue(""); PurchaseOrderLineAdd.PurchaseOrderLineAdd.Rate.SetValue(1500); PurchaseOrderLineAdd.PurchaseOrderLineAdd.CustomerRef.FullName.SetValue("sagar rana");//existing customer name responseSet = sessionManager.DoRequests(requestSet); response = responseSet.ResponseList.GetAt(0); sessionManager.CloseConnection(); sessionManager.EndSession(); MessageBox.Show("New PurchaseOrder Import Successfully."); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
If you have any questions about this article, please let me know and more information here.