G/L Acc. balance not matching after upgrade to NAV 2009 R2

hav

Hi
I have upgraded a NAV 4 GB database to NAV 2009 R2 GB and currently i am doing parallel testing.

I created one Sales Order in both db and posted it for invoice.


When i navigate to the G/L entries for the same invoice in both db. i get the details as below
in NAV 5 it shows
whereas in NAV 2009 R2 it shows

After comparing both entries, what i found is that in NAV 2009 R2, it shows 5 entries whereas in NAV 5 it shows 3 entries. I am not sure why in NAV 2009 R2 it shows separate entries for Sales Line Discount % Account 7130. In NAV 5 the discount% is included in the respective account viz 6118 & 6954.

My GL Posting setup is as shown below


Can someone guide me how to resolve the G/L balances?
Let me know if you need further info.

gerrykistler

Check your Sales & Receivables Setup in both and see if there is a difference in the Discount Posting field setting.

hav

I checked both the database and found that in old db. the Discount Posting on Sales & Receivables Setup was set to 'No Discount' whereas in new db. it was set to 'All Discount'.

I changed the Discount Posting to 'No Discount' in new db. and it resolved the problem.

Thanks for your help.

Regards,
Hemant