Solved

We’re getting ready to switch our ecommerce site to Shopify and I am in the process of trying to export our open non-web orders to the site so customers can see their order status.  We’re on 23R1 for now (planning on upgrading after this migration).  We’ve setup a new order type for orders being imported from Shopify (WB).  I have also configured an existing order type (SB) that we want to export.  The sales order entity is configured for a bi-directional sync direction.  After running some tests on a handful of our open SB orders, they’re being exported as expected and at first glance everything is working great.  However, after these SB orders get created in Shopify, the connector sees that they have been modified externally and the next time I process one of them a bunch of fields get updated in the ERP that we do not want to change.This list is not exhaustive but here are some changes I am seeing happen after the re-import:Both the Order date and the Cancel By date get changed from

What would cause the following behavior? Everything prints except the document details (Customer details, line items, etc.). It started occurring after a recent update to 2022 R2 Build 22.218.0023. We are using Device Hub when processing the print. The printers are set in the users profile. 

Hello all,Can anyone guide me on how one can make use of Acumatica for cheque printing. I am looking out for start till end steps & how to test it & process in real scenario.Thanks.

i am not able create check after upgrade acumatica in october 2024got this error{"message":"The request is invalid.","modelState":{"":["An exception occurred during input parsing"]}}please suggest me but missing my endpoint https://local//entity/Acumatica/1.0.3/Checkjson body this {"CuryOrigDocAmt":{"value":0},"CashAccount":{"value":"10060"},"Type":{"value":"Check"},"Vendor":{"value":"V001097"},"CurrencyID":{"value":"USD"},"Hold":{"value":false},"PaymentAmount":{"value":10.19},"PaymentMethod":{"value":"CREDITCARD"},"Details":[{"CashAccount":{"value":"10060"},"PostPeriod":{"value":"102024"},"BranchID":{"value":null},"InventoryID":{"value":null},"OrderQty":{"value":0},"WarehouseID":{"value":null},"AmountPaid":{"value":10.19},"Balance":{"value":10.19},"CashDiscountBalance":{"value":null},"DocType":{"value":"Bill"},"ReferenceNbr":{"value":"001301"}}],"PostPeriod":{"value":"102024"}}

Hi,I customized a ARM Balance Sheet Report to reflect 6 different branches at a time. What formula can I use in each column to pull the branch name automatically versus having to input manually for each colums? Here is a snapshot of the column set and highlighted fields.   Thanks,Frances   

Scenario: Issuing a Bill with a 5-Step Approval Flow A company, prepare bill to customer and needs approval before processing the payment.🔹 Approval Steps:1️⃣ Step 1: Accountant Review – Checks bill details and submits for approval.2️⃣ Step 2: Finance Manager Approval – Verifies bill accuracy and compliance.3️⃣ Step 3: Department Head Approval – Confirms budget availability.4️⃣ Step 4: General Manager Approval – Ensures approval for major expenses.5️⃣ Step 5: CEO Final Approval – Authorizes high-value payments before processing. Thanks in Advance  

Hello, I have a GI where add new button is not working. If I click the button nothing happens. It works well for all other GIs. Is there any change that I can do in the GI?I have attached the GI here.

Every time I try to search a customer or phone number with the universal search, I receive an error message. We have tried restarting the full-text search, cleared the cache, processed all in the rebuild full-text entity index, rebuilt a new database for my site, upgraded to the most recent version, and applied a new license. The problem still persists. 

I have two custom fields Absolute Variance Quantity for rows and Total Absolute Variance Quantity in the header. I can get these fields to update via PI Review and Scan and Count just fine, but when I do an action such as Set Not Entered To Zero, the custom header field won’t update.Here, the only value that got send to the custom header field was the first line (21), but the header field should be close to 101,772Here is my code for the field definitions and this screen:INPIHeaderExt.usrTotalAbsVarQty[PXDBQuantity][PXDefault(TypeCode.Decimal, "0.00")][PXUIField(DisplayName = "Total Absolute Variance Qty.", Visibility = PXUIVisibility.SelectorVisible, Enabled = false)]INPIDetailExt.usrAbsVarQty[PXDBQuantity()][PXUIField(DisplayName="Absolute Variance Quantity", Enabled = false)][PXFormula(null, typeof(SumCalc<INPIHeaderExt.usrTotalAbsVarQty>) )] Code Editor: INPIReview (Physical Inventory Review)using System;using System.Collections;using System.Collections.Generic;using System.L

For example, M &T Bank as bank name is rejected when entering data.  A developer can change the regular expression to “fix” this but will this cause issues with banks?

I have a customer with a credit balance on their account. They have called requesting we issue them a check for this amount, to bring their account with us to a zero balance.  How do I do this?

I am trying to pull a report for my client that shows all activities for Journal Entries including the workflow entries. I have already mapped in generic inquiries the audit history to GL Batch and EP Approval using the combinedkey, but I noticed the rejection in the Audit history has a GLBatch combinedkey and not a EPApproval Approval ID. This indicates that the record is only recorded in the audit history table and doesn’t have any corresponding entries in EPApproval.Is there anywhere in the system that the rejection reason is recorded and kept after the JE has been approved or deleted? The system is version Build 24.111.0011.Thanks!

Is it possible to remove a report completely from Acumatica if it was saved to the server by using the command “Save to Server” in Report Designer.I tried searching for the reports in the Acumatica folders including ReportsDefault but coming up empty.I assume it is located somewhere in the database. Much thanks

Hi, I have a report generated from the report generator. How do I add this new report to the Inventory menu group? Thanks,

Hi,In Live Instance,For a Grid(Form-Tabs screen) I am  Trying to add around 30 lines.Up to 28 lines Data got Entered..When we are trying to Enter 29th line Getting Below ErrorThe Page was not displayed Because the Request Entity is too large. In our Local Instances we are not getting this type of Issue.What are the changes need to do to Solve this in Live Instance?How can I replicate this Issue in Local to debug the code?Thanks,Giri. 

I have a list of BoMs and their revisions that I would like to archive. Seems PRETTY straight forward but I keep getting a “Document” error during my import. Error: 241 items have not been processed successfully. View name: Documents.

We want to integrate the maps with Acumatica to display the order coordinates based on shipping addresses. Our goal is to sequence the orders according to the shortest route and visually represent them with numbered stops on the map. We would appreciate any insights on how to achieve this efficiently.

Could anyone provide a screenshot of a Row Set Import Scenario for ARM Reports? I am just a little confused on how the Data Source portion works. We normally just setup the reports manually, but this is our first customer who has several hundred lines per report so we would much rather import the bulk. The Data Sources will be “Start Account”, “End Account”, “Start Sub”, and “End Sub”. 

I have a ACH Payment Business Event going and I need a way to show multiple RefNbr (Invoice)on the Notification Template Email that goes out. Single Invoice Paid in a Batch Payments I have no problem it when I select Multiple Invoices.What is the formula to show multiple invoices on a email notification for ACH Payment?Here is what I am working withA ((Document.PaymentMethodID)) Payment has been made by ADMAR Construction Equipment & Supplies.Payment Reference Number: ((Document.RefNbr))Payment Date: ((Document.RefNbr.DocDate))Payment Amount: ((Document.CuryOrigDocAmt)) Vendor Ref: ((Adjustments_print.AdjdRefNbr))   ← this works with 1 invoice in a batch and shows the Invoice Ref # we need to showI tried this below but it breaks the Business Event.<foreach view="APPost"> ((APPost.SourceRefNbr)) - ((APPost.SourceRefNbr)) </foreach>Anyhow if anyone has any ideas that would be great. Thank you 

Is there any latest help document how to integrate Okta with Acumatica.

Hi Everyone,I am currently working on a Generic Inquiry to display stock items along with their quantities on hand across all warehouse locations. I have managed to achieve the desired results by grouping the data using “InventoryItem.InventoryCD” to eliminate duplicates. However, I face a challenge when I attempt to use the GI in a business event that is meant to inactivate items once the quantity on hand reaches zero. The business event works correctly when I remove the grouping from the GI. Can anyone suggest a solution for this issue? I have attached the GI for your reference. 

Hello,I am trying to limit the available values for an attribute based on a value selected for another attribute.Eg: If user select TOYOTA in the Make Attribute, the Model attribute shows only the models for TOYOTAIs there a way to achieve this?

What do I do with outstanding deposits in ACU?  I don’t see it addressed in the cash mgmt pdf’s.

When emailing invoices through the ‘Print Invoices and Memos’ screen, the invoices get marked as ‘Emailed’ even if the process encounters errors and the emails do not send.The emailed status should only be updated to ‘Emailed’ once the email is successfully sent and not when the process errors out.

I’ve been trying to find an estimate for when the Acumatica Interactive Courses on the Open University will be available again. Can’t seem to find a firm time estimate. Anyone have any info on the matter?