ECOMMR-4719 – Opening Statements in Account Area Issue Resolved (SPEC Only).
A customer noticed that when they tried to open statements using the Job Summary Remit Only setting in the Account area, and they tried to print the statement, they received the message:
The selected statement did not print as expected. This occurred in Spruce and in Spruce eCommerce. We corrected this issue to ensure that Job (Summary and Remit Only) statements print as needed on both platforms.
LBMHR-278 – True Value Limited Use Coupon Issue Resolved.
When applying a True Value Limited Use Coupon to a sales transaction, the application applied the coupon before assessing whether the total amount met the coupon criteria. We updated this process to ensure the coupon validity assessment is completed before we apply the coupon to the transaction.
LBMHR-773 – Update Ensures Specified Users cannot Change Card on File Settings for Accounts. There is a security setting in the User ID form that prevents unauthorized users from changing the Card on File (COF) settings for an account. When this setting, Restrict Prompts to Add/Replace Card on File is enabled, it should prevent that user from changing the COF settings for a customer. However, during the checkout process for a customer with a COF, when the application detected the COF account setting, the system prompted the user to ask if the customer wanted to make a change in the card. This was true, even if the user’s COF setting above was enabled. We have updated the checkout process to prevent this prompt from displaying. Qualified users can add or change an account’s card on file settings using the Payments > Add Card on File only.
LBMHR-1325 – Changes Prevent Future Branch-Specific AP Billing Posting Issues.
When reversing an AP Billing document from a branch different than the transaction’s original branch, the system incorrectly posted the reversal (Vendor Credit) to the current user's branch AP GL account rather than the original AP billing branch GL account. This caused GL accounts to be off balance, which were caught in the resulting AP Aging reports, and created branch-level AP discrepancies in the data. This required manual journal entries to correct, which were time-consuming.
We updated our AP billing reversal logic to ensure that the application retrieves the original AP billing document‘s GL account and ensures that the Vendor Credit reversal posts to the same AP GL account used in that original billing document. We also added additional validation to ensure that the original document’s branch GL account is used in this processing. We are implementing additional safeguards to prevent the current session branch from overriding historical document branch data. We have added additional logging to track these types of reversals across branches and now include GL account validation to ensure we are offsetting entries correctly to maintain branch consistency.
LBMHR-1677 – Updating POS Assured Transactions to Reflect Cash Drawer Assignments. When your internet connection goes down, you can continue processing transactions using POS Assured. When your internet service is restored, POS Assured uploads the transaction data to your cloud instance and makes it available for import. In the past, these transactions were not assigned to any specific cash drawer because the expectation was that the software would assign the cash drawer based on the station that imports the transactions during the invoicing process. This caused issues in the End-of-Day reconciliation process because the transactions were attributed to the wrong cash drawers.
To resolve this issue, we added new code that ties the user’s cash drawer assignment to each transaction. If the user does not have a cash drawer assignment, but the station that submits it has an associated cash drawer, the transaction uses the cash drawer assigned to that station instead.
LBMHR-1762 – Database Error Caused by Cost Corrections Issue Resolved with Better Messaging. A customer reported that their database experienced a lock time-out when two people attempted to process routine inventory cost corrections simultaneously. After some investigation, we found that while these users were working on different cost correction records, the two items were related because the new cost correction was based on an earlier related cost correction receipt. To manage the issues we found, we made the following changes to prevent the database error:
No Cost Corrections over a Year Old Allowed
When a user attempts to update a receipt to add a cost correction, and the receipt is over a year old, a new message displays, and the Document ID field that contains the old receipt clears:
By design, the application will only display receipts that are less than a year old.
New Process for Cost Corrections Receipts to Identify Earlier Cost Corrections that Require Update.
If a user selects a receipt to make a cost correction, the application searches for any related inventory receipts to determine whether they require updates as well. When a prior receipt does require an update a new message displays:
This allows the user to choose to review and update the previous (related) receipt or to continue without updating it.
-
If the user chooses Yes, the application processes the new receipt as is already specified and updates the older cost correction receipt with the new cost correction amount. Both receipts contain the current date.
-
If the user chooses No in this case, the application only processes the cost correction for the newly selected receipt, not for the older one. The new receipt contains the current date, and the older receipt is unchanged.
Note: If the user chooses No, when the End of Day (EOD) process runs for the inventory, and the Needs Update cost correction exists for the process date, the application will not create journal entries for any documents with “needs update” in the details.
LBMHR-1796 – Do It Best BOPIS Parameter No Longer Disabled by Mistake.
A customer reported that when someone without administrator credentials accessed the EDI parameter settings and clicked Process (F12), this action disabled the Do It Best BOPIS setting. We corrected this issue to ensure that even if a user with these permissions accessed the EDI parameter tab and selected the Process key, no changes would occur.
LBMHR-2292 – Updates to the Numbering Process Improve Job ID Creation.
Customers have asked us to update the automatic job-numbering process when a new job is created in Point of Sale and Receivables. In the past, if someone added an out-of-sequence job ID manually, the application would use that ID to create the next job ID in the sequence by default. For example,
-
For the ABC Construction account, if the existing job IDs were 0, 1, and 2, and someone added a new job ID of 12345, the next time someone added a new job, the application would set the new ID to 12346 by default to keep them in sequence.
This caused issues when someone added a new job ID that was 99999999, because you cannot add a higher job ID.
To resolve this issue, whether you add a new job ID in the:
-
Point of Sale Delivery tab, as when you process a Sales and Orders transaction, or
-
Job Maintenance form (via Point of Sale > Database > Job or Receivables > Database > Job)
The application will now increment the job ID automatically based on the last automatic sequential entry. So, in the ABC Construction example above, if you add a new job to the account, the application will set the new Job ID to 3 by default. Users can still add a custom Job ID manually if they choose. The application will still prevent a user from adding a duplicate Job ID for the same account.
LBMHR-2321 – True Value Local Inventory Daily Transmission Restored.
A customer reported that the True Value local inventory daily send report (SPEC 98) was not transmitting as usual. This information is critical for updating the customer’s ecommerce sites with item details, including current quantities. Customers were subsequently able to send this report manually as a workaround. It appears this occurred because many companies submitted their SPEC data simultaneously. We updated the code to ensure the True Value system processes these reports correctly.
LBMHR-2414 – Branch Issues Associated with Online BOPIS Orders Resolved.
When a customer places an online BOPIS order, and the ordered materials are not in the Master Branch, the application should accurately associate the transaction amount and inventory data with the branch from which the materials were purchased. Some Totals reports showed that sale amounts for some BOPIS orders were appearing in two branches: the branch where the item was located and the Master branch. We have corrected this issue to ensure that reports that include BOPIS orders accurately reflect the invoice and inventory records in the application.
LBMHR-2535 – Validating Do It Best BOPIS Invoices Process Updated.
Previously, when a tax-exempt customer placed a Do it Best BOPIS order, the application correctly removed the tax from the order. However, when the Release request was received (when the customer picked up the item or had it delivered), to finalize the invoice, the system's validation logic compared the tax-free invoice total against the original web request total (which still included tax). This mismatch caused a "Remittance Amounts Incorrect" error, preventing the invoice from processing automatically. We have updated the validation process to compare the order subtotal rather than the grand total. This ensures that invoices process successfully for both tax-exempt and taxable transactions by focusing on the base price of the ordered items.
LBMHR-2684 – Interim Statements Showing Account Payments Correctly Again.
In the last release, we attempted to fix how credits display, but inadvertently omitted payments when the interim statement was generated. We have adjusted the logic to ensure that the full payment amount posted in the current billing cycle displays, and that the application properly subtracts that amount from the Net Amount Due. This ensures that the interim statements generated during the current billing cycle display the correct account balance information.
32.0 Release