- Getting Started 2
- R365 Support
- R365 Knowledge Base
- Logging in to the R365 App
- Troubleshoot User Login Issues
- R365 Implementation Process (Accounting and Operations)
- Using R365 2
- R365 Navigation
- Address Verification
- AskR365 Beta 1
- Keyboard Shortcuts
- Attachment Viewer
- Working with List Views
- Working With Smart Grids
- Upload File
- R365 Academy Overview
- Using Restaurant365 in Other Languages
- R365 Mobile Language Options
- How to Import Excel CSV with Leading Zeros
- Submitting a Product Idea
- Create a R365 Support Center Login
- System Requirements
- Getting Started with Accounting
- Golden Rules of Accounting
- Phase 1: Getting Started & Discovery
- Phase 2: Money In
- Phase 3: Money Out
- Phase 4: Accounting Cutover
- Accounting Cutover Process
- Phase 5: Banking
- Phase 6: Payroll
- Accounting Onboarding to Adoption
- Key Accounting Reports
- Using Monday.com
- Exporting Data from QuickBooks®
- Export Chart of Accounts List From QuickBooks® Desktop
- Export Chart of Accounts List From QuickBooks® Online
- Export Vendor List From QuickBooks® Desktop
- Export Vendor List From QuickBooks® Online
- Export Customer List From QuickBooks® Desktop
- Export Customer List From QuickBooks® Online
- Pulling Data from QuickBooks® Desktop for R365 Migration
- Pulling Data from QuickBooks® Online for R365 Migration
- Completing a Crosswalk
- Getting Started with Operations
- Golden Rules of Operations
- Using Monday.com
- Preparation for Operations
- Phase 1: Items In
- Phase 2: Item Management and Transactions
- Phase 3: Inventory
- Phase 4: Recipes
- Phase 5: Scheduling
- Phase 6: Ops Onboarding to Adoption
- Operations Reporting Essentials
- Restaurant Operational Reports List
- Key Operations Reports
- Key Labor Reports
- Restaurant Manager Training Outline
- Building Great Habits
- Advantage Migration to R365
- Frequently Asked Questions 1
- How To Videos
- Release Notes
- Administration 2
- Administration FAQ
- Audit Log
- Autonumbering
- GL Export
- GL Types
- Import Tool
- Location Groups
- Beginning Balance
- Radar Imports
- Start of Day
- Fiscal Years
- Legal Entities
- Locations
- Payment Type Accounts
- POS Mapping Tool
- Preferences 2
- System Preferences: Accounts
- System Preferences: Location Reporting Categories
- System Preferences: AP Processing Email
- System Preferences: Miscellaneous Updated
- System Preferences: Location Additional Info
- System Preferences: Payments Updated
- Adding Your Organization's Internal Support Link
- Undeposited Funds
- Outbound Emails
- Email Settings: Common Webmail Provider SMTP Settings
- Repoll DSSs
- Sales Accounts
- Setup Assistant
- Users & Security
- User Setup, Security, and Location Access
- Security & Permissions
- Security & Permissions: Overview & Security
- User Roles: R365 User Role Descriptions
- Custom User Roles
- User Permissions: Permission Reference
- User Roles
- Report Roles
- Passwords
- Auto Log Out
- Authentication (MFA)
- Audit Access
- Generating a User Access Report
- Generating a Permissions Access Report
- Generating a User's Permissions Report
- Multi-Factor Authentication Method Enrollments
- Users
- Full Access User Role
- User Preferences
- Troubleshoot User Login Issues
- Accounting User Setup
- Operations User Setup
- Workflows
- Single Sign-On (SSO)
- Accounting 8
- Accounting FAQ
- Year-End Close
- Budgets
- General Ledger
- GL Accounts
- ASC 842 Federal Accounting Mandate
- Add a New GL Account
- GL Account Record
- Parent Accounts and Child Accounts
- Restrict Access on GL Accounts
- Disable Entry on GL Accounts
- Operational Reports Categories on GL Accounts
- Location Security on GL Accounts
- Report Settings on GL Accounts
- Budget Defaults on GL Accounts
- Statistical Accounts
- GL Types
- Entering Statistical Account Data
- Default Statistical Accounts
- GL Allocation Templates Overview & Security
- GL Allocation Templates: Create and Edit a Template
- GL Allocation Templates: Use a Template
- GL Allocation Templates: Allocation Calculator
- GL Allocation Templates: Mark as '(In)Active'
- Preset Allocations Overview & Security
- Preset Allocations: Create and Edit an Allocation
- Preset Allocations: Use an Allocation
- Preset Allocations: Mark as '(In)Active'
- Inactivate or Delete GL Accounts
- Journal Entries
- Daily Sales Summary
- Review a Classic Daily Sales Summary
- Approve a Daily Sales Summary
- Mass DSS Review
- Currency Conversion for DSS Data
- Troubleshoot a Daily Sales Summary
- Missing and Out of Balance Daily Sales Summaries
- Manually Delete a DSS
- DSS Paid Outs
- Paid Out Types
- Uploading Deposits via FTP
- DSS Validation Report
- DSS GL Account Mapping Report
- DSS Mapping
- Manage Undeposited Funds
- Map Refunds
- DSS Journal Entries
- Payroll Journal Entries
- Gross Sales vs Net Sales
- GL Accounts
- Fixed Assets
- Asset Classes
- Asset Categories
- Depreciation Method Definitions
- Convention Definitions
- CIP & Active Credit Offset Accounts
- Asset Record
- Asset Status
- Asset Actions
- Related Expenses
- Creating Assets
- Potential Asset List
- Fixed Asset Depreciation Form
- Fixed Assets Reporting
- Asset Tag Printout
- Adjusting the Acquisition Cost of an Asset
- Fixed Assets FAQ
- Delete a Fixed Asset
- Accounts Payable 8
- AP Center 1
- AP Transactions
- Memorized AP Transactions
- Documents to Process 1
- Documents to Process: Supported File Types
- Documents to Process: Upload Methods
- Documents to Process: Manual Upload
- Documents to Process: Uploading Files with AP Automation
- Documents to Process: Uploading Files via FTP
- Documents to Process: How to Process Uploaded Files
- Documents to Process: Log and Errors
- Documents to Process: Mark as Archived
- Documents to Process: Comments
- AP Capture AI
- OCR Mapping in AP Capture AI
- AP Capture Pro
- Documents to Process page Updated
- AP Capture: Labels in Review OCR Mapping
- Draft Transaction Sidesheet
- Resolve Documents With Issues
- Payment Runs 1
- Payment Runs Page
- Payment Run: Payment Date
- Payment Run Statuses
- Create a Payment Run
- Payment Run: Discounts from Early Payment
- Payment Run: Creating Payments
- Payment Run: Applying Credits
- Payment Run Overview
- Printing Checks
- Manual Payment
- Check Numbering in R365
- Paying Your Credit Card Bill
- Recording American Express AMEX Charges
- Payment Run Record
- Payment Run Approvals
- AP Payment Record Updated
- System Prompting to 'Save As' for Report / Check
- Vendors 1
- Vendor Record
- Vendors Page
- 1099 Setup and Management
- Updating 1099 Vendor Type
- Vendor Merge
- Payment Terms
- Paying Vendors by ACH Updated
- Enter a Vendor Credit Issued as a Check or ACH
- Fintech Refunds
- Add a Vendor Group
- Add 1099 Historical Data to a Vendor
- Prepare a Remittance Advice for an ACH Vendor
- Invoices
- Mass Invoice Entry
- AP Credit Memo record
- AP Invoice record
- Voiding a Transaction
- Credit Expected
- Use Tax Vendors
- Unassigned Vendor – Accounts Payable
- Autopay AP Invoice
- Document Date & GL Date
- Payment Hold
- Mark as Paid
- Priority Status
- Location Groups in Accounting
- Alternate Currency Entry
- Currency Conversion Factors
- Working with Currency Conversion Factors
- Partially Pay an AP Invoice
- Imports & Automation
- R365 Payments Service 4
- Getting started with R365 Payments
- R365 Payments Vendor Enrollment
- Pay Vendors with R365 Payments
- Enable a Legal Entity for R365 Payments
- Add or Remove a Bank Account
- Add or Remove a Vendor
- Resending Failed/Unsent Payments Updated
- Scheduling a payment run
- Rescheduling Scheduled Payment Runs
- Cancelling a Scheduled Payment Run
- To and From Addresses in R365 Payments
- Payment Methods Updated
- R365 Payment Statuses Updated
- Voiding a payment with R365 Payments
- Flow of Funds
- Security and Fraud Prevention with R365 Payments
- Self-Service Onboarding and Verification
- R365 Payments: Frequently Asked Questions (FAQ) Updated
- Troubleshoot an R365 Payment That Did Not Go Through
- AP Payment v Bank Expense
- Banking
- Bank Accounts
- Bank Record
- Direct Bank Connections: Re-Authenticating Connected Bank Accounts
- Bank Account Record
- Adding a New Bank Account or Checkbook
- Direct Bank Connections Overview
- Direct Bank Connections: Connecting Bank Accounts
- Direct Bank Connections: Bank Accounts with Multi-Factor Authentication
- Update an Account Being Use in CFR
- Bank Transactions
- Bank Reconciliations
- Bank Activity Overview
- Bank Activity: Update and Match Transactions
- Direct Bank Connections: Retrieve Bank Activity
- Bank Activity: Manual Import and Export
- Bank Reconciliation
- Bank Reconciliation Report
- Reconciling Credit Cards
- Bank Rules
- Rule Vault Overview & Security
- Rule Vault: Create a Rule
- Rule Vault: Edit a Rule
- Rule Vault: Mark as '(In)Active'
- Rule Vault: Default Matching Rules
- Bank Activity Page
- Bank Activity: Create AP Payment from Bank Activity
- Uncleared Bank Transactions
- Troubleshoot Bank Rules Matching
- Unreconcile a Bank Reconciliation
- Repoll a Reconciled DSS Entry
- Bank Balance vs GL Account Balance
- Where can I see my Bank Account Balance?
- Canadian Check Format Transit Numbers
- Preparing Amex Data for a QFX Converter Resource
- BAI File Transmission
- Positive Pay Overview & Reports
- Check Printing Setup - UNITED STATES Check Format
- Check Printing Setup - CANADA Check Format
- Check Signatures
- Creating a Check Signature
- AP Payment v Bank Expense
- Record an Expense Report
- Bank Accounts
- Accounts Receivable
- Transactions
- Smart Ops 2 9
- Smart Ops FAQs
- Smart Ops: Overview
- Stand-Alone Ops: Overview
- Home (Operations)
- Task Management
- Forms
- Dashboards
- Sales & Forecasting
- Forecasting
- Forecasting Page
- Projection Models and Forecast Metrics
- Import Sales Forecast
- Adjusting Forecasts
- Review Projection Dates Page
- Customizing Projection Dates
- Publishing Forecasts
- Forecasting Settings
- Forecast Configurations Tab
- Create and Edit Forecast Configuration Groups
- Labor Forecasting by Job
- Additional Forecasting Features
- Smart Labor
- Legacy Forecasting
- Daily Sales
- Sales Tickets
- Cash
- Menu Items
- Menu Item Categories
- Forecasting
- Food 4
- Orders
- Invoices
- AP Invoices Overview & Security
- Invoices & Credit Memos
- Link a Purchase Order to an AP Invoice
- Create an Invoice
- AP Invoices: Review and Approve Invoices
- AP Invoices and Credit Memos: Split View
- AP Invoices: Alerts and Unlinked Items
- AP Invoices: Vendor Entry Instructions
- AP Credit Memos: Review and Approve a Credit Memo
- Linking Unlinked Items
- Keg Deposits
- AP Credit Memos Overview & Security
- Editing AP Transactions from the Purchased Item Record
- Create a Credit Memo
- Manage Overhead Costs
- Invoice Templates
- Inventory
- Inventory Counts Overview & Security
- Counts
- First Inventory Count
- What items are being counted on my Inventory Count Templates?
- Inventory Counts: Create and Edit an Inventory Template
- Create and Enter an Inventory Count
- Inventory Counts: Add New Items
- Review and Approve an Inventory Count
- Inventory Counts: Print Count Review Report
- Inventory Counts: Copying an Existing Inventory Template
- Inventory Counts: Using Multiple Count U of Ms
- Generate an Inventory Count Using Theo on Hand
- Inventory Transactions
- Inventory Count Variance Review
- Barcode Scanning
- Third-Party Inventory Counts
- Troubleshoot a Missing Inventory Count
- Resume Inventory Counts
- Inventory Templates
- Periodic Inventory
- Beginning Balances Inventory Count
- Transfers 4
- Waste
- Donations
- Memorized Prep Logs
- Prep Log
- Food Admin
- Item Costing
- Units of Measure
- Item Categories
- Items
- Smart Ops Items: Overview & Security
- Purchased Items
- Vendor Items
- Location Groups in Smart Ops
- Vendor Items vs. Purchased Items
- Sell Only Items (Merchandise) Sold through the POS with Recipe Costing
- Fix Duplicated Purchase Items
- Delete or Deactivate a Purchased Item Record
- Update the Measure Type on an Item Record
- Troubleshooting Item Costing Issues
- Recipes
- Item Locations
- Ingredients
- Items (Classic)
- Recipes (Classic)
- Prep Stations
- Brand-Managed Items
- Commissary
- Manager Log
- Labor 1 5
- Scheduling 5
- R365 Scheduling Quick Start Guide
- Schedule Calendar 5
- Labor Forecasting
- Suggested Hours
- Cross-Day Shifts
- Restrict Scheduling Minors
- Scheduled Now
- Manager Tools
- Labor Rules Updated
- Labor Details
- POS Employees
- Tip Automation
- Scheduling 5
- Team 1
- Jobs
- Employees 1
- Employees Page
- Employee Record 1
- New Employee Checklist
- Merge Employee Records
- Employee App Access
- Employee Master
- Inactive Employee Records
- Create Employee Records
- Assign Accrual Rules to Employees
- Employees with Multiple User Records
- Employee Update Templates
- Employees Legacy Smart Ops
- Employee Record 2024-2025 Update
- Resolve an Email Address Already in Use Error
- Employees Classic
- Responsibilities
- Departments (Labor)
- Sites
- Document Library
- Workforce 7
- R365 Payroll Processing Calendar - 2024/2025
- Workforce Payroll Process Overview
- Workforce Payroll Routine - Click and Easy
- Departments (Workforce Payroll)
- Payroll 6
- Pay Runs 5
- Net Pay Shortfalls Updated
- Payroll Audit & Troubleshooting
- Payroll Corrections Guide
- Funding and Payroll Journal Entries
- Editing DSS Labor Punches
- Paycheck Runs
- Year End Checklist
- Workers Comp
- Employees For Workforce Payroll
- Policies
- HR Support Center
- Locations
- Settings 1
- Documents
- Hire
- R365 Hire Overview
- Hire FAQ
- R365 Hire Reports
- Recruiting Module
- Hiring Process
- Recruiting Dashboard
- Jobs Listing
- Applicants Listing
- Contacting Applicants
- Message Templates
- Hiring Steps
- Post a Job
- Refreshing Jobs 2024 Update
- Prescreen Questions
- Confidential Account Name
- Share a Confidential Job
- Applicant Profile
- Location Setup
- Interview Scorecards
- Careers Page
- System Settings
- Job Templates
- Recruiting Bilingual Candidates
- Job Profile
- Job Boards
- Writing a Compelling Company Description
- Indeed Best Practices
- Departments Setup
- Populate Employee Records into Workforce
- Autopilot
- Reviewing New Applicants Page
- Remove an Applicant
- Track the Careers Page
- Access Applicant Assessments
- Write an Effective Job posting
- Using Application Forms
- View and Evaluate Assessment Scores
- Setting Benchmarks for Assesments
- R365 Hire Paychex Integration
- Onboarding Module
- R365 Hire: Onboarding Dashboard
- R365 Hire: Onboarding Checklists
- R365 Hire: Checklist Categories
- R365 Hire: Onboarding Defaults
- R365 Hire: Assign Tasks
- R365 Hire: Editing Checklists
- R365 Hire: Cloning Tasks
- R365 Hire: Onboarding Notification Settings
- R365 Hire: Creating and Uploading Onboarding Forms
- R365 Hire: Employee Custom Fields
- R365 Hire: My Info
- R365 Hire: Using E-Verify
- R365 Hire: Onboarding Record
- R365 Hire: Employees Listing
- R365 Hire: My Tasks
- R365 Hire: Account Settings
- R365 Hire: Add New Users
- R365 Hire: Using the Work Opportunity Tax Credit
- R365 Hire: Rehire Process
- R365 Hire: Add a New Employee
- R365 Hire: How to Export Employee to Payroll
- R365 Hire: E-Verify Statuses
- Troubleshoot the Tasks Tab
- Reports 2
- To Do Checklist
- P&L Comparison
- Dashboard
- Ad Hoc Reports
- My Reports
- My Reports FAQs
- My Reports Setup
- Report Subscriptions
- Vendors Reports
- Purchased and Inventory Reports
- Purchased and Inventory Reports Overview
- Above-Store Actual vs Theoretical Analysis
- Actual vs Theoretical Analysis
- AP Invoice Distribution
- COGS Allotment
- COGS Analysis by Location
- COGS Analysis by Vendor
- Contract Violations
- Inventory Variance by Location
- Item Cost Analysis by Location
- Item Cost Percent Breakout
- Item Price Change Analysis
- Item Price Verification
- Item Transfer Details
- Paid Invoice Distribution
- Payables Invoice Distribution
- Period Purchases Analysis by Vendor
- PO to Invoice Reconciliation Report
- Purchases by Vendor
- Receiving by Purchased Item
- Stock Usage
- Theoretical On Hand
- Vendor Analysis
- Waste History
- Waste Log Form
- Weighted Average
- Donations Form
- Inventory Stock Count Detail
- Food Variance Report
- P&L Report v AvT Report
- Labor Reports
- Academy Progress Report
- ADP Alternate Export
- ADP Workforce Export
- ADP WorkforceNow Temp Cost Number Export
- Daily Labor Review
- Daily Roster
- EEO Report
- Employee Certification Report
- Employee Merge Report
- Employee Separation Report
- Employee Shift Sign Off Report
- F9 Segment Descriptions
- Labor Actual vs Scheduled
- Labor Actual vs Scheduled - Detail
- Labor Actual vs Scheduled - Punch Details
- Labor Break and Split
- Labor by Employee by Job
- Labor Hour and Rate Analysis
- Labor Payroll Review
- Labor Productivity Analysis by Week
- Labor Punches
- Minimum Wage Adjustment
- Minimum Wage Adjustment - Raw Data
- Overtime Warning Report
- Paychex Flex Time Export
- Paychex Payroll Alternate Export
- Paycom Payroll TAI03 File
- PTO Balance Report
- PTO Liability Report
- Punch Audit Report
- R365 Payroll Export
- Sales and Labor Budget Chart
- Sales vs Labor
- Worked Hours Export
- Shift Availability Report
- Weekly Labor Evaluation
- Deduction Audit Report
- Demographic Audit Report
- Financial Reports
- Financial Reports Overview
- Account Balance by Location
- Account Balance by Location Export
- Account Trx Summary by Location Export
- AP Accrual
- Asset Tag Printout
- Asset Value Report
- Balance Sheet
- Balance Sheet - Layout Format
- Blackline Export
- Cash Flow
- Restaurant Financial Reports List
- Cash Flow Side by Side
- Daily Sales Report
- Extended Daily Sales
- Fiscal Calendar
- Fiscal Year Error Check
- Fixed Asset Activity - Depreciation
- Fixed Asset Activity - Disposal and Retirement
- Fixed Asset Activity - Place In Service
- Franchise Invoicing Report - Summary View
- GL Account Detail
- GL Account Detail Export
- GL Account Detail with Legal Entity
- GL Account Detail with Legal Entity Export
- Net Sales By Daypart
- Profit and Loss
- Profit and Loss - Custom Date
- Profit and Loss - Layout Format
- Profitability Report
- Transaction Detail Export
- Trial Balance
- Working Trial Balance
- GL Account Drill-Downs
- Synexus Sales Tax Export
- Spread Memorized Transaction List
- Controllable Profit and Loss Mapping Guide
- Troubleshoot an Out of Balance Balance Sheet
- Troubleshoot a P&L Report Missing Budget Data
- P&L Report v AvT Report
- Banking Reports
- Sales Reports
- Sales Reports Overview
- Avg Gross Sales by Hour
- Avg Gross Sales Ticket Count
- Forecast Report
- Forecast Download Report
- Menu Item Analysis
- Menu Price Analysis
- Product Mix
- Product Mix - Year Over Year
- Sales and Prime Cost
- Sales Payment Analysis
- Server Sales Analysis
- Weekly Sales and Labor
- Advanced Weekly Sales and Labor
- Recipe
- Customers Reports
- Operational Analysis Reports
- Cash Reconciliation Export
- Cash Sheet Export
- Cash Sheet Report
- Daily Sales and Log Entries
- DSS Status Report
- Employees vs Guest Count Chart
- Flash Report
- Flash Report - Advanced
- Guest Check Transaction Detail
- Location Comparison
- Location Sales and Reg Labor
- Location Vital Signs
- Operations Overview
- Operations Scorecard
- Sales and Labor Breakout
- Sales and Labor Productivity Report
- Weekly Log
- Weekly Review - Location
- Weekly Speed of Service Report
- Recipe and Theoretical Reports
- Workforce Reports
- Commissary Reports
- Catering Reports
- Comparable Stores
- Fiscal and Operational Calendars in Reports
- Labor Differences on Flash Report vs P&L
- Actual vs Theoretical Analysis – Troubleshooting Variances
- Troubleshoot the AP/AR Aging Report
- Year Over Year Comparison Days
- Custom Financial Reports
- Custom Financial Reports: Writer Overview and Security
- R365 Custom Financial Reports Writer: Initial Setup
- R365 Custom Financial Reports Writer: Organizational Structure
- R365 Custom Financial Reports Writer: Building Reports
- R365 Custom Financial Reports Writer: Templates
- R365 Custom Financial Report Writer: Report Rows
- R365 Custom Financial Reports Writer: Report Columns
- R365 Custom Financial Reports Writer: Creating Reports
- R365 Custom Financial Reports Writer: Combination Reports
- R365 Custom Financial Report Writer: Running Reports
- R365 Custom Financial Reports: Assigning Reports
- R365 Custom Financial Reports Writer: Report Packages
- R365 Custom Financial Report Writer: Report Groups
- R365 Custom Financial Report Writer: Reports with Multiple Fiscal Year Structures
- R365 Custom Financial Reports Writer: Report Viewer
- Custom Financial Reports page
- Duplicate a CFR report
- Financial Dashboard
- Workforce Reports 2
- Unverified TIN Report
- W-2 Detail Report
- Unpayable Employees Report
- Payroll by Pay Period & Payroll by Pay Date Reports
- Employee Census
- Benefits and Deductions Report
- Payroll Accrual Report
- Garnishment Remittance Report
- Negative Balances Report
- Returned Payments
- Workers' Compensation Report
- I-9 Report
- Workforce: Paystubs Updated
- Funding Page & Funding Details Report Updated
- Form 8027
- R365 Mobile
- Upload Files via the R365 Red App
- R365 Mobile FAQ
- R365 Mobile App
- Announcements
- Accounts Payable (Mobile)
- Daily Sales
- Food
- Logbook
- Scheduling
- My Pay
- My Tasks
- Forms
- Notifications
- R365 Messaging
- Mobile Intelligence
- R365 Intelligence 3 1
- R365 Intelligence: Overview & Security
- R365 Intelligence FAQ
- Install the R365 Intelligence Excel Plug In
- Excel Plug-in Beta
- R365 Intelligence Glossary Updated
- Dashboards 2
- R365 Intelligence: Dashboard Views
- R365 Intelligence: Creating a Dashboard
- R365 Intelligence: Editing Dashboards
- R365 Intelligence: Report Drill Downs
- R365 Intelligence: Duplicating Dashboards
- R365 Intelligence: Dashboard Action Menu
- R365 Intelligence: Sharing Dashboards Updated
- R365 Intelligence: R365 Dashboard Masters
- R365 Intelligence: Purchasing & Receiving Dashboard Master
- R365 Intelligence: PMIX Dashboard Master
- R365 Intelligence: Sales Dashboard Master
- R365 Intelligence: Labor Dashboard Master
- R365 Intelligence: Intraday Dashboard Master
- R365 Intelligence Dashboard Subscriptions Updated
- Visualizations
- R365 Intelligence: Editing Visualizations
- R365 Intelligence: Adding Data by Existing Objects
- R365 Intelligence: Visualization Types
- R365 Intelligence: Attributes v. Metrics
- R365 Intelligence: Creating Attributes
- R365 Intelligence: Creating Metrics
- R365 Intelligence: Using Filters
- R365 Intelligence: Creating Element Groups
- R365 Intelligence: Adding Thresholds to Visualizations
- R365 Intelligence: Formatting a Visualization
- R365 Intelligence: Importing New Data
- Integrations 19
- POS Integration
- POS Integration Overview
- POS Integrations List
- Intraday Polling
- Schedule Writeback
- POS Menu Item Modifier Management
- Setting up POS Menu Item Modifier Management
- POS Integration Whitelisted URLs & IP Addresses
- Change POS Systems
- POS Integration Settings
- Using the R365 Connect Installer
- Completing the POS integration import template
- POS Data Export – File Guide
- POS New Build Request Form
- Vendor Integrations
- FTP Site
- R365 API
- Integrations page 18
- NDCP Integration 4
- Supplyit Integration Beta 3
- QuickBooks 10
- QuickBooks Online Integration Beta
- Data Push to QBO Beta
- Manage the QuickBooks Online Integration Beta
- Connecting Multiple QBO Instances to R365 Beta
- Manage QuickBooks GL Account Mapping Beta
- Manage QuickBooks Vendor Mapping Beta
- Manage QuickBooks Item Mapping Beta
- Manage QuickBooks Location Mapping Beta
- Manage QuickBooks POS Mapping Beta
- QuickBooks Mapping Screen Beta
- Smart Safe Integration
- PAR Brink POS Integration
- Ben Admin Integrations 1
- Payroll Integrations
- POS Integration
- APS Payroll 3
- APS 2025 Processing Calendar
- General
- APS Payroll Overview
- APS Payroll: Single Sign On
- Updating a User Record and Password
- User Setup for Payroll
- Print and Void Prepay Checks
- Admin Console
- Employee eSELFSERVE
- Manager eSELFSERVE
- APS Payroll: GL Account Mapping
- APS Payroll: Departments and Department Groups
- APS Payroll: Cross-Platform Mapping
- APS Payroll: Payroll Journal Entry Import
- Tracking Work Opportunity Tax Credit (WOTC)
- APS Payroll: Incomes Explained
- APS Payroll: How to Approve Incomes and Deductions
- APS Payroll: Deductions Explained
- Payroll - Contact Us
- APS Payroll: Check Void Requests
- APS Payroll: eSelfServe Two-Factor Authentication (2FA)
- Employee Console
- Payroll Console
- Human Resources Console
- Payroll Reporting Console
- APS Year End 3
- Year-End Procedures (APS Payroll)
- Final Payroll Submission Dates 2024 (APS Payroll) Updated
- Tax Form Deadlines (APS Payroll) Updated
- APS Common W-2 Adjustments
- Year-End Dashboard (APS Payroll)
- Year-End FAQ (APS Payroll) Updated
- Tax Form Edits and Distribution (APS Payroll)
- Import Box 12 Health Amounts (APS Payroll)
- Paperless W2s (APS Payroll)
- Print & Ship W2s (APS Payroll)
- Year-End ACA Reporting (APS Payroll)
- ExpandShare
- ExpandShare FAQ
- ExpandShare User Quick-Start Guide
- ExpandShare Product Updates 2021-2024
- Using ExpandShare
- Home (ExpandShare)
- Training
- Checklist
- Library
- Location
- Admin (ExpandShare)
- Company
- Training (Admin)
- Training Assets
- Create Trainer and Self Checks
- Add a YouTube Video to a Course
- Add Images to a Course
- Quiz Grading
- Create Screen Capture Videos
- Upload PowerPoint Files (PPTX, PPT)
- Add Text to a Course
- Create a Simple Voiceover
- Add Videos to a Course
- Add Questions to a Course
- Course Builder Best Practices
- Course Builder
- Course Builder Modules
- Learning Tracks
- Assignments
- Automations
- Marketplace
- Training Assets
- Checklists (Admin)
- Knowledge Base
- ExpandShare Integrations
- Channel Partners
- Other 1
- Print
- Share
- DarkLight
- PDF
R365 Custom Financial Report Writer: Report Rows
- Updated on 04 Jul 2024
- 14 Minutes to read
- Print
- Share
- DarkLight
- PDF
This article is part of the R365 Financial Report Writer training on Building Reports. Click here for more information on Building Reports and click here for more information on R365 Financial Report Writer.
Default Row Layouts
The Default Templates that are included with the R365 Financial Report Writer contain various Row Layouts that are an excellent starting point to include each range of GL Accounts that exist in your General Ledger. You cannot modify these Row Layouts, but you can select them, then Save them as new Layouts. To select a Default Row Layout, click in the Row Layouts selector and chose one of the existing layouts.
Create New Row Layouts
After selecting a Default Row Layout, you can make any desired modifications to it, then click on the menu and select 'Save As New'. The 'Save' option is grayed out for Default Row Layouts, but will be available on any Row Layouts that you have manually created. Default Layouts cannot be deleted.
Once you have created your Custom Row Layout, you'll be prompted if you want to save the New Row Layout to the Current Report Template. Click 'Yes' to save and assign the Row Layout to your Template.
Custom Row Layout Actions
Lock - Enables a Row Layout to be locked and not editable by other Users. A layout can be unlocked by clicking the lock icon
Edit - Enables the selected Row Layout to be edited
Delete - This will delete the selected Row Layout. If the Row Layout is saved to any Templates (including the Current Template), the Delete iconwill be grayed out and unclickable.
Save - This will save the selected Row Layout
Column Sizing - The density of the row size. The options include 'Large', 'Comfortable', and 'Compact' (default)
Shared with all instances - This marks this layout as shared across all instances. Any edits made to this layout will then update across instances
Only Channel Partners will have access to this feature
Change Row Layout Name
If you need to change the Name of the Custom Row Layout, click the Editbutton, to open the 'Rename Row Layout' prompt and make the change and save.
Delete Custom Row Layout
To Delete a Row Layout, it must first be unassigned from all Templates where it is currently saved. Hover over the Deleteicon to view a tooltip that lists all Templates that are currently using this Row Layout:
Next, open the Template that was listed in the tooltip (if it is not the Current Template you are working on) and click on the Row Layout Selector:
Choose a different Layout, then click on the Save menu and select 'Save'. You will be prompted if you want to save the New Row Layout to the Current Report Template. Click 'Yes' to save and assign the Row Layout to your Template, thereby removing the Custom Row Layout from the Template and making it available to be deleted. Repeat this process for any other Templates that are utilizing the Custom Row Layout.
Once all required Templates are unassigned from the Custom Row Layout, select the Custom Row Layout on any Template. The Delete icon is now solid and clickable as shown below:
Click 'Delete' to delete the Custom Row layout.
Change Row Layout & Create a Copy of a Row Layout
Use the 'Save' option to save your Custom Row Layout, or to select and assign a different Row Layout. Select 'Save As New' to save a new version of the current Row Layout. You will be prompted to enter a name for the new Row Layout.
Close the Row Editor without Saving
If you click out of the Row Editor after having made any changes, the Save Options prompt will automatically appear to confirm that you want to close the Row Editor. The options include the following:
Return to Editor - Do not close the Row Editor and continue working
Discard Changes - Close the Row Editor and discard any changes that were made
Save - Save the Changes you made to the Row Layout (grayed out for Default Row Layouts) and close the Row Editor
Save As New- Save the Changes you made to the Row Layout as a New Row Layout and close the Row Editor. When selected the 'Save Row Layout' prompt will load and the Row Layout name must be entered to save
Row Layout Usage
Row Layouts list a number next to them to signify the number of templates that use the layout, which can help determine the layouts that have the highest and lowest impacts.
Hovering over the template icon will display the template names that use this layout, and the Shared iconwill be displayed when the Column Layout has been shared across instances.
Sharing Column Layouts is only available to Channel Partner Users.
Row Formatting
The R365 Financial Report Writer allows you to add custom formatting to each row on your Custom Financial Reports. Formatting Tools are located at the top of the row editing area and include the following options:
Bold
Italics
Underline
Font Size
Font Color
Fill Color
Border
Autofit
Height
Copy Format
Paste Format
Decrease Indentation
Increase Indentation
Show (Show/Hide Symbols ($, %) for the selected rows)
To modify the format of a row, first check the box of the row and then make the changes on the Formatting Tool.
You can select several rows at once to make formatting changes to all selected rows.
Each formatting change (as well as any other changes that are made to the rows) will be displayed in the Preview Pane immediately to the right of the Rows Editor, as shown below:
Multi-Select Actions
In addition to performing mass formatting edits as described above, when you select more than one row, you can perform the following actions:
Cut - Creates copies of the selected rows, which can be pasted elsewhere
Copy - Creates copies of the selected rows
Flip - Flips the sign on the selected rows when displaying on Reports (Positive vs. Negative). Typically rows that contain GL Accounts that belong to the following GL Types will necessitate a flip to the Negative ( - ) sign:
Current Liability
Equity
Long Term Liability
Sales
Hide - Hides the selected rows when viewing the Report. This is particularly useful for rows that contain Calculations that do not need to be seen on the actual Report
Delete - Deletes the selected rows and removes them from the Template
% Of Row- Updates the '% Of' entries for the selected rows
This will only be listed for P&L and Combination Reports
Row Type- Updates the 'Row Type' entries for the selected rows
This will only be listed for Combination Reports
Row Fields & Options
Description - Enter the description, or display name, for this row as it will appear when running Reports. To create a section header in your report, simply enter a description without adding an account or calculation. Remember to use the Formatting Tools to set your row indentations as desired
Account - Select the Account that will be displayed in this row. You can search for Accounts by name or number. You can select multiple Accounts or a range of Accounts. Refer to the 'Row Accounts' section below for more information
Note: For the P&L Templates only, Stat Accounts are included in this drop-down listing, and when selected, the value of this row will be determined by the selected Stat Account Type field on the Stat Account record
Calculation - The Calculation Field allows you to perform addition, subtraction, and division calculations using other rows or GL Types on rows that do not have an Account assigned to them. Refer to the 'Row Calculations' section below for more information
% of Row - This field only appears on the 'P&L' and 'P&L Date Range' Report Types. It allows the User to set a '% of Row' reference, where the current row will be displayed as a percent of the row selected in this field. The '%' Column can be disabled in Column Editor as needed
Note: The option to 'Hide %' can also be selected from this field
Options - This column lists the following row options:
- Click the Flip Sign icon to change the sign on this row to negative ( - ). Once flipped, the icon will appear with a slash through it
- Click the Hide icon to hide the row when running Reports. Once hidden, the icon will appear with a slash through it
- Click the Org Unit icon to filter and return the row's data for specific Org Unit(s). These can be chosen in the 'Org Type' and 'Org Values' drop-down selectors that appear when this icon is clicked on a selected row, as shown below
This is not available on rows that belong to a Dynamic Row Group
Move Row - Click on the Moveicon to move any row by dragging it to a new row ordering. When moving rows, any calculations on those rows will be updated to reflect the new row ordering of the moved row
Row Context Menu - In addition to moving rows, you can also click the Arrowicon to open the Row Context Menu and (1) insert a row above the current row, (2) insert a page break above the current row, (3) copy the current row, (4) cut the current row, (5) paste a previously copied or cut row above another row, or (6) delete the row from the Row Layout
Add Row- Below the final row in your Row Layout is the Plusicon. Click this button to add an additional row to your Row Layout
Row Accounts
Accounts can be added to each row using the following methods:
Individual - Search for the Account name or number, then click (or hit your 'Enter' key) to select it. Hit the 'Enter' key again or click off the row to complete the Account lookup. Hit the 'Esc' key to close without saving
Multiple - Search for the Account name or number, then click (or hit your 'Enter' key) to select it. Next type a comma to enable 'Multiple'. Proceed to search for the subsequent Account name or number, then click (or hit your 'Enter' key) to select it. To add another Account, continue the process of typing commas after each Account. When you have selected the final Account, hit the 'Enter' key again, or click off the row, to complete the Account lookup. Hit the 'Esc' key to close without saving
Range - Search for the Account name or number that will be first in the Range, then click (or hit your 'Enter' key) to select it. Next type a colon ( : ) to enable 'Range'. Proceed to search for the Account name or number that will be the final in the Range, then click (or hit your 'Enter' key) to select it. Hit the 'Enter' key again or click off the row to complete the Account lookup. Hit the 'Esc' key to close without saving
Row Calculations
Row Calculations are only available on rows where an Account has not been assigned (by any method). Create a calculation by selecting a row that has a blank 'Account' field, then entering the calculation formula in the 'Calculation' field. Formulas use the row number of each row to perform their calculations.
Row numbers are updated dynamically in calculations to ensure that the calculation remains true. If a row that is part of a calculation is moved or another row is inserted before it, the respective row number in any calculations will be updated accordingly.
To create the calculations, begin typing in any of the following row identifiers: Row #, Row GL Account #, Row Description. The row lookup will display all possible results, where you must then click on one of the values to select it. You will know you successfully selected a row for your calculation once the value used for searching changes to 'R##' as shown below:
The following types of calculations are supported:
Addition - Begin typing the row number that you will start with in your formula. The row lookup will appear where you can see all rows that contain the row number you typed. In addition to the row number, you will also see the row description. Select the desired row and the value will change to 'R##'. Next type the plus sign ( + ). Continue by typing the next row number that will be added to the first. Continue this process until your addition formula is complete, then hit the 'Enter' key again or click off the row to complete the calculation formula. Hit the 'Esc' key to close without saving
Subtraction - Begin typing the row number that you will start with in your formula. The row lookup will appear where you can see all rows that contain the row number you typed. In addition to the row number, you will also see the row description. Select the desired row and the value will change to 'R##'. Next type the minus sign ( - ). Continue by typing the next row number that will be subtracted from the first. Continue this process until your subtraction formula is complete, then hit the 'Enter' key again or click off the row to complete the calculation formula. Hit the 'Esc' key to close without saving
Division - Begin typing the row number that you will start with in your formula. The row lookup will appear where you can see all rows that contain the row number you typed. In addition to the row number, you will also see the row description. Select the desired row and the value will change to 'R##'. Next type the divide sign ( / ). Continue by typing the next row number that will be divided into the first. Continue this process until your division formula is complete, then hit the 'Enter' key again or click off the row to complete the calculation formula. Hit the 'Esc' key to close without saving
Complex & Order of Operations - Calculations are not limited to a single type but can be used with all three calculation types. Additionally you may utilize parenthesis to employ order of operations functions within your calculations as needed
Range Calculations - Ranges can be used in the various calculation types by using the colon ':' to represent a specific range of rows
Dynamic Row Groups
Dynamic Row Groups can be added from the Calculation Field. They allow groups of Account Rows based on GL Type to be added and maintained all at once. To view all of the options as they pertain to the different Row Groups, enter the entire Section Header name into the Calculation field and then select the desired option from its listing.
GL Type Row Groups
The Row Calculations field includes three GL Type options that allow rows to be built in a dynamic fashion but not hard-coded to specific GL Accounts. This enables newly-created accounts to be automatically included in a Dynamic Custom Row Layout for all Users and Row Layouts to be shared across instances that have different Chart of Accounts for Partner Channel Users. These Options include:
GL Type Total - A row that represents the GL Type Total
GL Type w/ Summary - A row with the GL Type as a Description Row and then an indented list of all Parent GL Accounts with the totals of all their Children GL Accounts
GL Type w/ Detail - A row with the GL Type as a Description Row and then indented Parent GL Account Description Rows with their indented Children GL Accounts and their totals. A Subtotal Row at the end of that GL Type section will display the sum of all totals for the rows within that section
When a Dynamic Row Group has been selected, restrictions will be put into place for individual rows:
Rows that are tied together by a Parent GL Account can only be edited as a group rather as individual rows
Rows will not contain a Row Context Menu for additional actions
Rows cannot be added or deleted within a Dynamic Row Group
'Other' Row Groups
Additional options are included in the calculation column under the 'Other' Row Group. The listed options are only available for certain report types.
Net Income - This is only available on Balance Sheet and Combination Report Types. This value returns the Net Income for the Column's Time Frame
Number of Full Periods - This is only available on P&L and Combination Report Types. This value returns the number of Full Periods included in each Column's Time Frame. This value can be used in combination with other calculation values such as dividing rows by the number of Full Periods to get a Monthly Average
Example: A YTD column based on Calendar Months that is ran on July 1st will return a value of 6
Number of Weeks - This is only available on P&L and Combination Report Types. This value returns the number of weeks that each Location was open. This value can be used in combination with other calculation values to compare Sales across weeks
If the column represents multiple Locations, the total number of weeks for each Location will then be added together
YTD Income - This is only available on Combination Report Types. This value returns the Year to Date Income