In Flex Billing, I need to change a crystal report. I can view the report in "Work Performed Detail Invoice" but nowhere on the screen does it tell me which .rpt file I am working with. I have tried to go through many of them in the User folder as well as the BI folder and can't seem to match them up.
First question: Is there some way to show the actual crystal file?
Second: Is there a place to see the mapping of report to screen for all reports?
*This post is locked for comments
Hello,
You can also find the format name if it is different from the standard report in the Report control Maintenance screen off the administration module, BI010 has only one format, but you can create other formats to use, this is basically a customized report beyond what the Invoice format Maintenance screen would do.
Best Regards,
Jana MacDonald
What I have done before was to set the report to default to print to file (PDF) through Dynamics printer settings, and to use the report number as the report name. After printing, the report name should indicate which report you want to view.
that's what I thought, but neither (or I should say any as they have soooo many versions) are matching what I'm seeing on the screen. Is there a link contained in a SQL table or view?
First, you need to know the Invoice Format Code from the Flex Billings Invoice & Adjustment Maintenance (BI.BAM.00) screen. Then, open the Invoice Format Maintenance screen (BI.ISM.00), and enter the Invoice Format Code. The Report ID field will be the Crystal Report, which an be found in either the Usr_Rpts folder (if modified), or in the BI folder (if standard).
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156