Solved

Hey, gang - our client gets an excel file monthly from one their customers to be imported into their system.  The issue is that the file may have Stock Items included within that are NOT in our Clients instance, nor should they be.  Nevertheless, they need the data associated with the item to be imported, but under a generic item.  In this case, the client wants the nonexistent Stock Item that’s in the Excel file to be renamed to a generic item (say, “GENERICITEM”) during the import scenario.  The client would prefer not to cross reference the existing stock item list with the monthly customer provided list and have the import scenario do the heavy lifting.  Is there a formula or a combination of formulas that can determine if a stock item is in the system and, if not, return a generic value?  Note:  Yes, you could cross-reference and update the spreadsheet beforehand or intentionally error it out and replace the errored items - I’m curious if there is a way to let the system handle th

Hi all,I need to create an import using the Close Production Orders screen.  The file upload in the Import Scenario will contain the Order Number and other details about all the completed prod orders.  Our process on closing the production orders is if it is completed by >= 14 days.Any help appreciated.Cheers,Laura 

Hi Everyone,We have customized the mobile app for the Scan and Transfer screen. Currently, the Save action is displayed; however, our requirement is to show the Release action instead, once all the steps are completed.Could you please guide us on how to achieve this?  

Hello all,I want to display the Barcode alternate Type from the Cross Ref tab in the Stock items (IN202500) screen. But unable to do so. i want to hard code in the join to only display the data for Barcode.Thanks.

When is the employee sales account used?

Hello Team,We have a client requirement to control or validate the posting/ creation of time entries against project budgets. Specifically, they would like the system to generate a warning notification when a user selects a project and task in a time entry and the recorded time exceeds the allocated budget. Ideally, the requirement is similar to the budget overrun notification that appears in the Purchase Order screen.   Can anyone please advise if there are any out-of-the-box configurations or possible workarounds that can be used to achieve this requirement?Thank you in advance for your guidance.-Yasali-

Similar to an older post, I ran into the same situation but have some more context and a more specific question. The ‘Invoice Payment Link Update’ is a straightforward quality of life process that triggers the payment link of an invoice to update when an invoice becomes ready for synchronization; very nice - clicks saved. However, we are seeing this out-of-the-box Business Event fail regularly.Digging into the notification itself in the Process Push Notifications screen, I noticed that every failed push notification JSON looks roughly like this:{Inserted values: {{INV: 000010}{needs_sync: true}, {INV: 000011}{needs_sync: true}},Deleted values: {{INV: 000010}{needs_sync: false}, {INV: 000011}{needs_sync: false}},Timestamp: 539096372739445064} Does two+ records being updated at the same time in the same notification cause business events with the ‘Trigger by Record Change’ to fail? Is there a different configuration to avoid this overloading? We regulary receive and process payments whic

We have just upgraded to 2025R1 and are trying to understand the inventory sources “Free Stock” and “Project Stock”. Main question described below:I’ve come across this basic description, but it’s not making sense to me based on our project settings: In our projects we have the inventory tracking as “Track by location”. For our projects we usually do “Project Drop-Ship” Purchase orders, so the inventory never shows up in our warehouse. Any inventory that we receive on normal purchase orders if available to be issued to any project.MAIN QUESTION: When processing inventory receipts or issuing inventory to a project, it now makes us choose whether it is “Free Stock” or “Project Stock”. We don’t want to classify it as such. Should we be worried about how it is classifying the stock? When issuing it to a project, the project will not be offered as a choice if we select “Free Stock” as you can see here: It only allows us to issue it to the project if we select “Project Stock” as the inventor

I am trying to add a DAC field to the Approve Clock Entry screen. I enabled it in the Customization Project Editor, and the field is displayed correctly in the Classic UI. However, the same field is not appearing in the Modern UI.  

Good day, has anyone perhaps ons successfully integrated with Deep Local Payroll (Payspace)  Th y are one of Acumatica’s API partners however I am struggling to post my ledgers from Payspace to Acumatica, the error I keep on getting is Your Acumatica login has expired. Please login and try againThis error pops up even directly signing in. I did setup a API user for payspace and I did send them the Client ID and Secret which they used to establish the connection, but I think I might be missing something. 

 I needed to restrict the SalesPersonID selection in ARTran so that users can only choose salespersons assigned to their organization, based on a custom field (UsrInternalCompanyID) added to the SalesPerson DAC. To achieve this, I attempted to override the selector using a CacheAttached event with a custom PXSelector that joins the Branch table and filters records according to the current user’s branch/organization. While this approach successfully limited the list of salespersons shown in the UI, it resulted in an issue where the selected value was cleared upon saving the document.Salesperson DAC extention public class SalesPersonAccessRestExtP : PXCacheExtension<PX.Objects.AR.SalesPerson> { #region UsrInternalCompanyID [PXDBInt] [PXUIField(DisplayName = "Company ID")] [PXSelector(typeof(OrganizationBAccount.organizationID), typeof(OrganizationBAccount.acctCD), typeof(OrganizationBAccount.acctName), Sub

Hi, I’m working on a customization project to incorporate a side panel for our Bills and Adjustments screen, but would like to map the navigation parameters to the Detail Transactions grid so it can reference Subcontract Nbr and Project Nbr. When working on the customization I’m only seeing the limited fields tied to the source APInvoice for selection.Because our invoices are not setup for Single-Project use, I do not have an available Project field to map to. Is there anyway that I can establish this link for Side Panel display and ease of navigation for our teams?

Hi Everyone,In the GL620500 Report, I have added the variable in the DetailSection1 and would like to display Total Amount and Total Count in the Header but it is not working. Can you please review and provide your inputs.  

I am currently working on setting up the Shopify integration with Acumatica (2025 R1 Commerce / Shopify Connector).I am facing an issue with the Shopify configuration steps mentioned in the documentation. The documentation refers to steps that no longer match the current Shopify UI (e.g., private apps vs custom apps).Specifically:I am unable to find the exact Shopify settings referenced in the documentation The steps for creating API credentials seem outdated There is no clear step-by-step guide for Shopify Dev (Custom App) setup aligned with Acumatica 2025 R1Could someone please provide:Updated step-by-step instructions for Shopify (Custom App / Admin API setup) Required API scopes for Acumatica integration Any updated documentation or internal guide for 2025 R1 Commerce (Shopify connector)Any screenshots or clarification would be greatly appreciated.

We have sales orders that come thru with retail (stock) items but also non-stock items such as donations to other organizations. We also take sales orders up to 6 months in advance before we can fulfill them (we deal with live plants and seeds). When donations come in I would like to invoice the sales orders for those lines. Is there a way to do that? 

We are displaying the approver on our sales order report.  We bring this information in as follows: I have a situation where the same approver is in two approval maps rules (one inside of a workgroup and one as an individual).  So when he approves a document, it comes through twice. This is now causing the detail lines on the sales order print out to duplicate.  I would like to group by the key field here, which is RefNoteID, but I get errors when doing this because it is not a normal numerical ID.Any suggestions?  There might also be cases where there are two approvers who are not the same person, so grouping on Approver ID is probably not ideal, but maybe a work around for now because I only need to display one approver on the report.  Still wondering if there is a better way though?

I have a program that PUTs Production Orders via REST API. It worked until our recent upgrade from 24R2 to 25R2. I was using endpoint version 23.200.001 but it happens with 25.100.001 also.I PUT to ~entity/MANUFACTURING/25.100.001/ProductionOrderDetail?$expand=Operations&$select=Operations/OperationDescription:{ "OrderType": { "value": "RG" }, "ProductionNbr": { "value": "TESTORD" }, "Operations": [ { "ControlPoint": { "value": true }, "OperationNbr": { "value": "010" }, "WorkCenter": { "value": "SAW" }, "rowNumber": { "value": 1 }, "OperationDescription": { "value": "Cut 12\"" } } ]}And it responds 200:{ "id": "ca50efb0-01c4-f011-843a-06b1b982e321", "rowNumber": 1, "Operations": [ { "id": "0846d663-06c4-f011-843a-06b1b982e321",

Hi all, i have import scenario. I Have some action which use data from address tab. When i debug this, i saw that Site_Address.Current is null. But my project have this data. Project.Current is not null. Have you any ideas?

Hello,After updating to 2025R2, Shopify orders that contain customer info are aborted with this error message. Orders without a customer get processed without issue. I have uninstalled and reinstalled the Acumatica App in Shopify a couple of times and still getting this error. We have two Shopify stores, one on Shopify Grow and another on Advanced. Both have the same issues. Complete Error Message: At least one GraphQL error has occurred. Error: Access denied for companyContactProfiles field. Required access: `read_customers` access scope or `read_companies` access scope. Also: The API client must be installed on a Shopify Plus store.

Hello there,We can add side panels to Entry screens now, and that’s awesome!  However, I can’t figure out a way to add a side panel, that would be filtered according to the selection on the SO Line.  I have created a couple GIs, added them onto a Dashboard that uses InventoryCD as a parameter.  Now, I would like to be able to add this Dashboard as a side panel to Sales Orders screen, and filter data based on what line item is selected on the sales order.Any ideas?  Thank you!

Can someone elaborate on this step in the Avalara Implementation help guide: 13. Configure AvaTax for nexus states and map companies. Make sure the ID/Code are identical in both systems. What is meant by ID/Code?? I’m assuming it means the Companies, but Avalara is asking for Locations, so not sure where to enter the ID/Codes. As it stands these do no match because I’m not sure where the word “Primary’ is coming from.Acumatica ID’s:  Avalara Locatons: Thanks for any help.

Hello all,I have been trying to create child Prod Orders, but unfortunately, when I click on Generate Orders for Subassemblies option under Prod Order Maintenance → More Menu, it runs & then says “The Operation has been complted”, but it doesnt generate any child orders. Also, I have defined default BOMs for my subassembly parts & also have defined Production Default Source as Manufacturing.How can I resolve this?

I have a custom field in the header of a screen.  I cannot find a way to add the hyperlink button to the field.This was addressed for a grid field here:I’ve added the [PXDBWeblink] to the DAC field, but that does not make the link button show.I think I might have to modify the TS file, but I cannot adapt the code from the above topic.export class CROpportunityHeader_Combined_generated {    UsrURL: PXFieldState; Any help would be super appreciated.  

We recently extended our default endpoint into a new endpoint for our Financial app partner Cube to use. Since some of the financial queries were so large, I ended up building a new GI to summarize transactions down to totals by period, by subaccount, by account for them to use.  The GI is working as expected, and I added a parameter to try and make it more ingestible by API. However, whenever our Cube dev tries to access the screen via API they get a 200 but null response, even though the screen when queried the same gets data. The webservice endpoint of this GI says to use a PUT method, though both PUT and GET have been attempted. Could someone please advise? Info:Webservice endpoint flag: Fields has the filter available: GI has OData permission, xml attached as well:GI loads as expected:GI XML (attached to ticket) API call attempted (getting 200, null)https://greatergood.acumatica.com/entity/Cube/24.200.001/CubeSubaccountGroup?$expand=CubeSubaccountGroupDetailsPUT{    "Parameters":

I would like to get a clarification regarding inventory transaction data in Acumatica. We are currently trying to identify whether there is a single table or a recommended data source that can be used to retrieve all types of inventory transactions, such as inventory issues, receipts, transfers, and adjustments, in a unified manner.From our understanding, tables like INTran, INRegister, and INTranSplit are involved in storing inventory-related data. However, we would like to confirm the following:Is INTran the correct and complete source to capture all inventory movements (issues, receipts, transfers, adjustments)? Are there any additional tables or views that should be considered to ensure no transactions are missed? Is there a recommended approach (or standard Generic Inquiry structure) to retrieve all inventory transactions accurately for reporting purposes? Are there any specific conditions, flags, or transaction types we should consider when filtering this data?Additionally, we ha