Edwin Rodriguez
Edwin Rodriguez
  • Male
  • Cidra, PR
  • Puerto Rico
Share on Facebook
Share Twitter
  • Blog Posts
  • Discussions (3)
  • Groups
  • Photos
  • Photo Albums
  • Videos

Edwin Rodriguez's Discussions

How can I do a Check Register Type Report on Peachtree BI?
5 Replies

I am trying to do a Money In/Out Report for a given month, basically a Peachtree Check Register Report UNION to a Payment Received Report. Basically Payments Received (sales), Payments Made (invoices…Continue

Tags: Register, Check

Started this discussion. Last reply by Ruth Gray Jan 31.

 

Edwin Rodriguez's Page

Latest Activity

Profile Icon
cristina simon left a comment for Edwin Rodriguez
Hello dear, my name is cristina, i came across your profile now on this Comment Site . So I decided to stop by an let you know that I really want to have a good friendship with you. Beside i have something special i want to discuses with you, but I…
yesterday
Profile Icon
Ruth Gray replied to Edwin Rodriguez's discussion 'How can I do a Check Register Type Report on Peachtree BI?'
Glad you have got that sorted Edwin. If you are looking for some data dictionaries on the conatainers that ship with Peachtree Business Intelligence, you can donwload those from the Peachtree Business Intelligence Group.
Jan 31
Profile Icon
Edwin Rodriguez replied to Edwin Rodriguez's discussion 'How can I do a Check Register Type Report on Peachtree BI?'
You betcha, yes it does feel really good! :)
Jan 27
Profile Icon
Dave Smith replied to Edwin Rodriguez's discussion 'How can I do a Check Register Type Report on Peachtree BI?'
Feels good to nail it, doesn't it Edwin!  Nice job, Cheers  Dave
Jan 27
Profile Icon
Edwin Rodriguez replied to Edwin Rodriguez's discussion 'How can I do a Check Register Type Report on Peachtree BI?'
I got It. The query is: SELECT JrnlHdr.Reference, JrnlHdr.MainAmount, JrnlHdr.TransactionDate, JrnlHdr.JrnlKey_Journal, JrnlHdr.TrxName, Employee.EmployeeName, JrnlRow.RowNumber FROM (JrnlRow LEFT OUTER JOIN JrnlHdr ON…
Jan 27
Profile Icon
Dave Smith replied to Edwin Rodriguez's discussion 'How can I do a Check Register Type Report on Peachtree BI?'
A couple of tips to help you get going in the right direction, Edwin.  In your WHERE clause of your SELECT statement, add this >> WHERE "JrnlHdr"."JournalEx" in (3, 5, 7, 13).  Then you may want to use a CASE END…
Jan 18
Profile Icon

How can I do a Check Register Type Report on Peachtree BI?

I am trying to do a Money In/Out Report for a given month, basically a Peachtree Check Register Report UNION to a Payment Received Report. Basically Payments Received (sales), Payments Made (invoices paid and Payroll checks).I am working on the connector, and I am having trouble identifying the fields from the Journal Row table, especially the Payroll fields.Is there a Database reference, which has the different database fields and corresponding Peachtree Fields? Is there any documentation on…See More
Discussion posted by Edwin Rodriguez Jan 18
5 Comments
Profile Icon
Edwin Rodriguez is now a member of The BI Community - Powered by Alchemex Jan 16
Welcome Them!

Profile Information

Alchemex Powers the Following BI Solution, Pick Yours
Sage Peachtree Intelligence
Website
http://www.mejiasandassociates.com
About Me:
Software developer.
Where did you hear about us?
Other
If other, please specify
Friend refereal

Comment Wall (1 comment)

You need to be a member of The BI Community - Powered by Alchemex to add comments!

Join The BI Community - Powered by Alchemex

At 12:42am on February 22, 2012, cristina simoncristina simon said…

Hello dear,

my name is cristina, i came across your profile now on this Comment Site . So I decided to stop by an let you know that I really want to have a good friendship with you. Beside i have something special i want to discuses with you, but I find it difficult to express myself here, since it's a public site. I will be very happy, If you can get back to me, through my e-mail. (cristina.simon84@yahoo.com) So we can get to know each other better,and i well give you my pictures and also tell you more about me OK, you can contact me through my e-mail id Is, (cristina.simon84@yahoo.com)
Regard,
cristina

 
 
 

Follow Alchemex on twitter

Like Alchemex on facebook

This Weeks Top Content 

1 Sage MAS Intelligence Report Designer and 13 fiscal periods

Sage MAS Intelligence Report Designer and 13 fiscal periods
2 SQL Join using 2 fields

SQL Join using 2 fields
3 Create and Link does not save account mapping

Create and Link does not save account mapping
4 SMI Consolidating companies w/different fiscal years

SMI Consolidating companies w/different fiscal years
5 Pivot table from sheet 1 and sheet 3

Pivot table from sheet 1 and sheet 3

Alchemex Integrates with:


© 2012   Created by Admin.

Badges  |  Report an Issue  |  Terms of Service

Sign in to chat!