Search code examples
acumatica

How to get 'Bills and Adjustment' grid fields in an endpoint extension

I'm working with a client on obtaining Bills and Adjustments values through the Contract based web services. I understand that certain fields aren't available in the Default Endpoint, and have to be obtained through an extension.

I'm trying to add fields from the Bills and Adjustments' Applications tab, but I'm running into a warning that I don't understand. If I extend the Default endpoint for 'Bills' (call it 'BillExt'), and I try to add the Reference Number field from the 'Applications' tab/grid (or any other field from that grid) - I get the following warning (see screenshot below)...

Can someone explain what the issue is, and how I go about adding these fields from the 'Applictaions' tab/grid? I've added fields from the 'Approval Details' grid without this warning without a problem. Is this a warning I can disregard?

enter image description here

Solution

  • You are trying to add a field from another table/view that can return multiple rows for a single Bill. The correct way to do this is by adding a separate collection on the object and map the view on that collection. e.g: Applications or Details collections here. enter image description here

    That collection will have the information for all records related to the header once you retrieve them using the ?$expand=Details on the query string request.