{"type":"doc","content":[{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{"outline":{"value":"true"},"_parentId":{"value":"498436748"},"style":{"value":"none"}},"macroMetadata":{"macroId":{"value":"03f5aaee-c47f-40c8-a0da-b50613d19cb1"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"8c932e6a-6aa0-43fd-bb6b-1fbafd574de0"}},{"type":"heading","attrs":{"level":2},"content":[{"text":"About Custom Reports","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Overview","type":"text"}]},{"type":"paragraph","content":[{"text":"Custom Reports","type":"text","marks":[{"type":"strong"}]},{"text":" is a built-in HTML Template Engine that uses HTML Coding and external frameworks to allow Users to write their unique Reports using PCR-360 data and format them however their Organization desires. Before writing a Report, a User should be familiar with HTML programming and should first read the external documentation for ","type":"text"},{"text":"Smarty","type":"text","marks":[{"type":"link","attrs":{"href":"https://smarty-php.github.io/smarty/4.x/designers/language-basic-syntax/"}}]},{"text":" and ","type":"text"},{"text":"Bootstrap 5.1","type":"text","marks":[{"type":"link","attrs":{"href":"https://getbootstrap.com/docs/5.1/getting-started/introduction/"}}]},{"text":". ","type":"text"}]},{"type":"paragraph","content":[{"text":"Custom Reports empower users to customize their organization's customer experience. Your organization can make the Reports available on CustomerCenter, in a backend reports grid or directly on specific backend application grids and forms. PCR has structured the Custom Report creation process to mimic best the workflow needed to build the Report.","type":"text"}]},{"type":"paragraph","content":[{"text":"Additionally, Custom Reports allow Users to run a Report and save the output directly to the server. The saved report can be shared with others without re-running it or worrying about the data within the Report changing.","type":"text"}]},{"type":"paragraph","content":[{"text":"An example Custom Report is available at the bottom of this article.","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/pages/resumedraft.action?draftId=17236994#CustomReports-example"}}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Writing a Custom Report","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":1056,"widthType":"pixel"},"content":[{"type":"media","attrs":{"__fileSize":23580,"__fileMimeType":"image/png","width":1075,"alt":"image-20241218-042522.png","id":"52d514e3-0d0a-4a23-8f38-4d520db22bee","collection":"contentId-498436748","type":"file","__fileName":"db2f68ae-a0f2-47a3-854b-218cf4c473e6#media-blob-url=true&id=97fc70eb-a91d-4ee5-a4c2-e41df87ced29&collection=&contextId=28419&mimeType=image%2Fpng&name=image-20241218-042522.png&size=29958&width=1075&height=225&alt=image-20241218-042522.png","height":225}}]},{"type":"paragraph"},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"The Admin > Reports > Custom Reports menu option brings the User to the Custom Reports grid. From this grid, a User can ","type":"text"},{"type":"mediaInline","attrs":{"width":60,"alt":"Add","id":"bc0c3d70-e92a-4170-a7b6-e96b95bfbcd9","collection":"contentId-498436748","type":"image","height":34}},{"text":" , ","type":"text"},{"type":"mediaInline","attrs":{"width":110,"alt":"Edit Selected","id":"9f3a88a4-7432-41ec-96d8-c19ad6289fe0","collection":"contentId-498436748","type":"image","height":27}},{"text":" , and ","type":"text"},{"type":"mediaInline","attrs":{"width":127,"alt":"Delete Selected","id":"46a5ba36-514e-4548-a3fa-6ec0c3a32d27","collection":"contentId-498436748","type":"image","height":30}},{"text":" Custom Reports. For convenience, PCR-360 also offers the ability to ","type":"text"},{"type":"mediaInline","attrs":{"width":74,"alt":"Import","id":"04fa24d0-fcd8-4d18-b4d0-874e9774034a","collection":"contentId-498436748","type":"image","height":34}},{"text":" and ","type":"text"},{"type":"mediaInline","attrs":{"width":72,"alt":"Export","id":"321deb0a-e131-49b9-8aa7-d8dca87627cf","collection":"contentId-498436748","type":"image","height":28}},{"text":" Custom Reports for easy migration of Custom Reports from your Organization’s Test Systems to their Production Systems without having to re-create the Report manually.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Creating a New Report","type":"text"}]},{"type":"paragraph","content":[{"text":"A Custom Report is composed of multiple components. Every Custom Report has a unique ","type":"text"},{"text":"Identifier","type":"text","marks":[{"type":"em"}]},{"text":", a Report ","type":"text"},{"text":"Name, ","type":"text","marks":[{"type":"em"}]},{"text":"and ","type":"text"},{"text":"Roles ","type":"text","marks":[{"type":"em"}]},{"text":"assigned to access it.","type":"text"}]},{"type":"paragraph","content":[{"text":"Custom Reports consist of ","type":"text"},{"text":"Logic","type":"text","marks":[{"type":"em"}]},{"text":" (for querying system Data), ","type":"text"},{"text":"Parameters","type":"text","marks":[{"type":"em"}]},{"text":" (for determining Report content), a ","type":"text"},{"text":"Template","type":"text","marks":[{"type":"em"}]},{"text":" for formatting the Report, ","type":"text"},{"text":"Options","type":"text","marks":[{"type":"em"}]},{"text":" (for adding a Report Title, Footer, and additional CSS), ","type":"text"},{"text":"Attachments","type":"text","marks":[{"type":"em"}]},{"text":" (for external files to be used within the Report) and details to define it for ","type":"text"},{"text":"Batch Processing","type":"text","marks":[{"type":"em"}]},{"text":".","type":"text"}]},{"type":"paragraph","content":[{"text":"Custom Reports also maintain a short-term log of any ","type":"text"},{"text":"Debug","type":"text","marks":[{"type":"em"}]},{"text":" information, which is useful for refining the report's Logic and checking for possible errors within that Logic.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Logic Tab","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":703,"widthType":"pixel"},"content":[{"type":"media","attrs":{"__fileSize":23036,"__fileMimeType":"image/png","width":852,"alt":"Logic Section","id":"8dd687dd-d5a8-4d51-b056-aca7f01a1b30","collection":"contentId-498436748","type":"file","__fileName":"New_Custom_Report_Logic_Form.png","height":635}}]},{"type":"paragraph","content":[{"text":" Custom Reports utilizes the internal PCR-360 ","type":"text"},{"text":"Custom Logic","type":"text","marks":[{"type":"strong"},{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/sAIHAQ"}}]},{"text":" functionality that is also available to ","type":"text"},{"text":"Custom Events","type":"text","marks":[{"type":"strong"},{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/BgMHAQ"}}]},{"text":", ","type":"text"},{"text":"Custom API","type":"text","marks":[{"type":"strong"},{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/AQMHAQ"}}]},{"text":" and ","type":"text"},{"text":"Custom Validations","type":"text","marks":[{"type":"strong"},{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/PAMHAQ"}}]},{"text":". ","type":"text"}]},{"type":"heading","attrs":{"level":5},"content":[{"text":"Custom Report Functions","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"assign: Assigns a variable from the Logic to be used in the Template","type":"text"}]},{"type":"heading","attrs":{"level":5},"content":[{"text":"Example","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"/**\n * @param string $name - name of the assigned variable in the Smarty Template\n * @param array $value - value of the assigned variable in the Smarty Template\n * @return void\n */\n$this->assign('variableName', $variableValue);","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"loadReport: Loads another Report based on the Report Identifier","type":"text"}]},{"type":"heading","attrs":{"level":5},"content":[{"text":"Example","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"/**\n * @param string $identifier - another report's identifier\n * @param array $params - array of parameters used to render the other report\n * @return string - the Rendered Report\n */\n$report = $this->loadReport('customReportIdentifier', ['paramName' => $parameterValue]);","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"barcode: Generates an HTML IMG tag of a barcode","type":"text"}]},{"type":"heading","attrs":{"level":5},"content":[{"text":"Example","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"/**\n * @param string $code - string text to encode\n * @return string - barcode IMG tag\n */\n$barcodeImgTag = $this->barcode('test test');","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"addError: Forces the Report to render an Error Message instead of the Report","type":"text"}]},{"type":"heading","attrs":{"level":5},"content":[{"text":"Example","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"/**\n * @param string $message - string error message to display instead of rendering report\n * @return void\n */\n$this->addError('Some error in the Report Logic');","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"The Logic Tab is used for querying PCR-360 data. The Logic section has two parameters available for use in the ","type":"text"},{"text":"Custom Logic","type":"text","marks":[{"type":"strong"},{"type":"link","attrs":{"__confluenceMetadata":{"isRenamedTitle":true,"linkType":"page","contentTitle":"Custom Logic","versionAtSave":"7"},"href":"https://pcr360.atlassian.net/wiki/spaces/pcr360wiki/pages/17236656"}}]},{"text":": ","type":"text"},{"text":"$params","type":"text","marks":[{"type":"em"}]},{"text":" and ","type":"text"},{"text":"$user","type":"text","marks":[{"type":"em"}]},{"text":". ","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"$params","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"A key/value paired array of parameters that were passed into the Report are available within this array. Any changes to this array are also assigned to be accessed from the Smarty HTML Template.","type":"text"}]},{"type":"codeBlock","attrs":{"language":"php"},"content":[{"text":"if(isset($params[\"reportParameter\"]) && $params[\"reportParameter\"] === true)","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"$user","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"A key/value paired array of User information about the currently logged in User. The example below shows the options that are available within this array. This data enables Custom Reports to be specifically tailored to the User viewing the Report.","type":"text"}]},{"type":"codeBlock","attrs":{"language":"json"},"content":[{"text":"[\n \"isSysAdmin\" => true,\n \"isCoordinator\" => true,\n \"isCustomerCenterOnly\" => false,\n \"attributes\" => [\n \"USERS_RECID\" => \"1204\",\n \"USERID\" => \"demo\",\n \"CONTACTS_RECID\" => \"215962\",\n \"NAME\" => \"demo PCR\",\n \"FIRST_NAME\" => \"demo\",\n \"LAST_NAME\" => \"PCR\",\n \"DEPT_HIERARCHY_RECID\" => null,\n \"TENANTS_RECID\" => \"0\",\n \"EMAIL\" => \"demo@mailinator.com\"\n ],\n \"permittedGlas\" => [\n \"29\",\n \"30\",\n \"31\"\n ]\n]","type":"text"}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":5},"content":[{"text":"Debug Tab","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":786,"widthType":"pixel"},"content":[{"type":"media","attrs":{"__fileSize":31685,"__fileMimeType":"image/png","width":856,"alt":"Debug Section","id":"9e4e9db9-0645-4f4b-ab78-254f56b4e36d","collection":"contentId-498436748","type":"file","__fileName":"New_Custom_Report_Debug_Form.png","height":640}}]},{"type":"paragraph","content":[{"text":"Only data sent to the debug() function is displayed in the Debug section. Debug information only exists for 24 hours before it is automatically cleared out by the system. For more information on the debug() function, please see our article on ","type":"text"},{"text":"Syntax.","type":"text","marks":[{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/Bd8QAQ"}}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Parameters Tab","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":770,"widthType":"pixel"},"content":[{"type":"media","attrs":{"__fileSize":46514,"__fileMimeType":"image/png","width":856,"alt":"Parameters Section","id":"082d8cce-a0bd-420e-95a9-6bacb33402f3","collection":"contentId-498436748","type":"file","__fileName":"Custom_Report_Parameters_Form.png","height":640}}]},{"type":"paragraph","content":[{"text":"A User can click the [Add] button to define each Parameter for the Report.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":600,"widthType":"pixel"},"content":[{"type":"media","attrs":{"__fileSize":12572,"__fileMimeType":"image/png","width":632,"id":"6850814d-936c-4149-8c79-159bf33103a3","collection":"contentId-498436748","type":"file","__fileName":"Add_New_Build_Parameters_Form.png","height":230}}]},{"type":"paragraph","content":[{"text":"Parameters require a ","type":"text"},{"text":"Name","type":"text","marks":[{"type":"em"}]},{"text":" to be accessed within the Report Logic, as well as a ","type":"text"},{"text":"Description","type":"text","marks":[{"type":"em"}]},{"text":" to allow the User to know what they are entering. Parameters must also be defined as a specific ","type":"text"},{"text":"Input Type","type":"text","marks":[{"type":"em"}]},{"text":", much like ","type":"text"},{"text":"User-Defined Fields","type":"text","marks":[{"type":"strong"},{"type":"link","attrs":{"__confluenceMetadata":{"isRenamedTitle":true,"linkType":"page","contentTitle":"User Defined Fields","versionAtSave":"8"},"href":"https://pcr360.atlassian.net/wiki/spaces/pcr360wiki/pages/17237763"}}]},{"text":" are. Parameters can also be assigned an ","type":"text"},{"text":"Order","type":"text","marks":[{"type":"em"}]},{"text":" value to determine the order in which they are presented to be populated by the Report generator. Finally, all Parameters have a ","type":"text"},{"text":"Display ","type":"text","marks":[{"type":"em"}]},{"text":"checkbox to determine if that Parameter value will be shown in the Report's Preview.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Input Types accepted:","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph"},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Checkbox","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"This is the only type of Input that can not be defined as required, as checkboxes are either Checked or Not Checked.","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Currency","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Date","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Date/Time","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Decimal","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Drop Down","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"When a Drop-down Input is assigned, the User must define the Value and Text for each option within the Drop-down menu.","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Number","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Picker","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"When an Input is assigned to the Picker Type, the User must also define what type of Picker it is. Almost all types of Records within PCR-360 can be accessed by a Picker","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Text","type":"text"}]}]}]}]}]},{"type":"paragraph","content":[{"text":"When a User runs a Custom Report, the related Parameters will be available to be set in the panel on the left side of the screen.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":1060,"widthType":"pixel"},"content":[{"type":"media","attrs":{"__fileSize":27690,"__fileMimeType":"image/png","width":1280,"alt":"example Report","id":"72225238-09a9-43c9-b101-479ba8d83712","collection":"contentId-498436748","type":"file","__fileName":"Custom_Report_Parameters_Report_Preview_example.png","height":502}}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Template Tab","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":726,"widthType":"pixel"},"content":[{"type":"media","attrs":{"__fileSize":24407,"__fileMimeType":"image/png","width":856,"alt":"Template Section","id":"e28631c9-f92f-45af-b9f6-d9d8613d470a","collection":"contentId-498436748","type":"file","__fileName":"New_Custom_Report_Template_Form.png","height":635}}]},{"type":"paragraph","content":[{"text":"The Template Tab is where the bulk of the Report is made. The User can write HTML code here to access the information obtained in the Logic Tab, and format it into its desired finished product. A User should be familiar with HTML programming and should first read the external documentation for ","type":"text"},{"text":"Smarty","type":"text","marks":[{"type":"link","attrs":{"href":"https://smarty-php.github.io/smarty/4.x/designers/language-basic-syntax/"}}]},{"text":" and ","type":"text"},{"text":"Bootstrap 5.1","type":"text","marks":[{"type":"link","attrs":{"href":"https://getbootstrap.com/docs/4.0/getting-started/introduction/"}}]},{"text":" before attempting to develop the Template for a Report.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Options Tab","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":667,"widthType":"pixel"},"content":[{"type":"media","attrs":{"__fileSize":26520,"__fileMimeType":"image/png","width":950,"alt":"Options Section","id":"c36a9fb5-6e77-4d10-89e2-496a396cf481","collection":"contentId-498436748","type":"file","__fileName":"image-20240813-183910.png","height":712}}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"The Options Tab is used for creating the Report's Title (either a fixed Title, or generated based on information obtained when the Report was run, with a 100-character limit), as well as adding in additional Footer and other general CSS formatting. The Report's Footer is limited to 500 characters or less. A User can also define specific options for when the Report is requested as a PDF file, such as Header and Footer details. For assistance in using these PDF settings, please review the ","type":"text"},{"type":"mediaInline","attrs":{"width":237,"alt":"Snappy wkHTMLtoPDF Documentation","id":"58b4ab56-8a18-42db-9da3-a76f1b22b0cb","collection":"contentId-498436748","type":"image","height":31}},{"text":" .","type":"text"}]},{"type":"paragraph","content":[{"text":"PDF Options Example:","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"PDF Options","type":"text"}]},{"type":"codeBlock","attrs":{"language":"php"},"content":[{"text":"{\n\t\"footer-center\": \"{$pdfFooter}\",\n \"footer-right\" : \"[page]/[topage]\",\n \"footer-spacing\" : 1\n}","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Logic","type":"text"}]},{"type":"codeBlock","attrs":{"language":"php"},"content":[{"text":"$this->assign('pdfFooter', 'This is the FOOTER');","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"PDF Footer Result","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":874,"widthType":"pixel"},"content":[{"type":"media","attrs":{"__fileSize":4970,"__fileMimeType":"image/png","width":1130,"alt":"image-20240829-114951.png","id":"4dd80205-838b-46cd-a9f5-c488a7df0be2","collection":"contentId-498436748","type":"file","__fileName":"image-20240829-114951.png","height":98}}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Attachments Tab","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":681,"widthType":"pixel"},"content":[{"type":"media","attrs":{"__fileSize":19819,"__fileMimeType":"image/png","width":1147,"alt":"image-20240828-182950.png","id":"c033e986-c4fd-4799-bfa4-e0bb0adf2af5","collection":"contentId-498436748","type":"file","__fileName":"image-20240828-182950.png","height":432}}]},{"type":"paragraph"},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Before Files can be uploaded to a Custom Report, the Custom Report must first be saved.","type":"text"}]},{"type":"paragraph","content":[{"text":"Unlike other Attachment Tabs within PCR-360, files Attached to a Custom Report are uploaded to the ","type":"text"},{"text":"/media/custom/","type":"text","marks":[{"type":"textColor","attrs":{"color":"#36b37e"}}]},{"text":" directory on the Server. ","type":"text"},{"text":"This makes ALL Attachments to ANY Custom Report available to all other Custom Reports, as long as the User knows the path to the file name.","type":"text","marks":[{"type":"em"}]}]},{"type":"paragraph","content":[{"text":"Attachments can be uploaded from the User’s PC using the ","type":"text"},{"type":"mediaInline","attrs":{"width":103,"alt":"Upload File(s)","id":"a974cebd-0b4f-4962-a68d-4d05e52f4d8c","collection":"contentId-498436748","type":"image","height":23}},{"text":" button, or from among any file previously loaded onto the ","type":"text"},{"text":"/media/custom/","type":"text","marks":[{"type":"textColor","attrs":{"color":"#36b37e"}}]},{"text":" directory by using ","type":"text"},{"type":"mediaInline","attrs":{"width":142,"alt":"Attach from Directory","id":"927a7b75-9ad1-464d-bd60-e78db49dc428","collection":"contentId-498436748","type":"image","height":29}},{"text":" button.","type":"text"}]},{"type":"paragraph"},{"type":"mediaSingle","attrs":{"layout":"center","width":542,"widthType":"pixel"},"content":[{"type":"media","attrs":{"__fileSize":30501,"__fileMimeType":"image/png","width":704,"alt":"image-20240828-184032.png","id":"e1ae5a9a-e50c-458e-9647-4e0e0aa1942c","collection":"contentId-498436748","type":"file","__fileName":"image-20240828-184032.png","height":522}}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"When using ","type":"text"},{"type":"mediaInline","attrs":{"width":128,"alt":"image-20240828-183948.png","id":"3c3bf30e-1dc6-4c92-9c28-fc12a1364817","collection":"contentId-498436748","type":"image","height":26}},{"text":" Users have the option to ","type":"text"},{"text":"Attach","type":"text","marks":[{"type":"em"}]},{"text":" a file from the Server, ","type":"text"},{"text":"Download ","type":"text","marks":[{"type":"em"}]},{"text":"the file from the Server to ","type":"text"},{"text":"Delete ","type":"text","marks":[{"type":"em"}]},{"text":"the file from the Server. ","type":"text"},{"text":"When a File is Deleted from the Server, it will break any Report that is using that file","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"}]},{"type":"paragraph","content":[{"text":"Warning","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}},{"type":"strong"}]},{"text":":","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":" because all files are easily accessed using the same basic File Path, ","type":"text"},{"text":"Uploading a File with the same name as a previously uploaded File will overwrite that File on the Server","type":"text","marks":[{"type":"strong"}]},{"text":". When a Custom Report is exported, only Attachments on the Report will be exported. ","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Note: ","type":"text","marks":[{"type":"strong"}]},{"text":"It is highly recommended NOT to attach JavaScript files to Custom Reports as that can be a severe security risk","type":"text","marks":[{"type":"em"}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Batch Processing Tab","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":684,"widthType":"pixel"},"content":[{"type":"media","attrs":{"__fileSize":33389,"__fileMimeType":"image/png","width":952,"alt":"image-20241216-154315.png","id":"d007b67b-c2e4-40d1-ac01-725894ba9612","collection":"contentId-498436748","type":"file","__fileName":"image-20241216-154315.png","height":710}}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"The Batch Processing Tab displays information about Scheduled Batches, and allows a User to ","type":"text"},{"type":"mediaInline","attrs":{"width":54,"alt":"image-20241216-154354.png","id":"acb97def-3a02-40a1-9f1a-b07f745d6a57","collection":"contentId-498436748","type":"image","height":31}},{"text":" , ","type":"text"},{"type":"mediaInline","attrs":{"width":110,"alt":"Edit Selected","id":"9f3a88a4-7432-41ec-96d8-c19ad6289fe0","collection":"contentId-498436748","type":"image","height":27}},{"text":" , and ","type":"text"},{"type":"mediaInline","attrs":{"width":127,"alt":"Delete Selected","id":"46a5ba36-514e-4548-a3fa-6ec0c3a32d27","collection":"contentId-498436748","type":"image","height":30}},{"text":" Batches. For more information on the Batch Process, please see the section of this article for ","type":"text"},{"text":"Automatically creating the Report","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/pages/resumedraft.action?draftId=17236994#CustomReports-auto"}}]},{"text":".","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Updating an Existing Report","type":"text"}]},{"type":"paragraph","content":[{"text":"To edit a Custom Report, a User simply needs to select the desired Report from the Custom Reports grid and click on the [Edit Selected] button. This will open the Report and the User can change any Logic, Parameters, Options, Attachments Batches, or the Template as needed.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Importing/Exporting a Custom Report","type":"text"}]},{"type":"paragraph","content":[{"text":"For convenience, PCR-360 has built in functionality to Import and Export Custom Reports. This is particularly useful when building a report in a Test Environment, and then loading it into your Organization’s Production Environment without building the report fresh.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Exporting a Custom Report","type":"text"}]},{"type":"paragraph","content":[{"text":"To Export a Custom Report, the User must select the desired report in the ","type":"text"},{"text":"Admin > Reports > Custom Reports","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":" grid. Then the User can click on the ","type":"text"},{"type":"mediaInline","attrs":{"width":70,"alt":"image-20240904-192151.png","id":"1b906883-d084-4112-9cb2-5c0ca24d5bb6","collection":"contentId-498436748","type":"image","height":30}},{"text":" button to save a JSON Source File of the report onto their local computer.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Importing a Custom Report","type":"text"}]},{"type":"paragraph","content":[{"text":"To Import a Custom Report, the User must click on the ","type":"text"},{"type":"mediaInline","attrs":{"width":70,"alt":"image-20240904-192347.png","id":"e51c0b79-f79a-47c1-8cae-1752d0b9fb17","collection":"contentId-498436748","type":"image","height":34}},{"text":" button on the ","type":"text"},{"text":"Admin > Reports > Custom Reports","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":" grid. The User can then upload a JSON Source File from their local computer into PCR-360.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Linking a Custom Report","type":"text"}]},{"type":"paragraph","content":[{"text":"Reports can be linked to ","type":"text"},{"text":"Data-Entry forms","type":"text","marks":[{"type":"link","attrs":{"__confluenceMetadata":{"isRenamedTitle":true,"linkType":"page","contentTitle":"The Data Entry Form","versionAtSave":"9"},"href":"https://pcr360.atlassian.net/wiki/spaces/pcr360wiki/pages/17238882"}}]},{"text":" or ","type":"text"},{"text":"Data Grids","type":"text","marks":[{"type":"link","attrs":{"__confluenceMetadata":{"isRenamedTitle":true,"linkType":"page","contentTitle":"Grid Toolbar","versionAtSave":"11"},"href":"https://pcr360.atlassian.net/wiki/spaces/pcr360wiki/pages/17238915"}}]},{"text":". When opening a Custom Report that has been linked a single parameter called “recid” is passed. To process this parameter the report requires that the “recid” parameter is added to the Parameters tab in the Report Builder.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Running a Custom Report","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Back Office generating the Report","type":"text"}]},{"type":"paragraph","content":[{"text":"Back office users can generate Custom Reports from multiple places in PCR-360: Admin, the Reporting menu, CustomerCenter, Form → Reports menus, and Grid → Reports menus.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Admin: Custom Reports","type":"text"}]},{"type":"paragraph","content":[{"text":"From the Custom Reports grid Users can click on ","type":"text"},{"type":"mediaInline","attrs":{"id":"UNKNOWN_MEDIA_ID","collection":"","__fileName":"UNKNOWN_ATTACHMENT"}},{"text":" to generate a Report.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":1056,"widthType":"pixel"},"content":[{"type":"media","attrs":{"__fileSize":23580,"__fileMimeType":"image/png","width":1075,"alt":"image-20241218-042522.png","id":"52d514e3-0d0a-4a23-8f38-4d520db22bee","collection":"contentId-498436748","type":"file","__fileName":"db2f68ae-a0f2-47a3-854b-218cf4c473e6#media-blob-url=true&id=97fc70eb-a91d-4ee5-a4c2-e41df87ced29&collection=&contextId=28419&mimeType=image%2Fpng&name=image-20241218-042522.png&size=29958&width=1075&height=225&alt=image-20241218-042522.png","height":225}}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Reporting: Available Reports","type":"text"}]},{"type":"paragraph","content":[{"text":"Users can generate new Reports from the Main > Reporting > Custom Reports > Available Reports menu option. However, when accessed from the Main menu, the Grid is limited based on the logged in User's assigned Roles, based on what Reports are assigned to those Roles.","type":"text"}]},{"type":"paragraph","content":[{"text":"To view a Report, a User must select the Report from the grid and click on [View Report]. For User convenience, a User can also [Bookmark Selected] Reports to access more quickly through the PCR-360 Footer.","type":"text"}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":1029,"widthType":"pixel"},"content":[{"type":"media","attrs":{"__fileSize":24298,"__fileMimeType":"image/png","width":1861,"alt":"image-20240828-174410.png","id":"a95fe0ba-f177-49fa-ac80-30c8fa65e099","collection":"contentId-498436748","type":"file","__fileName":"image-20240828-174410.png","height":171}}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Report Preview","type":"text"}]},{"type":"paragraph","content":[{"text":"On the Report Preview page, the User must fill in any required parameters and then click on the [Open Report] button to open the report in a new tab. After entering the required parameters, a preview of the report may be run by clicking the \"Refresh\" button.","type":"text"}]},{"type":"paragraph","content":[{"text":"When a Report is run, Users can share the Report using the functions provided.","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":1190.0,"localId":"aa364356-28ff-460d-aae9-0d450bbbacf7"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[121.0]},"content":[{"type":"mediaSingle","attrs":{"layout":"align-start","width":75,"widthType":"pixel"},"content":[{"type":"media","attrs":{"__fileSize":553,"__fileMimeType":"image/png","width":69,"alt":"Copy Link","id":"3a1dd16f-ff31-4e1f-8722-5cd986b6fd0b","collection":"contentId-498436748","type":"file","__fileName":"image-2023-11-3_12-0-18.png","height":34}}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1069.0]},"content":[{"type":"paragraph","content":[{"text":"The [Copy Link] button will copy a link to the Report, including the parameters, to the User's clipboard so that they can share it as a Web URL.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[121.0]},"content":[{"type":"mediaSingle","attrs":{"layout":"align-start","width":75,"widthType":"pixel"},"content":[{"type":"media","attrs":{"__fileSize":645,"__fileMimeType":"image/png","width":82,"alt":"Save a Copy","id":"2d4f0794-edad-4c96-9318-df3b895c7325","collection":"contentId-498436748","type":"file","__fileName":"image-2023-11-3_12-0-49.png","height":40}}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1069.0]},"content":[{"type":"paragraph","content":[{"text":"The [Save a Copy] button will save the Report so that it becomes available from the ","type":"text"},{"text":"Saved Reports","type":"text","marks":[{"type":"strong"}]},{"text":" grid.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[121.0]},"content":[{"type":"mediaSingle","attrs":{"layout":"align-start","width":75,"widthType":"pixel"},"content":[{"type":"media","attrs":{"__fileSize":657,"__fileMimeType":"image/png","width":90,"alt":"Download PDF","id":"21b01234-6c62-43f1-a839-a93b86e8282d","collection":"contentId-498436748","type":"file","__fileName":"image-2023-11-3_12-1-6.png","height":38}}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1069.0]},"content":[{"type":"paragraph","content":[{"text":"The [Download PDF] button will download a PDF Copy of the Report to the User's local system.","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Saved Reports","type":"text"}]},{"type":"paragraph","content":[{"text":"Alternatively, Users can view previously saved Reports from the Main > Reporting > Custom Reports > Saved Reports menu option.","type":"text"}]},{"type":"paragraph","content":[{"text":"From this grid, the User can click on [View Report] to open the saved Report directly or click on [Delete Selected] to delete the saved Report.","type":"text"}]},{"type":"paragraph","content":[{"text":"Admin Users can also click on [Bulk Assign] to have a Report display for other Users.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":1095,"widthType":"pixel"},"content":[{"type":"media","attrs":{"__fileSize":32365,"__fileMimeType":"image/png","width":1280,"alt":"Reporting Saved Reports grid example","id":"d0d4462b-a93b-46a2-a344-437c5bf9915f","collection":"contentId-498436748","type":"file","__fileName":"image-2023-11-3_11-54-47.png","height":192}}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"CustomerCenter providing the Report","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":1222,"widthType":"pixel"},"content":[{"type":"media","attrs":{"__fileSize":30444,"__fileMimeType":"image/png","width":1280,"alt":"Custom Reports in CustomerCenter","id":"b0a79b93-0566-414d-a5a1-601d31bac386","collection":"contentId-498436748","type":"file","__fileName":"CustomerCenter_Custom_Reports_Page.png","height":317}}]},{"type":"paragraph","content":[{"text":"Custom Reports are available in ","type":"text"},{"text":"CustomerCenter","type":"text","marks":[{"type":"strong"},{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/l5EQAQ"}}]},{"text":". Just like the Main > Reporting > Custom Reports > Available Reports menu option, the page is limited based on the logged in User's assigned Roles, based on what Reports are assigned to those Roles.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Automatically running the Report","type":"text"},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"auto"},"legacyAnchorId":{"value":"id-(2024.2)CustomReports-auto"},"_parentId":{"value":"498436748"}},"macroMetadata":{"macroId":{"value":"b5d2cdaa-13e8-440b-80cd-4694f7d33316"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"3f3caf4b-ced1-45f5-9998-448432463246"}}]},{"type":"paragraph","content":[{"text":"From the Custom Reports grid, Users can open a Report, and click the ","type":"text"},{"type":"mediaInline","attrs":{"width":57,"alt":"image-20241212-154708.png","id":"79ec5f5a-93ab-4e15-9e0b-5d07dcbf8009","collection":"contentId-498436748","type":"image","height":31}},{"text":" button on the “Batch Processing” tab of that report.","type":"text"}]},{"type":"paragraph"},{"type":"mediaSingle","attrs":{"layout":"center","width":919,"widthType":"pixel"},"content":[{"type":"media","attrs":{"__fileSize":8976,"__fileMimeType":"image/png","width":919,"alt":"image-20241212-154620.png","id":"26da6dea-7eda-4230-9411-085b48b2e59b","collection":"contentId-498436748","type":"file","__fileName":"image-20241212-154620.png","height":111}}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":4},"content":[{"text":"Report Batch Process","type":"text"}]},{"type":"paragraph","content":[{"text":"The Report Batch Process allows an Admin User to apply SQL ","type":"text"},{"text":"Filters","type":"text","marks":[{"type":"em"}]},{"text":", define a ","type":"text"},{"text":"Notificatio","type":"text","marks":[{"type":"em"}]},{"text":"n Message when the Report Batch is generated, and set a specific ","type":"text"},{"text":"Schedule","type":"text","marks":[{"type":"em"}]},{"text":" for the Report to run automatically.","type":"text"}]},{"type":"layoutSection","content":[{"type":"layoutColumn","attrs":{"width":33.33},"content":[{"type":"mediaSingle","attrs":{"layout":"center","width":497,"widthType":"pixel"},"content":[{"type":"media","attrs":{"__fileSize":32501,"__fileMimeType":"image/png","width":784,"alt":"image-20241212-154322.png","id":"689e6ab3-bc4f-4460-a4d5-21f06a1f915a","collection":"contentId-498436748","type":"file","__fileName":"image-20241212-154322.png","height":723}}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"When the Batch executes, each Record from the User defined SQL Filter Query will be fed into the Report's Logic as the parameters. Each unique row of the Filter Query will generate a particular Report. The CONTACTS_RECID of each record will determine which Contacts are assigned to the individual Reports.","type":"text"}]},{"type":"paragraph"}]},{"type":"layoutColumn","attrs":{"width":33.33},"content":[{"type":"mediaSingle","attrs":{"layout":"center","width":497,"widthType":"pixel"},"content":[{"type":"media","attrs":{"__fileSize":24080,"__fileMimeType":"image/png","width":780,"alt":"image-20241212-154342.png","id":"dd113c32-071c-49a2-af20-f251fc5f807b","collection":"contentId-498436748","type":"file","__fileName":"image-20241212-154342.png","height":721}}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Users can define a custom Subject Line for an automatic notification, as well as provide a message for the Notification. Users can also opt to attach the PDF of the Report to the Notification automatically.","type":"text"}]},{"type":"paragraph"}]},{"type":"layoutColumn","attrs":{"width":33.33},"content":[{"type":"mediaSingle","attrs":{"layout":"center","width":497,"widthType":"pixel"},"content":[{"type":"media","attrs":{"__fileSize":21444,"__fileMimeType":"image/png","width":781,"alt":"image-20241212-154405.png","id":"d82b383e-1c67-4c77-a73f-ea80d5c31b80","collection":"contentId-498436748","type":"file","__fileName":"image-20241212-154405.png","height":723}}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Users can have a Batch run Immediately or set a Frequency for the Report to execute on, as well as set a date for when to run the Report next.","type":"text"}]},{"type":"paragraph","content":[{"text":"The Frequency can be set for:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Run Once","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Daily","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Weekdays","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Weekly","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Monthly","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Quarterly","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Yearly","type":"text"}]}]}]}]}]},{"type":"paragraph","content":[{"text":"Example Custom Report: Invoice","type":"text"},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"example"},"legacyAnchorId":{"value":"id-(2024.2)CustomReports-example"},"_parentId":{"value":"498436748"}},"macroMetadata":{"macroId":{"value":"fab6d9d7-5541-4cef-86ba-ffd88709fb45"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"38848c75-9e66-4a69-985c-1250cd8b6dd8"}},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"example"},"legacyAnchorId":{"value":"id-(2024.2)CustomReports-example"},"_parentId":{"value":"498436748"}},"macroMetadata":{"macroId":{"value":"0ca71176-8098-4434-852e-ed7e7528125a"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"54ea50c5-cb5b-4faf-bced-2c394da3a216"}}]},{"type":"mediaSingle","attrs":{"layout":"center","width":1132,"widthType":"pixel"},"content":[{"type":"media","attrs":{"__fileSize":41795,"__fileMimeType":"image/png","width":1120,"alt":"Sample Custom Invoice","id":"1dbd6dbf-6721-454a-94fd-f9a3f6e45db2","collection":"contentId-498436748","type":"file","__fileName":"image-2023-11-10_8-29-10.png","height":670}}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Below is an example of how Custom Reports can generate a Custom Invoice.","type":"text"}]},{"type":"paragraph","content":[{"text":"Invoice - Logic","type":"text","marks":[{"type":"strong"}]}]},{"type":"heading","attrs":{"level":5},"content":[{"text":"Invoice - Logic","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"$invoice = $this->query(<< $params['invoice']]);\n$invoice = $invoice[0];\n\n$this->assign('invoice', $invoice);\n$this->assign('fmtBillDate', (new DateTime($invoice['BILL_DATE']))->format('M y'));\n$this->assign('gla', $invoice['ACCOUNTNUMBER']);\n$this->assign('invoiceTotal', number_format($invoice['BILLED_AMOUNT'], 2));\n$this->assign('invoiceDate', (new DateTime($invoice['INVOICE_DATE']))->format('m/d/Y'));\n\n$billingAddress = $this->query(<< $invoice['GLA_RECID']]);\n$billingAddress = $billingAddress[0];\n$this->assign('billingAddress', $billingAddress);\n\n$billingContact = $this->query(<< $invoice['GLA_RECID']]);\n$billingContact = $billingContact[0];\n$this->assign('billingContact', $billingContact);\n\n$bdTableSuffix = '_' . (new DateTime($invoice['BILL_DATE']))->format('ym');\n$tableExists = $this->query(\"SHOW TABLES LIKE 'BILL_DETAILS{$bdTableSuffix}'\");\n$this->debug($tableExists);\n$bdTable = \"BILL_DETAILS\" . (empty($tableExists) ? '' : $bdTableSuffix);\n$this->debug(<<query(<< $invoice['RECID']]);\n$this->assign('billDetails', $billDetails);","type":"text"}]},{"type":"paragraph","content":[{"text":"Invoice - Parameters","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":1222,"widthType":"pixel"},"content":[{"type":"media","attrs":{"__fileSize":21920,"__fileMimeType":"image/png","width":853,"alt":"Parameters Example","id":"8b1bdf45-3db7-4455-a106-1cfc2b3fe5e7","collection":"contentId-498436748","type":"file","__fileName":"image-2023-11-3_15-25-49.png","height":256}}]},{"type":"heading","attrs":{"level":5},"content":[{"text":"Invoice - Template","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"

\n \t

0000 Nowhere Street
\n \tNowhere Village, No State 00000

\n \t

To Attention:
\n Account Number: {$gla}
\n {$billingContact.FIRST_NAME} {$billingContact.LAST_NAME}
\n {$billingAddress.STREET_ADDRESS} {$billingAddress.ADDRESS2}
\n {$billingAddress.CITY}, {$billingAddress.STATE} {$billingAddress.ZIP_CODE}\n

\n \n \n \n \n \n

Account Number:	{$gla}
Invoice Number:	{$invoice.INV_NUMBER}
Invoice Period:	{$fmtBillDate}

\n\n\n\t\n \t\n \t\t\n \t\t\n \t\n \t\n \n \n \n \n\t\n\t\n \n \n \n \n \n \n \n \n

Invoice Date

Invoice Number

Invoice Amount

{$invoiceDate}

{$params.invoice}

${$invoiceTotal}

\n \n \n \n \n \n \n \n \n \n \n \t{foreach $billDetails as $bd}\n \n \n \n \n \n \n {foreachelse}\n \n {/foreach}\n \n

Charge Code	Charge Description	Owner	Cost
{$bd.CHRG_CATALOG_NAME\|escape}	{$bd.CHRG_CATALOG_DESCRIPTION\|escape}	{$bd.DEPT_HIERARCHY_PATH\|escape}	{$bd.FMT_COST\|escape}
No Transactions Found

\n \n

Total Amount Due:

${$invoiceTotal}

\n\n\n

Please include a copy of this invoice with payment or reference this invoice # on your check.

Amount Due - Upon Receipt

Remit To: Office of the Black Voild
\n 0000 Nowhere Street, Nowhere Village, No State 00000
\n \tState ID # XXXX00000 00
\n \tFor All Billing Inquiries: 555-555-5555
\n noWhere@voidMail.com\n

","type":"text"}]},{"type":"paragraph","content":[{"text":"Invoice - Options","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":797,"widthType":"pixel"},"content":[{"type":"media","attrs":{"__fileSize":36742,"__fileMimeType":"image/png","width":951,"alt":"image-20240813-185444.png","id":"90088747-3119-494f-945e-abf42486f0ae","collection":"contentId-498436748","type":"file","__fileName":"image-20240813-185444.png","height":709}}]},{"type":"paragraph"},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"children","parameters":{"macroParams":{"_parentId":{"value":"498436748"}},"macroMetadata":{"macroId":{"value":"ee7f5c0a-5ca7-4309-bbcd-cfabae15e51f"},"schemaVersion":{"value":"2"},"title":"Child pages"}},"localId":"df9827ab-4c36-4920-b72f-3965b984c94c"}}],"version":1}

0000 Nowhere Street\n \tNowhere Village, No State 00000

Please include a copy of this invoice with payment or reference this invoice # on your check.

0000 Nowhere Street
\n \tNowhere Village, No State 00000

Browser not supported