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 SL (Archived) / Labor Entries not post...
Microsoft Dynamics SL (Archived)

Labor Entries not posted to GL

(0) ShareShare
ReportReport
Posted on by Community Member

Hello.

We are trying to close an Accounting Period in SL. Error message is - "5 Labor Entries are not posted to GL".

We have gone back to the GL Labor Posting Screen for all 5 companies and there is nothing to post.

Any assistance on how we can resolve this is greatly appreciated.

Thanks in advance.

*This post is locked for comments

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

    Hello John,

    If you have access to SQL Server you can run a query to identify the records.      The closing process is looking for pjlabdis records where status_gl = U and the fiscalno matches your closing period.

    Once identified,  review the cpnyid_chrg and cpnyid_home as well as gl_subacct and home_subacct.    If populated incorrectly GL Labor Posting will ignore.

  • Community Member Profile Picture
    Community Member on at

    Hello Shertel,

    Here is an example of the SQL script which has worked successfully in prior closing periods.

    Select employee, docnbr, * from pjlabhdr where le_status not in ('P', 'X') and pe_date < '05/31/2013'

    Can you suggest specific amendments to this?

    Thanks again.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    John,

    Your script is used for located Unposted (not approved) timecards.    It can be used to address the "warning unposted timecards exist" message during closing.

    When looking for Labor Entries not posted to GL,    SL runs the following query during the closing process.   IF the Require GL Labor Posting to Close option in T&E Setup is enabled.

    select  employee, docnbr, * from PJLABDIS
    where   fiscalno = <current period> and status_gl = 'U'

    If one of the fields from my previous post is blank or populated incorrectly the pjlabdis records will be ignored by  GL Labor Posting and cause the closing error.

  • Community Member Profile Picture
    Community Member on at

    Shertel,

    Thanks for your help with this.

    Regards,

    John

  • Community Member Profile Picture
    Community Member on at

    Good morning,

    We have tried to SQL script above and it returned no data.  In project controller, we are still showing 1 labor entry not posted  so we are unable to close the current period.  Are there any other queries to uncover this labor entry?

    thanks,

    Darren

  • Community Member Profile Picture
    Community Member on at

    Hi Darren,

    Run the following to identify

    select  fiscalno, employee, docnbr, * from PJLABDIS
    where  status_gl = 'U'

    Thanks,

    Stacie

  • Community Member Profile Picture
    Community Member on at

    Thanks so much Stacie -

    We were able to use that and locate one record that shows "posted" but one line item on the time card is not showing up on the gl distribution and hanging us up from close.  Any thoughts on how to push this through?

    Sincerely,

    Darren

  • Community Member Profile Picture
    Community Member on at

    Hi Darren,

    Make note of the fiscalno that was returned from the select query.     Then in SL >  T&E > Processes,   Run the GL Labor Posting for that period.       

    If the the transaction still isn't moved to GL,   the most common reasons are invalid or blank cpnyid_home or cpnyid_chrg fields,  invalid  GL_acct, gl_subacct or home_subacct fields.

  • Community Member Profile Picture
    Community Member on at

    Appreciate the time - we did review the time card and it appears ok.  We did a correction and resubmittal and posted which appeared to post.  But now it's saying 3 labor entries not posted.  So it added the correction and new time card to the errors.  All fields appear to be correct.  Any further advice?

    Darren

  • Community Member Profile Picture
    Community Member on at

    Something on the pjlabdis records is not allowing the gl labor posting to pick up  the transactions.    invalid or blank field,   invalid acct/sub combo,  etc.    Maybe someone went in and set a subaccount to inactive.

    run the following query and post or email the results.   

    select fiscalno, cpnyid_home, cpnyid_chrg, gl_acct, gl_subacct, home_subacct,* from pjlabdis where status_gl = 'U'

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 SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans