Finance | Project Operations, Human Resources, ...

Net Amount left in blank or wrong calculated in Sales order Lines after Migration Ax 2012

(0) Share

Report

Posted on by CBNestor

529

Hi all,

I have just migrated all open sales orders (header and lines) from AX3.0 to AX2012

problems is that when I take a look into the sales lines in many cases the net amount is just not calculated or is miss calculated

for examples qty: 500 * Unit mount: 225 gives a net amount of : 117.500 which is not true. or in the majority of cases is just left in blank

Any help is greatly appreciated guys.

thanks a lot for your time

All responses (10)

Answers (0)

Suggested answer

CBNestor 529 on at

Like (0)

Report

RE: Net Amount left in blank or wrong calculated in Sales order Lines after Migration Ax 2012

I had made a script. calculates and updates the LineAmount for all open migrated orders.

after that I updated my Processing group's source mapping and added the LineAmount. so for future sales orders migrations I will migrate all together with LineAmount included at once. I thing that is the best option. thank you guys for your time
Suggested answer

nmaenpaa 101,156 on at

Like (0)

Report

RE: Net Amount left in blank or wrong calculated in Sales order Lines after Migration Ax 2012

You need to debug what causes it, and perhaps then you already figure out how to solve it.

If not, please share all details that you learn in debugging it.
CBNestor 529 on at

Like (0)

Report

RE: Net Amount left in blank or wrong calculated in Sales order Lines after Migration Ax 2012

I added the modifySalesQty

now is asking me to Recalculate ships and receipt dates? I select yes for each line. but the sales order is still the same. does not update the net amount :(
Suggested answer

nmaenpaa 101,156 on at

Like (0)

Report

RE: Net Amount left in blank or wrong calculated in Sales order Lines after Migration Ax 2012

Nestor,

use the InventDim of your sales line.
CBNestor 529 on at

Like (0)

Report

RE: Net Amount left in blank or wrong calculated in Sales order Lines after Migration Ax 2012

How do i take the InventDim for the second parameter
CBNestor 529 on at

Like (0)

Report

RE: Net Amount left in blank or wrong calculated in Sales order Lines after Migration Ax 2012

Hi Ludwig. No I did not import the Net Amount. because on the purchase orders it was not needed
Suggested answer

nmaenpaa 101,156 on at

Like (0)

Report

RE: Net Amount left in blank or wrong calculated in Sales order Lines after Migration Ax 2012

You could try to call method SalesLine::modifySalesQty in your code (it can be found if you follow SalesLine\modifiedField method, which is executed when user modifies a field via a form.
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Net Amount left in blank or wrong calculated in Sales order Lines after Migration Ax 2012

Hi,

What AX2012 version do you operate exactly?

Did you include the net amount into your migration sheet and upload it?

How did you do the actual upload?

Best regards,

Ludwig
CBNestor 529 on at

Like (0)

Report

RE: Net Amount left in blank or wrong calculated in Sales order Lines after Migration Ax 2012

Hi Nikolaos,

thanks for replying

With DIXF. the same I did with the Purchase orders. Just that for the purchase orders the net amount is calculated correctly I dont know whats going on.

if I update the salesprice manually the net amount gets updated correctly. so I tried to do kinda same logic with a x++ Job but not refreshing the Net Amount. not even by clearing all the salesprices to zero(0)
nmaenpaa 101,156 on at

Like (0)

Report

RE: Net Amount left in blank or wrong calculated in Sales order Lines after Migration Ax 2012

Hi Nestor C,

how did you do the migration?