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
We've had this happen to us about once a month. Are there any indications for what would cause an invalid or blank field? Multiple employees will have the same entries, yet only one employee seems to be missing data.
update pjlabdis set dl_id05 = '0000', home_subacct = '998000000' where status_gl = 'U' and fiscalno = '201604'
update pjlabdis set cpnyid_home = 'BGC', home_subacct = '998000000' where status_gl = 'U' and fiscalno = '201604'
These scripts accomplished our database field errors and we were able to close the period! Thanks Stacie!
Thanks much Stacie - we will forward to our IT group.
Darren
Darren,
You can run an update stmt in SQL. Are you familiar with SQL update statements?
If yes, here is a sample statement
update pjlabdis set cpnyid_home =cpnyid_chrg, home_subacct = 'XXXXXXX' where status_gl = 'U' and fiscalno = '201604' and cpnyid_home = ''
--replace the 'XXXXXX' with the appropriate subacct
Use Begin Transaction and commit or rollback. Make sure you have a current backup.
If you need help with the correction you can phone me at 636.898.8141
201605 ASP ASP 5010 230SCPCAT
201604 BGC 6025 230000000
It looks like you are correct, the top line is a normal posting with company "ASP". The second line is the troubled entry, which doesn't have a home company or home subaccount. How do we enter into the database?
Darren
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'
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
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.
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
Hi Darren,
Run the following to identify
select fiscalno, employee, docnbr, * from PJLABDIS
where status_gl = 'U'
Thanks,
Stacie
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (