Does anyone have any ideas on how to keep the 1099 amount from chanig ina previous year when voiding a check.
example: 2008 check issued in 2008. the check is voided in 2009. A new check (for same invoice) is issued in 2009. Since this is a re-issue of a check ( that was lost?) we should not have to correct the 2008 1099 amounts and the 2009 1099 amounts should be zero. Currently GP will store the 1099 amounts in 2009 and reduce the 2008 amount.
*This post is locked for comments
Hello Brian,
Thank you for using Microsoft Online Communities. I understand that you are wondering if there is a way to void a check from a previous year without changing the 1099 amounts.
The 1099 amount is updated when you post a payment and apply it to the invoice. It is the apply date that determines when the 1099 amount is showing as updated, not the date of the invoice or payment.
So you could try applying it to the previous year even though the check was issued in the current year. I would test this in a test company to make sure that your values still show the same before the void was done.
If this does not work then there is not an option to have the 1099 stay the same for the previous year when it is reissued and applied in the current year.
If you have any other questions please let me know.
Best regards,
Brad G
Microsoft Dynamics GP
We hope you get value from our new forums platform! Tell us what you think
community.dynamics.com/.../default.aspx
This posting is provided AS IS with no warranties, and confers no rights
Here's the script I came up with that matches up 1099 amounts from the Detail to the Summary tables
WITH
GPTEN99SUMMARY_CTE (GPVENDORID, GPPERIODID, GPYEAR1, GPTEN99AMNT, GPTEN99TYPE, GPTEN99BOXNUMBER)
AS (SELECT RTRIM(VENDORID),PERIODID,YEAR1,TEN99AMNT, TEN99TYPE, TEN99BOXNUMBER
FROM PM00204
WHERE YEAR1 = 2011
AND TEN99AMNT <> 0.00
)
,
--Calculation that I have found that matches the 1099 Summary Table
MY1099SUMMARY_CTE (MYVENDORID, MYPMPERIODID, MYPMYEAR1, MYPMTEN99AMNT, MYTEN99TYPE, MYTEN99BOXNUMBER)
AS
(
SELECT
RTRIM(VENDORID) as [MYVENDORID]
,MONTH(CASE DOCTYPE WHEN 5 THEN DATE1 WHEN 6 THEN DOCDATE END) as [MYPMPERIODID]
,YEAR(CASE DOCTYPE WHEN 5 THEN DATE1 WHEN 6 THEN DOCDATE END) as [MYPMYEAR1]
,SUM(TEN99AMNT - Credit1099Amount) as [MYPMTEN99AMNT]
,DEFTEN99TYPE as MYTEN99TYPE
,DEFTEN99BOXNUMBER as MYTEN99BOXNUMBER
FROM PM30300 as a WITH(NOLOCK)
WHERE 1=1
AND YEAR(DATE1) = 2011
GROUP BY VENDORID, MONTH(CASE DOCTYPE WHEN 5 THEN DATE1 WHEN 6 THEN DOCDATE END), YEAR(CASE DOCTYPE WHEN 5 THEN DATE1 WHEN 6 THEN DOCDATE END), DEFTEN99TYPE , DEFTEN99BOXNUMBER
HAVING SUM(TEN99AMNT - Credit1099Amount) <> 0.00
)
--Full Join them Together
SELECT
a.MYVENDORID
, a.MYPMPERIODID
, a.MYPMYEAR1
, a.MYPMTEN99AMNT
, a.MYTEN99TYPE
, a.MYTEN99BOXNUMBER
, b.GPVENDORID
, b.GPPERIODID
, b.GPYEAR1
, b.GPTEN99AMNT
, b.GPTEN99TYPE
, b.GPTEN99BOXNUMBER
FROM MY1099SUMMARY_CTE as a
FULL JOIN GPTEN99SUMMARY_CTE b ON a.MYVENDORID = b.GPVENDORID AND a.MYPMPERIODID = b.GPPERIODID AND a.MYPMYEAR1 = b.GPYEAR1
-- AND MYTEN99TYPE = GPTEN99TYPE AND GPTEN99BOXNUMBER = MYTEN99BOXNUMBER
-- AND MYPMTEN99AMNT = GPTEN99AMNT
WHERE 1=1
--Comment this out to get everything, leave uncommented to see any conditions that do not match 100%
--AND a.MYPMTEN99AMNT <> b.GPTEN99AMNT OR a.MYVENDORID IS NULL OR b.GPVENDORID IS NULL
ORDER BY 1, 2--, 7, 8
This is funny that it came up on a search and I already answered. But I know much more about this now in terms of how GP handles it, and it is VERY interesting. (well to me, but I'm nerdy)
Here is my situation now.
We issue a lot of 1099 Statements. We need to be able to back up 1099 amounts with Detail. We don't just go into the summary records and update a period. We are able to calculate 1099 amounts by period based on the "Apply" table. PM30300. 1099 Amounts are captured at the time when a payment is made or a credit memo is applied.
We had one Vendor who we paid multiple checks last year (2010) for 1099 invoices. About $200,000. Come to find out this year, this person never cashed those checks and said he never got them. So we voided all the payments from last year (removing the apply records from the PM30300) and cut one check in July of this year for $200,000. Except that the apply table records from this payment from this year have NO 1099 Amounts. As if GP knew that we already sent out a 1099 for 2010. I tried to figure out how GP knew that, since the old apply records are gone. I found a reprint table called PM80500 and that is how GP knows (I'm almost positive)
Anyways, I just had a case with Microsoft opened about this and they couldn't reproduce it. Come to find out that he was trying to reproduce it in GP 2010 and I am using GP 10.0. Long story short, Microsoft claims that this is a Bug in GP 10.0 that was subsequently fixed in GP 2010, that's why they couldn't reproduce it.
So from that information, think of this scenario. Vendor X gets a 1099 Statement in 2010 for $200,000 and doesn't say anything to us about it. Assume that this person paid tax on $200,000 of income for payments that he did not ever receive. Because as far as we knew and the IRS knew, he has a $200,000 1099. Now, we voided the 2010 checks and reissued this year. Without this "Bug" that Microsoft claims (so existing functionality in GP 2010), this Vendor is going to get a 1099 this year as well for $200,000 and then maybe pay taxes on it again.
How would anyone handle this? Should you submit a 1099 correction for 2010 (correct it to 0.00) and just send him the 2011 one? Or should we consider it case closed, he already got that 1099 last year. In the second case, how do I respond to the IRS if they audit me and ask me to show the detail behind the 1099 statements. Because one way or another, I can't back up one of them. I can't tell you why we issued a 1099 in 2010 because the apply records are gone from the apply table. The detail does not match the summary.
I'm going to post my 1099 tie out script after this, because it is interesting. This is the table that Reconcile 1099 Amounts uses to recalculate the summary records.
Isn't the 1099 amount from the invoice and not the check? I'm not too familiar with the 1099 process, but if you void the check, it will leave an open payable that already has the 1099 amount in it. Does re-issuing a check even have an effect on that 1099 amount?
if we knew that the check needed to be voided in 2008 then we would have done it. Thanks for your wisdom.
You should have voided the check in 2008.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156