Offset Ledger Dimension

Finance and Operations/AX Developer Forum
1

Hello,

I have a query how i can get offset ledger dimension by Employee Id for example if i have employee ID : 00001 then how i can get its dimension so that i can insert it in ledgerjournaltrans.offsetLedgerDimension

2

Do you have empl Id as dimension attribute?Can you please elaborate?

3

DimensionAttributeValueCombination dimensionAttributeValueCombination;

DimensionDynamicAccount ledgerDim;
MainAccountNum mainAccountNum = “5070010014”; //Example Account
MainAccount mainAccount = MainAccount::findByMainAccountId(mainAccountNum);

DimensionServiceProvider DimensionServiceProvider = new DimensionServiceProvider();
LedgerAccountContract LedgerAccountContract = new LedgerAccountContract();
DimensionAttributeValueContract ValueContract;
List ListValueContract = new List(Types::Class);
DimensionStorage dimStorage = DimensionStorage::construct();

LedgerAccountContract.parmMainAccount(mainAccountNum);
// ListValueContract.addEnd(
LedgerAccountContract.parmValues(ListValueContract);
dimStorage = DimensionServiceProvider::buildDimensionStorageForLedgerAccount(LedgerAccountContract);

dimensionAttributeValueCombination = DimensionAttributeValueCombination::find(dimStorage.save());
if (dimensionAttributeValueCombination.RecId)
{
info(strFmt("%1 %2",dimensionAttributeValueCombination.RecId,dimensionAttributeValueCombination.DisplayValue));

}

}

i get an DimensionStorage feom MainAccount . Now how can i get other dimension with employee’s Recid

4

That doesn’t answers the question. Do you want to build LedgerJournalTrans.offsetLedgerDimension with main account and other dimension attributes. (hoping worker is a dimension attribute)?

5

Yes i want to build LedgerJournalTrans.offsetLedgerDimension with main account and other dimension attributes.

6

This can help you,
blogs.msdn.microsoft.com/…/

7

Hello Salman,
If you want to get it for Vendor, here is the code.

VendAccount accountNum = ‘104’;
int enumValue = LedgerJournalACType::Vend;

info(strFmt("%1",DimensionStorage::getDynamicAccount(accountNum , enumValue)));

Hope by same way you can find out for Employee.

8

Hi

empDim = phcCreateInvoice.getDimensionValuesEmployees(phcReservationBookingReqDetail.DimensionDefault);
// info(strFmt("%1",empDim));
offsetdim = [‘5070010014’,‘5070010014’,1,‘Employees’,empDim];

ledgerJournalTrans.OffsetLedgerDimension=trans.parmOffsetLedgerDimension(AxdDimensionUtil::getLedgerAccountId(offsetdim));

i get a default dimension value in empDim variable when i add it in Container OffsetDim it show me an error Financial Dimension 000063 does not exist

9

Thanks Kranthi I have resolved the issue

10

If the thread is resolved. Make it as verified solution, replies.