Create Finance Charge Memo per dimension

julkifli33

hi all..
i have question
i want to modify how the nav create finance charge memo
is it possible to create finance charge memo per dimension 1?
so we group it per dimension 1
my dimension 1 is Department
so department IT --> 1 finance charge memo
other department will be 1 different finance charge memo
how to do that?
thanks

julkifli33

what i know is codeunit no 394 (FinChrgMemo-Make)
is there any clue... which portion should i modify or add code?

couberpu

Can you give more detail information?
Are you planning to use different layout for different department value?
We modified the report to get the result.

CouberPu

julkifli33

couberpu wrote:

Can you give more detail information?
Are you planning to use different layout for different department value?
We modified the report to get the result.

CouberPu

Current FC memo group by Customer and Currency.
What we need is to group by :
(1) Dimension 1
(2) Customer
(3) Currency.
Cos we cannot combine multiple Dimension in 1 invoice.
so when we create FC memo, it should segregate from these 3 elements

couberpu

Not sure if you can create a key ("Shortcut Dimension 1 Code","Customer No.","Currency Code") and use GroupTotalFields.

julkifli33

couberpu wrote:

Not sure if you can create a key ("Shortcut Dimension 1 Code","Customer No.","Currency Code") and use GroupTotalFields.

do you mean in table 302 (Finance Charge Memo Header) ?

couberpu

That is where I would do.
I have 3.6.

couberpu

Or you can add 'Shortcut Dimension 1 Code' as one of the search to only select the record match the dimension code you want

julkifli33

couberpu wrote:

Or you can add 'Shortcut Dimension 1 Code' as one of the search to only select the record match the dimension code you want

that's it... that what i confused about
i modified codeunit 394 in MakeHeader Function
but still failed
do you have any clue?

couberpu

Let's go back a little. Are you only want to run report for certain dimension? You still calculated the finance charge the same way, correct? What have you changed in codeunit 394?
Which report ID are we talking about here? 118, 191 or ...
Can you add the shortcut dimension 1 code to your report instead?
Just add it to ReqFilterFields.

CouberPu

julkifli33

couberpu wrote:

Let's go back a little. Are you only want to run report for certain dimension? You still calculated the finance charge the same way, correct? What have you changed in codeunit 394?
Which report ID are we talking about here? 118, 191 or ...
Can you add the shortcut dimension 1 code to your report instead?
Just add it to ReqFilterFields.

CouberPu

i'm talking about report Create Finance Charge Memos (191)
if we filter using reqFilterfields then we must produce one by one,right?

couberpu

Report 191 was against Customer table 18 and it should select all customer has same shortcut dimension code. You can also use or logic, | sign, to group several code together. We use something like ' Retail|BOM|DepartmentStore' in our selection.