Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

re-issue a check from a prior year w/o changing 1099 $

Posted on by 859

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

  • Re: re-issue a check from a prior year w/o changing 1099 $

    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

  • K Day Profile Picture
    K Day 7,365 on at
    Re: re-issue a check from a prior year w/o changing 1099 $

    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

  • K Day Profile Picture
    K Day 7,365 on at
    Re: Re: Re: re-issue a check from a prior year w/o changing 1099 $

    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.

  • K Day Profile Picture
    K Day 7,365 on at
    Re: Re: Re: re-issue a check from a prior year w/o changing 1099 $

     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?

  • Brian P Connell Profile Picture
    Brian P Connell 859 on at
    Re: Re: re-issue a check from a prior year w/o changing 1099 $

    if we knew that the check needed to be voided in 2008 then we would have done it. Thanks for your wisdom.

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    Re: re-issue a check from a prior year w/o changing 1099 $

    You should have voided the check in 2008.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans