Skip to main content

Notifications

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:
  • Richard Wheeler Profile Picture
    75,848 Moderator on at
    RE: Batch Transaction Count changes

    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.

  • Bill Campbell Profile Picture
    12 on at
    RE: Batch Transaction Count changes

    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,848 Moderator on at
    RE: Batch Transaction Count changes

    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?

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

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

#1
Martin Dráb Profile Picture

Martin Dráb 601 Most Valuable Professional

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 416

#3
Adis Profile Picture

Adis 384 Super User 2025 Season 1

Product updates

Dynamics 365 release plans