Hi All,
I am doing Aging report for that report i had a column named Project name it is the dimension value from shortcut dimension 4, if the customer ledger entries source code field is set to sales then i want project name from the salesinvoice line. i am writing my code from onaftergetrecord of customer ledger entry but it is not coming, correctly can anyone help me.
if CustLedgEntryEndingDate."Source Code" = 'Sales' then begin
GLSetup.Get();
DeimensionSetEntry.Reset();
DeimensionSetEntry.SetRange("Dimension Code", GLSetup."Shortcut Dimension 4 Code");
DeimensionSetEntry.SetRange("Dimension Set ID", SalesInvLine."Dimension Set ID");
if DeimensionSetEntry.FindFirst() then
Var_JobNo := DeimensionSetEntry."Dimension Value Code";
DimensionValue.Reset();
DimensionValue.SetRange(code, Var_JobNo);
if DimensionValue.FindFirst() then
Var_JobNo := DimensionValue.Name;
end;
Thanks & Regards,
Satish.