GL_DetailPosting - Linking GL account to Job Number

Hi,

I am trying to find a path from the GL detail back to the AP/PO data where Job number is recorded.  Wanting a query to do this instead of having to manually track down the PO lines.

Is the same Sequence Number field that appears in the GL_DetailPosting table written to any other tables during posting or is that specific to the GL table?

Thanks,

Ryan

  • 0

    Your problem is that the Job data is combined in the comment field so there is no actual direct link.

  • 0 in reply to BigLouie

    That is what I gathered, but figured I'd ask if there was something I was missing.  I think I found a decent work around with the GL_DetailPosting[JournalRegisterNo] matching up with the AP_Header[SouceJournalNo].  From there I dig into the AP_Detail table to find the Job numbers by line.  Just had to do some calculated fields for matching up the transaction amounts where the GL table has a summary of all lines posted at once with the same job.  

  • 0

    I needed Job numbers in the GL as well, I created UDF's to post the job number from the transactions into the GL.  The only problem with that is that you will only be able to get data out of the GL from the point at which you create the UDF's and transactions begin posting, unless you populate the job number field in GL for older transactions.  We did not have a lot of transactions yet, since we just started to use job cost.