Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / SOP and Voiding Invoic...
Microsoft Dynamics GP (Archived)

SOP and Voiding Invoices (GP 10)

(0) ShareShare
ReportReport
Posted on by K Day 7,365

I have a question about transaction flow in SOP.  I am working with a company that uses SOP but not Inventory (their parts are all non-inventry items).  There was a situation where they wanted to void an Invoice and they ended up doing it through "Posted Transactions."  The nex effect seems okay since their distributions on Sales Orders are only Sales and A/R (not COGS/Inventory).  So the Transaction shows up as voided (OPEN*) in Transactions by Customer, but when looking at the transaction in Inquiry, there is not "Voided" status like you would see in A/P Transactions or R/M Transactions.  So it is really hard to look at it and tell the situation.

I even went to Paid Transaction Removal and moved it to History (now HIST*)

However, going into Smartlist still shows a void Status of "Normal."

How would I go about excluding this transaction from reports?  I know they should be doing Returns in SOP (they know this now), but for reporting purposes, where can I find that it is picking up this transaction as Voided.  It is not showing on the A/R Trial Balance.

Thanks in advance.

Kevin 

*This post is locked for comments

  • FAC Profile Picture
    FAC 65 on at
    Re: Re: Re: SOP and Voiding Invoices (GP 10)
    Great!, Thanks a lot Richard, i'm realizing how the flow works now. I was trying to make a sales report, by articles sold, and i was joining SOP30200 and SOP30300 for that so far was simple but then i saw transactions that were void, so searching in the DB saw a void status 1 in RM but 0 in SOP i guess i've got to join RM tables too. Thanks a lot and pardon my english (its not my native language)
  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Re: SOP and Voiding Invoices (GP 10)

    Ok, you have to think of it this way to fully understand what is happening.  There are really two modules here: Sales Order Processing and Receivables Management.

    SOP allows users to create a sales transaction, fulfill it, others with real parts will ship, and then invoice the sale.  Up until this point, the transaction can be voided by opening it in Sales Transaction Entry and selecting VOID. 

    When you POST the invoice, it is moved to history and can no longer be voided.  It creates a receivable sales transaction that is also already posted.  The receivable transaction posts to AR and Sales and ends up showing as an open receivable transaction (the sales order is not open).

    The receivable transaction can be voided.  The sales transaction was completed, finished, invoiced, and posted.  It cannot be voided.  It is in history.  A void status on a sales transaction says it was never finished, never invoiced, never posted. 

    What exactly are you trying to accomplish by voiding a historical sales transaction?

  • FAC Profile Picture
    FAC 65 on at
    Re: SOP and Voiding Invoices (GP 10)
    Hi, what would be the correct steps to void a transaction originated in SOP? Because everytime the users want to void a SOP transaction they go to Posted Transactions and void the SOP but just the RM is voided not the SOP what is the correct way to make the void status of SOP to 1? thanks a lot
  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    Re: Re: Re: Re: Re: Re: Re: Re: SOP and Voiding Invoices (GP 10)

    This is where I draw the line... Voiding the transaction in RM should create the necessary reversing entries in GL.

  • Mark Huesca Profile Picture
    Mark Huesca 20 on at
    Re: Re: Re: Re: Re: Re: Re: SOP and Voiding Invoices (GP 10)

     additional info is the transaction posted up to financial module, if yes you should also updated the GL tables void status (VOIDED).Coz once the transaction is posted the distribution entry of the transaction is in the GENERAL LEDGER

     

     

    GL20000 for OPEN YEAR TRANSACTION/S

    GL30000 for HISTORICAL YEAR TRANSACTION/S

  • Shyamala Sivalingam Profile Picture
    Shyamala Sivalingam 55 on at
    Re: Re: Re: Re: Re: Re: SOP and Voiding Invoices (GP 10)

    Thanks!@

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    Re: Re: Re: Re: Re: SOP and Voiding Invoices (GP 10)

    This would be a SQL Server trigger.

  • Shyamala Sivalingam Profile Picture
    Shyamala Sivalingam 55 on at
    Re: Re: Re: Re: SOP and Voiding Invoices (GP 10)

    HI Mariano

    I know this is a old thread and we are experiecing this as well. This tirgger on your suggestion, shoudl it be setin Dex or SQL?

     

    Thanks

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    Re: Re: Re: SOP and Voiding Invoices (GP 10)

    Victoria is correct! You can update the Void Status (VOIDSTTS) column in the Sales Transaction History table by adding a trigger to the RM Open File (RM20101) table that checks for an update to the Void Status (VOIDSTTS) = 1 column. This will make the operation much easier and automatic going forward.

     

  • K Day Profile Picture
    K Day 7,365 on at
    Re: Re: SOP and Voiding Invoices (GP 10)

    Correct, the Sales Transactions Smartlist is showing up as "Normal."  Is is showing voided in the RM Tables.

    I'll try your suggestion in a test enviornment first.  Hopefully moving forward they won't have this problem again.

    Thanks,

     Kevin

     

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans