Finance | Project Operations, Human Resources, ...

Answered

Create Trade Agreement Journal Lines

(0) Share

Report

Posted on by Michael Hutcheson

131

Hi all,

I am trying to create Trade Agreement Journal Lines in D365 FO via a REST APIs - currently I'm testing in Postman.

I can successfully create the Journal Header and retrieve the Journal Number by performing:

POST: /data/TradeAgreementJournalHeaders?cross-company=true

And in the body I put:

{

/dataAreaId/: /A123/,

/JournalDescription/: /Purchase Price Test/,

/DefaultTradeAgreementType/: /Purch/,

/TradeAgreementJournalNameId/: /P_Price/

}

In the response I receive the newly created Journal Number that I will pass in the Journal Line.

But which Entity do I POST to then create the Lines? I've had a look at the below Entities via Postman but they do not contain Trade Agreement Journal Lines:

Can anyone assist or point me in the right direction?

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Anthony Blake 2,926 Super User 2025 Season 2 on at

Like (1)

Report

Take look at:

OpenSalesPriceJournalLine

OpenPurchasePriceJournalLine

Both reference PriceDiscAdmTrans Table which is where I think you will want your lines to go.

There are additional entities for discounts and multi-line discounts, all point back to PriceDiscAdmTrans Table (in the most part)

OpenSalesLineDiscountJournalLine
OpenSalesMultiLineDiscountJournalLine
OpenSalesTotalDiscountJournalLine

OpenPurchaseLineDiscountJournalLine
OpenPurchaseMultiLineDiscountJournalLine
OpenPurchaseTotalDiscountJournalLine

Was this reply helpful? Yes No
Michael Hutcheson 131 on at

Like (0)

Report

Thanks for the reply.

I have tried performing a GET to the two URI's but they don't appear to exist:

"Message": "No HTTP resource was found that matches the request URI 'https://xxxxxxxxxxxxx/data/OpenPurchasePriceJournalLine?cross-company=true'. No route data was found for this request."

"Message": "No HTTP resource was found that matches the request URI 'https://xxxxxxxxxxxxx/data/OpenSalesPriceJournalLine?cross-company=true'. No route data was found for this request."

Regards,

Michael

Was this reply helpful? Yes No
Verified answer

Anthony Blake 2,926 Super User 2025 Season 2 on at

Like (0)

Report

Add the letter s to the end:

OpenSalesPriceJournalLines

OpenPurchasePriceJournalLines

If your ever looking for exactly what's available in your environment by the way, query the data endpoint without any criteria, and the response will contain all available entities:

https://xxxxxxxxxxxxx/data

e.g.
...
{
"name":"OpenPurchasePriceJournalLines","kind":"EntitySet","url":"OpenPurchasePriceJournalLines"
}
...

Was this reply helpful? Yes No
Michael Hutcheson 131 on at

Like (1)

Report

Hello Anthony,

That has worked thank you, and thanks for the tip that is useful to know.

Regards,

Michael

Was this reply helpful? Yes No

Join the conversation

Community site session details

Create Trade Agreement Journal Lines

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Create Trade Agreement Journal Lines

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates