Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Transaction in Sales D...
Microsoft Dynamics GP (Archived)

Transaction in Sales Documents but not in Debtors Documents

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi,

The Dynamics GP version we use is Dynamics GP 9.

 

I have a problem with a number of sop transactions. The users generate the transactions and it posts through without errors or problems. However, when it comes to our day-end, we find that the transactions cannot be found in the debtors module!

 

If i go to Enquiry->Sales documents, i can find the transaction. 

If i go to Enquiry->Trx by document/debtor, i cannot find the transaction.

 

Also, when i view the distributions of the transaction, i notice that the COGS and INV distributions are missing and looking at the Enquiry->Inventory, i find that the transaction has not yet removed the items from inventory either.

Strange enough, the transaction does go through to the GL without a hitch, excluding the COGS and INV entries of as they are still missing in the GL as well.

So, the transaction posts, bypasses all modules and goes straight to the gl. It happens infrequently, but recently seems to be increasing. We seem to have about 4 of these type of error transaction every 2 days.

 

Can someone kindly assist. Possible to fix without having to recapture the entire transaction etc.? Any routines to run to fix? Any idea on what is probably causing this?

 

Kind regards.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Transaction in Sales Documents but not in Debtors Documents

    Hi,a lot there to digest.

    Yes, Terminal Services could cause issues, but the users would most likely get error messages etc. Testing the network connectivity may not identify all issues, usually people just track / test for disconnections...but individual packets could be getting lost due to bandwidth without actual disconnects. I wouldn't concentrate on this however. TS would be low down the list of potential problems given your other information (modified SOP).

    The one area you need to concentrate on now is the modifications. If I was a betting man, I would wager that this is where you will find the issues. Debugging is going to be hard. You need to find out exactly what the developments are supposed to do. You need to find out exactly what triggers are running and where. The issue is most likely with the SOP posting process since two other areas of the system do not get updated - RM and Inventory (ie, its not an issue with RM alone). Are all SOP documents manually entered, or do you have any kind of integration running? The SOP entry process can be very sensitive to the timing of triggers. Custom triggers placed in the wong place can sto standard triggers firing.

    Who developed the modifications? Internal or outside consultants? If outside, was there a formal acceptance of the developments - whereby you accepted the developments as working? Have you toldthem of your issues? Might not be a bad idea, they might be able to dbug the developments easier / quicker that you.

    If you search through the RM Open table, can you find any reference to these SOP transactions - bearing in mind that the records might be corrupt - i.e. missing a document number or something. Worth looking at the data in these tables to see if there is any corruption anyway. Might tell you something.

    Best regards,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Transaction in Sales Documents but not in Debtors Documents

     Hi Ian,

     

    Thanks for the reply.

     

    It is very unusual. Its actually started around last year, a while after we had upgraded to Dynaics GP 9. I think you guessed quite right, we do have a custom form for SOP. Unfortunately, due to the nature of the business processes, we dont use the standard form at all (its only me who does). 

     

    As for triggers, i have disabled triggers and the problem still exists.

     

    The transactions are definitely posted in SOP. I find them after selecting HISTORY in the Sales Transactions enquiry screen, i find them in SOP30200 and SOP30300 including sop tax tables etc. I dont find them in any of the RM tables though. However, they do appear in the GL20000 tables as well.

     

     The item numbers are sometimes typed in and sometimes looked up. Usually, items are looked up, but for the easy to remember codes, the users do enter the code and tab along.

     

    Our GP install initially was a fresh install.

     

    I must also mention that we do have third-party add-ons as well, however, we've been using them since our first install of Dynamics GP 7.5.

     

    I have also checked the security and everything is fine.

     

    We have a terminal server environment (sql is on another server). Someone did mention that a sudden loss in the connection to the servers could cause this problem. My networking service providers have been through the site and find no problems with network connectivity etc.

     

     Kind regards.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Transaction in Sales Documents but not in Debtors Documents

    Hi Ismail, if the behaviour is as you describe, it goes without saying that this is very unusual - its certainly not a bug or anything like that in GP - unless I missed seeing this in a service pack!! Have you any third party developments installed? Are there any triggers running on the SOP entry window? any triggers running at 'Post' time? ...Something is interfering.

    Just to be sure...

    When you find a doument in Enquiry >> Sales Documents but can't find it in RM - are you sure it is actually posted in SOP? The fact that it is not posted in RM, and that stock has not been reduced, and that COGS has not been calculated - indicates that the SOP invoice has not been posted. If you entr this documents number into the SOP Transaction Entry window, can you call up the transaction, or does SOP tell you that it has already been posted? Please try this, and let us know the results.

    For the moment we will ignore the GL transactions.

    How is the item number in the SOP transaction being entered, is it being typed in, or selected from a list? Do you allow entry of Non-Inventory Items?

    Was there anything unusual about the install of GP - did you for example restore the company data from a previous install or restore the DYNAMICS database from a test enviornment or anything outside of actually installing everything fresh?

    You seem to be having a few issues with SOP - ie your other post about long posting times. Please check if there are custom triggers / procedures / developments running in SOP. You could try looking at Security - see if a modified or alternate dynamics window has been assigned to you for the SOP Trx Entry window. If so, revert yourself back to the standard window in a test company and test enter a return (as per your other post)...and ask why there is a modified / alternate window in the first place.

    Best regards,

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans