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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Project Accounting Bat...
Microsoft Dynamics GP (Archived)

Project Accounting Batch Master

(0) ShareShare
ReportReport
Posted on by Bill Campbell 12

Is there a table in PA that holds all the batch header detail?  Or am I looking for something that does not exist.

Here is the situation.
Client has about 50 transactions that appear to be available to POST, however, when you print the edit list, it reports that the transaction is already posted.

So, doing a SQL compare between the PA10000 and the PA30100 I can find the Timesheet Headers listed there.

The client question is - can you assure me of this by printing a list of Open Batches from PA that agrees to this list you are planning to remove from the OPEN table.

I have so far been able to find the PA Batches in the SY00500 with a batch source of PA_TS which is kind of what I want, but she thinks this is referencing the batches in the GL for the same timesheets.

QUESTION

Can anyone tell me (1) there is or is not a Batch Master Table for PA (2) when I see PA_TS in the SY00500 that is ALL of the batches in PA10000.

Thanks.

*This post is locked for comments

I have the same question (0)
  • kdraper Profile Picture
    kdraper on at

    I work with Project batches on a regular basis and I have not updated any PA tables when I have had issues with batches.  The regular rules apply.

    UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='XXX'

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 12 on at

    Kerry, you  point out how to look up the Bach ID in the SY00500 and that is what we did, however, in the end of the day we did a script that looked for the PA_TS number in the PA30100 and PA30101 and if there deleted them from the PA10000 and PA10001.  As well we removed the record from the SY00500 for all the PA_TS Batches that were no longer in the PA10000.

    This has resolved our problem and we have moved on - the client is satisfied the case is closed.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans