Solved

I have a bunch of Android Tablet users who would like to print .ZPL files from a Zebra Label Printer. Usually I use DeviceHub or a .bat file to get this moving, but Android doesn’t support .bat and it looks like DeviceHub isn’t supported either.How do we print .ZPL files to a label printer in the Android OS?

Hello Everyone,Kindly assist in making AFE Number field enabled once the requisition is approved.And also is there a way to make Files field mandatory/Required once a requisition is approved?see below Kindly assistURGENT!Any kind of response will be highly appreciated.

Our base currency is ZAR, and so our inventory costs are calculated in ZAR.When doing a service order for a foreign customer (USD), the costs are coming through incorrectly.  As an example, this item has a cost of ZAR 106.3938.  We are selling it for USD 9.59.The since the service order is in USD, Acumatica should be taking the ZAR cost and converting it into USD, to compare apples with apples for profitability :-)  But it takes the nominal value of 106.3938 and uses that for the USD cost. Now when I use the toggle button to view the base currency (ZAR) a fictional cost is displayed (the actual cost multiplied by the currency rate):As a result the profitability is incorrect.  How do I log this as a bug?

Just updated to version 2022 R2.  Previously inventory was automatically updated at time of invoice.  Since the update, IN updates at shipment confirmation.  Where is this change coming from?  And how do I change it back?  Thanks in advance.

Does anyone have a good video/link they can share for customing workflows in acumatica? I am trying to customize our billing process so everything is laid our in easy steps! 

is there a way to have certain screens automatically open upon signing into Acumatica?  Same situation as if you are logging into your computer, and automatically have teams, or another program open without actually having to manually open it.

Hi, when posting any Adjustment to the Stock Item with Lot/Serial Number and Expiry date, if a user accidently enters a different Expiry date,  the system updates the Expiry date on all the stock for that item and set this new expiry date. can this be prevented or tracked so the client can see the old and new dates? Many Thanks 

When I applying the invoice to debit adj it showing the following error. Error: Inserting  'AP Address' record raised at least one error. Please review the errors. Error: 'Country' cannot be empty.I checked the vendor has set up the country and the transaction  remittance has the country. Not sure what else has been missing.transaction error message transaction remittanceThank you.  

Hi! We are in the process of setting up our Acumatica account and are stumped with payment processing.We have some customers on 30-60 day terms, and our preference is that they pay at that time with ACH. Avoiding cc fees after floating the money for their company for a few months is ideal for our small biz. In QuickBooks, we can toggle payment preference of ACH or CC at either the customer OR the invoice level.We talked to one provider today and they basically told us that we can’t separate payment preferences by Customer Class (we have one for day-to-day customers and another for those in terms). Is anyone aware of an Acumatica-friendly payment processing service that will allow us this kind of flexibility?   

Hi,How to call multiple value on Barcode? Currently, I have configured the report to print barcodes for each value. I have try using concat» CONCAT([ARInvoice.CustomerID],[ARInvoice.CustomerID_BAccountR_acctName]) and set variable to call multiple value however not successful.Is it possible to setup report designer to call multiple value on barcode? Thank you

Trying to import sales orders but some of the lines have invalid inventory ID’s that do not exist in Acumatica. I still need to import the lines that do but they all fail because of the inventory items that don’t exist. How can I skip invalid inventory line and get the rest of the file to import.The import works if I only import inventory ID’s that are in Acumatica. 

Hello everyone,I’m trying to create a new instance of an existing database but I get an exception with the following error.Kindly assistViolation of PRIMARY KEY constraint 'UPHistory_PK'. Cannot insert duplicate key in object 'dbo.UPHistory'. The duplicate key value is (5).The statement has been terminated. -------------------------------------- Inner Exception: Violation of PRIMARY KEY constraint 'UPHistory_PK'. Cannot insert duplicate key in object 'dbo.UPHistory'. The duplicate key value is (5). The statement has been terminated. ​​​​From the database this is how the situation looks like; NB:database was moved to a different server.​​Any kind of response will be highly appreciated

Hello everyone,I'm trying to connect Sql server in a DB server to App server so as to create the application ERP but i get this error.Kindly assist. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) -------------------------------------- Inner Exception: The network path was not found

The system names all the PDF’s ARInvoiceINV.pdf for the Invoice report AR641000. Has anybody tried to change this to include the invoice number in the report? Or does anybody know if this is possible. For example, can we change it to ARInvoice12345? Or something like that….

Hello all,I have been trying to add the tasks under Revenue Budgets tab of the Projects (PM301000) screen. i have selected Task under Cost & Revenue Budget level fields under Summary Tab. Even Empty Item Code has been set as <N/A> under the preferences screen, but still when trying to add the tasks the system is triggering the below mentioned error. The Inventory feature has also been disabled under Enable/Disable features. Kindly guide me to resolve this issue.Thanks in advance.

how do I resolve Row updated and row inserted getting called multiple times which executions logic twice 

Hi Team,I have create a new processing screen and in view delegate trying to access a Use Defined Field value from Customer screen to show on UI and I am using 22.106.0015 build version. I have referred some community posts but not been able to access the defined field value. Below are the samples I have verified:The customer’s user defined field value stored in BAccountKvExt table and in DB able to access it but in code not able to access this table. Access User Defined Field from business logic | Community (acumatica.com) from this community post tried to access using new cache object but that also does not helps. public sealed class SOLineExt : PXCacheExtension<SOLine>    {        public static bool IsActive() { return true; } #region UsrEmployer        [PXString()]        [PXUIField(DisplayName = "Employer")]        public string UsrEmployer { get; set; }        public abstract class usrEmployer : PX.Data.BQL.BqlString.Field<usrEmployer> { }        #endregion} public cl

Hi all,I am struggling with a report filter, when I attempt the below filter I am only receiving about 20 results and the GI has 370. Any suggestions? Thank you,Kage

Hello,     Our company has run Acumatica for nearly 3 years. We installed Acumatica on our own server and database. As an IT stuff, I checked there are large amount of history records when opening screen SM205035.    These records are not quiet necessary, so I want to clean them.     However, if I click “Delete ALL” button, I would get request timeout. Maybe these records are too much(we set some scheduler run in minutes interval).       I can select 1 page and delete 1 page’s record at once by clicking “delete”. but that is so time consuming.      Is there a better way to clean them?      To delete them directly from DB is probably a way to go, but I am afraid to broke the table constraints and reference of each other.       Can anyone give me some directions.

Have been trying to import an invoice into the system, but while importing it throws and error as shown below:  This error also gets triggered while I am trying to create the same invoice( Invoice Number: INV-0035) manually into the Invoices and Memos form.Whereas when I am trying to import other invoices (of different invoices numbers) the system is accepting it.Can anyone let me know the reason for this error getting triggered for this single invoice number and the resolution.Thank you in Advance.

Hello linkies,I would like to have a clarification on the Complete Order option which under More Menu of the Sales Orders(SO301000) screen.  I have been trying to modify the status of an order from Open to Completed without creating any shipments.Even when the Completed checkbox is active at the line level, the status of the Sales Order still remains to be Open as shown below: Kindly let me know the use of Complete Order option for the same. Thank you in advance.

@Irina or someone, I am looking for advise/KB articles or anything else that can help me determine why a report is running so slow.  I know it could be the joins, subreports etc but I am hoping for someone to point out the typical culprits.My report takes about a minute + to run, has two subreports and only a few tables that are joined as recommended.  Any assistance would be greatly appreciated. 

Hello all,I am attempting to add a salesmen parameter to my AR Aging report so I can run that report as it is relevant to each salesman. I have attempted to add a parameter, however it still returns all invoices, and not just the invoices based on the salesmen entered into the parameter. Here is how it is currently set up -As stated, the report returns all invoices regardless on the salesperson ID entered into the parameter. Thanks all!

Hello: how create a transfer from sales order, but the item comes from secondary warehouse? Best regards

I’d like to setup Multi-factor authentication for all users in our tenant. I see options for sending an email or SMS but I would prefer using an authenticator app such as Microsoft Authenticator. Is this possible and I’m just not finding how to set this up?