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.

Exporting GL Transaction detail with VI in 4.3

Posted By rajncajn72 over 10 years ago

Tried to create export with VI for GL Transaction detail and it pulls 0 records. Need it to pull for a whole month. and currently using the GL_TransactionJournalHeader. Want it to pull SourceJournal, EntryNo, PostingDate, JournalComment, and JournalTotal.

I haven't changed anything, but it is still pulling 0 records. The Select is a Range from 20131001 to 20131031, Sort is by postingdate.

Any idea why this would not be pulling any records?

0 Steve Passmore over 10 years ago

Posted G/L transactions are in table GL_DetailPosting. The table you are using is the header table for the G/L Transaction Journal Entry task.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rajncajn72 over 10 years ago in reply to Steve Passmore

GL_Detail Posting doesn't give me the columns I need ie EntryNo, or Journal Total. I can pull Debit or Credit, but not a total for the posting
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Exporting GL Transaction detail with VI in 4.3

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING