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": {}
}
Â