Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
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

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 12 on at
    RE: Project Accounting Batch Master

    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.

  • kdraper Profile Picture
    kdraper on at
    RE: Project Accounting Batch Master

    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'

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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

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 >

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans