3.9.1 SAMMS Stability / Enhancements
This page summarizes the released work for RedRock SAMMS 3.9.1. Version 3.9.1 brings more reliable approval routing, easier searching across contracts and receiving, new capital project controls, the ability to add items from the scanner during physical counts, and 10 new reports.
Highlights
- Inventory: Items scanned during a physical count that don't exist in that inventory can now be added directly from the scanner, along with their count.
- Approvals: Fixes for auto advance, negative amounts, vacation bumping and merged routes, plus new detail tabs on Approve Document.
- Procurement: Partial-word item search, a new item search on Receive a Contract, and pricing fixes on requests and purchase orders.
- Finance: A % threshold for capital projects set to Can Exceed, and project balances that track release amounts.
- Reports: New spend analytics, EDI pricing reconciliation, inventory and retail reports, and a progress indicator when a report is running.
Customer Facing Improvements
Requests and Orders
- Inquiry grids, including All Documents and the approval grids, now include Terms Amount and Extended Amount columns.
- Copying a procurement request now rebuilds the accounts from your current setup instead of reusing the accounts on the original request.
- The capital project picker on purchase orders now filters by the document's property, so users only see their own projects.
- The Create from Order Guide button is back on Request from Guide.
- When you add a supplier to a misc item line on a request, the supplier and price you entered are kept.
- Resetting pricing on a purchase order keeps the correct price origin, such as low bid.
- The user search in Email on Process & Finalize now finds people by first and last name together.
- Property Terms and Conditions are attached only to external emails, not internal ones.
Contracts
- Simple search can find expired contracts again.
- Item search on Open Direct Receipts and Open Releases matches partial words. For example, "rocky" finds “Ice Cream Rocky Road.”
Receiving
- Receive a Contract now has an item search box, like Contract Releases.
- Delivery confirmation emails include the receipt (RV) number.
Bids
- Bid Pricing Maintenance shows supplier item numbers from item maintenance.
Approvals
- Approve Document details now include Reference Documents and Transmission Status tabs, matching the inquiry pages.
- Approval Find and Replace now covers entity, property and company approvals, not just department approvals.
- Departments in D (deleted) status with no approval routes no longer appear in Approval Routes.
- The Orphaned Approvals clean-up job now clears documents that remain in approval queues after being approved.
- When a route has a Notify Only level set at $0, documents submitted for $0 now go through approval instead of moving straight to Open-NA.
- When an approver creates a request under their own approval limit, it now fully approves as soon as the required approver below them approves.
- Auto advance no longer skips the final approver on a route. Like vacation bumping, it stops at the final approver.
- Documents with negative amounts now go through every approval level, based on the absolute amount.
- Processing a request whose only approver is on vacation no longer shows an error. The request stays in that approver's queue.
- Clearing the Use Setting of option on an approval route now resets the route.
- Unmerging dollar limit approvals from commodity-level entity approvals restores the dollar limit approvers.
- Merged approvals combined with Notify Only now use the Dollar Limit Behavior set on the route.
Finance
- Capital projects set to Can Exceed can now use a % threshold, as budgets already can.
- All inventory transactions now count toward a capital project's remaining balance, not just appear in its CapEx buckets.
- Capital project balances now count contract release amounts instead of the full contract amount. This prevents out-of-balance errors as documents move between types.
- Capital project spending limits are now enforced when the project is assigned only on the document lines, not the header.
- On Manage Budgets, the Expenditure section now follows the budget's date setting, using the Required date when the budget is set to it.
- For the WD invoice interface, adjustment invoices are now identified using active invoice lines only.
Inventory
- New: During a physical count, an item scanned that doesn't exist in that inventory can now be added directly from the scanner at that time, along with its count. No more photos or separate spreadsheets after the count.
- Department count guides no longer accept duplicate items, which led to double counts and spend data on reports.
- Closed physical counts still show items whose storage location was changed after the count was finalized.
Administration, Settings and Scheduled Jobs
- Settings has a new page with the download link for the latest mobile app.
- A new Approval Notification Sender job can email chosen recipients when procurement requests in selected departments are fully approved.
- The Document Cleanup job can email you when it closes a document, with more scheduling flexibility.
- The PO Emailer job has a Buyer option, so buyers can receive internal copies of their own POs.
- EDI price change emails now show the price change as a percentage only.
- The Approval Clean Up job no longer restarts the application when it runs, which has caused intermittent errors.
- The On Order Cleanup job is no longer available in the scheduled jobs list. A more efficient database job replaces it.
- Expired passwords, invoice amounts that differ from the calculated amount, and WD invoice export XML messages are now logged as warnings, not errors.
Reports
- When you click Run Report, the page now shows that the report is running, so you don't need to click again.
New Reports
- EDI Pricing File Reconciliation: Reviews the latest EDI 832 pricing file: matches, unit issues, unmatched items, price changes since the last file, and last purchase price. Found under Reports > Administration > EDI.
- Procurement Spend Analytics: Supplier spend grouped by department, supplier or commodity.
- Supplier Last Purchase (Purchase History): Supplier details, status and contact with the last purchase date, to help review inactive suppliers.
- Transactions By Type/Date/Supplier (Purchase History): Procurement transactions filtered by type, date and supplier.
- Invoice Match with Account Summaries (Custom Reports): Three-way match information with account summaries as shown on a printed invoice.
- Physical Inventory Count - Mobile Upload: Mobile app count uploads compared with the counts recorded in the system.
- Storage Areas: Every storage area, whether it is occupied, primary or secondary, and how many items it holds.
- Inventory Issues By Item: Ordered quantity per item split into open, closed and deleted, with drill-down to documents.
- RTL POS Export Log: Item exports sent to the POS, mirroring what the POS received.
- Outlet Sales by Vendor & Item: Line-level retail sales by outlet, vendor and item attributes.
Updated Reports
- Purchase Order Receipt: Shows the warehouse delivery signature and warehouse dock notes.
- Delivery Sheet: Shows the alternate unit for any variable-weight item, matching the receiving screen.
- Inventory Document (IDOC): Shows deleted lines, clearly marked, once a document is closed; Created time uses the property time zone; prints for all customers.
- Contract print: Uses the receiving area set on the contract first.
- Month End Check List: Timestamps use the property time zone instead of UTC.
- JE Support Open Receipts/Accruals: Longer document numbers fit in the Document # field.
- Payment Information: New supplier, date range and All / Paid / Unpaid filters.
- Invoice Listing: Shows the date and time each invoice was created.
- Cap-Ex Project Purchase Summary: New Building Enhancement column.
- Open P.O.s by Due Date: New version supports scheduled runs with a fixed begin date.
- Top 100 Moving Items, and Top 100 Moving Items by Commodity: Product detailed description added.
- Procurement Documents Data (Custom Reports): Includes requests that have no supplier.
- Stock Requisitions Listing: Includes stock transfers, with a document type filter and the correct from and to departments.
- Department Count Summary: Grouped by department, then commodity, with drill-down to items.
- Receipts By Location & Date: Shows primary and secondary storage locations for put-away.
- Inventory Charges Grouped by Item: Item spec added to the item description.
- Physical Inventory Variance: Commodity and supplier added to the horizontal view.
- User System Access Role Assignments: Includes the newest system access roles.
- User Role Assignments: New user status filter.
- Supplier Item References Matrix: New status filter for supplier items.
- Change Tracking - Items: Terms column always shows, even when no items have terms.
- RTL Inventory Balance: Global totals, column labels and parameter fixes.
- PO Delivery Tracking: Supports item codes up to 20 characters.
- POS Item Sales Summary: No more duplicate lines for items with several POS SKUs.
- Document Approval Reminders: Days waiting reflects the line still pending approval.
- Procurement Document Reference Tracking: Includes documents that don't start from a procurement request.
- Customer Retail Report: Updated for the RTL portal.
Operational Notes
- The On Order Cleanup job has been removed from the scheduled jobs list and replaced by a more efficient database job.
- Capital project balances now count contract release amounts instead of the full contract amount.
- Documents with negative amounts route through every approval level based on the absolute amount.
- Expired passwords, invoice amount differences and WD invoice export XML messages are now logged as warnings, not errors.
- Each change in the table below has a reference number in the Key column. If you have a question about a change, include that number when you contact Support.
Included in Release Notes
The items below are the issues in this version marked for release-note inclusion.
| Area | Key | Release Note Item |
Procurement |
SAMDEV-3300 |
Limited Property Terms and Conditions attachments to external emails. |
Procurement |
SAMDEV-3597 |
Added Terms Amount and Extended Amount columns to inquiry grids, including All Documents and the approval grids. |
Procurement |
SAMDEV-3841 |
Fixed the entered supplier and price being lost when adding a supplier to a misc item line. |
Procurement |
SAMDEV-3849 |
Copied procurement requests now rebuild accounts from the current setup. |
Procurement |
SAMDEV-3870 |
Filtered the purchase order capital project picker by the document's property. |
Procurement |
SAMDEV-3891 |
Fixed the Process & Finalize email user search to match first and last name together. |
Procurement |
SAMDEV-3898 |
Restored the Create from Order Guide button on Request from Guide. |
Procurement |
SAMDEV-3905 |
Fixed the price origin being lost when resetting pricing on a purchase order. |
Contracts |
SAMDEV-3857 |
Restored expired contracts in simple search results. |
Contracts |
SAMDEV-3892 |
Added partial-word matching to item search on Open Direct Receipts and Open Releases. |
Contracts |
SAMDEV-3924 |
Removed ended contracts from Manage Contracts. |
Receiving |
SAMDEV-3846 |
Added an item search box to Receive a Contract. |
Receiving |
SAMDEV-3871 |
Added the receipt (RV) number to delivery confirmation emails. |
Bids |
SAMDEV-3908 |
Added item master supplier item numbers to Bid Pricing Maintenance. |
Approvals |
SAMDEV-2502 |
Fixed auto advance skipping the final approver on a route. |
Approvals |
SAMDEV-2598 |
Added Reference Documents and Transmission Status tabs to Approve Document details. |
Approvals |
SAMDEV-3240 |
Removed deleted departments with no approval routes from Approval Routes. |
Approvals |
SAMDEV-3720 |
Fixed the error when processing a request whose only approver is on vacation. |
Approvals |
SAMDEV-3747 |
Fixed negative-amount documents skipping approval levels. |
Approvals |
SAMDEV-3756 |
Routed $0 documents through approval when a route has a $0 Notify Only level. |
Approvals |
SAMDEV-3854 |
Applied the route Dollar Limit Behavior to merged approvals combined with Notify Only. |
Approvals |
SAMDEV-3869 |
Restored dollar limit approvers when unmerging from commodity-level entity approvals. |
Approvals |
SAMDEV-3877 |
Extended Approval Find and Replace to entity, property and company approvals. |
Approvals |
SAMDEV-3881 |
Orphaned Approvals clean-up now clears approved documents left in approval queues. |
Approvals |
SAMDEV-3883 |
Fixed full approval of requests an approver creates under their own approval limit. |
Approvals |
SAMDEV-3904 |
Fixed approval route reset when clearing the Use Setting of option. |
Finance |
SAMDEV-3814 |
Enforced capital project spending limits when the project is assigned only on document lines. |
Finance |
SAMDEV-3833 |
Fixed the Manage Budgets Expenditure section to follow the budget's date setting. |
Finance |
SAMDEV-3855 |
Added a % threshold for capital projects set to Can Exceed. |
Finance |
SAMDEV-3867 |
Changed capital project balances to count contract release amounts instead of the full contract amount. |
Finance |
SAMDEV-3875 |
Fixed WD invoice interface adjustment invoice detection to use active invoice lines only. |
Finance |
SAMDEV-3886 |
Counted all inventory transactions toward a capital project's remaining balance. |
Inventory |
SAMDEV-3738 |
Fixed items missing from closed physical counts after a storage location change. |
Inventory |
SAMDEV-3798 |
Added the ability to add items that are not in the inventory, with their count, directly from the scanner during a physical count. |
Inventory |
SAMDEV-3828 |
Blocked duplicate items on department count guides. |
Administration |
DAT-641 |
Changed EDI price change emails to show the percentage change only. |
Administration |
DAT-652 |
Added a Buyer option to the PO Emailer job. |
Administration |
DAT-653 |
Added close notifications and more scheduling options to the Document Cleanup job. |
Administration |
DAT-658 |
Added the Approval Notification Sender scheduled job. |
Administration |
SAMDEV-3901 |
Added a Settings page with the latest mobile app download link. |
Administration |
SAMDEV-3915 |
Retired the On Order Cleanup scheduled job in favor of a database job. |
Administration |
SAMDEV-3916 |
Stopped the Approval Clean Up job from restarting the application. |
Administration |
SAMDEV-3921, SAMDEV-3922, SAMDEV-3923 |
Changed expired password, invoice amount difference and WD invoice export XML messages to log as warnings. |
Reports |
DAT-584 |
Updated Document Approval Reminders: days waiting reflects the line still pending approval. |
Reports |
DAT-640 |
Updated Customer Retail Report: updated for the RTL portal. |
Reports |
DAT-647 |
Updated Contract print: uses the receiving area set on the contract first. |
Reports |
DAT-649 |
Updated POS Item Sales Summary: no more duplicate lines for items with several POS SKUs. |
Reports |
DAT-650 |
Updated PO Delivery Tracking: supports item codes up to 20 characters. |
Reports |
DAT-659 |
Updated Physical Inventory Variance: commodity and supplier added to the horizontal view. |
Reports |
REP-581 |
Updated Procurement Document Reference Tracking: includes documents that don't start from a procurement request. |
Reports |
REP-606, REP-607 |
Updated Top 100 Moving Items, and Top 100 Moving Items by Commodity: product detailed description added. |
Reports |
REP-610 |
Updated RTL Inventory Balance: global totals, column labels and parameter fixes. |
Reports |
REP-611 |
Added the Procurement Spend Analytics report. |
Reports |
REP-614 |
Updated JE Support Open Receipts/Accruals: longer document numbers fit in the Document # field. |
Reports |
REP-617 |
Updated Month End Check List: timestamps use the property time zone instead of UTC. |
Reports |
REP-618, REP-624, DAT-648 |
Updated Inventory Document (IDOC): shows deleted lines, clearly marked, once a document is closed; Created time uses the property time zone; prints for all customers. |
Reports |
REP-619 |
Updated Supplier Item References Matrix: new status filter for supplier items. |
Reports |
REP-625 |
Added the Inventory Issues By Item report. |
Reports |
REP-626 |
Updated Delivery Sheet: shows the alternate unit for any variable-weight item, matching the receiving screen. |
Reports |
REP-627 |
Updated Inventory Charges Grouped by Item: item spec added to the item description. |
Reports |
REP-629 |
Added the Storage Areas report. |
Reports |
REP-631 |
Updated Change Tracking - Items: terms column always shows, even when no items have terms. |
Reports |
REP-632 |
Updated Receipts By Location & Date: shows primary and secondary storage locations for put-away. |
Reports |
REP-633 |
Added the Outlet Sales by Vendor & Item report. |
Reports |
REP-634, REP-639 |
Updated Stock Requisitions Listing: includes stock transfers, with a document type filter and the correct from and to departments. |
Reports |
REP-635 |
Updated Department Count Summary: grouped by department, then commodity, with drill-down to items. |
Reports |
REP-636 |
Updated Cap-Ex Project Purchase Summary: new Building Enhancement column. |
Reports |
REP-638 |
Updated Procurement Documents Data (Custom Reports): includes requests that have no supplier. |
Reports |
REP-640 |
Updated Payment Information: new supplier, date range and All / Paid / Unpaid filters. |
Reports |
REP-643 |
Added the Supplier Last Purchase (Purchase History) report. |
Reports |
REP-644 |
Added the Invoice Match with Account Summaries (Custom Reports) report. |
Reports |
REP-645 |
Added the RTL POS Export Log report. |
Reports |
REP-646 |
Updated User Role Assignments: new user status filter. |
Reports |
REP-648 |
Updated User System Access Role Assignments: includes the newest system access roles. |
Reports |
REP-650 |
Added the Physical Inventory Count - Mobile Upload report. |
Reports |
REP-652 |
Updated Open P.O.s by Due Date: new version supports scheduled runs with a fixed begin date. |
Reports |
REP-654 |
Updated Invoice Listing: shows the date and time each invoice was created. |
Reports |
REP-655 |
Added the Transactions By Type/Date/Supplier (Purchase History) report. |
Reports |
REP-656, DAT-643 |
Updated Purchase Order Receipt: shows the warehouse delivery signature and warehouse dock notes. |
Reports |
REP-666 |
Added the EDI Pricing File Reconciliation report. |
Reports |
SAMDEV-3902 |
Added a running indicator after clicking Run Report. |