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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Batch Transaction Count changes

(0) ShareShare
ReportReport
Posted on by 12

We have been encountering a situation with a client who has been on GP since early 2008 - so experience is not an issue - user has been there since day 1.  

What we are seeing is a series of transactions being entered as Sales Orders or Quotes and then being processed into Invoices.  This is not the only case - the user has informed me that she will also at times directly create a new batch and enter invoices directly into the system.  After she has entered - there maybe a time gap - she will go to POST and the window will show that there are no transactions in the batch.  Only solution is to open the Sales Transaction Entry window, select each Invoice and move it to a different batch - then and only then can she post.

Once this is done, the user is reporting that the number of transactions in the Batch are changing to a negative value.  I can open the SY00500 and see that the number of transactions for a specific batch now shows a value of -2

But when I look at the SOP10200 (Line Detail) I can see over 45 lines items attached to a specific batch - that also appears in the SOP10100 (Header) - in three specific Invoice documents.

However in the SY00500 the record shows that there are -2 transactions in the same batch.

***** Second part *****

When this is happening all the values in the SY00500 seem to be getting dumped.  This client has a QUOTE file of over 4500 documents - active - and they use it each and every day, but after I ran CHECK LINKS on the Sales module last week, it was recovered and in the SY00500 the QUOTES batch showed over 4500 transactions, and NOW when I run the query for the SOP10100 for QUOTES I get 4750 records, but in the SY00500 the number of transactions show ZERO 

Thanks in advance for your assistance

Categories:
I have the same question (0)
  • Richard Wheeler Profile Picture
    75,850 Moderator on at

    You don't have any third party products that transfers orders to invoices, do you? Did someone queue up a SQL job that does this? There is nothing in GP that does this.If you check GP Activity Monitor is there anything there? How about under Timed?

  • Bill Campbell Profile Picture
    12 on at

    Thanks I will have to look into any SQL jobs, but pretty sure not.   They use Horizon Light Manufacturing - but client tells me that she enters the INOVICES manually or transfers them from the the document of ORDER or QUOTE

  • Richard Wheeler Profile Picture
    75,850 Moderator on at

    I have a similar problem but I found were users pulling up transactions and changing the batch ID. The batch hash totals normally do update correctly but every now and then they are wrong. Check links will correct the batch totals.

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…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 449 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 422 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans