Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

Batch Transaction Count changes

Posted on by 22,647

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
    Richard Wheeler 75,730 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
    Bill Campbell 22,647 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
    Richard Wheeler 75,730 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

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans