Discussion Forums

Does anyone have experience with Markets Pro in Shopify?   It is supposed to allow us to bring in sales from other countries (CAD for example), however it looks like it brings it in with the Currency of the foreign country, and fails for us because we do not have MultiCurrency enabled. I was hoping it would perform the conversion of the currency and import as USD.    It seems the JSON file contains the USD amount and the conversion: Are we supposed to MAP this in the connector?!Cheers,k2

Created Service contract in 2022R1 with newer Billing Type of Beginning - Period Plus and created annual billing for monthly scheduled service.The service line on the scheduled service is not showing ‘in contract’ as expected and the appointment billing will bill the service when expected to be covered by contract.Am I doing something wrong or is this a bug? 

We want to be able to use Projects to document activities for Research and Development (R&D) tax credits.  I expect that the labor expenses will be the largest component of the R&D credit, with materials and prototyping materials the next largest component.   With the R&D Tax credit Solid documentation is required, but we need to be able to keep it simple as well for the engineers. Need to keep the tasks down to a minimum otherwise the engineers will not properly record their time.  Has anyone setup an internal R&D Project using the projects module?  Are there any tips to share, especially when generating the cost for auditors.

I have successfully set up a field on the Customers Default Address to flag if the address is verified.  On the Customers screen adding a FieldUpdated event for AddressLine1 allowed me to reset this flag if the field was edited.This is the code:protected void Address_AddressLine1_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e, PXFieldUpdated InvokeBaseHandler){ if(InvokeBaseHandler != null)  InvokeBaseHandler(cache, e);  var row = (Address)e.Row;        if (row == null) return;  var addrExt = PXCache<Address>.GetExtension<AddressExt>(row);  if (addrExt?.UsrAIAddressVerified == true)  {  cache.SetValueExt<AddressExt.usrAIAddressVerified>(row, false);  }}This works great on the Customers screen. If I edit Address Line 1 and tab away it resets the flag. I want to reproduce the same thing on the Shipping Address on the Sales Order Screen.I added the following:protected void SOShippingAddress_AddressLine1_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e, P

Hi everyone,I'm trying to create an export scenario on the Customer Payments screen (AR302000), and I’d like to filter the exported records based on the LastModifiedDateTime field.Since this field is not active by default, I made it available using a customization project. Now, the field is visible and selectable in the Source Field of the export scenario.However, I’m facing an issue:Even though I can select LastModifiedDateTime as a source field, I cannot select values for Value 1 or Value 2 in the filter condition – those inputs are disabled, making it impossible to define a date range or comparison.What I observed: Built-in date fields (like DocDate) work fine and allow date inputs. These native fields are of type datetime2, whereas LastModifiedDateTime appears to be of type datetime.

I’ve found several entries here for this, but haven’t found a solution yet.Requirement:Enter Start and End Period (can be anything up to 12 periods and can cross fiscal years/calendars) The data in each period’s column display just the turnover for that period (not the ending balance at that period)I have found good formulas to suppress printing periods not in the parameter selection. However, I cannot figure out how to get just the turnover for that period when I use a start and ending period in the parameter. Thank you in advance!

Hello, Trying to have the report printed with alternate color for line items to make it easier for user to read the printed report. picking list report for instance.  Thanks!

Hey everyone - My AP report does not run in alphabetical order but rather by Vendor ID chronological order and it drives me nuts!! Tried to fix it myself on the report designer but I can’t find where the sorting feature is for the data in that column. Can someone offer some assistance?  I only run AP in summary form. 

The client requires a prepayment before production begins and full payment before delivery.  Is there a good way to set up this kind of term?

Some tables throw ‘The multi-part identifier could not be bound.’ when filtering by specific fields. Below is an example for Invoice filtering by BillToContactOverride. Attached is the SQL query executed by the API as retrieved from the request profiler. It looks like the generated SQL is incorrect. This is happening across multiple versions (tested v23 and v24). No customizations have been applied to the instance.  DECLARE @P1 AS INT = -2147483648, @P2 AS INT = -2147483648, @P4 AS BIT = 1;SELECT TOP (1000) [Document_ARInvoice_ARRegister].[DocType] AS [DocType], [Document_ARInvoice_ARRegister].[RefNbr] AS [RefNbr], [Document_ARInvoice_ARRegister].[NoteID] AS [NoteID], NULL AS [NoteText], NULL AS [NoteFiles], (SELECT TOP (1) [DocumentNoteExt].[NoteText] FROM [Note] AS [DocumentNoteExt] WHERE ([DocumentNoteExt].[CompanyID] IN (1, 2)

Acumatica currently charges their SaaS clients a 25% Retired Version Premium when upgrading from a retired version. Our VAR has informed us that Acumatica will start to charge the same 25% fee to private hosted clients as well. There is no press release that I can find and our VAR tells us it came from their source at Acumatica. Can anyone else confirm this?

 Hi all,I created some custom DAC views from sql for GI. When I publish the project for the first time, the tables still appear normally. But when I publish the next times for other projects, the tables in GI will disappear. I checked on the database and the views are still there but not appearing on GI.This is my sql code in the database script This is the code I let the system automatically createDo I need to adjust the initialization code for the above scripts? Or do I need to do something else ? 

We had to request for Acumatica Support for checking one of our SaaS client’s site for Service Order Appointment processes. Unfortunately, we cannot link the employee record to the built-in AcumaticaSupport user. So, we had to create a new user account which causes the confusion to our client because they are a bit peculiar about user access on their system. And just a thought that it would be really nice if we can link the employee access for AcumaticaSupport user for cases as well.   

Hi,I am working with a 25 R1 site that was originally created using 24 R2 and later upgraded to 25 R1. The site includes several customizations, including enhancements to base screens and the development of new custom screens.After configuring the necessary Modern UI settings in the web.config and site map, the standard base screens are correctly displaying in the Modern UI. However, the customized base screens and newly developed screens are not rendering in the Modern UI as expected.I have used the built-in converter and followed all the recommended steps for the transition. Below are sample .html and .ts files from a very simple screen that I have converted.WS101001.html<template>    <qp-grid id="FreightForwarder_grid" view.bind="FreightForwarder"></qp-grid> </template> WS101001.tsimport { Messages as SysMessages } from "client-controls/services/messages";import { createCollection, createSingle, PXScreen, graphInfo, PXActionState, viewInfo, handleEvent, Custo

We often allocate input materials to a Production Order ahead of time — but the materials are in a different location than the production site.Once allocated, Acumatica won’t let us transfer the materials to the correct location because the inventory is locked.Our current workaround is to: Unallocate from the Production Order Transfer the inventory Reallocate it again This feels messy and inefficient.Our VAR suggested we just consume from the original location and physically move the material — but we’re not comfortable doing that due to compliance concerns.Has anyone run into this?Is there a way to transfer allocated inventory while keeping the link to the Production Order?Appreciate any ideas! 

Is there a report that I can run to see the Prepayment usage. Our customers would like to know where the prepayment applications with  the details like Invoice Ref Nbr, inventory item, quantity and amount at invoice line level. -Thank you,Nalini  

Currently when users request to send an SMS for the two factor authentication code (if they app or other options aren’t available), it send the code only, with nothing else.  Is there a way to modify the SMS message sent so that it includes something like “Your code is XXXXXX” or similar so devices like MacOS and iOS know to offer it to enter into the browser for you rather than needing to type it manually?  

My company is needing to mass create sales orders with the CM type. We have a tax customization that throws an error unless I over ride the tax zone from “TAXABLE” to Null (or blank)My current import scenario only completes this for every other record.  Attached is the XML.The only other possible work around I can think of is, is there a setting that will make all CMs “null” for the tax zone by default?

Mid-market Commercial Construction company new to Acumatica - Live 1/1/25.  1 Entity with 7 Branches.  We are struggling a bit in learning Acumatica and recovering some operating efficiencies, particularly in project accounting - budgeting - subcontracting workflows- and accounts payable management.  Interested in a connection-conversation with a construction company a little further down the road using Acumatica Construction Edition happily and successfuly to manage project finance, or those who have been down our path and done something different for project accounting (Procore Integration?)

Can’t delete a sub account. Can’t figure out where to find the rest of them so i can delete them.  2/3/2022 6:54:58 PM Warning at ParentDeletingHandler.cs:159:RaiseConstaintViolationException():Subaccount (00  -   -) cannot be deleted because it is referenced in multiple tables. 1: Currency (USD) - Foreign key Currency(aRProvSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute 2: Currency (USD) - Foreign key Currency(aPProvSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute 3: Location (118, MAIN) - Foreign key Location(cSalesSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute 4: Location (118, MAIN) - Foreign key Location(cDiscountSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute 5: Location (118, MAIN) - Foreign key Location(cRetainageSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute 

It's great that we have such a vibrant Acumatica community to get quick answers to questions and gain product knowledge! We have very active members jumping in to help others out all the time. The goal of the community is to respond to every member’s question so that no one goes away "empty handed".Connect, Learn, Share Taha Yab Ali - Acumatica Community Featured Member for May 2025Meet Taha Yab Ali our Acumatica Community Featured Member for May 2025. It’s great to have you as part of the Acumatica Community ​@tahayabali! Acumatica User GroupsNew! Michigan Acumatica User Group, Northern New England Acumatica User Group, NorCal Acumatica User Group Request to join today!All Acumatica User Groups How to Answer Questions on Acumatica Community - We need everyone’s help!Active Participation is needed from every Community user; everyone can provide valuable input using their individual skills and interests.  When more people participate, all members benefit - - we need diverse backgrounds,

(Obviously) this is a test order from our sandbox tenant.  We’re trying to come to grips with the process here, but we are stuck.  This order at “Released” status, but the ellipsis menu is pretty much all greyed out, and we can’t add a labor transaction.  Can you help us solve the mystery?  

Before I recreate the wheel, does anyone have anything like this?We have a lot of variables in our product lines.  When customers request a new Length/Width/Material/etc we have to create a new Stock Item, Build a BOM, etc.Right now, we have ~5 spreadsheets with our product lines that have to be maintained to provide a quote for the customer.  This is also sent to the Product Manager to build the Item and BOM.I want to build a New Item page that would have variables depending on Product Type, in which certain dropdowns would be available or options in those dropdowns would be selectable.  Based on those parameters selected, it could build the Inventory Item, BOM, and provide a more accurate Quote. 

I created a user defined field [Location.AttributeCHILDACCT] that is of type String ( nvarchar)In my generic inquiry if [Location.AttributeCHILDACCT] is blank then I want it to pull in the Project Customer [PMProject.CustomerID] otherwise I want it to pull the string in [Location.AttributeCHILDACCT]Here is my formula: =iif(([Location.AttributeCHILDACCT]=' '),[PMProject.CustomerID],[Location.AttributeCHILDACCT]) I keep getting the error message below.  The C002452 is the [Location.AttributeCHILDACCT] field. The issue is definitely with my condition in the iif statement. Are you able to set a string to a condition of blank in a GI?  I think I just don’t have the correct syntax for the empty condition.  

Hello,  Does anyone know how to convert a decimal values to inches in report designer?Example: Customer orders 12.50 feet in ACU on the sales order screen but want the value displayed on the report as 12ft 6inches.  Thanks