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 / Finance | Project Operations, Human Resources, ... / BI batch preventing cl...
Finance | Project Operations, Human Resources, ...
Answered

BI batch preventing closing of Project Controller

(0) ShareShare
ReportReport
Posted on by Community Member

Client is trying to close period and receives the following:

"Unposted Allocations in Current or Prior Period"

Following the instructions found in KB933082, I installed PA450c.rpt in the Usr_Rpts folder and added it to Report Control Maintenance for PA450. I ran the report and noted that the sole batch listed originated in the BI module. I tried to post the batch in that module, but none was found.

In SQL, I tracked the batch transactions from PJTRAN to ARDOC/ARTRAN and finally to GLTRAN. All transactions appear as they should and are released/posted. It appears that the records that are in this particular report are there erroneously and are interfering with the closing process.

What is the best way to resolve this issue? 

SL 2011 FP1

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

    Digging in a bit more, I have found that the PJTRANWK table is populated with the BI transactions noted above. The schema definitions in the help file state that the records should have deleted after processing. If I remove these records now, will that allow the closing process to complete?

  • Verified answer
    CFROTON Profile Picture
    CFROTON 4,710 on at

    Dear Stuart,

    Delete the batch from pjtranwk, BI batches don't allocate normally. When you have auto allocation turned on ALL transactions that insert to pjtran, insert also to pjtranwk, Allocator processes the transaction by allocating or not allocating, and deletes the pjtranwk record,  that BI batch got stuck in there and didn't delete.

    Your solution is to Delete * from pjtranwk, and then you can close.

    This normally happens if there is a network problem or the user posting the BI batch, doesn't have full access to the allocator (remember this is auto allocation) Give the invoice posting user access rights to the allocator.

    Best Regards,

    Jana MacDonald

    Microsoft Dynamics Support

  • Community Member Profile Picture
    Community Member on at

    Thanks, Jana! This did the trick.

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 503 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 434 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 278 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans