Solved

There’s many times I need to do an entry to hit a direct customer’s account in AR or vendor’s account in AP.  How can I do this in Acumatica?  Here’s a screenshot of an example how I used to do it in Quickbooks: 

Currently on 21R1, in the process of upgrading to 22R2 - is it possible in 22R2 to map product Sales Categories to a product/variant metafield in Shopify?

Running into an error that the transaction getter is not working, yet we have everything turned on in the processing center. Are we missing something? See images...

Dear Sense,I have a 7GB SnapShot file from Acumatica Cloud. I want to migrate it to my local laptop, but I don’t have access to the Acumatica database because it’s hosted in the cloud. Can you help me migrate my data to my local laptop?Please Help

I’m looking for a stand alone document scanner for use in shipping to scan all documents that go into the box and then attach it to the shipment as a PDF file.I’ve tried a couple of different scanners (Lexmark and Kyocera) but they are not standalone and the TWAIN software does not play well with device hub as both require user input on the scanner and never sends the scanned document back to device hub. Any recommendations of scanners that have worked for you?  I’m current running 2020 R2, planning to upgrade to 2021 R1

Just wondering if anyone might know the answer on the Customer Contract (CT301000) you can set an Expiration Date. There is also a Status of Expired but i cannot see any Action/Process that will set the Contract to Expired as the Contract will stay active. If i change the Date to be in the Past it does not update the Status 

I have the Invoices and Memos GI exposed to the mobile app.  The summary screen is dreadful.  I find it dreadful for pretty much any list view.  Once you click the record, you can make the details look really nice with headers etc.Also, what defines the fields that show up in the list view of a GI that is exposed to the Mobile App?  I can modify the fields in the Details view, but not the list view.  This may be in the help, so I will look, but since I am bugging folks with the primary question, I thought maybe someone had a quick answer that might save me a bunch of publish-wait-repeat.  :-)This is just not very helpful.  Especially if I were to add a custom field SO Order Nbr to this list.  You would not be able to tell which is the invoice number vs. Sales order number.I WANT LABELS!  😁 

Sales Order had UOM of “EA”.  This is correct.Shipment details line has UOM of “EA”  This is correctWhen I add contents to the BOX on the shipment, the UOM in the contents screen changes to the Stock Items Base UOM.   ***This is NOT correct**It converts the QTY correctly, but the UOM  on the contents subscreen should not be different than the Sales Order UOM and the shipment’s UOM.

Im trying to add this field to sales order Generic Inquiry.  Currently its duplicating the results for each line by every possible Attribute Value and not the one that is selected.  Is there an option or formula for it to display only the selected value?     

Before i log a case on this as it does not appear correct to me. I have setup a Service Contract Schedule with a Start Date of 12/1/2025 (or any date between 3/2/2025 to 12/31/2025) to reoccur every 2 years in August on saving the Next Expiration Date if 8/1/2027 which is the result i want If i change Start Date on same schedule to be 1/1/2026 up to 8/1/2026 (one month forward) the next Execution Date changes to 8/1/2026 (comes back 2 years) which does not appear correct  

Hi community,We are in the process of upgrading our customer's environment from 2024 R1 to 2025 R1. when we published our existing customization package on the 2025 R1 environment, we encountered the following validation error:[2025-09-02 11:27:41.384] Building directory '\WebSiteValidationDomain\App_RuntimeCode\'. [2025-09-02 11:27:42.797] \App_RuntimeCode\SOInvoiceEntry.cs(7): error CS0234: The type or namespace name 'Concurrency' does not exist in the namespace 'PX' (are you missing an assembly reference?) [2025-09-02 11:27:42.797] \App_RuntimeCode\SOShipmentEntry.cs(40): error CS0234: The type or namespace name 'Concurrency' does not exist in the namespace 'PX' (are you missing an assembly reference?) [2025-09-02 11:27:42.797] Compiler time, in seconds: 17.8884243 [2025-09-02 11:27:42.891] Validation failed.In the 25 R1 release notes, we noticed that the PX.Concurrency namespace was renamed/modified.PX.Concurrency was renamed → PX.AsyncHowever, we only have access to the most recen

In our warehouse our lower shelves are Forward Pick locations and upper shelves are Reserve Stock. We keep a supply of all inventory in the Forward Pick locations but any overstock that won’t fit below will go to the Reserve Stock locations. Both location types have their respective inventory marked Include in Qty Available but only the Forward Pick locations are marked as Sales Allowed. This allows a sales order to be created regardless of inventory location but will prevent the Shipment/Picklist creation if doing so would direct a picker to a Reserve Stock location.This is where the pain point is introduced. We currently utilize the “Tasks” feature in Acumatica to direct our warehouse mobile users to transfer items from Reserve Stock to Forward Pick so that shipments containing affected items can be created.Ideally we would like a proper means of creating a Transfer Order which would direct a warehouse user to transfer the items between locations.I’m wondering if this is already an o

I am using the following code to combine two reports programmatically:public PXAction<BAccount> Print1099Reports;[PXButton(CommitChanges = true, Category = "Actions")][PXUIField(DisplayName = "Print 1099 Cover", )]protected virtual void print1099Reports(){ var reportParams = new Dictionary<string, string>(); string bAccountID = Base.CurrentBAccount.Current.AcctCD; reportParams.Add("BAccount.BAccount", bAccountID); PXReportRequiredException ex = null; ex = PXReportRequiredException.CombineReport(ex, "ZRLTTX03", reportParams, false); ex = PXReportRequiredException.CombineReport(ex, "ZRLTTX04", reportParams, false); if (ex != null) { ex.Mode = PXBaseRedirectException.WindowMode.New; throw ex; }}However, the reports have different portrait/landscape orientation, and this is not taken into account. Is this possible, and if not, when will it be?

Hi Acumatica People, Can I create nonstock Kit with a stock item component that has a serialized lot which has a serial lot class that has an "when received” assignment method and a “User enterable" issue method? Details: I have a problem with a set of kits which needs to be fixed.  A good example is kit, 1000-9117K, which is a non-stock item and one of the components has a serial lot number (lot serial class of SUPPFORKIT set-up as pictured below).It throws this error when trying to save: Warning 2025-09-03 17:47:31 UTC IN Error: Components with the 'When-Used' assignment method and 'User-Enterable' issue method are not allowed in non-stock kits   Here is the lot serial class. The error is informing me that the components lot serial class needs to have an assignment method not of “When Used” and issue method of “User Enterable”.   *******************question************************ Can I not use the lot serial class, “SUPPFORKIT” which has the assignment method

When our data was originally imported to Acumatica, some template items were imported with no value in some of the required attribute fields.  I now cannot do any maintenance on these items because I get the error “The value of the STYLE attribute must be specified” (in this case the item has no value in the attribute named STYLE.)I have tried adding the attribute in the template and the updating matrix items. It does not work.I have tried adding a value in the item itself and I cannot.I have tried adding the value to the item using an import scenario.  It does not work.Can anyone help me with this please?

Has anyone created custom dashboards or business events to help track essential system metrics, such as user activity, system health, or security related information? While we’re familiar with the existing screens and reports, we’re looking for solutions that provide streamlined insights. We would greatly appreciate any recommendations or practices you’ve found effective. (Note: working in Acumatica Cloud ERP 2024 R1)

I am in report designer and trying to build my schema. Report designer will not let me add specific tables to the schema and I cannot figure out why. I initially thought it was because there was no primary key between EPTimecardDetail and the other table I had in there, but I have removed all tables and am now only adding EPTimecardDetail, and it is still not allowing me to add it and popping up the message “An entry with the same key already exists.” I tried adding other tables associated with time cards and I am unable to add those as well.Please help. 

Could someone kindly share an export scenario for ACH with Bank of America? Thank you so much.

What is the best process of handling multiple employees on the same appointment in regard to documenting their time

Hello all, i try to create an Business Event in the Opportnuitys, that creates a task for the Owner.Triggers:Estimated Date is 2 weeks in the past (todays date-14 days) The Opportnuity Stage is on “Angebot nacherfassen”Action:When the two Triggers happen, a task should be created for the owner of the opportunity. -------------------------------------------------------------------------------------------I treid to set it up as follows, but a task isnt created in my instance: Business Event:Maybe the @today -14 is set up wrong here?Subscriber ID: Maybe the owner field is set up wrong here? (I dont want the owner from the source lead, but from the opportnuity. I didnt found an “opportnuity→ Owner” field)Hope you can help.Greetings from Germany

Hello everyone,i want to achieve, that the “Owner” of the Sales Qoute is automatially trasnfered into the “Owner” Field of the Sales Order, that is created out of the Sales Qoute.When a Sales Order is Created out of an Sales Qoute, the Employee, that is linked to your User is put into the Owner Field of the Sales Order, no matter what Owner is originally written in the Sales Quote.I think it is also because the Owner field of the Sales Qoute is another field than the Owner Field of The Sales Order.Field in Sales Quote:Field in Sales Order: (Under the finacial tab) So in conclusion i just want that the Owner of the Sales Quote is written into the Owner Field of the Sales Order.I hope you can help. Greetings

While working in the Inventory Planning Display, I noticed the Group Nbr. column when generating a Purchase Order. The screen lets you assign a different Group Nbr. to each line, but when I run the process, I still only get one PO (as long as the vendor is the same).My questions: What is the intended purpose of the Group Nbr. field in this context? Should assigning different numbers automatically split the lines into separate POs? Or is this field just informational unless you have specific consolidation settings or customizations in place? In my setup, Purchase Order Preferences and Inventory Preferences don’t have any options related to consolidation or grouping by Group Nbr., and in Create Purchase Orders (PO505000) I don’t see a “Group by Group Nbr.” option either.Has anyone successfully used this field to create multiple POs? If so, how is it configured?Thanks in advance!Varun Ram

Hi, Does any one have instructions in how to create an EFT payable file in Acumatica without having the Canadian localization installed. Let me know. The price for the Canadian localization is a little too much for the client and we have to go through the customization route. Thanks,Frances  

My client is looking for to send customers a prepay Invoice or a Proforma Invoice.  Basically Enter an SO and generate an invoice, and once payment arrives they will process shipment and invoice. I set them up using credit terms with prepayment required and it works great. My question is if there is a way to do proforma invoices? I’m thinking I can create a second version of the sales order acknowledgement form and make it look like an invoice. Any other ideas?

We have several customers who are paying through a Credit Card portal that is integrated into our Acumatica. Our main location is Atlanta, but we have customers paying from Orlando and Nashville using the portal.Acumatica will process the payments and the funds will be received. However, the funds will only go into our Atlanta Bank account and not the company for which the transaction took place. This then leaves the transaction as pending processing or balanced (unable to release or close). This is creating many Inter-branch Acumatica Issues. See screen shot below: My questions,1. will activating the Inter-branch Transaction feature in Acumatica release these transactions and show as paid? 2. If activating the Inter-branch feature, will this cause any other issues within Acumatica? Is this a viable solution?Thank you for your time.