Categories: QuickBooks Desktop

How To Add Purchase Order In Quickbook Desktop Using C#

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.

Sagar Rana

Sagar Rana is a Web Developer in Vision Infotech. He has strong skills and knowledge of ASP.NET C#, ASP.NET MVC, .Net Core, Jquery, JavaScript, WEB API, React.js, ADO.Net, Entity Framework, SQL and different integration like Xero, Stripe, Zoho CRM, Square, PayTM, PayKUN, RazorPay, Quickbook Desktop etc.

Recent Posts

Testing hk

Testing

2 years ago

Create and Used PIPE in angular

In this article, we have to show Create and Used PIPE in angular

2 years ago

Operation

Testing

2 years ago

Create and Used PIPE in angular

In this article, we have to show Create and Used PIPE in angular

2 years ago

Create and Used PIPE in angular

In this article, we have to show Create and Used PIPE in angular

2 years ago

TETS NEW

test

2 years ago