Hi all,
My goal is to establish the relationship between vendor & project.
The Projectsprofile gives me the project ID
subcontractsPL gives me subcntract & vendor
But when I tried to query both I am not getting the project id back. I suspect its to do with the relationship. However I have tried creating the relationship through generic inquery but linking the POORder, SOOrder, Customer etc with the contractCD in PMProject. Another post I created related to OData is here
How to add project item to subcontract | Community (acumatica.com)
Any help would be much appreciated
JSON response below
{
"id": "fc46c258-3934-434c-91e1-1afc1878d64c",
"rowNumber": 1,
"note": null,
"Results": [
{
"id": "c538d497-8af3-ec11-9d80-4851c5051c10",
"rowNumber": 1,
"note": {
"value": ""
},
"AccountIDBAccountR_AcctCD": {
"value": "V000000001"
},
"AccountIDCustomer_bAccountID": {
"value": 5441
},
"AccountIDVendor_bAccountID": {
"value": 5532
},
"CustomerID": {
"value": "C000000001"
},
"CustomerName": {
"value": "Jersey Central Office Equip"
},
"Project": {
"value": "X"
},
"SubcontractNbr": {
"value": "SC-000004"
},
"VendorNamePOOrder_vendorID_description": {
"value": "eQ Bank"
},
"VendorNameVendor_acctName": {
"value": "eQ Bank"
},
"VendorPOOrder_vendorID": {
"value": "V000000001"
},
"VendorVendor_AcctCD": {
"value": "V000000001"
},
"custom": {}
},
{
"id": "cb467071-82f3-ec11-9d80-4851c5051c10",
"rowNumber": 2,
"note": {
"value": ""
},
"AccountIDBAccountR_AcctCD": {
"value": "V000000001"
},
"AccountIDCustomer_bAccountID": {
"value": 5441
},
"AccountIDVendor_bAccountID": {
"value": 5532
},
"CustomerID": {
"value": "C000000001"
},
"CustomerName": {
"value": "Jersey Central Office Equip"
},
"Project": {
"value": "X"
},
"SubcontractNbr": {
"value": "SC-000003"
},
"VendorNamePOOrder_vendorID_description": {
"value": "eQ Bank"
},
"VendorNameVendor_acctName": {
"value": "eQ Bank"
},
"VendorPOOrder_vendorID": {
"value": "V000000001"
},
"VendorVendor_AcctCD": {
"value": "V000000001"
},
"custom": {}
}
],
"custom": {}
}
