Difference between revisions of "C Purchase Orders"

Revision as of 15:49, 22 October 2015

The SDK only Allows for Invoice documents to be processed through SalesOrder class. Sales Orders can either be placed by using the Save() method or they can be processed in to a Invoice using the Process() method. When a order is placed it is just a request for goods and is not posted to any posting tables but gets saved as a document in the invnum table and affects the items quantities ordered. Once the order is processed the necessary posting tables are populated affecting the General Ledger, Customer Ledger and Inventory. Since the ordered quantity might not be the Sold quantities , orders can be partially processed. A Sales Quotation can also be done as well as reserving of stock.

The following example displays how a typical order is placed using the SDK thereafter the order is partially processed then the balance of the order is completed:

//Create a new instance of a SalesOrder class SalesOrder order = new SalesOrder(); Customer cust = new Customer("Customer1"); order.Customer = cust;//Assign a value to the Customer property //the Detail property contains the document lines order.Detail.Add("ItemA", 5, 10); order.Save();//Place the Order string orderNo = order.OrderNo; MessageBox.Show(orderNo); There are a number of overloaded Add methods. The Add method used above specifies the product code as a string, but you may well find that the other versions of this method will better suit your purpose.Assuming the account is taxable, the document total as well as the total for line 1 (index 0 in the collection) will result in 57.00, local currency. Every sales order must have an order number, so at this point, unless you are supplying your own order number, you may want to store the value of order.OrderNo, which is generated.

To process the Order in to a Invoice we would need to specify a quantity to process and use the process method as follows.

order.Detail[0].ToProcess = 2; order.Process(); If we set the ToProcess quantity to 5, we would in fact be completing the order when we call Process. The Process function takes care of all the underlying transactions and returns the reference number of the invoice transaction created. Thereafter there would be no point in keeping this order opened, since the quantity of stock requested has now been sold; hence the order is then marked as archived and cannot be processed further. By setting the ToProcess quantity above to 2, you would end up with 2 documents: an archived document for 2 units, and a partially processed document for the remaining 3 units. The archived document cannot be altered, but we can later retrieve the partially processed document. Bys using the complete method we can even process the total quantity outstanding automatically and not specifying a quantity as below

SalesOrder newOrder = new SalesOrder(orderNo); newOrder.Complete();// the complete method completes the whole unprocessed order The following example displays a Sales order using a GL line as well as a inventory item with the customers default price list also we specify addresses to be used. To use a GL Account as a item the Account in Evolution has to first be edited and flagged to be used on a order:

SalesOrder SO = new SalesOrder(); SO.Customer = new Customer("CustomerSDK1"); SO.InvoiceDate = DateTime.Now;// choose to set the invoice date or Order date etc SO.InvoiceTo = SO.Customer.PostalAddress.Condense();//Condense method can be used or you can specify the address as below SO.DeliverTo = new Address("Physical Address 1", "Address 2", "Address 3", "Address 4", "Address 5", "PC"); SO.Project = new Project("P1");//Various SO properties like project can be set

OrderDetail OD = new OrderDetail(); SO.Detail.Add(OD); //Vaious Order Detail properties can be added like warehouse , sales reps , userfields etc OD.InventoryItem = new InventoryItem("ItemA");//Use the inventoryItem constructor to specify a Item OD.Quantity = 10; OD.ToProcess = OD.Quantity; OD.UnitSellingPrice = OD.InventoryItem.SellingPrices[SO.Customer.DefaultPriceList].PriceIncl;//Specify the Customer Default price list

OD = new OrderDetail(); SO.Detail.Add(OD); OD.GLAccount = new GLAccount("Accounting Fees");//Use the GLAccount Item constructor to specify a Account OD.Quantity = 1; OD.ToProcess = OD.Quantity; OD.UnitSellingPrice = 30;

SO.Process(); The following example is on processing a Sales Order Quotation:

SalesOrderQuotation SOQ = new SalesOrderQuotation(); SOQ.Customer = new Customer("Cust1");

OrderDetail OD = new OrderDetail(); SOQ.Detail.Add(OD); //Vaious Order Detail properties can be added like warehouse , sales reps , userfields etc OD.InventoryItem = new InventoryItem("ItemA");//Use the inventoryItem constructor to specify a Item OD.Quantity = 10; OD.ToProcess = OD.Quantity; OD.UnitSellingPrice = 20;

SOQ.Save();//You can Save the quote or process a existing quote in to a invoice Quantity can be reserved on a Sales Order if the Order Entry Defaults | Sales Orders is set to reserve quantities. The order has to be saved and not processed to reserve stock.

SalesOrder SO = new SalesOrder(); SO.Customer = new Customer("Cust1");

OrderDetail OD = new OrderDetail(); SO.Detail.Add(OD); //Vaious Order Detail properties can be added like warehouse , sales reps , userfields etc OD.InventoryItem = new InventoryItem("ItemA");//Use the inventoryItem constructor to specify a Item OD.Quantity = 5; OD.Reserved = 5;//specify quantity to reserve OD.UnitSellingPrice = 20;

SO.Process();// To reserve quantity the order must be saved not processed The following example is on processing a existing sales order and specifying the quantity for each line.

SalesOrder SO = new SalesOrder("SO00023");//Specify the order number to process foreach (OrderDetail NewOD in SO.Detail) {

   NewOD.ToProcess = NewOD.Outstanding;//specify outstanding quantity to process for each line other changes can also be made

} SO.Process();//Process the SalesOrder - See more at: http://kb.pastel.co.za/article.php?id=1999#sthash.NdRz3YVv.dpuf