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

Announcements

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 587

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 552 Super User 2026 Season 1

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 542 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans