Discussion Forums

I have a custom field on the Invoices and Memos screen that is a link to the Sales Order if the invoice is linked to a Sales Order.  Works great on the UI.  However, when I added the field to the AR301000 screen on the mobile app, there was no link.  I scoured the net and could not find the secret.I finally DID find something in the Acumatica documentation that solved the issue.This is the single line I needed to add to my code to get it to work:update screen AR301000 {  update container "InvoiceSummary"  {    containerActionsToExpand = 3    fieldsToShow = 11    add recordAction "PrintInvoice" {          redirect = True    }    add field "SOOrderNbr" {      displayName = "Sales Order Nbr"      special = "AllowEdit"    }  }}FYI, PrintInvoice action is a VS action to be able to print the Invoice/Credit memo.  A BIG shout out to ​@dcomerford and ​@DipakNilkanth for helping through my Mobile App growing pains. 

We are looking at using ‘cases’ for a basic internal IT ticketing process.  I am trying to set it up so that users would send an email to a certain email address and it would auto open a case.  I have set the email up to do this, however how do I set it up so that internal users are the contact or requester? I would hope that the users name would auto populate from who sent the email.We would also like to see it put the Internal user in the ‘to’ section when we click on ‘create email’. Is this possible?

Hi Acumatica,Is there a way to set up Sales Prices based on the credit terms used in the Sales Order Screen?Thank you!

Good morning community,We are fairly new to the system and our data was transferred from Quickbooks. I have locations on accounts with different emails to send invoices to various departments. How do I assign emails to different locations instead of the main email address on the bill to.

I encountered an issue during the import process. Although the history shows that 80 lines were successfully imported, when I reviewed the Non-Stock items, only 7 lines appeared. Could you kindly advise on this matter? I appreciate your guidance and support in advance.

I can create a percentage of individual wages accounts to be shown as a % of Total Sales. However, my client wants the calculations to be different based on different areas and Im not sure if this can be done.For Example, we have 5 wages accounts and 3 Sales Accounts.Wages Regular  to be shown as a % of the  Sales Regular accountWages Casual  to be shown as a % of the Sales Casual AccountWages Supervisor, Wages Manager, Wages Clerical to be shown as a percentage of total sales. The accounts change throughout the report.  Is there a mechanism to do this within the ARM reports.I have tried using rowcode and baserowcode calculations but only get to a certain point.Any indications of how this should be setup would be most appreciated.Thanking you 

I tried to change the database connection that was pointing to my Orange Pi Zero portable Linux server to my AWS MySQL Linux DB. It wanted to create the DB rather than just connecting to it. Is this normal or is there another method beyond the Acumatica ERP Configuration utility?

Hello! I want to send an automatic email to customers on December 1st to remind/teach them how to set up Fiscal Year for the next year. Is there a way to automatically send this email from the system if there is no event that triggers it? I thought about using Business Event but I can’t think any changes in the system that would process this, other than maybe when system date changes? But I’m not sure if that can be done with Business event.I also thought of Automation schedules, but I don’t have a screen ID to use that would cause this email to send… Any ideas? Thank you!

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 Brendan White - Acumatica Community Featured Member for September 2025Meet Brendan White our Acumatica Community Featured Member for September 2025. It’s great to have you as part of the Acumatica Community ​@bwhite49! Save the date: Coffee & Code - OAuth & API [Sept 25th, 2025]In this Coffee & Code session, we’ll dive into OAuth and APIs, with a focus on creating and managing custom endpoints, and use of different parameters for integration.Register here: Teams Webinar Acumatica User GroupsNew! Michigan Acumatica User Group, Northern New England Acumatica User Group, NorCal Acumatica User Group Request to join today!Upcoming Meetups!NE Acumatica User Group

We have had some clients run into fairly frequent issues with the Outlook plugin stopping or ceasing to function. There are community posts out there related to removing the cache files. For some users this can be somewhat onerous or difficult for them to manage. To make this easier, I’ve created a batch file for windows. This batch file:shuts down active Teams and Outlook processes Deletes the folders and files associated with the file path: %localappdata%\Microsoft\Office\16.0\Wef\To install, just unzip the file and have the user put it in an easy to find location (desktop, temp folder etc).This will not uninstall the plugin or reinstall it, but may help some users who are having periodic problems with the plugin ceasing to function.Also note, this may only be applicable to the Outlook desktop app.If anyone has other suggestions I can modify or add to the tool.

We have a lot of customers that have no recent activity, either open sales orders or invoices.  I know I could report on this by doing a group by GI with Customers, grabbing the max order date from SOOrder and the max invoice date from ARInvoice, but I really want to get this in front of the users both in the Customers GI as well as on the Customers screen.I see there is a “LastActivity” date in the Customers DAC, but it’s marked as Obsolete (we’re on 23R1, upgrading to 25R1 later this month).  Are there any other “In DAC” values that would help me avoid adding yet another set of joins (and the complexity of needing to group by the relevant customer fields) to the Customers GI?I’m going to post another thread in the Development forum about adding a DAC field, but before I write up a customization I wanted to see if I was missing something obvious already in the system.

How do all of you juggle manufacturing and shipments?    I came from a fully warehouse background and now supporting an on-site Manufacturing facility with a warehouse attached.  I am trying to optimize the existing location layout for most efficient processing without Shipping stealing from Production or vice versa. Raw material feeds to production most of the time, but could ship out.Production has different lines that do different processes and we step through the different stages.We also send finished goods back to Production for customization.The site had prioritized the finished goods storage locations the first priority, which works, until we get a return or sample order less than standard case quantity.  Second priority is Production drop locations for finished builds (saves time for allocation to allocate from the drop vs putting items away in finished goods storage to allocate).  Picking is by a standard pack (case) quantity.  If we have a partial in finished goods, it would

Are we able to set up a Create Shipment automation schedule that creates a shipment based on the sched shipment date/request date earlier than the actual shipment date? Ex.Sched Shipment Date/Request Date is June 20th.We want the shipment to be created on June 18th with a shipment date of June 20th. So when June 20th rolls around, we just have our warehousing team confirm the shipment on its way out. I’d expect this to be easy to set up but seems as though this processing screen only works on the day of shipment? I must be missing something here.

I am trying to see how much labor is required for producing Items but I keep running into issues with how  qty to produce for each operation ID is calculated.From what I have seen it is setting it to be always equal to the qty of the Inventory ID you are trying to make. Shouldn’t it be equal the the quantity needed in the BOM times the qty of the inventory ID?The materials seem to get calculated correctly and lists the total qty of the subparts under each operation ID correctly. Anyone else run into this?I have attached an example Production order with the first step being one that should have made a qty of 3.  

HiI am want to add the purchase order number to the below screen, on the details tab on landed cost screen. I want to add another column. Currently i am only able to see the PO receipt number.   

Hi there,We’ve restored the snapshot on a new Tenant on the same site, changed credentials, and Printers were populated to the system. When we execute a Print Job, DeviceHub receives it, getting Poll but failing Printing after a couple of attempts. If having the same settings, we changed credentials to the other tenant, and everything is working as expected.Has anybody encountered a similar issue? Please share your thoughts

I have a warning message on the customer master but we don’t use dunning. How do I turn this off?Thanks 

public class ProjTaskAttribute : ProjectTaskAttribute { public const string Labor = "LABOR"; public ProjTaskAttribute(Type projectID) : base(projectID) { Type Labor = typeof(CONTAINS_LABOUR); Type SearchType = BqlCommand.Compose( typeof(Search<,>), typeof(PMTask.taskID), typeof(Where<,,>),typeof(PMTask.projectID),typeof(Equal<>),typeof(Current<>),projectID, typeof(And<,>),typeof(PMTask.description),typeof(Like<>),typeof(Current<>), Labor ); PXDimensionSelectorAttribute select = new PXDimensionSelectorAttribute(DimensionName, SearchType, typeof(PMTask.taskCD), typeof(PMTask.taskCD), typeof(PMTask.description), typeof(PMTask.status)); select.DescriptionField = typeof(PMTask.description); select.ValidComboRequired = true; _Attributes.Add(select);

I need assistance in making the Financial Period based on the date is it possible?

Hi I am trying to update the purchase order line details via API call below using the GUID:Request Type: PUTURL: https://{URL}/entity/Integration/23.200.001/PurchaseOrder/5ad3671b-217f-f011-ac46-0a3ddcc27c8dThe above GUID used in the request URL is the purchase order related one. Body:{    "id": "5ad3671b-217f-f011-ac46-0a3ddcc27c8d",    "Type": {        "value": "RO"    },    "OrderNbr": {        "value": "SPC005897"    },    "Details": [        {            "id": "d109d928-217f-f011-ac46-029be7b75a6f",            "VesselName": {                "value": "TEST"            },            "DepartureDate": {                "value": "2024-01-15T00:00:00Z"            },            "ETA": {                "value": "2024-02-20T00:00:00Z"            },            "FirstFreeDay": {                "value": "2024-02-22T00:00:00Z"            },            "LastFreeDay": {                "value": "2024-02-25T00:00:00Z"            },            "ContainerNumber": {                "value": "CONTAINER1

Is there an OOTB way to pass the customer po number to the shipping label - UPS or FEDEX? Feels like there should be a mapping somewhere but I feel like I am missing it.  

Hello, In our stock item screen, we have 2 options for the “Default Mark For” setup, production and purchase. However, there are a few items that are showing numbers instead of purchase or production. See the below screenshots for part number 021. You will notice, it is setup for production, but on the stock item screen it shows “10.” I have included a shot of the GI setup as well. This is only happening on a few stock items and does not seem to matter if it is setup as production or purchase. Any ideas on why this has happened and how to resolve? FYI, I already changed the item to purchase, then back to production and am still showing the same “10” 

I need to know how to close a AP Bill that has already been paid and closed, but reopened due to its Account being reclassified. I have listed the full process the Bill went through below.Billed Entered Approved Released Paid in full by a check, closing the Bill Bill was then reclassed using “Reclassify Bill” functions and specifically the Account was changed during the reclassification.The bill is still linked to the check and it shows that it was paid and the amount paid, but is in open status.The check that it is tied to still shows the full amount as well 

Hello,I have an AP Bill that I was trying to reclass. When I initiated the reclass and attempted to ‘release’ the bill, I received an error message ‘Updating the ‘PMRegister record failed because data in some field is too long’ (screenshot is below)How can I shorten the description so that I can release the bill?Thank you. 

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: