Finance | Project Operations, Human Resources, ...

How to get the Financial 'To dimension' from Transfer journal in X++

(1) Share

Report

Posted on by Saran S

333

Hi,

I want to know how to get the 'To dimension' data from transfer journal via x++,

Does anyone have any ideas on how to do this?

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Martin Dráb 239,451 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

What data do you want to get? The value of a particular dimension? A map of dimension attributes and their values?

It may be good to start by telling us what you're trying to achieve from business point of view.

Was this reply helpful? Yes No
Saran S 333 on at

Like (1)

Report
Copy link

Link copied!

Thanks for the reply Martin,

I try to create the Project item journal from Transfer journal, if the Transfer journal is Posted.
For this process, I need the 'To dimension' data from that Transfer journal.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 239,451 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

If you look into InventJournalTranfer form, you'll see that DimensionEntryControlTo is bound to TmpDimension data source. Go there and notice linkActive() method; it contains code populating DimensionDefault field at runtime. The key piece there is the call of toDimensionDefault() method on InventJournalTrans table. The same method is used in actual postings, not just to display values in this form.

Was this reply helpful? Yes No
Saran S 333 on at

Like (1)

Report
Copy link

Link copied!

Yes I noticed that,

inside the toDimensionDefault() method, I find the InventSite::changeDimension() method, so I tried the below code

inventJournalTrans.DefaultDimension = InventSite::changeDimension(inventJournalTrans.DefaultDimension, InventDim::find(inventJournalTrans.ToInventDimId).InventSiteId);

is this correct?

Was this reply helpful? Yes No
Martin Dráb 239,451 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Honestly, I don't see any relation between your code and your requirement.

Your code is trying to update a single dimension value (Site) from the inventory dimension, while you're talking about getting all dimensions for creation of a project item journal.

Was this reply helpful? Yes No
Saran S 333 on at

Like (1)

Report
Copy link

Link copied!

ok,

inventJournalTransCreate.DefaultDimension = inventJournalTransSelect.toDimensionDefault(inventJournalTransSelect.inventJournalTable(), InventDim::find(inventJournalTransSelect.ToInventDimId));

is this correct?

Was this reply helpful? Yes No