--- schema_version: "1" id: 34a6a91c37df88722d0586c328fb5f5368d8df248688801d6602fab1be2be4a9 title: Viewing & Generating Electronic Journal (EJ) Reports collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/commerce/264-0-0/rt_cms_reports_view_generate_ej_reports.md canonical_url: https://help.salesforce.com/s/articleView?id=commerce.rt_cms_reports_view_generate_ej_reports.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: a58a27e76ffb917a7ad07c1111e2422628d64903ee68e36a4271f4d28571b583 description: Provide digital records of Point of Sale sales transactions and order details to help merchants track sales and manage inventory. Generate reports by configuring stores, date, time, and time zone to view the data. products: - Commerce release: "264" --- # Viewing & Generating Electronic Journal (EJ) Reports Provide digital records of Point of Sale sales transactions and order details to help merchants track sales and manage inventory. Generate reports by configuring stores, date, time, and time zone to view the data. ## Viewing and Generating Reports - Go to **Store Management > Electronic Journal**. - Under **Store**, multiselect the stores you want to view data‌ from. - Configure the date, time, and time zone. The maximum range is 31 days. - Under **Pinned Filters**, you can narrow your search by filtering by X additional criteria in the report. **Order number**, **transaction type**, and **tender type** are shown by default, but users can add parameters under **Additional Filters**. - To remove a field or add another pin, select the ellipses (three vertical dots) to the right. After specifying a column, you can also specify a rule along with a corresponding value. For example, if you configure "**Total Discount <= 200**," only transactions with a total discount less than or equal to 200 appear. - If you configure "**Associate ID contains 12345**," only transactions that were completed by the specified associate will show. - Select **SEARCH** to generate a report with your configured fields.![The New Report section, where you click search to generate a new report.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-commerce-retail-264-0-0-production-enus/17d647fb-8988-49fb-9add-c4f4cc79c9e4/retail/images/rt_cms_reports_generate_ej_report.png) ## Supported Transaction Types - User Activity: Login, Logout - Till Management: Create Till, Reconcile Till - Cart/Order Management: Appeasement, No Sale, Sale, Order, Mixed Cart, Return, Exchange, Suspend Sale, Void, Pickup, Offline, Sale Initiated, Sale Failed, Resume Sale, Price Correction, Reward Card, Employee Sale, Employee Return, Employee Exchange, Line Item Voids [Learn More](https://help.salesforce.com/s/articleView?id=commerce.rt_cms_reports_electronic_journal_overview.htm&release=264.0.0&type=5 "Customize filters for transaction research and record store transactions in Retail Cloud.") - Cash Activity: Paid In, Paid Out - Safe Management: Safe Float, Till Float, Expense, Miscellaneous 1, Miscellaneous 2, Bank Deposit - Store: Store Close ## Available Report Filters | Field Name | Allowed Rules | Description | | --- | --- | --- | | Amount | <= / >= | Filters records of a specified amount | | Associate | Contains/Does Not Contain | Filters records corresponding to a specified associate ID | | Bank Deposit Variance | <= / >= | Filters records of a specified bank deposit variance | | Cash | <= / >= | Filters records of a specified cash amount | | Check | <= / >= | Filters records of a specified check amount | | Credit Card | <= / >= | Filters records of a specified credit card amount | | Credit Tip Amount | <= / >= | Filters records of a specified credit tip amount | | E-Comm | <= / >= | Filters records of a specified ecommerce amount | | Finance | <= / >= | Filters records of a specified finance amount | | Gift Card | <= / >= | Filters records of a specified gift card amount | | Miscellaneous | <= / >= | Filters records of a specified miscellaneous amount (charges that aren't easily categorized or classified under specific predefined categories or accounts) | | No Receipt Return | True/False | Filters records for a completed returned order that had the original receipt or not | | Notes | Contains/Does Not Contain | Filters records for transactions of specified keywords | | This is a catchall field depending on the event type. It stores the following based on an event: |   | Bank Deposit—date of store closure the deposit is associated with (vs. Transaction Time that will record when the deposit ‌happened, which could be a later date than the store closure) | | Offline | True/False | Filters records for transactions made either online or offline | | Online Order ID | Contains/Does Not Contain | Filters records for transactions associated with the specified online order ID(s) | | Order # | Contains/Does Not Contain | Filters records for transactions associated with the specified order ID(s) | | Original Price | <= / >= | Filters records of a specified original price | | Original Tender | <= / >= | Filters records of a specified other tender amount | | PRT Receipt | N/A | Filters records for orders that have completed checkout with a receipt | | Penny Rounding | <= / >= | Filters records of a specified penny rounding amount | | Product ID | Contains/Does Not Contain | Filters product-specific events (for example price correction) by product ID mapped in Product - Field Mappings | | Reason Code | Contains/Does Not Contain | Filters records for transactions of a specified Reason Code (for example "Price Correction") | | Reason Text | Contains/Does Not Contain | Filters records for transactions of a specified Reason Code text (for example "Not for Sale") | | Register # | Contains/Does Not Contain | Filters records for transactions associated with the specified register ID(s) | | Return Order ID | contains/does not contain | Filters records for transactions associated with the specified return order ID(s) | | Store Type | contains/does not contain | Filters records of a specified store type. Supported types are Regular and Outlet | | Tax | <= / >= | Filters records of a specified tax amount | | Tax Exempt | True/False | Filters records of a specified tax exemption status | | Tax Exemption | <= / >= | Filters records of a specified tax exemption amount | | Tender Type | Contains/Does Not Contain | Filters records of specified tender types; supported types are: Cash, CreditCard, GiftCard, Check, Miscellaneous, Finance, RewardCard, Others, or All | | Total Discount | <= / >= | Filters records of a specified discount amount | | Trans # | Contains/Does Not Contain | Filters records for transactions with the given transaction ID(s). This is different from Order ID because the transaction ID is a specific financial transaction or event, while the order ID is the customer's order. | | Trans-Type | Contains/Does Not Contain | Filters records for specific transaction types, refer to Supported Transaction Types for more information | | Variance | <= / >= | Filters records of a specified variance amount | ## Saving & Sharing Reports To learn how to save and share Electronic Journal search queries, allowing quicker access, see [Saving and Sharing Electronic Journal Reports](https://help.salesforce.com/s/articleView?id=commerce.rt_cms_reports_saving_sharing_ej_reports.htm&release=264.0.0&type=5 "Track and document sales transactions in Point of Sale CMS. Include details such as the date, customer information, item description, quantity sold, and the corresponding financial amounts.").