BYOD data issue

(0) Share

Report

Posted on by Frank Bruemmer

343

Hello D365 community,

I have set up a working BYOD job that transfers data from a custom LedgerJournalEntity to the BYOD. I recently added the LedgerJournalTrans.TransactionType to the data entity as well as to the staging table.

I refreshed the data entity list, renegerated the mapping, regenerated the staging to target BYOD mapping and everything looks ok.

However, when I execute my job, all ledger transactions (thousands) end up as (LedgerTransType) 36, which is some sort of Russian amortization type. I was expecting a variety of types such as 15 for payments.

Any idea what I'm missing ?

Thanks

Frank

All responses (4)

Answers (1)

Frank Bruemmer 343 on at

Like (0)

Report

RE: BYOD data issue

I'm don't think so. I assume the problem relates to duplicating the original data entity and making it work by the person who developed it. Further investigation revealed that there were also records missing.

I gave up and went and extended the GeneralLedgerJournalLineCDSEntity to include the transaction type, build, synced, remapped and it worked right away.

Thanks for your time anyways.
Verified answer

Sergei Minozhenko 23,089 on at

Like (0)

Report

RE: BYOD data issue

Hi Frank,

Could it be that you export only transactions with type 36? Do you have ranges on entity? Filters in data project?
Frank Bruemmer 343 on at

Like (0)

Report

RE: BYOD data issue

Sergey,

thanks for your help.

You are right, 36 is General Journal. 15 is still Payments though. Looking at my ledgerJournalTrans table I have records with 36, 15 and many others. However, when they are copied to the BYOD, these all turn to 36.

Best regards

Frank
Suggested answer

Sergei Minozhenko 23,089 on at

Like (0)

Report
RE: BYOD data issue

Hi Frank,

Are you sure that 15 is Payments and 36 Russian amortization type? In my case 36 is General ledger. LedgerTransType is an extensible enum and the number in the list of values in AOT is not always equal to the number in the database.

Try to run the next code to check values.

static void main(Args _args) { DictEnum d = new DictEnum(enumNum(LedgerTransType)); int i; for (i = 1; i <= d.values(); i ) { Info(strFmt("%1 %2", d.index2Value(i), d.index2Symbol(i))); } }