Spire 3.2 Release Notes (3.2 to 3.2.9)

Spire 3.2 was released on May 8, 2019; the latest update in this version is 3.2.9 (October 1, 2019). Below are Spire Systems’ release notes for every 3.2 release, organised by area, newest first. Spire 3.x and Spire 4.x are separate lines; these notes are for Spire 3. All Spire 3.x release notes.

In this version: 3.2.9 · 3.2.8 · 3.2.7 · 3.2.6 · 3.2.5 · 3.2.4 · 3.2.2 · 3.2.1 · 3.2

Highlights

Faster inventory. Inventory was refactored to speed up everything that uses it.
Margins on sales orders. Current and standard cost and margin in the order footer, and cost columns in order and history items.
Purchasing and currency. Receive a new purchase order without issuing it first, look up and adjust exchange rates anywhere, and set a base currency without multi-currency.
Inventory lists. Last receipt and last sale dates, and sales orders created from selected items.
Also: void selected payments from an AP payment batch, and pgAdmin 4 as an install option.

Spire 3.2.9 (October 1, 2019)

Improvements and corrections

Improve AR and AP account view screen for AR and AP accounts with many records, add ability to turn off sorting with a system setting for more speed
Allow Discount to be unchecked when paying a Vendor Debit memo
Improve recovery when a Purchase Order Receipt posting fails with an error and the user ignores it
Correct error using Change Vendor Code when Inventory Preferred Vendor needs to be changed in the process
Correctly import Sales Department during Inventory Import
Correctly import multiple price records during Inventory Import
Correctly show Contract Cost on Sales Order line
Retain current cost and standard cost when posting a Sales Order with Contract Cost to Sales History
Correctly respect Company Settings, Sales Order, Process/Invoicing, Reset phase when invoicing Standing Orders during Invoicing
Limit employee information shown on Employee Lookup List

New Reports

Bank Disbursement Journal – add new report for Bank Accounts to General Ledger, Transactions
Historical Comparative Statement – add new report to General Ledger, Reports, Historical Financial Report template

Report Changes

AP EFT Payment Remittance – add report to cheque reports dialog
Account Reconciliation – separate reconciled and unreconciled items, add user initials
Last Year’s totals and compare to previous year from GL History
Historical Comparative Statement – add support for Start Date
Payroll Cheque-Bottom – correct union dues amount
Payroll Cheque-Centre – correct union dues amount
Payroll Cheque-Top – correct union dues amount
Payroll Direct Deposit – correct union dues amount —

Spire 3.2.8 (August 21, 2019)

New Features

Add ability to select a Base Currency Bank GL Account when paying foreign Vendors and allow the exchange rate to be set for the payment

Improvements and corrections

Correct error trying to Save a Preset Filter without a name
Correct error adding a new Employee with out of date Payroll Tables
Correct error adding a new Employee without a Default Payroll Department set
Set default Sales Departments and GL Accounts on new Sales Order created from Sales History Invoice, Copy. (Sales History Invoice, Credit retains original Sales Department and GL Accounts)
Populate all Sales Order Line Cost fields when user types in one cost field, only on non-inventory items
Correctly allow Cost to be edited on Sales Order lines for non-physical inventory items
Correct Fill Backorders on Sales Orders with non-physical items
Correctly post a Refund Payment to Payfirma when paying a Credit Sales Order
Correctly post a USD Payment to Payfirma
Calculate Service Charges based on Due Date, on AR Records without Payment Terms
Allow ShipTo ID to be set on a Price Matrix record
Respect Company Settings, Special Accounts, Bank Account as needed when paying Foreign Vendors
Check for transactions in all Division before allowing the GL Account Group to be changed
Allow more than 99 labels to be printed
Correct error when clicking Set Quantity to BOH on a non-inventory in a Purchase Order, Print Labels
Populate Sequence # column in Purchase Order immediately
Correct error changing the cost on a subsequent receipt, on a Purchase Order

New Reports

GL Account Foreign Balance – add new report to General Ledger Reports tab

Report Changes

Comparative Statement – invert Net Profit (Loss) percentage
Components Usage – remove accessories from Kit section
Customer Sales History Details – use Kit Cost in calculating GP
Customer Sales History – use Kit Cost in calculating GP
Receipts Order Fulfillment – correctly print report even when no Inventory Requisition records exist for the inventory item
Receiver General by Payroll Dates – correct grouping and totals —

Spire 3.2.7 (July 30, 2019)

New Features

Add record locking to Timecard Batches so that only one user can work in a batch
Add column Amount Remaining Ordered to Sales Order List
Add the ability to store Kit, and Kit Component flags to Sales Order Items table as well as Kit Costs to improve Gross Profit Reporting

Improvements and corrections

Respect Currency Exchange Rate from Main tab for records dated same as logon date, otherwise respect monthly rate as per document date
Post an Inventory Variance to the GL when the user modifies the cost on a Purchase Order Return (negative receipt)
Correctly respect Inventory tax settings on Purchase Order lines
Correctly update Purchase Order Issued Amount without requiring the user to click Save before Issue in a PO
Do not change Current Cost when performing a positive Inventory Adjustment
Correct Customer, Sales History, Items list after Customer Code change
Correct occasional Errors in Update Sales Orders after changing Customer Credit Limit
Correctly allow Override Credit Limit on a Sales Order that is failing Check Credit on Save
Correctly show Extended Levy on Quotes
Correct error privileges error when a user without permission to Modify UOM, Invoices a Sales Order
Correct Sales Order, Store selected price when focus is not moved from Unit Price
Correct occasional Price Matrix error when adding a part number to a Sales Order which uses cumulative pricing and quantity break pricing at the same time
Correct issue adding a part number to a Sales Orders with Show Options checked in Edit Inventory, Components and yet no Accessories have been set up
Correct error when entering a PO number ending with a backslash, in a Sales Order
Correctly blank Sales Order, Terms field on invalid entry
Correct error when Invoicing a Service Order with backorders
Correct auto allocate on a Lot number with negative available quantity
Correct error when performing Credit in Sales History Invoice for serialized items
Correct permission error when performing Credit in Sales History Invoice with a Kitted item
Correctly copy cost values when performing Credit in Sales History Invoice (Reverse the Invoice)
Correctly populate Kit current Cost when performing Credit in Sales History Invoice (Reverse the Invoice)
Correct problem causing POS to show Kit options when it has not been set to do so on a Kit
Correct error when attempting to Email Statements to customers who have no email address in their profile
Correct Price Matrix Import for items with a Product Code defined
Correct Customer ShipTo Import with Salesperson defined
Do not allow GL account for bank to be changed in Review GL Transaction in Payables Cheque
Correctly show recently voided payments in a new Account Payable Payment Batch
Refresh bank account when AP Payment Batch currency is changed
Correct error during Inventory Item copy with Components
Correctly show Inventory part numbers containing a “+” in auto complete, searches and filtered lists
Correct divide by 0 error when User Serial/Lot costing is enabled in Company settings and bad serial number data exists
Improve message when changing Product Code in Edit Inventory
Correctly show all records in Edit Inventory, Purchasing, History tab
Put user back into the already open Timecard batch is they try to open it again
Correctly auto assign Vendor Number if Company Settings, Sequence Numbers, Vendor No > ‘0000000000’

Database Changes

sales_history_items – add fields kit, kit_component, kit_average_cost, kit_current_cost, kit_standard_cost

Database Changes

sales_order_items – add fields kit, kit_component, kit_average_cost, kit_current_cost, kit_standard_cost

Report Changes

AP Payments Batch – sort on reference number
Inventory Sales History – use kit_cost for Top Level Kits , use component cost = 0 for Kit Components
Inventory Sales History Details – use kit_cost for Top Level Kits , use component cost = 0 for Kit Components, remove test condition from selection criteria
Inventory Sales History in Base – for use in Inventory Reports tabs, use kit_cost for Top Level Kits , use component cost = 0 for Kit Components
Packing Slip – print the first date field with a value; ship_date, pack_date, required_date, order_date
Payroll Ledger by Department – replace employee ID with employee number
Payroll Ledger – replace employee ID with employee number
Receiver General by Payroll Dates – replace employee ID with employee number
Ship Slip – print the first date field with a value; ship_date, pack_date, required_date, order_date
Workers Compensation Remittance – replace employee ID with employee number —

Spire 3.2.6 (July 3, 2019)

Improvements and corrections

Correct error voiding an AR Payment in a different Division than the payment was posted in
Immediately recalculate Purchase Order total after adding a Macro
Right align Inventory Cost column in Purchase Order Items
Allow Receive date to be changed while working on a quick Purchase Order
Allow Non-Physical Items to be returned (negative received) on a Purchase Order
Correctly adjust Inventory On Order quantity when closing a PO with some items not received
Correctly set inventory_order_qty on a Purchase Order when UOM is changed after Quantity Ordered
Remove non-inventory receipts and sales, in Edit Inventory, Purchases and Sales tabs if part number is added to Inventory, after being put on a Purchase Order or Sales Order
Correct error when trying to add a Sales Quote to a Batch
Correct occasional Null error opening Sales Order with hidden UDF page
Retained Sales Order Created by User, Date/Time in suffixed Sales Order, created by backorder
Retain Sales Order Created by User in Sales History Invoice
Do not respect Customer Default warehouse setting in the POS screen
Improve serial number management in Purchase Order Receive so that the same serial number can’t be used twice on different lines
Allow AR and AP transactions with an exchange rate = 0 to be Voided
Improve tooltip on Accounts Payable Batch, Select All Due button
Remember sort order set on Timecard, Details
Correctly display multi-edit dialog in Price Matrix
Correct error toggling a sub-assembly in an Open Production Order
Show all warehouses in warehouse lookup in Change Location dialog

Report Changes

Balance Sheet – Improve Account Balance reset on page break
Historical Trial Balance – remove multiple records for each account
Inventory Sales History – correct divide by 0 error
– Calculate cost columns for Kits and Components
– add indicators for Kits and Components
– correct selection criteria
– improve linking
– move report to Sales History, Reports tab
Inventory Sales History in base – correct divide by 0 error
– Calculate cost columns for Kits and Components
– add indicators for Kits and Components
– correct selection criteria
– improve linking
– move report to Sales History, Reports tab
Inventory Sales History Details – calculate cost columns for Kits and Components
– add indicators for Kits and Components
– correct selection criteria
– improve linking
– move report to Sales History, Reports tab
Sales Order – correct F.O.B. in translate() function —

Spire 3.2.5 (June 13, 2019)

Improvements and corrections

Correctly recreate Inventory and Sales History List Views when migrating Spire 3.2.x databases

Spire 3.2.4 (June 12, 2019)

Improvements and corrections

Correct occasional ‘function “hstore_to_jsonb” already exists’ error when restoring snapshots

Spire 3.2.2 (June 4, 2019)

New Features

Add ability to edit Company Access flag from User List

Improvements and corrections

Correct occasional QEvent error creating a Sales Order
Correctly populate Subtotal Ordered column on Sales Order List
Put initial focus in Customer Code when creating a new Sales Order in Compact Mode
Correct pop Communication Alert when creating a Sales Order from Edit Customer, Sales tab
Do not clear Salesperson or Territory fields on Sales Order when lookup is closed with Validate settings enabled
Show part number that is not returnable on error that is displayed when performing a Sales History Invoice, Credit
Correct error using Add to Order with an On Hold item
Correctly allow Credit Limit to be set in Customer multi-edit
Add locked records support multi-edit
Do not allow a negative currency exchange rate in GL Transactions
Improve GL Account selection in AP Payables batch for multi-currency companies
Correct error Applying records with empty audit dates in AP and AR
Correct occasional error when adding a Note to the Communications module
Display invalid login date error only once when logging in with an invalid date
Correct error deleting a blank line on a Purchase Order
Correct error exporting Price Matrix when blank audit fields exist
Correct error importing Price Matrix UOM
Correct date error purging Price Matrix records
Correct error importing Inventory Primary Vendor field
Correct error creating accounts table on a new Spire installation where the first company is created with a BV conversion that has database errors

Database Changes

system_record_locks – remove field link_table, link_no

Database Changes

system_record_locks – add field record_table, record_id

Report Changes

Pick Ticket – always print Kit components
Ship Slip – Restore version with multi language support —

Spire 3.2.1 (May 21, 2019)

Improvements and corrections

Correct issue when selling to a migrated customer whose credit limit has never been set
Correctly create Backorders for Kit Components not shipped on original Sales Order
Remove Company Settings, Inventory, Miscellaneous, Use permissive FIFO setting
Correctly allow 20 character reference numbers on a Purchase Order line
Correct occasional migration error regarding hstore to JSONB during database upgrade
Allow 40 character Customer Type (User Defined 2) field to contain 40 characters during Customer import

Report Changes

Customer Sales History Details – respect Admin user permissions on Cost columns, use Current Cost on Inventory Kitted items
Customer Sales History – respect Admin user permissions on Cost columns, use Current Cost on Inventory Kitted items
Inventory Purchase History – respect Admin user permissions on Cost columns
Inventory Sales History Details – respect Admin user permissions on Cost columns, use Current Cost on Inventory Kitted items
Inventory Sales History – respect Admin user permissions on Cost columns, use Current Cost on Inventory Kitted items
Inventory Sales History in Base – respect Admin user permissions on Cost columns, use Current Cost on Inventory Kitted items
Purchase History – respect Admin user permissions on Cost columns —

Spire 3.2 (May 8, 2019)

General

Critical Actions required
AP and AR User permissions must be reviewed for each user that has access to Accounts Payable and/or Accounts Receivable
Custom Reports using UDF fields must edited
Customized Invoice Batch Reports must use ?SalesOrderID in the selection criteria for emailing
pgAdmin 4.x needs the server added

New Features

Add cancel button to Add UDF
Add ability to drag fields up and down in UDF setup
Add Last Receipt Date and Last Sales Date columns to Inventory List, populate values at Inventory Receipt and Sales Order time
Display Company name on Window Title bars
Refactor Inventory to improve database speed with all objects that use Inventory
Add Production, Templates tab to Edit Inventory
Add Create Sales Order button to Inventory List to use for highlighted Inventory rows
Add Total Current Cost, Current Margin, Current Margin %, Total Standard Cost, Standard Margin and Margin % to Sales Order footer and Sales History Invoice footer
Add Cost columns to Sales Orders, Items List
Add Standard Cost column to Sales History, Items List
Add Reference and Memo columns to Inventory Adjustments
Add ability to Receive a new Purchase Order without the requirement for Issue process
Add ability to look up Currency rate and adjust the rate from anywhere that Currency is displayed
Add ability to set and Edit Base Currency without requiring Multi-Currency to be enabled
Add ability to Void selected Payments from an Accounts Payable Payments batch, Requires User, Accounts Payable, Void Transaction enabled
Show Communication Notes with blank times in the Calendar as All Day
Add option to install pgAdmin 4 in Spire Server Installer
– pgAdmin 4 runs in a Web Browser
– pgAdmin 4 requires that a Server be added to the menu

Improvements and corrections

Change udf_data fields to store JSONB – requires slight change to all Crystal Reports SQL Expressions reading UDF fields. Replace “>” with “>>”.
Improve speed opening Lists and Dialogs
Improve speed adding rows to a Production Order
Improve Phase filters to allow the selection of available Phases
Correctly respect number of decimal places set in UDF numeric setup
Allow <blank> to be an option in UDF field drop down as applicable
Place cursor in Field Name when adding a new UDF
Validate UDF data immediately after tabbing off the field rather than waiting for Save
Improve the ability to set UDF as “Required”
Improve filters to treat blank and null the same
Allow a non Admin user to set a Company Filters as their Default Filter
Correct occasional error clicking on Sales Order, Fill Order tab and Purchase Order, Receive Order tab when serial numbers are involved
Correctly respect Salesperson and Territory on Sales Order Billing Address when User settings have Restrict Users’ Customers/Sales Order by Salesperson and/or Restrict Users’ Customers/Sales Order by Territory enabled
Recalculate total weight on Sales Order after deleting an item from the Order
Correctly show Part Number in On Hold banner warning in a Sales Order
Correct occasional error “MessageBox has been deleted” error adding a line to a Sales Order
Remove plural from Sales Order, Updates Prices dropdown text to say Refresh Selected Price and Store Selected Prices
Correctly post Sales Order to Base GL Accounts if no Location is specified on the Sales Order when Location Accounting is enabled
Correctly retain multiple Communication links when changing a Quote to a Sales Order
Allow Kits with negative quantity components to be added to a Sales Order
Correctly display Kit cost in Sales Order when Components have multiple quantities
Correctly display the effect of UOM conversion on Kit Component cost in a Sales Order
Correctly display Kit Costs on the Sales Order after being copied from a Sales History Invoice
Allow users without Modify Prices permissions to add Kits that contained priced components, to Sales Orders
Allow a Credit Sales Order (Return) to be created without validating customer credit limits
Correct occasional ‘maximum recursion depth exceeded’ error adding a Kit to a Sales Order
Maintain Macro items within a Job Header on a Sales Order
Correctly stamp UTC time on Sales Order batch created date
Correctly group attachments when emailing Invoices from an Invoice Batch – ensure customized Invoice Batched Reports use ?SalesOrderID in selection criteria
Correct occasional errors using POS multiplier with no quantity or negative quantity
Change T5018 process to use Payments rather than Invoices
Correctly display user list on a newly created company
Do not close Purchase Order screen when UnIssue is clicked
Use correct Exchange rate for Freight and Duty when receiving a foreign Purchase Order
Correctly respect Company settings, Inventory, Enforce Product Codes when adding a new Inventory item
Correct issue removing a newly added Kit component to Edit Inventory, Components tab
Correct occasional error clicking on Expand triangle in Production Template in Edit Inventory, Bill of Materials tab
Do not commit both sub-assembly and it’s components when the sub-assembly is toggled in a Production Order
Correctly display Margin in Price Matrix for non-default UOM
Correctly advance Last Serial number for the part number after using Auto Generate to create new Serial numbers when receiving or creating new Inventory items
Improve speed loading Inventory Count during Freeze operation
Do not allow an Inventory User Type value to be deleted when in use in Inventory Items
Correctly zero Employee This Year and Last Year Benefits and Deductions total during Recalculating Employee Amounts before re-adding timecard values
Support Print All and Print Selected in Employee, Timecards tab, Print
Allow user to click Ignore Lock if record is reported to be locked by another user
Do not allow a particular Edit Window to be opened multiple times from multiple places, ie. Open the same Sales Order twice from two different places
Correct GL Segment sort in General Ledger, Reports, Base Segment dropdown
Correct issue if Paying an Invoice in Accounts Receivable Batch which gets paid by another process before Batch is Posted
Correct issue clicking on Browse button in Mail Merge
Allow a Job Account to be selected on an AR or AP entry without requiring the user to have Edit Job permissions
Do not allow discounts on AR Credit Memos and AP Vendor Credits
Correct occasional UnApply, not unlinking amounts in AR and AP
Cleanup some A/R and A/P User Permissions defaults This may need to be reviewed for each user that has access to these modules
Allow user to correct an invalid date when posting an A/R or A/P Invoice
Support cheque number field in AP Payment only when GL Account is set as a Bank Account, otherwise present Reference Number field
Write AP Payment Reference number to GL Transaction memo
Correct field spacing in Company Settings, General Ledger, Special Accounts
Removed Un-postable status from Recurring Journal Entry screen
Improve Employee Calculated Net Pay total during migration from BV data
Correct Customer, Salesperson import
Correctly remember the Export path for each module’s Export button
Spanish and French word translations improved
Do not close Spire Desktop on Connection refused error, try connection again
Install pgAdmin 4.3 with Spire Server, will require user to add server the first time they launch it

Database Changes

addresses – remove field native, billto_csp
ap_batch_items – add field payment_id, payment_trans_no, void_id, void_trans_no
ap_batches – add field status,

Database Changes

ar_transactions – remove field link_trans_no, link_date, upload_flag
bom_item_replacements – remove field uuid
currencies – add field date_format
currencies – remove field cheque_text, cheque_date_format

Database Changes

customers – remove field tax_prompt, last_sale_amt, open_ord
employees – remove field notes, td1_line_6_9, ytd_munic_tax, lst_munic_tax, image_path, direct_deposit_method
equipment – remove field engine, irp_no

Database Changes

gl_accounts – remove field browse
gl_history_accounts – remove field browse
gl_history_tansactions – remove field job_cost_flag
gl_recurring_pending – remove field mc_revise

Database Changes

gl_recurring_transactions – remove field template_mc_revise, template_posted
gl_transactions – remove field job_cost_flag
inventory – add field last_sale_date, last_receipt_date

Database Changes

inventory – remove field tax_code, chgn_int, chgn_date, non_standard
inventory_adjustments – remove field currency, received_date
inventory_adjustment_items – add field reference, comment

Database Changes

inventory_adjustment_items – remove field duty_by_pct, duty_pct, duty_amt
inventory_conversion_factors – remove table
inventory_price_matrix – remove field cust_price_code

Database Changes

inventory_product_codes – remove field sub_category, top_category_code, code_sequence_no, code_page_size, code_display_type, discount_code, discount_mode, discount_pct, discount_amt

Database Changes

inventory_uoms – remove field break_qty, break_qty_price
notes – remove field alert_flag
payroll_timecards – remove field munic_tax
production_history – remove field assemble_qty, user_type

Database Changes

production_history_items – remove field yield_pct, expected_yield_pct, phase_id
production_order_items – remove field yield_pct, expected_yield_pct, phase_id
production_orders – remove field user_type

Database Changes

production_template_items – remove field user_flag
purchase_history – remove field invoice, customer_ship_id, customer_ship_type, user_type
purchase_history_items – remove field template_no, template_guid, revision

Database Changes

purchase_order_items – remove field date
purchase_orders – remove field customer_ship_id, customer_ship_type, user_type
sales_history – remove field status, last_inv_no, last_inv_date

Database Changes

sales_history_items – remove field last_invoice_no, last_invoice_date
sales_order_equipment – remove field order_type
system_record_locks – add field link_table, link_no, acquired

Database Changes

system_record_locks – remove field file_id, file_key

Database Changes

system_report_permissions – remove field default_email01, default_email02, default_email03, default_email04, default_email05, default_email06, default_email07, default_email08, default_email09

Database Changes

vendors – remove field fob_desc, po_type

New Reports

AP Payments Batch – replace Pending Payment report in AP Payments Batch List Print and AP Payments Batch dialog to support Closed Batches and Void Payments
Inventory Lot Trace – add report to Inventory, Lot number tab

Report Changes

Custom Reports reading udf_data will need to have the SQL Expressions changed to conform to JSONB standards using two greater than signs. ie. ((inventory.udf_data)->>’GlutenFree’)::Boolean
1099-MISC 1-UP Report – verify database to recognize table changes
1099-MISC 2-UP Report – verify database to recognize table changes
Accounts Payable List – verify database to recognize table changes
Accounts Payable by Due Date – verify database to recognize table changes
Accounts Receivable List – verify database to recognize table changes
Accrued Payables Summary – verify database to recognize table changes
AP Cheque Remittance – replace ap_transactions.link_transno with ap_transaction.trans_no, remove unused numberVar date_format, verify database to recognize table changes
AP EFT Remittance – replace ap_transactions.link_transno with ap_transaction.trans_no, remove unused numberVar date_format, verify database to recognize table changes
AR Payment Receipt – verify database to recognize table changes
Backorder Details by Customer – verify database to recognize table changes
Balance Sheet – suppress subgroup horizontal line for blank subgroups, verify database to recognize table changes
Batch Journal – verify database to recognize table changes
Batch Journal Reprint – verify database to recognize table changes
Cash Balance Details – verify database to recognize table changes
Cash Balance – verify database to recognize table changes
Cheque Deposit List – verify database to recognize table changes
Cheque-bottom – replace ap_transactions.link_transno with ap_transaction.trans_no, respect changes for currencies.date_format, correctly count detail records and show “Please see attached Remittance advice” as required, verify database to recognize table changes
Cheque-centre – replace ap_transactions.link_transno with ap_transaction.trans_no, respect changes for currencies.date_format, correctly count detail records and show “Please see attached Remittance advice” as required, verify database to recognize table changes
Cheque-top – replace ap_transactions.link_transno with ap_transaction.trans_no, respect changes for currencies.date_format, verify database to recognize table changes
CPRS-T5018 List – verify database to recognize table changes
Communication – verify database to recognize table changes
Comparative Statement – verify database to recognize table changes
Components Usage – verify database to recognize table changes
Consolidated GL Activity – verify database to recognize table changes
Customer Activity – verify database to recognize table changes
Customer Payments List – verify database to recognize table changes
Customer Price Matrix – verify database to recognize table changes
Customer Sales History Details – verify database to recognize table changes
Customer Sales History – verify database to recognize table changes
Customer Statement – verify database to recognize table changes
Daily Fill Rate by Invoice – verify database to recognize table changes
Daily Fill Rate by Item – verify database to recognize table changes
Deleted Sales Orders – verify database to recognize table changes
Disbursements Journal – verify database to recognize table changes
Employee Ledger – verify database to recognize table changes
Employee Ledger Detailed – verify database to recognize table changes
Employee ROE Info – remove unused numberVar date_format, verify database to recognize table changes
Employee Summary – remove the use of employees.ytd_munic_tax field
Employee Termination – verify database to recognize table changes
Invoice Posted – remove the use of sales_history.status field to set the Report label, correct labels for F.O.B., Tax, Unit and Net Amount
Equipment Information – verify database to recognize table changes
Equipment Service History – verify database to recognize table changes
Financial Statement by 12 Periods – verify database to recognize table changes
Financial Statement by Period – verify database to recognize table changes
Financial Summary – verify database to recognize table changes
GL Chart of Accounts – verify database to recognize table changes
GL Foreign Balance – verify database to recognize table changes
GL Historical Transactions – verify database to recognize table changes
GL Open Balance Check – verify database to recognize table changes
GL Transactions by Month – verify database to recognize table changes
General Ledger Account Activity – verify database to recognize table changes
General Ledger Journal Transaction – verify database to recognize table changes
Historical Accounts Receivable List – verify database to recognize table changes
Historical Balance Sheet – verify database to recognize table changes
Historical Income Statement – verify database to recognize table changes
Historical Inventory Status – verify database to recognize table changes
Historical Trial Balance – verify database to recognize table changes
Income Statement – verify database to recognize table changes
Inventory Bar Code Label 5160 – verify database to recognize table changes
Inventory Count Review – verify database to recognize table changes
Inventory Count Sheet – verify database to recognize table changes
Inventory Label 2X1 – verify database to recognize table changes
Inventory Label 5160 – verify database to recognize table changes
Inventory Purchase History – verify database to recognize table changes
Inventory Re-order – verify database to recognize table changes
Inventory Sales History Details – verify database to recognize table changes
Inventory Sales History in Base – verify database to recognize table changes
Inventory Sales History – verify database to recognize table changes
Inventory Statistics – verify database to recognize table changes
Inventory Status UDF – verify database to recognize table changes, change SQL Expressions for UDF structure change
Inventory Status – verify database to recognize table changes
Inventory UPC List – verify database to recognize table changes
Invoice Batched – add “Invoice Batch” to template, verify database to recognize table changes
Item Allocations – verify database to recognize table changes
Item Components – verify database to recognize table changes
Job Accounts List – verify database to recognize table changes
Job List – verify database to recognize table changes
Job Revenue and Expenses – verify database to recognize table changes
Materials Requirements by Inventory – verify database to recognize table changes
Order Confirmation – verify database to recognize table changes
Packing Slip – verify database to recognize table changes
Payment on Account B – verify database to recognize table changes
Payment on Account P – verify database to recognize table changes
Payment on Account Receipt – verify database to recognize table changes
Payroll Cheque-Bottom – remove the use of payroll_timecards.ytd_munic_tax field, respect changes for currencies.date_format
Payroll Cheque-Centre – remove the use of payroll_timecards.ytd_munic_tax field, respect changes for currencies.date_format
Payroll Cheque-Top – remove the use of payroll_timecards.ytd_munic_tax field, respect changes for currencies.date_format
Payroll Direct Deposit – remove the use of payroll_timecards.ytd_munic_tax field, respect changes for currencies.date_format
Payroll Ledger – remove the use of payroll_timecards.ytd_munic_tax field
Payroll Ledger by Department – remove the use of payroll_timecards.ytd_munic_tax field
Pending Inventory Adjustments – verify database to recognize table changes
Pending Payments – remove report, replace with AP Payments Batch
Pending Purchase Order Receipts – verify database to recognize table changes
Pending Receipts – verify database to recognize table changes
Pick Ticket – verify database to recognize table changes
POS Receipt Reprint – verify database to recognize table changes
POS Receipt – verify database to recognize table changes
Post Inventory Adjustments – verify database to recognize table changes
Post Inventory Count – verify database to recognize table changes
Post Inventory Receipts – verify database to recognize table changes
Price Matrix List – verify database to recognize table changes
Process Slip – verify database to recognize table changes
Production Build – verify database to recognize table changes
Production Order – verify database to recognize table changes
Production Schedule – verify database to recognize table changes
Production Template – verify database to recognize table changes
Production Trial Build – verify database to recognize table changes
Purchase History – verify database to recognize table changes
Purchase Order Details – verify database to recognize table changes
Purchase Order Reprint – verify database to recognize table changes
Purchase Order Summary – verify database to recognize table changes
Purchase Order – verify database to recognize table changes
Quote – verify database to recognize table changes
Receipts Order Fulfillment – verify database to recognize table changes
Receiver General by Payroll Dates – verify database to recognize table changes
Requisition List – verify database to recognize table changes
RMA Order – verify database to recognize table changes
Sales History Reports tab Sample – verify database to recognize table changes
Sales Order – verify database to recognize table changes
Sales Order Details List – add support for foreign currency Sales Orders, verify database to recognize table changes
Sales Order List – add support for foreign currency Sales Orders, verify database to recognize table changes
Sales and Taxes 4 – verify database to recognize table changes
Sales and Taxes – verify database to recognize table changes
Sales by Payment Method – verify database to recognize table changes
Sample Address Label – verify database to recognize table changes
Sample Customer Address Label-5160 – verify database to recognize table changes
Sample Customer Address Label – verify database to recognize table changes
Sample Vendor Address Label – verify database to recognize table changes
Ship Slip – verify database to recognize table changes
T4-14b-CRA – verify database to recognize table changes
T4-14b-employee – verify database to recognize table changes
T4-14b-employer – verify database to recognize table changes
T4-Summary – verify database to recognize table changes
T4A – verify database to recognize table changes
T5018 – verify database to recognize table changes
Trial Balance – verify database to recognize table changes
Trial Post Transactions – verify database to recognize table changes
Vendor Activity – verify database to recognize table changes
Vendor Ledger – verify database to recognize table changes
Workers Compensation Remittance – verify database to recognize table changes
Work Order – verify database to recognize table changes —

Upgrading

Spire 3.13 and higher require Windows Server 2022/2025 or Windows 11 (64-bit) or higher. Before upgrading, read Spire’s Upgrading to this Version page in the Spire 3.13 user manual.

Ask your AI assistant about this release

With SpireAssists MCP, Claude, ChatGPT and other AI assistants can answer questions like “What changed for purchase orders in Spire 3.2?” or “What’s new between my version and the latest?”, citing Spire’s own documentation. It’s free. Connect SpireAssists.

← Spire 3.1 · All Spire 3.x release notes · Spire 3.3 →

Source: Spire Systems Inc. release notes for Spire 3.2, 3.2.1, 3.2.2, 3.2.4, 3.2.5, 3.2.6, 3.2.7, 3.2.8, 3.2.9, as published by Spire and retrieved on 2026-10-08, organised by SpireAssists. Highlights are our summary. Spire is a trademark of Spire Systems Inc.; SpireAssists is an independent Certified Spire Integration Partner.