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

having problem inserting record to "sales job price list".

(0) Share

Report

Posted on by Fisher A

I am trying to insert new record to "sales job price lists" but not sure how to exactly do that :) i exposed three pages (7015 Sales price lists, 7016 sales price list, 7019 sales job price lists). i am able to insert new record to page 7015, but not sure how to set the type to :"job".

this is my request json:

{

"AssignToParentNo": "",

"SourceNo": "",

"AssignToNo": "",

"VATBusPostingGrPrice": "",

"PriceIncludesVAT": false,

"AmountType": "Price & Discount",

"Status": "Draft",

"CurrencyCode": "",

"StartingDate": "0001-01-01",

"EndingDate": "0001-01-01",

"AllowUpdatingDefaults": false,

"AllowInvoiceDisc": false,

"AllowLineDisc": false

}

Url Odata: api.businesscentral.dynamics.com/.../SalesPricesList (this is the path of page 7015)

i would like to insert to page 7019, but it does not allow inserting..."

"message": "Entity does not support insert. CorrelationId: 7fb19d8b-80a7-4725-95fd-9fba69d7ddbf."

if i request HTTP get, i get the list of job pricess, but post to this page is not allowed.

I have the same question (0)

All responses (9)

Answers (0)

Sort by

Suggested answer

IB-29041624-0 1,187 Moderator on at

Like (0)

Report
Copy link

Link copied!

You should look at these two fields:

Was this reply helpful? Yes No
Fisher A 37 on at

Like (0)

Report
Copy link

Link copied!

Please, tell me more:) the worst thing that i lack finding good documentation...

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 100,629 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, Personally, I don't recommend publishing standard pages to Web Service and then accessing them with Odata. This has many limitations and will have performance issues.

You can create a new API page.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-develop-custom-api

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

I would suggest go with Zhu, create new Page with the standard table and publish that page and consume it for inserting the data, as standard page can give your some limitations.

Thanks.

Was this reply helpful? Yes No
Fisher A 37 on at

Like (0)

Report
Copy link

Link copied!

Thank you! Api did the job and now i am able to insert records to the price list header table. Just couple of quiestions..

1) on insert i am not able to supply the status value 'active'. It works just with the status value 'draft' and later i can patch/update this value to active. I guess thats how it works?

2) i can set the value of ending_date but i can not set value for starting_date...there has to be some constraints that i can not figure out yet.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 100,629 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, I briefly checked the standard code and it doesn't look like this part is limited.

You can add some behaviors that you want to attach in the trigger of the API page.

Here is information from BC API expert AJ.

https://www.youtube.com/watch?v=5iRv0y0rVzw&t=68s

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No
Fisher A 37 on at

Like (0)

Report
Copy link

Link copied!

Thank you! I will check the videos.

For now,i came to TEMP solution that if i make POST request to insert new price list header - item is created and if later on i make separate requests (patch) with supplying only startig_Date and on another request ending_Date, dates stays as expected. Problem happens if both dates are supplied in same request. Then just ending_date is set and starting_date is set to "0000-00-01".

Was this reply helpful? Yes No
Fisher A 37 on at

Like (0)

Report
Copy link

Link copied!

this is the PAth i request:

api.businesscentral.dynamics.com/.../priceListHeaders

Request json:

{

"description": "List",

"status": "Draft",

"sourceType": "All Jobs",

"priceType": "Sale",

"sourceGroup": "Job",

"startingDate":"2022-11-01",

"endingDate":"2022-11-02"

}

response:

{

"@odata.context": "api.businesscentral.dynamics.com/.../$metadata

"@odata.etag": "W/\"JzE5OzExMzA0ODkyMTQzMzU4ODk4NTkxOzAwOyc=\"",

"systemId": "764d7fc9-b385-ed11-9989-0022489ea374",

"description": "List",

"code": "J00032",

"status": "Draft",

"sourceType": "(All)",

"priceType": "Any",

"assignToNo": "",

"assignToParentNo": "",

"startingDate": "0001-01-01",

"endingDate": "2022-11-02",

"currencyCode": "",

"sourceGroup": "Job"

}

as from response seen:

1) sourceType is changed to ALL, though value was supplied "All Jobs"

2) startingDate is set to "0001-01-01"

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,421 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hello

I always recommend using a custom page api

perhaps creating staging tables in which to check the data and in AL insert the record in a standard entity

learn.microsoft.com/.../devenv-api-pagetype

DAniele

Was this reply helpful? Yes No