Dynamics 365 CommunityForums Microsoft Dynamics SL (Archived) GL Labor Posting not d...

GL Labor Posting not done for previous period

(1) Share

Report

Posted on by Community Member Microsoft Employee

I closed my PR on the first day of each month and am supposed to run the GL Labor Posting from the Projects/Time and Expense for Projects but I think I may have forgotten that step in my closing as when I run my FRX financials there is only a small total in wages. I have ran the script below in sql and the total labor for the month is showing as unposted. I tried to run the GL Labor Posting for the period but it will not allow me to due to the period being closed. I have checked the GL setup and I am able to post to past periods. I tried updating (changing status_gl to P) one line in the following data batch to see if it effective the totals and it did not.

SELECT EMPLOYEE, DOCNBR, * FROM PJLABDIS WHERE FISCALNO='201903' AND STATUS_GL='U'