create ledger Dimension for the new values(which are not available in DAVcombination table)

create ledger Dimension for the new values(which are not available in DAVcombination table)

if(ledgerDimensionvalueCombination.recid != 0)
    {
        ledgerJournalTrans.ledgerDimension  = ledgerDimensionvalueCombination.recid;
    }
    else
    {
        recId = DimensionStorage::getDynamicAccount(_projForecastUnion.ProjId, 3, 129);
        davc = DimensionAttributeValueCombination::find(recId);
        ledgerJournalTrans.DefaultDimension = davc.RecId;
    }

Ledger Offset Account Update in Expense journals.

MainAccount must.

ledgerJournalTrans.OffsetLedgerDimension = DimensionDefaultingService::serviceCreateLedgerDimension( projPosting.LedgerDimension,ledgerJournalTrans.DefaultDimension,defaultDimensionView.DefaultDimension,defaultDimension);


////////////////////////////////////////////////////////////////////////////

public static str Tri_WorkerPersonelNo(DimensionDefault _defaultDimension)
{
    DimensionAttributeValueSet           DimensionAttributeValueSet;
    DimensionAttributeValueSetItem       DimensionAttributeValueSetItem;
    DimensionAttributeValue              DimensionAttributeValue;
    DimensionAttribute                   DimensionAttribute;
    Name                                 dimvalue,worker,workername;





     select DimensionAttributeValueSet
            where  DimensionAttributeValueSet.RecId == _defaultDimension
    join RecId, DisplayValue from DimensionAttributeValueSetItem
            where DimensionAttributeValueSetItem.DimensionAttributeValueSet == DimensionAttributeValueSet.RecId
    join RecId from DimensionAttributeValue
            where DimensionAttributeValue.RecId == DimensionAttributeValueSetItem.DimensionAttributeValue
    join RecId, Name from DimensionAttribute
            where DimensionAttribute.RecId == DimensionAttributeValue.DimensionAttribute && DimensionAttribute.Name == "Worker";

    worker = DimensionAttributeValueSetItem.DisplayValue;
    //workername = HcmWorker::findByPersonnelNumber(worker).name();


    return worker;
}
................................................................................................