Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

GL_DetailPosting - Linking GL account to Job Number

Posted By Ryan OHara over 1 year ago

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

Parents

0 BigLouie over 1 year ago

Your problem is that the Job data is combined in the comment field so there is no actual direct link.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 BigLouie over 1 year ago

Your problem is that the Job data is combined in the comment field so there is no actual direct link.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 Ryan OHara over 1 year ago 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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

GL_DetailPosting - Linking GL account to Job Number

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING