1099 Detail / Tie Out

almhansen

I've run my report for 1099-MISC and I am doing a test to verify that the report ties to what has posted to the vendor ledger entry. I am not able to tie out. Can anyone explain the logic behind the totals on this report? I've tried dumping the ledger entries to excel and filtering by date, vendor and 1099 code / amount but I just can't reconcile.

Thanks,
Amanda

Alex_Chow

I should probably write a blog article about this.

But the reason why it's not tieing out is because at the time of entry of the purchase invoice, the 1099 code is not specified.

There's also a bug in version <5.0, where the 1099 Liable field does not get updated when you enter the purchase line.

Your NAV partner can create an easy fix to update your existing ledger entries so 1099 calculate can be correct. Also, ask them to patch up the 1099 liable field bug.

Alex_Chow

Here's the blog that explains it. As well as a tool to fix it.

http://www.dynamicsnavconsultant.com/20 ... amics-nav/