G/L posting Problem

Tharanga_Chandrasekara

Hello all,
I am a NAV developer and my functional consultant want to do few posting modification to G/L. Here is the scenario for that,

In sales invoice line they have a field where the user can select a pre defined setup. This setup includes,

Ex
Code Dim Dim_Val Percentage
001 Dim01 Department_01 70%
001 Dim01 Department_02 20%
001 Dim01 Department_03 10%
002 Dim01 Department_01 75%
002 Dim01 Department_02 25%
so on...

in sales line user will select which code they need to use for the selected invoice line and will post the line in normal way.
when posting to the revenue account in GL it should posts lines to the particular G/L account depending on the selected code in the above mention table and value should be divide depending on the given percentage and dimension_Val should attached to each line.

as a example if the user has selected the 001 code in the line (line amount is 1000), when posting it to GL, this particular line should create 3 lines in revenue account and amounts must be,
700
200
100
and each line post with dimension attached
line 01 - Department_01
line 02 - Department_02
line 03 - Department_03

I check code unit 80 *(sales post) and 12 (Gen. Jnl.-Post Line) but i could not fond the place to modify.

If any of you have any ida of how to do this modification please post it here.

Thank You.

bbrown

I would go back to the consultant for a better explantion of what business problem they are trying to solve. Then together you can devise a proper solution.