Discussion Forums

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.  

Does anyone know the answer to this question from our customer? We are getting ready to go live with the ability to ship internationally out of Acumatica. We were testing a shipment this morning and comparing the label that printed to the label that prints from UPS Worldship, and the Worldship label has a second label printed that is a barcode version of the commercial invoice.  Is it possible that we can get the commercial invoice that is created in acumatica to also print out as a second label to be placed on the package? We were told by our UPS rep that the second barcode label needs to be on the box so customs can scan and bring it up electronically. 

How is everyone monitoring project inventory costs through their balances/cost budgets? Our issue is that the cost of inventory when ordered will appear on a Committed or Open committed column, but once that project inventory is received (or transferred directly) onto the project, it does not appear in the balances UNTIL those inventory items are issued.We need a way to reflect project inventory balances on the Balances tab, ideally on the Actual + Open Committed amount column.Example below. You will see we ordered $303k worth of inventory. It is all received and sitting on the project inventory. But it is not reflected in the Actual +Open Committed amount and is actually showing as a major variance. Between transfers & PO orders, there is $307k worth of materials sitting on this job that are not being accurately reflected at this WIP state of the project.How is everyone handling project inventory for budgeting/cost tracking? 

We are on 25R2 modern UI and using the New Release Process for Manufacturing.  I have seen two glitches so far, and wondered if anyone else has seen these in their instance:A Move that completes an operation no longer records Actual Start Date and Actual End Date in the AMProdOper (Production Details, routing section) table.  We have critical reports that rely on these dates, and they are broken right now due to this issue. The final Move (production receipt) for a linked Production Order to SO Line no longer allocates the inventory to the SO Line.  You have to delete the SO Line and re-add it to invoice the sales order.  The issue this creates for us is that the production order loses the link to the Sales Order, also breaking critical reports that help us report on stock product versus build-to-order product.I don’t see a way to undo the New Release Process, but I would like to.

Dear community!This customization package is applicable to Acumatica 25R1 and later versions.The package includes a generic inquiry that demonstrates the new project & construction reporting capabilities. The inquiry is provided “as is”.After publication of the customization package, in order to view the data for the existing projects, you need to run the recalculate project balances process.This customization package contains 3 generic inquiries. Two of them are used in the third generic inquiry “Project Bdg vs Actuals Through Date”, which gets added to the menu once you publish the package.This generic inquiry allows the user to see the date-through actuals and review the budget performance for a specific date (as the screenshot below illustrates). More information and demo will be provided

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 are excited to announce that we are entering Managed Availability for our Modern Customer Portal initiative! We are looking for early adopters to explore the new features in a sandbox environment beginning with 2025 R2.The steps to sign up are listed below and are also available in the Managed Availability program details.If you would like an overview of the Modern Portal, please refer to the link below:2025 R2 Release Notes – Modern Customer Portal starts on page 139 The 2026 Acumatica Summit Customer Portal Presentation is attached to this post

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 b

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\"" }

New Drip Campaign Available in MAP! I’m excited to share a brand-new drip campaign in MAP designed to help you share the benefits of Accounts Payable Automation, powered by BILL. This campaign is your go-to resource for showcasing how this powerful integration can transform financial operations for your customers. With automated approval workflows, seamless bi-directional data syncing, and flexible vendor payment options, this solution is built to streamline invoice workflows and enhance cash flow visibility.Here’s a sneak peek at what the campaign highlights:Automated approval workflows to reduce errors and speed up processing. Flexible vendor payment options to simplify financial operations. Real-time dashboards and reporting for a 360° view of cash flow. Seamless connection to BILL’s network of over 8M businesses.Getting started is easy!Ac

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 everyone,I’m having the following problem: I’m trying to convert a Classic UI screen into Modern UI and 3 of the buttons are not getting hidden for some reason but there’s a try that my colleague tried doing a while ago and the buttons are working as expected there but I’m unable to recreate them for some reason using the automatically converted screen into Modern UI. The buttons I’m having that issue are “Confirm, Generate and Change Order” also another thing I noticed is that we cant reuse the Transactions variable because if we do, the Subcontracts grid is not being automatically loaded on page refresh or load.The version of Acumatica I’m working with is 2025 R2. Here’s the automatically generated source code: I’ll have to paste the source code into pastebin since the source code is a bit too long and the post cannot be created

What is the best way to add a subcontractor to a service order?  Is there a way through a PO or how do you tie the bill to the service order? 

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:

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?

Good day.  This is shot in the dark question.  However, we have SPSS EDI for fulfillments of our purchase orders.  We are getting this weird occurrence with the Vendor Cross reference duplicates and also it seems to make up alternate IDs as well.  Has anyone experienced this phenomenon?We are on 2025R2.  If we delete them they just reoccur.Thank you.Evan  

Is there a way in the MFG BOM to have the Component flagged to only pull from Lot number?In other ERP systems ( like GP) , there is a single lot feature. Goal is have MRP understand that our component can only be consumed from one lot.  

Dear all, In the old version, If there are multiple lines in the AP Invoice, there will be corresponding multiple lines in Convert purchases to assets.But Now in the new version 2023 R2,  If there are multiple lines in the AP Invoice, there will be only one line with total amount in Convert purchases to assets.So If I want to have multi lines as the old version, how to config? Thanks and Best regards,

Hi,I have a requirement to transfer the balance of the cash account in one company to a cash account in another company. For that, when Im trying to create the Inter Branch mapping the system does not show me the offset account in the search. What could be the reason ?Thanks!

When importing historic balances into the GL, one was imported into an Asset account with an incorrect branch.The asset account was subsequently used for a cash account and, after recalculating the balance, it was discovered that the offending transaction did not appear in the reconciliation.I am now unable to reclassify or journal the transaction out and replace it with one in the correct branch because the branch does not match the branch associated with the Cash Account.  We have already imported transactions into the Cash account so I can’t delete it and start again either.  It would appear that I am stuck between a rock and a hard place.Does anyone have any bright ideas on how to resolve or work around this? Thanks in advance…   John