You’re offline. This is a read only version of the page.
135
Hello - First time I have used this forum and not for sure if I am looking in the right place. I need help setting up a report using Crystal Reports and GP Dynamics. I would like to pay someone to help me setup this report that is knowledgeable with both products. I have incidents out with both companies right now and I am getting nowhere fast. The report I am needing is mostly out of A/P in Dynanics dealing with Vendors and Budget.
If this is in your field, please let me know.
Thanks very much.
C. Scheible
*This post is locked for comments
Dear C Scheible
Pleae mail your requirement on tariq_erp@yahoo.com
Thanks
Tariq
Thank you for writing me. I am willing to pay for the time spent on my report, because I am very new with Crystal. Can you let me know when you are available to help me, such as during the work day, evening, weekend, etc.? I would like you or whoever helps me to streamline in and we both be on the phone together to build this report. Please let me know if you would like to do this. My office number is 432.897.0202.
Thanks.
Cherry Scheible
@C Scheible
I have worked a lot in crystal report with MSGP. I can help you wiht or with out payment if you really require my service in developing any reports relating GL,AP,AR,SOP , POP or Analytical Accounting and Bank Reconciliation.
e-mail : tariq_erp@yahoo.com
Kevin
Thank you very much for your help. I have written Frank first to see if he is interested. I really appreciate your help.
C. Scheible
Or you could also work with Frank from the post above,
I think I would like to pass this to someone else as I don't have a copy of Crystal Reports to work with anymore. There is someone on this site names Victoria Yudin who seems to be very experienced in Crystal and here is a link to her website. Why don't you try to get in touch with her
http://www.flex-solutions.com/gpreports.html
Kevin
I spoke with you last week about my Dynamics and Crystal issue. I was waiting on a support call that I had paid for with Dynamics and Sap Crystal, but neither were able to help me. What I would like is to pay you or someone with Dynamics and Crystal experience to help me setup this report that I need. I work with Dynamics but not Crystal so I am at a big loss with Crystal. Most of this report is coming from accounts payable (if not all of it). If you are interested please write me back and I can give you my phone #, email or whatever we need to work out some kind of deal that is workable for both of us. I really need to have this report done before the 21st. if at all possible.
Thank you Kevin.
C. Scheible
u must mail me details on my add eco_pak@hotmail.com.
Hi Kevin
This looks like what I am wanting. I will start back on it again tomorrow and I will keep intouch.
Thanks
Where is that budgeted information stored? I don't know anywhere in GP that stores a budget for Vendors. However, I have had success attaching Crystal Reports to an excel spreadsheet as a data source (use a named range). Or you could use a SQL table or an access database.
So first you would want to get a spreadsheet (or some other sort of database) with a column for Vendor ID and Budget amount. This way you can link Vendor ID to Vendor ID.
Looks like in your example you would need dynamic columns (Calculated fields in Crystal) and that they would go 4 weeks out. I am thinking that you could accomplish this by creating 4 columns (week1, week2, week3, week4) and pull in the table for payables transactions (PM20000). This is the open invoices table.
Column 1 might be (in english, not in any sort of code) "Where Due Date < Today + 7 days"
Column 2 Where Due Date > Today + 7 Days and < Today + 14 days.
See where I'm going with this?
You could do all sorts of date manipulations with Crystal or SQL. You need to figure out exactly what your columns need to be. For instance, do you want just 7 days out from the date they run the report? Or always have weekly buckets? I would say you don't want to hard code these dates or you will have to change them all the time. This might be the trickiest part
To bring in the summary information about what a vendor has done to date, there are tables that store that too. PM00201 stores this YTD summary information. All these tables would be linked by Vendor ID.
If you brought in all of this data in your "Detail" section of the crystal report, then you can Group and Subtotal (in Crystal) by Vendor ID. What if you want to see just a bucket of dollars for a vendor as opposed to individual invoices? For instance, what if above TXu Electric had 3 invoices for 100.00 due on 7-1. Do you want to see it as $300 or as three $100 invoices?
This is where you start getting into supressing rows in Crystal. You might want to supress the detail section after you group by vendor and let the user drill into the section by double clicking it if they want to see the detail.
Hope this sends you in the right direction. Hopefully someone else will have some more to add or correct me if I am wrong in any of this.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (