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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / SLSTE Sales order tran...
Microsoft Dynamics GP (Archived)

SLSTE Sales order transaction (customer invoice) Deletion

(0) ShareShare
ReportReport
Posted on by J Calalang

Is it possible to delete an already posted invoice out of GP via a table deletion? If this is possible does anyone know the table I can seach through to find this, or a write up?

 Cheers,

 Jon

Error I have is below the invoice I am trying to delete is 1058202:

Exception Occured at TAIVTransactionLineInsert: Value of Error is:System.InvalidCastException: Conversion from type 'DBNull' to type 'String' is not valid.   at Microsoft.VisualBasic.CompilerServices.Conversions.ToString(Object Value)   at WindowsApplication1.Form1.Button1_Click(Object sender, EventArgs e) in C:\Documents and Settings\danj\Desktop\SOP_To_INV_Windows\WindowsApplication1\WindowsApplication1\Form1.vb:line 17300165296,1058202                  eConnect Exception Occured - Value of Error is:Microsoft.Dynamics.GP.eConnect.eConnectException: Sql procedure error codes returned:Error Number = 4733  Stored Procedure taIVTransactionLineInsert  Error Description = Kit, Service, Miscellaneous and Flat Fee Items may not be adjustedNode Identifier Parameters: taIVTransactionLineInsert                          IVDOCNBR = 00165296IVDOCTYP = 1ITEMNMBR = *99999    Related Error Code Parameters for Node : taIVTransactionLineInsert                         

 

*This post is locked for comments

  • Dencio Profile Picture
    Dencio on at
    Re: SLSTE Sales order transaction (customer invoice) Deletion

    Hi Jon,

    There is a utility in SOP that allows you to purge completed SOP documents via Remove Sales History (in GP 10 MSDGP>>Tools>>Utilities>>Sales>>Remove Sales History.  However, you can install GP SDK to guide you on the Transaction flows (showing the physical tables).

    Hope this helps!

    Cheers,

    Dencio

  • J Calalang Profile Picture
    J Calalang on at
    Re: Re: SLSTE Sales order transaction (customer invoice) Deletion

    Hey Dencio,

     Thanks for the help, I tried doing it within GP and the invoice wont vanish, have you ever heard of where this would live in DB for a manual deletion..?

  • Dencio Profile Picture
    Dencio on at
    Re: Re: Re: SLSTE Sales order transaction (customer invoice) Deletion

    Hi Jon,

    I would recommend you install GP SDK and use the guidelines from SOP Transaction Flows  via Table Integration>>The Sales Series>>Sales Order Processing>>SOP Transaction Flows (SOPTRX.docx file),
    You can manually delete records within SQL from these tables (SOP10100, SOP10200, SOP30200, SOP30300.......) but it is NOT the BEST PRACTICE as you are compromising the integrity of your financial data.  As much as possible, purging or maintenance should be done within Great Plains.

    As a troubleshooting steps, can you manually enter the document number in GP and found out what's the actual error message GP will highlight?  We can then strategise how to go about it.

    Cheers,

    Dencio

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans