- 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 Reports Writer: Report Columns
- Updated on 16 Jul 2024
- 20 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 Column Layouts
The Default Templates that are included with the R365 Financial Report Writer contain various Column Layouts that are an excellent starting point to mimic common Column Layouts in other R365 reports. You cannot modify these Column Layouts, but you can select them, then Save them as new Layouts. To select a Default Column Layout, click in the Column Layout selector and chose one of the existing layouts.
Trial Balance Type Template does not allow the modification of the Column Layout
Create New Column Layouts
After selecting a Default Column 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 Column Layouts, but will be available on any Column Layouts that you have manually created. Default Layouts cannot be deleted.
Once you click 'Save As New', the 'Save Column Layout' prompt will appear where you must enter the name of the Custom Column Layout:
If you are working on a Default Template, once you save the Custom Column Layout, you will also be prompted if you want to save the New Column Layout to a New Template. Click 'Yes' to create a New Template and assign the Column Layout to the Template.
If you are working on non-default Template, and you select a Column Layout that is different than the layout that has previously been saved on your Template, you will be prompted if you would like to assign the Column Layout to the Template.
Custom Column Layout Actions
Lock - Enables a Column Layout to be locked and not editable by other Users. A layout can be unlocked by reclicking the lock icon
Edit - Enables the selected Column Layout to be edited
Delete - This will delete the selected Column Layout. If the Column Layout is saved to any Templates (including the Current Template), the Delete iconwill be grayed out and unclickable.
Save - This will save the selected Column Layout
Column Sizing -The density of the column size. The options include 'Large' (default) and 'Comfortable'
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 Partner Channel Users will have access to this feature
Change Column Layout Name
If you need to change the Name of the Custom Column Layout, click the Editbutton, to open the 'Rename Column Layout' prompt and make the change and save.
Delete Custom Column Layout
To Delete a Column 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 Column 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 Column 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 Column Layout to the Current Report Template. Click 'Yes' to save and assign the Column Layout to your Template, thereby removing the Custom Column Layout from the Template and making it available to be deleted. Repeat this process for any other Templates that are utilizing the Custom Column Layout.
Once all required Templates are unassigned from the Custom Column Layout, select the Custom Column Layout on any Template. The Delete icon is now solid and clickable as shown below:
Click 'Delete' to delete the Custom Column layout.
Change Column Layout & Create a Copy of a Column Layout
Use the 'Save' option to save your Custom Column Layout, or to select and assign a different Column Layout. Select 'Save As New' to save a new version of the current Column Layout. You will be prompted to enter a name for the new Column Layout.
Close the Column Editor without Saving
If you click out of the Column Editor after having made any changes, the Save Options prompt will automatically appear to confirm that you want to close the Column Editor. The options include the following:
Return to Editor - Do not close the Column Editor and continue working
Discard Changes - Close the Column Editor and discard any changes that were made
Save - Save the changes you made to the Column Layout (grayed out for Default Column Layouts) and close the Column Editor
Save As New - Save the Changes you made to the Column Layout as a New Column Layout and close the Column Editor. When selected, the 'Save Column Layout' prompt will load and the Column Layout name must be entered to save
Column Layout Usage
Column 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 the 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.
Column Formatting
The R365 Financial Report Writer allows you to add custom formatting to each Column Header, the Data in the Column, and the optional '%' Column on your Custom Financial Reports. Formatting Tools are located at the top of the Column Editor and appear when you click into any of the 'Header' areas on a column. Each type that can be formatted has a separate set of formatting tools. By default, the 'Data' tools will be selected. You can switch between each formatting option using the buttons above the tools, as shown below:
Header Formatting Tools - Select the tools for editing the format of the Column Headers. These tools are described below
Data Formatting Tools - Select the tools for editing the format of the data in the columns. These tools are described below
% Column Formatting Tools - Select the tools for editing the format of the optional '%' column. These tools are described below
Copy Format - Copy the format on the selected Column Header/Data/%. Is used in conjunction with Paste Format (#5)
Paste Format - After copying the format (#4), this button is enabled and allows you to select another column and paste the copied format to the Header/Data/%
Header Formatting Tools
Bold
Italics
Font Size
7 pt
8 pt
10 pt
12 pt
Font Color
Fill Color
Border
Data Formatting Tools
Bold
Italics
Font Size
7 pt
8 pt
10 pt
12 pt
Font Color
Fill Color
Border
Width
Number Format
$
%
Number Only
Rounding
0
.0
.00
% Formatting Tools
Bold
Italics
Font Size
7 pt
8 pt
10 pt
12 pt
Font Color
Fill Color
Border
Width
Rounding
0
.0
.00
To modify the format of a column, first check the box of that column, then make the changes on the Formatting Tools.
You can select several columns at once to make formatting changes to all selected columns.
Finally, you can check all columns by checking the 'All Cols' checkbox.
Columns that use the repeat function require the use of the 'All Cols' checkbox as all repeat columns must have identical formatting.
Each formatting change (as well as any other changes that are made to the columns) will be displayed in the preview pane immediately below the Column Editor, as shown below:
Multi-Select Actions
In addition to performing mass formatting edits as described above, when you select more than one column, you can perform the following actions:
Copy - Create copies of the selected columns
Delete - Delete the columns and remove it from the Template
Column Headers
The R365 Financial Report Writer supports up to three distinct levels of Column Headers. When using either the 'Financial' or 'Budget' column types, Column Header 1 will be required. Column Header 2 and Column Header 3 are optional. Header 1 is the lowest header (closest to the data) when more than one Header is in use. Headers can contain the following value types:
Text Description - Manually entered text that is set by the User
Dynamic Header- Dynamically set header value based on a selection (Time Frame, Date Range, or Organization Values). Dynamic Headers are updated at the time the Report is ran to reflect the report parameters
Dynamic headers are only available on 'Financial' or 'Budget' column types
Header 2 and Header 3 can also be used to span across several columns at once, allowing you to group the columns under a common Header. This is accomplished by hovering over the edge of column, then clicking and dragging the header to encompass the other headers, as shown below:
Add and Remove Additional Headers
Click the plusicons to add an additional header. Click the icon to remove the additional header.
Dynamic Headers
Dynamic Headers are only available on 'Financial' or 'Budget' column types and allow a dynamically set value to become the description of the column header at the time when the Report is ran. The options for Dynamic Headers will vary depending on the report type, if a repeat is set on the column, and the Location Reporting Categories that you have setup in your R365 Database (please refer to the Organization Structure article for more information).
Dynamic Headers can be entered on their own or combined with free text. To use a Dynamic Header, simply enter '@' and then select the desired option from the drop-down listing. The available options are dependent upon the selected Report Type. Select the desired Dynamic Header to include in that column. Options include the following:
Org Value - The Organization Structure Unit Value the Report was ran for
Org No. - The Organization Structure Unit Number the Report was ran for
Org No. + Org Value - A combination of the Organization Structure Unit Number and Value the Report was ran for
Time Frame Type- The value set in the 'TF Type' Field. When a CFR report is based on a Time Frame Type, Time Frame Fields in the Template columns are not customizable. All columns will use the date range selected.
Time Frame Types are only applicable when the Column is non-repeating. Options include:Day (available for Financial Column Types only)
Week
Period
Quarter
Year
Week to Date
Period to Date
Quarter to Date
Year to Date
Time Frame Types that are 'to Date' reflect the Report Date selected in the Report Settings
YTD Cols by Quarter
YTD Cols by Quarter w/Ttl
YTD Cols by Period
YTD Cols by Period w/Ttl
YTD Cols by Week
YTD Cols by Week w/Ttl
QTD Cols by Period
QTD Cols by Period w/Ttl
QTD Cols by Week
QTD Cols by Week w/Ttl
PTD Cols by Week
PTD Cols by Week w/Ttl
PTD Cols by Day
PTD Cols by Day w/Ttl
WTD Cols by Day
WTD Cols by Day w/Ttl
The YTD, QTD, PTD, and WTD Cols options listed will display the data for the time frame to date and not just the time frame, if selected. These columns are not valid in calculations, and they do not apply to P&L Custom Date or Trial Balance templates
TF Type + TF Value - The Time Frame Type that is set on the repeat (same options listed above) combined with the value of the Time Frame Type, i.e., 'Week 42'
TF Type + TF Value + Year - The Time Frame Type that is set on the repeat (same options listed above) combined with the value of the Time Frame Type, combined with the Year, i.e., 'Period 9 2019'
Ending Date (date) - The end date of the selected Time Frame written as 'MM/DD/YYYY'; for example, 04/01/2020
Ending Date (text) - The end date of the selected Time Frame written as 'Month DD, YYYY'; for example, April 1, 2020
TF + Ending + EndDate (date) - The Time Frame Type + 'Ending' + the last date in the selected Time Frame Type written as 'MM/DD/YYYY'; for example 'Period Ending 03/31/2020'
TF + Ending + EndDate (text) - The Time Frame Type + 'Ending' + the last date in the selected Time Frame Type written as 'Month DD, YYYY'; for example 'Period Ending March 31,2020'
Start Date - End Date (date) - The date range listed as 'MM/DD/YYYY - MM/DD/YYYY'; for example, '04/01/2020-04/30/2020'
Start Date - End Date (text) - The date range listed as 'Month DD, YYYY - Month DD, YYYY'; for example, 'April 1, 2020-April 30, 2020'
No. of Full Periods - The number of months of data that are represented in this column
Client Name- The name of the Client assigned to the Org Unit. If the Report or Column represents one or more Locations, one of the following variables will populate the Column Header:
Client Name - This will display if all Locations have the same Client assigned to them
Multiple Clients - This will display if the Locations have different Clients assigned to them
Client Missing- This will display if none or at least one Location have Clients assigned to them
Only Partner Channel Users have access to Client records. Click here to learn more about Client Records
Column Fields
Header 2 - Click the plus icon to add Header 2. After doing so, you'll also have the opportunity to create Header 3 as needed. Both Header 2 and 3 have Repeat options, Formatting, Dynamic Header options, and Column Merging / Grouping capabilities
All Cols Checkbox - All Columns Checkbox. Check this box to check all Columns for mass formatting
Description - Enter the manual Text Description, select to use a Dynamic Header to add a Description to the Column Header, or use a combination of Text and Dynamic Header (initiate using '@')
Col Type - Column Type. Select the Column Type for this Column. Options include:
Financial - A financial value will be displayed in the column where applicable (based on the Row Layout of the report). This can be used in conjunction with Dynamic Headers
Budget - A Budget value will be displayed in the column where applicable (based on the Row Layout of the report). This can be used in conjunction with Dynamic Headers
Calculation - The results of a calculation formula will be displayed in this column. Calculations will be described below. No Header is required for this Column Type
Better / Worse Var.- A variance column that shows good increases as positive and bad increases as negative
Column Type will appear only on P&L Templates
% Column Var.- A Better / Worse Variance that is subtracting the %'s of 2 columns
This Column Type will appear only on P&L Templates
Blank - A blank column will be displayed. This can be used for visually breaking up your data. No Header is required for this Column Type
Row Description - The Row Description (which is displayed at the far left of the Report) will be displayed again. This can be used for lengthy reports that have numerous columns to assist in tracking back data values to Row Descriptions. No Header is required for this Column Type
Vertical Line - A Vertical Line will be displayed. This can be used for visually breaking up your data. No Header is required for this Column Type
Calculation - Used in conjunction with the 'Calculation' Column Type. Enter a Calculation formula to display the results of the Calculation in this Column
TF Type - Time Frame Type. When a CFR report is based on a Time Frame Type, Time Frame Fields in the Template columns are not customizable. All columns will use the date range selected. This field is only applicable when the Column is non-repeating and allows the User to set a specific Time Frame Type on the Column. Options include:
Day (available for Financial Column Types only)
Week
Period
Quarter
Year
Week to Date
Period to Date
Quarter to Date
Year to Date
Time Frame Types that are 'to Date' reflect the Report Date selected in the Report Settings
YTD Cols by Quarter
YTD Cols by Quarter w/Ttl
YTD Cols by Period
YTD Cols by Period w/Ttl
YTD Cols by Week
YTD Cols by Week w/Ttl
QTD Cols by Period
QTD Cols by Period w/Ttl
QTD Cols by Week
QTD Cols by Week w/Ttl
PTD Cols by Week
PTD Cols by Week w/Ttl
PTD Cols by Day
PTD Cols by Day w/Ttl
WTD Cols by Day
WTD Cols by Day w/Ttl
The YTD, QTD, PTD, and WTD Cols options listed will display the data for the time frame to date and not just the time frame, if selected. These columns are not valid in calculations, and they do not apply to P&L Custom Date or Trial Balance templates
Time Frame - Used in conjunction with the 'TF Type' setting, allows the User to select a previous (or specific) Time Frame based on the 'TF Type' setting, i.e., TF Type = 'Period', Time Frame = 'Prior'. When 'Specific' is selected, an additional field appears where the User must set the Specific Time Frame desired
Year - Only used in conjunction with 'TF Type' = 'Period' and 'Time Frame' = 'Specific'. Allows the User to select a previous (or specific) Year. This option is rarely used
Org Type - Used to set a specific Org Type value on the column. The Org Values are then set in the next field. This option is rarely used
'Concept', 'District' and 'Region' represent Location Reporting Categories that were created in the R365 Database used in creating these screenshots. Your specific Location Reporting Categories will be listed here
Org Values - Used in conjunction with the 'Org Type' field. Allows the User to select which Org Values from the selected 'Org Type' to include in the Column
'Legal Entity' is selected in the 'Org Type'; therefore, the Legal Entities for the R365 Database used to create these screenshots are displayed below. Your specific Legal Entities will be listed here.
Include % - Click the percenticon to disable the '%' column that appears to the right of each column when running reports. When enabled, the percent icon will be bold: , when disabled it will become translucent:
Repeat - Allows you to set a Repeat function on the column. Refer to the 'Repeat Functions' section below for more information
Column Checkbox - Check this box to perform formatting or multi-selection functions on this column
Column Context Menu - Hover over any column to display the Context Menu icon. Click this icon to open the Column Context Menu and perform any of the following actions: Insert Column (#1) with all corresponding Column Types, Copy (#2) the selected Column, Cut (#3) the selected Column, Paste (#4) the Copied/Cut Column, Delete (#5) the Column, or Clear the Header (#6) of the selected Column
If the Column can be assigned a Dynamic Header (and it has not yet been assigned), #6 'Clear Header' will be replaced with 'Use Dynamic Header'
Move Column - Click on the Moveicon to move any column by dragging it to a new column ordering. When moving columns, any calculations on those columns will be updated to reflect the new column ordering of the moved column
Hide Button - This button allows the User to hide the column in the Viewer, on the Sample Report of the Builder, or when a report is printed or exported to PDF. If exported to Excel, this column will display as hidden in the Excel file. To show this column again, simply click the hidden icon
Repeat Functions
In place of manually duplicating columns, the Repeat Function allows you to setup a single column (with a Column Type of 'Financial' or 'Budget'), then repeat that column for each Entity / Location / Location Reporting Category / Time Frame that you select when you run the Report.
Repeats can also be used on the Header 2 or Header 3 fields. If you have combined columns under a Header 2, you have the ability of using a repeat function on the combined Header 2 to repeat the group of columns when the Report is ran. Repeats cannot be used if the column is used in a calculation.
To set a repeat function on a column, click the Repeat icon to display the repeat options, then make the desired selection.
Location (Sort by Name) - Repeat the column for each Location selected at Report running. Sort the Locations alphabetically by name
Location (Sort by Number) - Repeat the column for each Location selected at Report running. Sort the Locations numerically by number
Legal Entity (Sort by Name) - Repeat the column for each Legal Entity selected at Report running. Sort the Legal Entities alphabetically by name
Legal Entity (Sort by Number) - Repeat the column for each Legal Entity selected at Report running. Sort the Legal Entities numerically by number
Location Reporting Category - Repeat the column for each Location Reporting Category selected at Report running
Week - Repeat the column for each week. Only available on P&L Date Range Report Types
Period - Repeat the column for each period. Only available on P&L Date Range Report Types
Quarter - Repeat the column for each quarter. Only available on P&L Date Range Report Types
Year - Repeat the column for each year. Only available on P&L Date Range Report Types
Column Calculations
Column calculations are only available on columns where the 'Col Type' has been set to 'Calculation'. Create a calculation by selecting a column, then setting the 'Col Type' to 'Calculation', and finally entering the calculation formula in the 'Calculation' field. Formulas use the column number of each column to perform their calculations. Only columns with the 'Col Type' of 'Financial' or 'Budget' can be used in calculations.
Column numbers are updated dynamically in calculations to ensure that the calculation remains true. If a column that is part of a calculation is moved or another column is inserted, the respective column number in any calculations will be updated accordingly.
To create a calculation, begin typing in any of the following column identifiers: Column # or Column Description. The column lookup will display all possible results, where you must then click on one of the values to select it. If a column is not appearing in your search results, confirm that the Col Type is set to 'Financial' or 'Budget'. You will know you successfully selected a column for your calculation once the value used for searching changes to 'C##' as shown below:
The following types of calculations are supported:
Addition - Begin typing the column number that you will start with in your formula. The column lookup will appear where you can see all columns that contain the column number you typed. In addition to the column number, you will also see the column description. Select the desired column and the value will change to 'C##'. Next, type the plus sign ( + ). Continue by typing the next column 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 calculation field, to complete the calculation formula. Hit the 'Esc' key to close without saving.
Subtraction - Begin typing the column number that you will start with in your formula. The column lookup will appear where you can see all column that contain the column number you typed. In addition to the column number, you will also see the column description. Select the desired column and the value will change to 'C##'. Next type the minus sign ( - ). Continue by typing the next column 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 calculation field to complete the calculation formula. Hit the 'Esc' key to close without saving.
Division - Begin typing the column number that you will start with in your formula. The column lookup will appear where you can see all column that contain the column number you typed. In addition to the column number, you will also see the column description. Select the desired column and the value will change to 'C##'. Next type the divide sign ( / ). Continue by typing the next column 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 calculation field 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.