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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / SOP - line details wit...
Microsoft Dynamics GP (Archived)

SOP - line details with no corresponding header

(0) ShareShare
ReportReport
Posted on by Ronie 1,080

Hi,

We have a client that having a problem in the SOP (data problem) they are using GP v8, there is a 3rd party that retreive some of the records from SOP table then add details from the 3rd party window and save to the 3rd party table also they are using Crystal Reports to print only the deliver receipt. 

Problem 1. There are records in the header table (SOP10100) but there's no corresponding records in the line detail (SOP10200) - I know that we can create record and save without line item details. According to our client they are always entering the line details.

Problem 2. There are records in the line detail table (SOP10200)  but there's no corresponding records in the header (SOP10100).

I really don't have idea what's the cause of the problem. I'm trying to recreate/reproduce the problem but until now still can't replicate. I really appreciate if any one can help me. 

Thanks, 

Ronie 

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi Ronnie,

    Is the 3rd Party product writing to GP?

    If not, when does it query the SOP tables? i.e. how is it taking data out?

    It may not be the 3rd party that is the issue - it could just be data corruption caused by network issues etc.

    I would stop the 3rd party product, then tidy up the SOP tables until they are perfectly clean, Then create a SQL trace on the SOP tables, then switch on the 3rd party product and let it do its thing.

    If data is being sent into GP - then consider using eConnect to do this. Writing to tables is fraught with potential issues, and depends completely on the GP expertise of the consultant. I've lost count of the number of such integrations we have replaced with eConnect.

    Best regards,

    Ian.

    Ian.

  • Ronie Profile Picture
    Ronie 1,080 on at

    Hi Ian,

    Thanks for your reply. I talked to our developer who handled the 3rd party product then he answered the question below.

    Is the 3rd Party product writing to GP?

    The 3rd party does not write/update/delete any tables in GP our developer created a third-party tables to store data information’s.

    If not, when does it query the SOP tables?

    The 3rd party does not  query the SOP tables. The customization scripts  triggers  upon transferring the SOP Order transactions to invoice transactions. This will validate and update the status in the 3rd party table if the transaction is transferred to invoice.

    how is it taking data out?

    The customization only read data from SOP work tables.

    Thanks,

    Ronie

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans