August 2026
This article describes the significant feature enhancements in JustPerform v26.08.
Enhancements to Multi-Language Support: Add Italian and Dutch
Italian and Dutch languages are now added to workspace multi-language settings and user preferences. Admins can enable these languages per workspace in Admin Central > Settings > Multi-Language Settings, and users can select them in their profile's Preferred Language dropdown. All UI text, functional area content, and master data descriptions are translated to the selected language.
For more information, see Enable Multi-Language Settings article.
Enhancements to Transaction Table Import and Data Entry
Transaction Table data import is now more robust and flexible, handling edge cases that previously required manual file preprocessing. Users can import with confidence, knowing the system will warn them of potential data mismatches.
-
Extended Local Dimension Character Length
Local dimensions in Transaction Tables now support up to 50 characters, extended from the previous limit of 32 characters. This eliminates constraints that forced users to abbreviate descriptive labels. The new limit applies to both manual entry in the grid (hard-capped at 50) and imports from files (rejects over-limit values with logging).
-
Import Warning for Excel Formatting Mismatches
When importing Excel files, a warning now alerts users if cell formatting differences (such as dates, percentages, accounting notation with brackets, scaled numbers, fractions, or formulas) will cause imported values to differ from the visible display. Users can proceed with the import using underlying cell values, or cancel and re-upload the file as CSV to preserve the displayed values.
For more information, see Transactions – Table article.
Enhancements to Workflow - Transaction Write Node
Transaction Tables allow duplicate rows by design, so workflows that run repeatedly or on schedules accumulate duplicate data with each execution. The Write Transaction Table node now supports Overwrite mode to prevent this: before writing new data, it clears existing rows matching a user-defined dimension key, then writes fresh.
The new Write Option dropdown offers Overwrite, Merge, and Append strategies. When Overwrite is selected, use the Set Overwrite based on section to define which dimensions determine the clear scope.
For more information, see the Configuring Table Node section in the Working with Write Nodes article.
Enhancements to Workflow - Sheet Write Node
-
Layout simplification
The Layout section retains three buckets — Rows, Columns, and Filters — with clearer roles. Columns is now reserved exclusively for Metrics; dimensions cannot be added to Columns, and Metrics cannot be moved out. Rows holds dimensions that render as output columns. Filters holds dimensions moved out of Rows, each scoping the write to a single leaf member; filtered dimensions are excluded from both the Mapping table and the output. FA Context is removed from the Write node entirely. The Target field is renamed to Output.
-
Overwrite toggles
Each dimension added to the Set Overwrite based on section now displays a toggle (default OFF). When the toggle is OFF, the Filter icon lets the user select specific members. When the toggle is ON, the dimension resolves to all members and the filter is hidden. Publish is blocked if any toggle-OFF dimension has no members selected, or if no dimension is configured for Overwrite.
For more information, see the Configuring Sheet Node section in the Working with Write Nodes article.
Enhancements to Workflow: File Reader Cell Control and Refresh
File Reader now splits the single Start Cell into Header Start Cell and Data Start Cell. Excel files accept custom cells (for example, D7 for headers, D10 for data); CSV files are automatically locked to A1 for both. When you swap file types (Excel → CSV), cells automatically reset to A1 with a warning. A new Refresh button lets you control when columns are re-deduced after editing start cells or swapping source files. Until you click Refresh, the column list remains unchanged, preserving downstream node mappings. A stale indicator appears when columns are outdated.
For more information, see Configuring File Reader Node in the Working with Read Nodes article.
Enhancements to Workflow: SQL Input Validation and Security
Previously, SQL nodes could reference backend table IDs directly, bypassing workspace data access controls. Now, SQL queries can only reference tables explicitly added as Input nodes (via read nodes, preference options, or Master Data nodes). Direct backend table ID or name references are blocked at both save and execution time, ensuring workflows respect workspace-level data security.
For more information, see Configuring SQL Node in the Working with Transform Nodes article.
Enhancements to Transaction Table: Clear Error Messages on Invalid Saves
The grid now validates each row during save and blocks the entire operation if any row targets a locked version or attempts to write to a parent (non-leaf) member. Clear error messages explain why: "Cannot Input as Version is locked" or "Cannot input data to Parent member." Users correct the offending rows and re-save without data loss.
For more information, see Transactions – Table article.
Enhancements to Login and Password Security
-
Enforce 12-Character Password Minimum
Password reset screens now display and enforce the updated policy: minimum 12 characters (up from 8), plus uppercase, lowercase, digit, and special character. Live validation shows progress as users type, with a checklist of met/unmet rules.
-
Enforce Password Expiry and Account Lockout
Backend now enforces 90-day password expiry, blocks reuse of the last 5 passwords, and locks accounts for 24 hours after 5 failed login attempts. Existing users continue with their current passwords until next reset; no forced immediate change is required.
For more information, see Password Policy article.
SFTP Connection Enhancements
Automatic ASC/PGP/GPG File Decryption
The SFTP Connector now supports automatic decryption of ASC/PGP/GPG-encrypted files at the connection layer, before data ingestion. Users can configure a decryption private key (with optional passphrase) on their SFTP connection, enabling secure file delivery with encryption at rest. The system automatically detects whether downloaded files are encrypted based on file content and decrypts them transparently during ingestion
A new optional File Decryption section is available for both Password and SSH Private Key authentication types. When enabled, users upload a ASC/PGP/GPG private key and optionally specify a passphrase. The system validates the key and passphrase at configuration time to ensure they are valid. During file processing, the connector inspects each downloaded file's content to determine if it is encrypted. Encrypted files are automatically decrypted with the configured key and passed to ingestion; plaintext files are processed unchanged. This transparent approach supports mixed folders containing both encrypted and plaintext files without manual intervention or additional configuration.
Text File Import with Pipe Delimiter
The SFTP Connector now supports importing text files with pipe delimiters alongside the existing CSV, Excel, and Parquet format options.
A new Text option in the Remote Table Selector Type dropdown enables seamless ingestion of pipe-delimited text files. When Text is selected, the Delimiter field automatically displays the pipe symbol (|) as a read-only field.
Flexible Header Row and First Data Row Configuration
Users can specify the header row and first data row positions for Text, CSV, and Excel files, accommodating non-standard file layouts with extra title rows, multiple header lines, or other variations. This eliminates the need to preprocess or convert enterprise text files before ingestion.
Two new optional fields, Header row and First data row, are added to the Remote Table Details panel and apply to Text, CSV, and Excel files. These numeric fields allow users to specify custom row positions when files deviate from the standard layout (header on row 1, data starting on row 2). When left empty, the system defaults to current behavior, requiring no changes for standard files.
RSA Key Pair Authentication for Snowflake Connector
The Snowflake Connector now supports RSA key pair (private key) authentication as an alternative to Basic Authentication (username/password). Users can upload a private key file and optionally provide a passphrase, enabling secure, password-less authentication to Snowflake in compliance with enterprise security policies.
A new Private Key option is available in the Authentication Type dropdown alongside the existing Basic Authentication option. When Private Key is selected, users can upload a .pem formatted private key file via drag-and-drop or the Choose File button. If the private key is encrypted, an optional Passphrase field allows users to enter the associated passphrase (displayed as masked input for security). The system validates the private key and passphrase at configuration time. If validation fails, such as when the passphrase is missing, incorrect, or the file is invalid, the save is blocked with a clear error message. Only one private key file can be attached at a time, and uploading a new file overwrites the previous one. A delete icon allows users to remove the uploaded file at any time.
Benefits
- Enhanced Security: RSA key pair authentication eliminates reliance on passwords, reducing vulnerability to brute-force attacks and credential theft.
- Compliance Support: Enables organizations with strict security policies that mandate password-less authentication to use the Snowflake Connector.
- Industry Standard: Aligns with security best practices by supporting the same authentication method natively supported by Snowflake.
- Flexible Configuration: Supports both encrypted and unencrypted private keys, accommodating different key management practices.
Fixed Value and Advanced Script Filters in Data Filter for Remote Table Flows
The Data Filter tab for remote table to sheet/model dataflows now supports two filtering modes: Fixed Value and Advanced Script. Users can choose the appropriate mode for each filter column, enabling both simple static filtering and complex dynamic filter conditions. The Enable User Selection toggle controls whether filter values are editable or locked at execution time.
Each row in the Filter column now displays a dropdown selector showing the active mode (FV for Fixed Value or AS for Advanced Script) alongside a text box.
- Fixed Value mode (the default) allows users to enter specific dimension member values, including comma-separated values for multiple members (e.g., 2024.P01, 2024.P02). Leaving the text box empty applies no filter, allowing all members to be used during execution.
- Advanced Script mode enables users to write advanced filter expressions directly into the text box (e.g., BETWEEN '2024.P01' AND '2024.P12').
Users can switch between modes at any time by clicking the dropdown trigger; the previously saved value persists until Save is clicked in the new mode. The text box is editable at execution time with pre-populated values. Each filter row maintains independent configuration with no impact on other rows.
Benefits
- Flexible Filtering Options: Support for both fixed values and advanced scripts accommodates simple and complex filtering scenarios in a single interface.
- Dynamic Conditions: Advanced Script mode enables range-based, conditional, and dynamic filters that adapt to different execution contexts.
- Independent Configuration: Each filter row operates independently, allowing designers to mix Fixed Value and Advanced Script filters as needed.
Delete Row Functionality for Journal Line Items
Currently, users cannot delete entire Journal Line Items, they can only manually clear individual cell values. This feature introduces a Delete Row option in the right-click context menu, allowing users to remove one or multiple line items with a single action. When deleted, the item is immediately removed from the UI and permanently deleted from the backend upon save, with remaining line items automatically reordered to maintain sequential numbering.
Benefits
- Improved Efficiency: Users can delete entire rows in one step instead of manually clearing each cell, reducing time and effort.
- Enhanced Data Integrity: Dedicated deletion logic ensures clean removal from both UI and backend, eliminating orphaned or incomplete data.
- Better User Experience: A familiar context menu action aligns with standard application behavior and reduces confusion.
Time Summary Formula for YTD, QTD, and HTD Time Series
The Time Summary Method, Formula, now applies consistently to YTD (Year-to-Date), QTD (Quarter-to-Date), and HTD (Half-year-to-Date) cumulative time series. Previously, Time Summary calculations only worked for natural time periods (Quarter, Year), creating inconsistent behavior when viewing cumulative time series.
The system now recognizes YTD, QTD, and HTD members as parent/aggregate members and automatically applies the appropriate Time Summary formula to each cumulative member.
The aggregation logic works independently of the selected parent period (Year, Quarter, or Month), ensuring consistent behavior whether viewing standard time periods or cumulative time series.
Benefits
- Consistent Aggregation: Time Summary calculations now work uniformly across all time hierarchies, both natural periods and cumulative time series.
- Reduced Manual Work: Financial analysts no longer need manual calculations to achieve proper running totals and period-based aggregations.
- Flexible Reporting: Support for the aggregation method, Formula, gives analysts greater control over how cumulative data is presented.
- Predictable Behavior: Time Summary settings apply seamlessly regardless of which parent period (Year, Quarter, or Month) is selected, eliminating unexpected calculation variations.
Auto-Sync Snippet Data Between Excel Add-In and Web
Snippet data now synchronizes automatically and bidirectionally between the web and Excel add-in. When you save updated set range reports on the web, the changes instantly reflect in your Excel sheets. Similarly, updates made in the Excel add-in automatically sync back to the web. This seamless two-way synchronization keeps all versions current across platforms without manual intervention.
Limit Journal Amount Decimal Precision to 4 Places
This feature limits decimal precision to 4 places after the decimal when users import or create journals in the UI, ensuring that amounts display cleanly without unwanted trailing zeros or scientific notation (such as 0E-12). By standardizing decimal handling across both imported and manually created journals, the feature eliminates value errors that previously occurred due to inconsistent precision. Users benefit from more accurate data representation, reduced confusion from formatting artifacts, and a more reliable journal creation experience, regardless of whether data is imported or entered directly in the interface.