C# PO Write Fails BOI

Question

First, thanks in advance for taking a look at this. I'm looking at doing PO creation from C# and have been able to connect, get the next PO number etc., but everytime I try to finalize the PO, such as call the "nWrite" command, it always fails. Any insight into what could be happening? Below is my code. 
 using (DispatchObject poObject = new DispatchObject(pvx.InvokeMethod("NewObject", "PO_PurchaseOrder_bus", oSS.GetObject()))) { try { string poNumber = ""; //int test1 = (int)poObject.InvokeMethod("nGetNextPurchaseOrderNo"); object[] poPass = new object[] {poNumber}; successCheck((int)poObject.InvokeMethodByRef("nGetNextPurchaseOrderNo", poPass), "GetNextPurchaseOrder"); 
 //this was just to see what the PO number was coming back. poNumber = poPass[0].ToString(); 
 //we continue successCheck((int) poObject.InvokeMethodByRef("nSetKey", poPass), "SetKey"); object[] divisionNoObject = new object[] {"APDivisionNo$", "00"}; successCheck((int) poObject.InvokeMethodByRef("nSetValue", divisionNoObject), "SetDivisionNo"); object[] vendorObject = new object[] { "VendorNo$", "0006630" }; successCheck((int)poObject.InvokeMethodByRef("nSetValue", vendorObject), "SetVendorNo"); object[] taxObject = new object[] { "TaxSchedule$", "NONTAX" }; successCheck((int)poObject.InvokeMethodByRef("nSetValue", taxObject), "SetTaxSchedule"); 
 DispatchObject poLines = new DispatchObject(poObject.GetProperty("oLines")); successCheck((int)poLines.InvokeMethod("nAddLine"), "AddLine"); object[] firstLine = new object[] { "ItemCode$", "/1." }; successCheck((int)poLines.InvokeMethodByRef("nSetValue", firstLine), "PoLineItemCode"); firstLine[0] = "QuantityOrdered"; firstLine[1] = "1"; successCheck((int)poLines.InvokeMethodByRef("nSetValue", firstLine), "PoLineQuantityOrdered"); successCheck((int)poLines.InvokeMethod("nWrite"), "PoLinesWrite"); successCheck((int) poObject.InvokeMethod("nWrite"), "Write"); 
 MessageBox.Show("SUCCESS! " + poNumber.ToString()); 
 } catch (Exception ex) { MessageBox.Show(ex.Message); } 
 } 
 
 And below is my successCheck method to see what fails. 
 public void successCheck(int checkValue, string call) { if (checkValue == 0) { MessageBox.Show("Error! " + call); } }

yoandy valdes · Accepted Answer

BRO!!! Thanks man It works like a charm of course i change some thinks here am gonna paste my code for any who needed 
 using (DispatchObject pvx = new DispatchObject("ProvideX.Script")) { // Replace the text "*PATH TO MAS90\HOME*" with the correct MAS90\Home path in the line below pvx.InvokeMethod("Init", mas90); // Instantiate a new Session object and initialize the session // by setting the user, company, date and module using (DispatchObject oSS = new DispatchObject(pvx.InvokeMethod("NewObject", "SY_Session"))) { oSS.InvokeMethod("nSetUser", new object[] { username, password }); oSS.InvokeMethod("nSetCompany", new object[] { companyCode }); string date = DateTime.Today.ToString("yyyyMMdd"); oSS.InvokeMethod("nSetDate", "P/O", date); oSS.InvokeMethod("nSetModule", "P/O"); // Get the Task ID for the AR_Customer_ui program int TaskID = (int)oSS.InvokeMethod("nLookupTask", "PO_ReceiptofGoods_ui"); // int TaskID = (int)oSS.InvokeMethod("nLookupTask", "PO_ReceiptofGoods_ui"); var error2 = (string)oSS.InvokeMethod("sLastErrorMsg", null); Logger.Log("verificando si hay error en el PO_ReceiptofGoods_ui " + error2); oSS.InvokeMethod("nSetProgram", TaskID); try { using (DispatchObject PO_order = new DispatchObject(pvx.InvokeMethod("NewObject", "PO_Receipt_bus", oSS.GetObject()))) { string nextReceiptNo = ""; object[] nextReceiptObj = new object[] { nextReceiptNo }; int getNextReceiptTest = (int)PO_order.InvokeMethodByRef("nGetNextReceiptNo", nextReceiptObj); if (getNextReceiptTest == 0) { Logger.Log(PO_order.InvokeMethod("sLastErrorMsg").ToString()); Logger.Log("Error getting the next receipt."); } 
 var p = Convert.ToInt32(PO_order.GetProperty("nBatchEnabled")); if (p > 0) { Logger.Log("Batch Enabled"); object[] batchName = new object[] { "" }; letter = "L"; string num = ""; num = letter + DateTime.Today.Month.ToString() + DateTime.Today.Day.ToString(); Logger.Log(num); string BatchPrivateField = "N"; string BatchComment = "LaceupInvoices"; object[] batchNoObject = new object[] { num, BatchPrivateField, BatchComment }; PO_order.InvokeMethodByRef("nSelectNewBatch", batchNoObject); PO_order.InvokeMethod("nSetValue", batchNoObject); PO_order.InvokeMethod("nSetValue", "BatchNo$", batchNoObject[0].ToString()); } 
 object[] passedObject = new object[] { "", "" }; passedObject[0] = "receiptNo$"; passedObject[1] = nextReceiptObj[0]; var receiptNumber = nextReceiptObj[0].ToString(); int setReceiptNo = (int)PO_order.InvokeMethodByRef("nSetKeyValue", passedObject); if (setReceiptNo == 0) { Logger.Log(PO_order.InvokeMethod("sLastErrorMsg").ToString()); Logger.Log("Error setting a key value"); } 
 passedObject[0] = "ReceiptType$"; passedObject[1] = "G"; int setReceiptType = (int)PO_order.InvokeMethodByRef("nSetKeyValue", passedObject); if (setReceiptType == 0) { Logger.Log(PO_order.InvokeMethod("sLastErrorMsg").ToString()); Logger.Log("Error setting the receipt type."); } 
 int setKeyTest = (int)PO_order.InvokeMethod("nSetKey"); if (setKeyTest == 0) { Logger.Log(PO_order.InvokeMethod("sLastErrorMsg").ToString()); Logger.Log("Error setting the key."); } 
 passedObject[0] = "PurchaseOrderNo$"; passedObject[1] = order.PoNumber; int setPoNumber = (int)PO_order.InvokeMethodByRef("nSetValue", passedObject); if (setPoNumber == 0) { Logger.Log(PO_order.InvokeMethod("sLastErrorMsg").ToString()); Logger.Log("Error setting the PoNumber value."); } passedObject[0] = "InvoiceNo$"; passedObject[1] = ""; int setInvoiceNo = (int)PO_order.InvokeMethodByRef("nSetValue", passedObject); if (setInvoiceNo == 0) { Logger.Log(PO_order.InvokeMethod("sLastErrorMsg").ToString()); Logger.Log("Error setting the Invoice No. value."); } 
 passedObject[0] = "InvoiceDate$"; passedObject[1] = date; int setInvoiceDate = (int)PO_order.InvokeMethodByRef("nSetValue", passedObject); if (setInvoiceDate == 0) { Logger.Log(PO_order.InvokeMethod("sLastErrorMsg").ToString()); Logger.Log("Error setting the Invoice Date value."); } 
 passedObject[0] = "Comment$"; if (order.Comments.Length > 30) passedObject[1] = order.Comments.Substring(0, 30); else passedObject[1] = order.Comments; 
 int setComments = (int)PO_order.InvokeMethodByRef("nSetValue", passedObject); if (setComments == 0) { Logger.Log(PO_order.InvokeMethod("sLastErrorMsg").ToString()); Logger.Log("Error setting the check comments."); } 
 try { using (DispatchObject poLines = new DispatchObject(PO_order.GetProperty("oLines"))) { passedObject[0] = order.PoNumber; //the "1" value on the next line indicates copy all the lines and quantities. essentially complete the order. passedObject[1] = 1; int copyPOLinesTest = (int)poLines.InvokeMethodByRef("nCopyPurchaseOrderLines", passedObject); if (copyPOLinesTest == 0) { Logger.Log(poLines.InvokeMethod("sLastErrorMsg").ToString()); Logger.Log("Error in copying the po lines."); } 
 int moveFirstTest = (int)poLines.InvokeMethod("nMoveFirst"); if (moveFirstTest == 0) { Logger.Log(poLines.InvokeMethod("sLastErrorMsg").ToString()); Logger.Log("Error moving to the first line."); } foreach (var detail in order.PoDetails) { string orderLineKeyString = ""; object[] lineKeyObject = new object[] { "OrderLineKey$", orderLineKeyString }; int getValueTest = (int)poLines.InvokeMethodByRef("nGetValue", lineKeyObject); if (getValueTest == 0) { Logger.Log(poLines.InvokeMethod("sLastErrorMsg").ToString()); Logger.Log("Error getting the first line key value."); } 
 orderLineKeyString = lineKeyObject[1].ToString(); 
 //now that we've got the lineKey value from above, we need to find the quantity that we want to receive at this point double quantity = 0.0; foreach (var tempdetail in order.PoDetails) { var parts = tempdetail.OriginalId.Split(new char[] { '-' }); //if we've found the line key we are looking for if (orderLineKeyString.Equals(parts[1])) { //set the quantity to the corresponding value in the quantity list quantity = detail.QtyReceived; //get out of the for loop break; } } 
 passedObject[0] = "QuantityReceived"; passedObject[1] = quantity; double quantityOrdered = 0.0; object[] quantityOrderedObject = new object[] { "QuantityOrdered", quantityOrdered }; int gettingQuantityOrderedTest = (int)poLines.InvokeMethodByRef("nGetValue", quantityOrderedObject); if (gettingQuantityOrderedTest == 0) { Logger.Log(poLines.InvokeMethod("sLastErrorMsg").ToString()); Logger.Log("Error getting the quantity ordered."); } quantityOrdered = double.Parse(quantityOrderedObject[1].ToString()); 
 int setQuantityReceivedTest2 = (int)poLines.InvokeMethodByRef("nSetValue", passedObject); if (setQuantityReceivedTest2 == 0) { Logger.Log(poLines.InvokeMethod("sLastErrorMsg").ToString()); Logger.Log("Error setting the quantity received for the first line."); } 
 int writeFirstLineTest = (int)poLines.InvokeMethod("nWrite"); if (writeFirstLineTest == 0) { Logger.Log(poLines.InvokeMethod("sLastErrorMsg").ToString()); Logger.Log("Error writing the first line."); } 
 int moveNextLineTest = (int)poLines.InvokeMethod("nMoveNext"); if (moveNextLineTest == 0) { Logger.Log(poLines.InvokeMethod("sLastErrorMsg").ToString()); Logger.Log("Error moving to the next line after writing the first."); } } 
 int writePOObjectTest = (int)PO_order.InvokeMethod("nWrite"); if (writePOObjectTest == 0) { Logger.Log(PO_order.InvokeMethod("sLastErrorMsg").ToString()); Logger.Log("Error writing the PO Object."); } 
 
 } } catch (Exception ex) { Logger.Log(ex); } 
 } } catch (Exception ex) { Logger.Log(ex); } } }

David Speck · Answer

Only include the trailing $ in the field name for string fields in sage 100. Refer to the online file layouts and object reference for target table. 
 https://help-sage100.na.sage.com/2019/FLOR/#File_Layouts/Purchase_Order/PO_PurchaseOrderDetail.htm 
 The TUR column indicates Type (String/Number), UpperCase (Y/N), and Required (Y/N). 
 
 https://help-sage100.na.sage.com/2019/FLOR/

Sage 100

C# PO Write Fails BOI

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING