You’re offline. This is a read only version of the page.
How do I recreate 1099 preview report for prior year that is closed? ie I want to reprint 2013 1099 preview report
*This post is locked for comments
Interesting. I've done this multiple times in the past with no issues.
Well, I hope it works for the original poster.
I actually tried what John suggested before writing my response and found that it did not appear to actually work as the results gave me the same figures for the current 1099 year that I had before setting the year back. I would have thought that what was in that article would have worked so I was surprised that the figures did not change for either the current or next year.
If you try that approach, run the 1099 preview for the current year before performing the steps and then perform those steps and run the report again to see if your figures change.
Also, the article fails to mention that you would have to do similar steps to change back to the correct current year when done. It also does not mention that, if you edited any 1099 info under initialize mode in the true current year, those edits could be lost and would have to be done over again.
If following what this article suggests actually works for you, please post that on this thread.
You would need to use SQL to manually re-open the 2013 year. This article provides guidance:
www.dynamictechservices.com/.../rebuild-1099-year-in-microsoft-dynamics-sl
I do not believe you will be able to do this. The 1099 Preview report gets its data from ap_balances and that table is cycled each time you purge the oldest 1099 year. So, assuming your current 1099 year is beyond 2013, the 2013 1099 data is no longer available to that report.
You could still get the figures by using the following query:
Select t.VendID,t.BoxNbr,Sum(Case When t.trantype <> 'AD' Then t.TranAmt Else -t.TranAmt End)
From APTran as t inner join APDoc as d on d.RefNbr = t.RefNbr
Where t.BoxNbr <> '' and Left(d.PerClosed,4) = 2013
Group By t.VendID,t.BoxNbr
This query would not properly take into account any voucher partially paid in 2013 with the balance paid in 2014 nor would it properly take into account any voucher from 2012 that was partially paid in 2012 with the balance paid in 2013. In order to handle those situations the query would have to include APAdjust and would be more complex. If you believe you might have some of these partially paid situations then let me know and I will work up a revised query.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (