What you may have missed in the Acumatica Community! December, 2022

Dear Community Member,

With so much going on in the Acumatica Community I have consolidated recent activities in case you missed anything.

Connect, Learn and Share

Community Introductions

A place to share with fellow community members about yourself and what your company does.

Tell the community about yourself and meet other members HERE

Product update announcements

Acumatica 2023 R1 Preview 2

Acumatica 2022 R2 Update 6 Build 22.206.0035

Acumatica 2021 R1 Update 28 Build 21.128.0009

Acumatica 2021 R2 Update 21 Build 21.221.0019

Acumatica 2022 R2 Update 7 Build 22.207.0013

Acumatica 2022 R1 Update 17 Build 22.117.0016

Tech tips and helpful information

Known issue: On the Purchase Orders form, if a purchase order of the Normal type was completed and then reopened, it was impossible to clear the Completed check box for a purchase order line linked to a sales order and not yet received

How to create a tax adjustment

Known issue: In Acumatica ERP 2022 R2 and earlier, the system incorrectly processed the scenario, when a user removed allocation for a lot/serial tracked material item in a production order

Known issue: In Acumatica ERP 2021 R2, customer refunds created for deposited AR payments were not shown on the Bank Deposits form

Term "local host" will not post without the space between words

Known issue: In certain updates of Acumatica 2022 R1 and 2022 R2, the screen never loaded when a user opened some of the Field Service forms

Known issue: If a user reversed an invoice by using the Reverse and Apply to Memo action and then increased the period of the reversing credit memo without changing its date, a balance discrepancy appeared for the customer

Known issue: In some cases, if the Project-Specific Inventory and Manufacturing features were enabled, the available quantity shown at the bottom of the Sales Orders form was calculated incorrectly and users could not confirm shipments

How to hide columns outside the range of Start and End periods on ARM report

How to resolve the 'Error rendering Control - usrCaption. An unhandled exception has occurred.' error on a user's attempt to add new page ListView template on the site project of Acumatica Framework solution

How to import orders from Shopify for Canadian orders where more than one province has same tax code

Known issue: In Acumatica ERP 2022 R2 and earlier, in some cases, on the Payments and Applications form, when a user clicked Record Card Payment action in a released payment or prepayment, nothing happened

Known issue: Users could not select the Mark for Production check box in sales order lines, if the related sales order type had the automation behavior of the Quote type

Known issue: In certain updates of Acumatica ERP 2022 R1 and 2022 R2, when a user attempted to execute an action after several navigations between different forms, in the same browser tab, the 'Error: 'FieldName' cannot be empty' error could occur

Known issue: In some cases, when a user initiated automatic payment application on the Auto-Apply Payments form, the 'The value to be entered must be greater than or equal to 'Period ID + 1'' error could occur

Known Issue: In Acumatica ERP 2022 R2 and 2022 R1, in some cases, if a user changed the class of a fixed asset on the Fixed Assets form, the asset balance was doubled in the FA Balance by GL Account report

How to resolve the 'Object reference not set to an instance of an object' error when running Update Taxes action on the Payroll Tax Maintenance form

How to resolve the 'Could not load type 'PX.Payroll.Data.ISettingDefinition' from assembly 'PX.Payroll'' error during publishing a customization project or opening Payroll module forms in Acumatica ERP 2022 R1

Known issue: In Acumatica ERP 2021 R1 and earlier, in some cases, on the Recalculate Customer Balances form, the recalculation process could close credit memos and customer refunds, if they were applied to each other

How to resolve a connection error when a user initiates the shipment processing using Acumatica Smart Shipment Integration in Microsoft Edge (Chromium) or in Google Chrome, Version 108 and later

How to add a side panel by using workflow API

Known issue: In Acumatica ERP 2022 R2 and 2022 R1, in some cases, when a user tried to generate an appointment or service order from a service contract schedule, the 'Service Contract cannot be found in the system' error occurred

How to resolve the issue when the Bank Feeds-related forms added by EIS Consulting customization project remain in the site menu in Acumatica ERP 2022 R2 and later after unpublishing the customization

How to resolve the issue when the Bank Feeds-related forms added by EIS Consulting customization project remain in the site menu in Acumatica ERP 2022 R2 and later after unpublishing the customization

How to create custom actions that accepts parameters in REST API

How to display record count in tab item with a grid

How to open a form with specific tab as the visible default tab

How to specify pop-up notes by using the REST API

How to print multiple copies in the Report Designer

How to add subcontracts to bills by using the REST API

How to resolve the 'Cannot resolve the table name: [PX.Objects.AR.ARStatementAdjust]' error on custom customer statement forms after Acumatica ERP has been upgraded to version 2022 R2 or later

How to ensure two-factor authentication emails are immediately processed

How to set up out-of-the-box CRM side panels for customized primary lists in Acumatica ERP 2021 R1 and later

How to create an adjusting entry to debit/credit foreign currency GL account linked to Cash account, to a base currency GL account

How to display Total values of already rounded values on ARM reports

How to resolve the 'The entered BOM ID exists' error on an attempt to copy the current bill of material to a new bill of material

How to create a new revision of a particular bill of material

Known issue: In rare cases, during an upgrade to Acumatica ERP 2022 R2, the following error could appear: 'Cannot insert the value NULL into column 'RefNoteID', table 'DatabaseName.dbo.ARStatementDetail'; column does not allow nulls. UPDATE fails'

Known issue: If a paycheck was created on certain builds of Acumatica ERP 2021 R2, 2022 R1, or 2022 R2, and then the instance was upgraded to a later version, no journal transactions were created during the release of the paycheck after the upgrade

Known issue: In Acumatica ERP 2022 R2 and earlier, in some cases, on an attempt to release an invoice or open the Unreleased AR Documents report, the 'An error occurred during processing of the field Margin: Conversion overflows' error could occur

Known issue: In Acumatica ERP, District of Columbia and Pennsylvania US states are not added to the CF/SF Program for the 1099-MISC Electronic Filing

Known issue: In Acumatica ERP 2022 R2 and 2022 R1, in some cases, in an attempt to release a move or labor transaction with a corresponding inventory transaction in the Balanced status, the 'Error: 'TranDate' cannot be empty' error could occur

How to print a text or an image indicating an invoice is being reprinted

How to prevent Acumatica ERP Sales Orders and Invoices from recalculating the taxes imported from external systems such as BigCommerce, Shopify, Amazon etc.,

1099-MISC and 1099-NEC updates for Tax Year 2022

Ask a Question, Get an Answer - January 2 - January 6, 2022 - we could use some extra help this week!

Known issue: On the Time and Expense Preferences form, if a user had more than 100 custom weeks for a year, when a user attempted to generate custom weeks for a subsequent year, the 'Another process has added the 'EPCustomWeek' record' error occured

Newsletters

Acumatica Customer Newsletter - December 2022

Acumatica ISV Newsletter - December 2022

Acumatica Newsletter - December 2022

Acumatica Partner Newsletter - December 2022

Don’t miss! - Upcoming events

How R&I Industries Streamlines Fabricated Metal Operations with Acumatica Manufacturing Edition - Wed, Jan 11, 11:00 AM - 11:45 AM

Why Acumatica Cloud ERP Outshines Oracle NetSuite - Tue, Jan 17, 11:00 AM - 12:00 PM

Tips and Tricks: Distribution Edition - Wed, Jan 18, 11:00 AM - 11:45 AM

Modernize Manufacturing Operations with a Comprehensive, Multi-Modal System - Tue, Jan 24, 11:00 AM - 11:45 AM

Retail Tools to Strengthen Customer Experiences - Thu, Jan 26, 11:00 AM - 11:45 AM

Acumatica Summit 2023 - Jan 29 - Feb 3, 2023

Did you miss? - Past events

Rethinking Your Current ERP’s Impact: Why Acumatica Cloud ERP Outshines QuickBooks - Tue, Dec 6, 10:00 AM - 10:45 AM PT

Modernize Manufacturing Operations with a Comprehensive, Multi-Modal System - Wed, Dec 7, 10:00 AM - 10:45 AM PT

How to Recession-Proof Your Construction Business - Thu, Dec 8, 10:00 AM - 10:45 AM PT

Expedite the Engineering to Manufacturing Hand-off with Connected Product Lifecycle Management - Tue, Dec 13, 11:00 AM - 11:30 AM PT

Automated Inventory and Order Management with Acumatica Distribution Edition - Thu, Dec 15, 10:00 AM - 10:30 AM PT

Building a Solid Foundation for your Construction Business - Tue, Dec 20, 10:00 AM - 10:45 AM PT

Smart Supply Chain Strategies for SMBs - Wed, Dec 21, 10:00 AM - 10:45 AM PT

Power Work Forward with Exceptional Usability in Acumatica Cloud ERP - Tue, Dec 27, 10:00 AM - 11:00 AM PT

Retail Tools to Strengthen Customer Experiences - Wed, Dec 28, 10:00 AM - 10:45 AM PT

That's it for now folks but I'm sure there will be a lot more soon! Take a moment to get in on the questions, conversations and ideas in the Acumatica Community and make your voice heard!

Regards,