Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / 1099 Update Informatio...
Microsoft Dynamics GP (Archived)

1099 Update Information Utility

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I am getting an error when attempting to run the Update 1099 Information utility for a specific Vendor.

The error reads 'You can't complete this process while transactions are being edited' I have tried to find any unposted/work transactions for this vendor in the SQL tables, but there don't appear to be any.

Also, I was able to clear the DEX_LOCK, DEX_SESSION, SY00800, SY00801, ACTIVITY tables overnight for the client, and she was able to run the utility, but now that users are back in the system today, the same error is showing up. 

Any suggestions on where to look? It does not seem feasible to have her be the only one in GP and clear the activity tables when she wants to run this for a vendor. 

Any help is appreciated.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: 1099 Update Information Utility

    Thank you for the response Lyn.

    Since the client was able to get all the 1099 vendors updated, I don't think that I'll have a chance to test this out. Though I may try to recreate the the situation she was having in a test environment and use your script to to verify, clear any records and retry. Thanks again!

    Jason

  • Lyn Barr Profile Picture
    Lyn Barr on at
    RE: 1099 Update Information Utility

    Try checking the company's batch activity table, too - companyDB..SY00500. There might be something there.

    It's not quite as likely, but there may also be a duplicate record causing a problem. Sometimes moving records from WORK>>OPEN>>HISTORY gets interrupted, resulting in a record being present in more than one of these tables.  Here are the scripts to identify any dupes for both purchasing & payables:

    -- POP PO Duplicates

    select PONUMBER, COUNT(*) as [COUNT] from

    (

    select PONUMBER from POP10100 W

    UNION ALL

    select PONUMBER from POP30100 H

    ) C

    group by PONUMBER

    having COUNT(*) > 1

    -- POP Receivingss Duplicates

    select POPRCTNM, COUNT(*) as [COUNT] from

    (

    select POPRCTNM from POP10300 W

    UNION ALL

    select POPRCTNM from POP30300 H

    ) C

    group by POPRCTNM

    having COUNT(*) > 1

    -- PM Duplicates

    select DOCTYPE, VCHRNMBR, COUNT(*) as [COUNT] from

    (

    select DOCTYPE, VCHNUMWK as VCHRNMBR from PM10000 W

    UNION ALL

    select DOCTYPE, VCHRNMBR from PM10300 P

    UNION ALL

    select DOCTYPE, VCHRNMBR from PM10400 M

    UNION ALL

    select DOCTYPE, VCHRNMBR from PM20000 O

    UNION ALL

    select DOCTYPE, VCHRNMBR from PM30200 H

    ) C

    group by DOCTYPE, VCHRNMBR

    having COUNT(*) > 1

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans