Mapping OpenSalesPriceJournalLine to Trade agreement when importing

(0) Share

Report

Posted on by richierich79

300

I intend to create a new Sales Price Trade agreement from an existing one, where all the data stays the same but the price, fromdate and toData.

I used to import journals into AX2012 through the AIF service PriceDiscountJournalService using entities AxdPriceDiscountJournal and AxdEntity_PriceDiscAdmTrans which mapped nicely to the fields required in the PriceDiscTable

I now need to do the same thing in D365 using OData and I'm trying to use the OpenSalesPriceJournalLine entity, however the fields do not seem to match up as nicely with the PriceDiscTable

e.g. OpenSalesPriceJournalLine contains the following fields I am unsure on. B

QuantityUnitSymbol
ProductConfigurationId
ProductSizeId
PriceWarehouseId
ProductColorId
IsGenericCurrencySearchEnabled
WillDeliveryDateControlDisregardLeadTime
ProductStyleId
SalesLeadTimeDays
ProcessingLog
SalesPriceQuantity
AttributeBasedPricingId
FixedPriceCharges
WillSearchContinue
PriceSiteId

By leaving them blank do I risk creating Trade agreements that are different from the original? Am I using the wrong entity, or an I missing something?

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Sergei Minozhenko 23,097 on at

Like (0)

Report
Copy link

Link copied!

Hi Richierich79,

In D365 for entities, MS is using user-friendly namings for fields.

For example WillSearchContinue - PriceDiscAdmTrans.SearchAgain.

If you have access to Dev machine, you can open an entity in AOT and select field properties to find system field name.

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 305,173 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi richierich79,

Some fields are required to use, but also depends on your scenarios. E.g. do you have pricing per color or not.

You can actually first export a current set of data using the entity to see which columns do have what exact value. Then you will have the answer based on the usage of your own environment.

Was this reply helpful? Yes No