Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Regular Contributor
skipwhitten
Posts: 257
Registered: 11-03-2008
0

GL Transactions Report Detail

I have an entry on this report that has no Transaction Date. The posting comment normally contains the invoice #, vendor # and transaction date. For this entry the posting comment states "Process Receipt Of Invoice" only. Not sure if the blank transaction date is the issue but I can't identify the vendor or what we purchased, Thanks in advance for any help.

 

Skip

Skip Whitten, MCP
Systems Administrator
Biocompatibles, Inc
Sage MAS 500 Customer
trodman
Posts: 233
Registered: 02-13-2009
0

Re: GL Transactions Report Detail

What does the batch number begin with? If it begins with GL then I don't think it will have a transaction date because when you enter a journal entry you get to pick a posting date, but not a transaction date.

Tim Rodman
Programmer Analyst
rodmant@robbinstbm.com
Version 7.30.6.0 (March 2011)
Regular Contributor
skipwhitten
Posts: 257
Registered: 11-03-2008
0

Re: GL Transactions Report Detail

It begins with POVO-

 

Skip

Skip Whitten, MCP
Systems Administrator
Biocompatibles, Inc
Sage MAS 500 Customer
JohnHanrahan
Posts: 205
Registered: 11-03-2010
0

Re: GL Transactions Report Detail

If you post in detail you should be able to drill into it.

 

If not you should be able to go into the AP Voucher View and look it up by batch.

 

John

Sage MAS 500 Customer
trodman
Posts: 233
Registered: 02-13-2009
0

Re: GL Transactions Report Detail

John, you mean drill into it in the GL Account Transactions explorer view right? I agree, a POVO transaction should have transaction date.  Must be a problem with that individual transaction.

Tim Rodman
Programmer Analyst
rodmant@robbinstbm.com
Version 7.30.6.0 (March 2011)
Sage MAS 500 Customer
JohnHanrahan
Posts: 205
Registered: 11-03-2010
0

Re: GL Transactions Report Detail

Correct, it just depends on their posting detail options. 

 

John

Regular Contributor
skipwhitten
Posts: 257
Registered: 11-03-2008
0

Re: GL Transactions Report Detail

I am in Voucher View and selected the Batch Number POVO-xxxxxxx and the transaction for $80.00 does not appear. Not having a transaction date must be the issue

Skip Whitten, MCP
Systems Administrator
Biocompatibles, Inc
Regular Contributor
skipwhitten
Posts: 257
Registered: 11-03-2008
0

Re: GL Transactions Report Detail

I would like explore the data with Crystal. Any idea with table I should access?

 

Thanks,

 

Skip

Skip Whitten, MCP
Systems Administrator
Biocompatibles, Inc
Sage MAS 500 Customer
trodman
Posts: 233
Registered: 02-13-2009
0

Re: GL Transactions Report Detail

tapVoucher and tciBatchLog

Tim Rodman
Programmer Analyst
rodmant@robbinstbm.com
Version 7.30.6.0 (March 2011)
Regular Contributor
skipwhitten
Posts: 257
Registered: 11-03-2008
0

Re: GL Transactions Report Detail

Thank you!

 

Skip

Skip Whitten, MCP
Systems Administrator
Biocompatibles, Inc