web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Void posted invoice

(0) ShareShare
ReportReport
Posted on by

Hi experts,

I create an invoice in the GP, after i void this inovice, I check the field VOIDSTTS in table sop10100 in DB, it changes to 1.

but when I create  a posted invoice in the GP, after I void this posted inovice,  I check the field VOIDSTTS in sop30200 in DB ,it is still as 0.

Is it a bug in for Dynamic GP? and is there any solutions to filter out the void transcation in the table sop30200?

thanks

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    sandipdjadhav Profile Picture
    18,335 on at

    Hi Denny,

    I don't think it is bug because when you void Sales Transaction you may have receive prompt about transaction in voiding only AR and GL side. 

    When you void Sales Transaction it void only Accounts Receivable (AR) and GL , no effect on Inventory. That's probably reason your SOP Sales Invoice void status still show 0. 

    If you have any reports base on VOID STATUS on SOP30200 I will recommend to change it manually. I did it several time.

    Thanks much

    Sandip Jadhav

  • Suggested answer
    Community Member Profile Picture
    on at

    Thanks Sandip,

    I also find the a solution in the forum. they say we can update the Void Status (VOIDSTTS) column in the Sales Transaction History table by adding a trigger to the RM Open File (RM20101) table.

    so now I use  RM20101 to join the sop30200 to get the VOIDSTTS to filter out the void transcation.

    Thank you for your help

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans