Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 100

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 2,172 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

  • J Calalang Profile Picture
    J Calalang 100 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 2,172 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

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans