Small and medium business | Business Central, N...

REST API: Accessing Table 5809: Item Charge Assignment (Sales)

(5) Share

Report

Posted on by AH-01101805-0

We are trying to read/write table 5809 (https://learn.microsoft.com/en-us/dynamics365/business-central/application/base-application/table/microsoft.sales.document.item-charge-assignment-(sales)) via the REST API. This table has charge assignments for line items in Credit Memos that associate those credits as costs against the shipment revenue.

In the UI I can take a Credit Memo line like this and click on Item Charge Assignment:

to see the assigned charges like this:

I created an Web Services API Page for this table, but when I read it, I get back and empty data set.

How can I read/write this table from the REST API? What are the field names?

The documentation link above does not even tell me the internal names for the fields.

All responses (8)

Answers (0)

Suggested answer

Khushbu Rajvi. 16,318 Super User 2025 Season 1 on at

Like (1)

Report

REST API: Accessing Table 5809: Item Charge Assignment (Sales)

I am not sure if this helps or nnot: https://community.dynamics.com/forums/thread/details/?threadid=a9b721d3-29ce-43e3-b829-a67af37fa0cf

https://community.dynamics.com/forums/thread/details/?threadid=2875af62-681f-ef11-9f89-0022482674fb
AH-01101805-0 24 on at

Like (1)

Report

REST API: Accessing Table 5809: Item Charge Assignment (Sales)

Hi @YUN ZHU,

Thanks for your suggestion.

Yes, I am already clicking Item Charge Assignment as you can see:

and the assignment is showing up in the UI:

But we cannot see any values when we read the table via the OData API.
Suggested answer

YUN ZHU 82,673 Super User 2025 Season 1 on at

Like (2)

Report

REST API: Accessing Table 5809: Item Charge Assignment (Sales)

Hi, The logic here is quite special. You can observe the data in table 5809.
The system will insert data only when the Item Charge Assignment action is clicked.
If it is not clicked, the table is empty.

If you want to read it in the API, you must first run the logic in the Item Charge Assignment action.

Hope this can give you some hints.

Thanks.

ZHU
Gerardo Rentería Ga... 18,643 Most Valuable Professional on at

Like (1)

Report

REST API: Accessing Table 5809: Item Charge Assignment (Sales)

Hi, good day
I hope this can help you, and give you some hints.

How To Create Custom APIs In Business Central - Business Central Geek

Extending standard APIs (1) – Kauffmann @ Dynamics 365 Business Central

Dynamics 365 Business Central: How to use Standard/Custom API Bound Actions | Dynamics 365 Lab

Best Regards
Gerardo
AH-01101805-0 24 on at

Like (1)

Report

REST API: Accessing Table 5809: Item Charge Assignment (Sales)

Sure @Yi Yong!

Here is the API Page we created:

When we make a request to it, we get back an empty set:

{"@odata.context": "https://api.businesscentral.dynamics.com/v2.0/7895fb4c-6523-42f4-bb8f-dd61efb36d98/ixstaging/ODataV4/$metadata#Company('CRONUS%20USA%2C%20Inc.')/ItemChargeAssignmentSales2",

"value": []}

This seems relevant, but we do not understand how to use it via OData: https://learn.microsoft.com/en-us/dynamics365/business-central/application/base-application/page/microsoft.sales.document.item-charge-assignment-(sales)
Yi Yong 2,058 Super User 2025 Season 1 on at

Like (1)

Report

REST API: Accessing Table 5809: Item Charge Assignment (Sales)

Hello,

It will be helpful if you can show us the pageAPI that you created along with the request+result.
AH-01101805-0 24 on at

Like (1)

Report

REST API: Accessing Table 5809: Item Charge Assignment (Sales)

@Jainam M. Kothari this is interesting, but I do not see any table or page permissions (here: https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-table-property-overview) that control whether a given table or page is accessible or modifiable from the REST/OData API.
Jainam M. Kothari 7,921 on at

Like (2)

Report

REST API: Accessing Table 5809: Item Charge Assignment (Sales)

May this can help : https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/api-overview

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-table-property-overview