I need to import value of Amount Paid using webservices to Acumatica ERP System. Please refer to this screenshot below.
I have already create some codes using Reference Number = "1700000016", DocType = "Bill", VendorRef = "SV-889-JKT-2", VendorID = "V000000030" and Amount Paid = "1,250,000". Please refer to this codes below.
sCon.getLogin(username, password, url, context);
AP301000Content konten = context.AP301000GetSchema();
//context.AP301000Clear();
List<Command> oCmds = new List<Command>();
//oCmds.Add(konten.Actions.Insert);
//--------------- adding header transaction -----------------//
konten.DocumentSummary.Type.Commit = false;
konten.DocumentSummary.Type.LinkedCommand = null;
oCmds.Add(new Value { LinkedCommand = konten.DocumentSummary.Type, Value = "Bill" });
oCmds.Add(new Value { LinkedCommand = konten.DocumentSummary.ReferenceNbr, Value = "0000" });
oCmds.Add(new Value { LinkedCommand = konten.DocumentSummary.Date, Value = dtDateSV.Text });
oCmds.Add(new Value { LinkedCommand = konten.DocumentSummary.VendorRef, Value = "SV-889-JKT-2" });
oCmds.Add(new Value { LinkedCommand = konten.DocumentSummary.Vendor, Value = "V000000030" });
//-------------- adding detail transaction (Based on values in Data Grid )-------------
int a = dgvDocDetailSV.Rows.Count;
for (int x = 0; x < a; x++)
{
oCmds.Add(konten.DocumentDetails.ServiceCommands.NewRow);
oCmds.Add(new Value { LinkedCommand = konten.DocumentDetails.Branch, Value = dgvDocDetailSV.Rows[x].Cells[1].Value.ToString() });
oCmds.Add(new Value { LinkedCommand = konten.DocumentDetails.InventoryID, Value = dgvDocDetailSV.Rows[x].Cells[2].Value.ToString() });
oCmds.Add(new Value { LinkedCommand = konten.DocumentDetails.JobOrderNbr, Value = dgvDocDetailSV.Rows[x].Cells[3].Value.ToString() });
oCmds.Add(new Value { LinkedCommand = konten.DocumentDetails.Quantity, Value = dgvDocDetailSV.Rows[x].Cells[4].Value.ToString() });
oCmds.Add(new Value { LinkedCommand = konten.DocumentDetails.UOM, Value = dgvDocDetailSV.Rows[x].Cells[5].Value.ToString() });
oCmds.Add(new Value { LinkedCommand = konten.DocumentDetails.UnitCost, Value = dgvDocDetailSV.Rows[x].Cells[6].Value.ToString() });
}
//------ add document in Applications Tab Menu -------//
string DocTypePrepayment = "Prepayment";
string RefNbrPrepayment = "1700000015";
oCmds.Add(new Key
{
ObjectName = konten.Applications.DocTypeDisplayDocType.ObjectName,
FieldName = konten.Applications.DocTypeDisplayDocType.FieldName,
Value = DocTypePrepayment
});
oCmds.Add(new Key
{
ObjectName = konten.Applications.ReferenceNbrDisplayRefNbr.ObjectName,
FieldName = konten.Applications.ReferenceNbrDisplayRefNbr.FieldName,
Value = RefNbrPrepayment
});
oCmds.Add(new Value { LinkedCommand = konten.Applications.AmountPaid, Value = "1250000" });
//------ save transaction in acumatica -------//
oCmds.Add(konten.Actions.Save);
var result = context.AP301000Submit(oCmds.ToArray());
I have an error message after trying to import this data. The error message is "System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> PX.Data.PXException: Error #111: An error occurred while processing the field CuryAdjdAmt : Object reference not set to an instance of an object.. ---> System.NullReferenceException: Object reference not set to an instance of an object. ". It seems that field CuryAdjdAmt is null, and this field is mapped to AmountPaid field in Application Menu Tab of Acumatica System.
Please give me reference to solve this issue. Thanks