Discussion Forums

Can we set up Acumatica to only allow the printing of a Shipment Confirmation once the Confirm Shipment button has been pressed, and not before?

When scanning 3 different documents, the scanner sends each document as a separate email with its own attachment. However, only one of the emails and its attachment gets downloaded into Acumatica. The other two emails remain on the email server and are still visible in Outlook.Could you help identify why Acumatica is not processing all the emails and attachments? Are there specific email processing or configuration settings I should check to resolve this issue?

Hello, We are running into an issue where, when we manually update the Alternate ID on a SO line item, this change is not always saved by the system. This can happen even if the alternate ID is blank. However, this error is not easily reproduced and seems to happen at random. Any ideas on what could be causing this behavior?   Thanks!

Can i add a UL label to a BOM?

Acumatica Snapshots can be tricky, but they are extremely useful.  If you are unfamiliar with the feature, Acumatica’s snapshot system is an amazing ERP feature that lets the customer export and import a company’s data into/from a zip file full of files that represent the data of SQL tables in the ERP.  With Snapshots, you can create a copy instance of an Acumatica site by company.   It’s an incredibly powerful tool that gives you a lot of power over your data.  Customers can create copies of their sites for testing, experimenting, or for historical analysis. I’ve been using snapshots to troubleshoot customer issues since I started working with the product in 2013.  No longer did I have to go through the nerve-wracking process of troubleshooting an issue in a customer’s production environment.  I didn’t need to get a customer to allow me access to their system so that I could poke around, perhaps send a SQL query via the chat window, and desperately try to infer the issue in the time a

We are in the process of implementing Acumatica for our manufacturing and distribution company and are looking for a new platform for our website and product guide. Currently, we have several custom-built style sheets that pull data from our old system and create a professional looking product guide. The guide can be viewed in PDF from our website or printed. Are there any platforms that offer this type of functionality out of the box or with minimal customization? Thanks! 

Where in the access rights by user list will I find the option to disable certain user roles from being able to release sales orders and invoices from credit hold?

Hello everyone, My company is currently on Sage 300 CRE, looking at moving to Acumatica. We’re heavy Procore users and the lack support for syncing prime contracts and prime C/O’s between Acumatica and Procore in the past has prevented us from making the switch. I understand that this feature has been enabled in a fairly recent release, but so far the references we’ve been sent by our Acumatica & Procore resale partner are not using this feature. Has anyone actually enabled this feature that would be willing to hop on a quick video call and show us how it works?

Hello,      Every time, I run export by scenario, I got a fixed file name.        Can I make the file name generated with date as suffix?

Hi all, I’m struggling to get an OData connection from excel and Power BI.Both the below urls gives me what I expect when running them in a browser:https://{site.com}/ERP/odata/{Tenant}/https://{site.com}/ERP/odata/{Tenant}/{GI}But when I try to use the same urls in excel’s OData Feed I get the following error:We encountered an error while trying to connect.Details: "The field 'Branch' already exists in the record." Our version: Acumatica 2023 R2 Build 23.206.0006Any idea on how to solve this issue?

 We are running Acumatica version 23.206.0006. Our last update was a couple of months ago. After the upgrade, we noticed that the reports were taking more time to be printed, but it wasn’t a problem.However, for the past couple of weeks, some reports have been missing images from time to time. As a workaround, users need to reprint the reports. This issue is occurring with multiple reports. Note that all the reports are using sub-reports, but the complexity in some cases is not too high – for example, a report with two sub-reports and not many tables in the schema is having the issue. This is how the images are displayed when the reports fail: We have tested on different PCs and printers, so it is definitely something in Acumatica and we believe that could be related to a performance issue. CPU and memory usage on Acumatica are at normal levels. Has anyone experienced the same issue or have any idea where to look? Any idea is welcome!Thanks!

We are needing to import data from multiple sheets in the same excel workbook. However, we have been told that all data must be on the first sheet in order pull. Has anyone else experienced this? What was your solution?  Also, once you have hit the upload button a common settings box pops up. Does anyone know what the null value field represents? We haven’t been able to get a clear answer.  Thanks in advance for any help/clarification you can provide. 

Hello!I am creating a custom GI that aims to pull the Shipment Details by a given date. I want to show what inventory ID shipped out on what shipment along with the qty shipped and the shipping address. However, I am facing some trouble when I try to pull the shipping address onto the GI.I was able to join the SOOrder and SOShipmentAddress tables by joining the SOOrder.shipAddressID and SOShipmentAddress.AddressID fields (See below).However, it seems to pull the shipping address from the customer rather than the shipping address that is on the Sales Order or Shipment. We typically have to override the shipping address when entering a Sales Order, as we are in a business where a customer has many open job sites / warehouses to ship to.Does anyone know how we can get around the override and have the user-entered Ship-To address to come up in the GI? Thank you! 

How does one return to the original width of fields after clicking "Fit to Screen"?

i am trying to export an ACH batch to upload to my bank.Using the AP305000 Batch Payments screen getting the following error:The bank routing number specified for the vendor is invalid or empty. The number must be at least 8 digits. Verify the vendor's payment settings on the Vendors (AP303000) form. The Routing number is 9 digits and set properly in the Vendor Profile.Any idea why i am receiving this error and how to correct? thank you

I am running a GI which shows all GL Transactions from a particular ledger. These branches belong to one of three company groups. I need to be able to show the company group for each branch on the line on the GI.Is there a way in which one can link the branch to the organisation company groups? Many of the ‘related’ tables are hidden.Any suggestion would be appreciated. Thank you.

I would like to delete the value for the field  "restrict visibility to" from suppliers screen via an import scenario. Anyone knows how to do that? I tried to add a formula =’Null’ but I am getting an error message: Field: Restrict Visibility To, Value: Null, Error: 'VOrgBAccountID' cannot be found in the system.Many thanks, Patricia 

I am trying to integrate a 3rd party address validation rest service into acumatica, is there any documentation on how to do that to using  the same workflow as avalara or vortex  plug-in 

I have been able to create an import scenario to save credit memos, but I cannot apply the credit memo to an invoice.I get a message“An error occurred during processing of the field Reference Nbr.: Error: 'Reference Nbr.' cannot be found in the system.”even through I am able to apply other credit memos to that invoice.Any ideas?  

In sales order I have the freight cost but freight cost is 0 in both shipment and AR Invoice.   

Hello,I wanted to add a custom column in SO3030PL that any invoice due date smaller than today’s date plus 5 days and the status of the invoice is “Open,” then it should say Past Due, otherwise it should say “Current.” Here is my IF statement that is working normally without considering the invoice status:=IIf([ARInvoice.DueDate] + Day( 5) < Today(), 'Past Due','Current') I just need help on how to add the invoice status to the statement. Also, I could not name the column. 

I am trying to compress the size of the content showing in the remittance area of the Check Form with Remittance.  I have that task completed.  My employer would like for me to squeeze as many lines into that section with smaller font sizes as possible, ideally between 30 and 40 entries being displayed.  I have the structure of the layout completed on the ap641000.rpx form in Designer.  I've checked all the field values and incremented them according to the pattern in the "canned" items on the report.  However, I am only successful in getting a total of 12 invoice item values to display.  The remaining items do show up on the form output, but "Invoice Date" shows zero, "Invoice Number" shows zero, and Invoice "Invoice Amt" and "Payment Amt" both show "0.00" instead of the appropriate values.  I have adjusted the Payment Method "Lines per Stub" to 33 since I have 33 items ready to be paid with a single check and listed in the remittance area.  Can the form not be manipulated in this way

Hello! Is there a way I can delete a new field I created in a customization project before it has been published? I tried to publish it but received the below error message and then tried to redo it by using the same field name and am now receiving duplicate error messages:  

Is there a way to block project insert when a customer is on credit hold status?

Not all stock items are showing on the IN2025PL.  They are visible on the IN202500 form.  I cannot figure out why this is happening.  I do not see it as a known item in 2024 R1, the part appears to be set up exactly as the visible parts.  The client is on 2024 R1 Build 24.111.0011. New stock item -Not on GI