Discussion Forums

Hello,   Two languages are set and active in my Acumatica instance : English and French.I currently log with french localization.Several of our customers need to receive their invoice in english version.I thought that set the local field on the customer screen would provide the correct the result but no : The printed invoice is always displayed in french version.The only way I found to get the english version is that : The user who clic to print/ send the invoice is logged with english on the logging page The user set “En-US” of parameters besore executing the repport .Is there any other way to send to english customer, english version of their invoice ? 

Hi Guys, Im having a little issue with redirections.I receive these errors:After I attempt redirection from here:The ‘Press and Glue Log’ works fine…My DAC key fields: #region DocNbrpublic abstract class docNbr : BqlString.Field<docNbr> { }[PXDBString(15, IsKey = true, IsUnicode = true)][AutoNumber(typeof(ISOSetup.autoNumberingQC), typeof(GCQCRecord.date))][PXSelector(typeof(GCQCRecord.docNbr), typeof(GCQCRecord.batchNbr), typeof(GCQCRecord.date), typeof(GCQCRecord.sOOrderNbr), typeof(GCQCRecord.status), ValidateValue = false)][PXUIField(DisplayName = "Doc Nbr", Enabled = false)]public virtual string DocNbr{ get; set;}#endregion#region BatchNbrpublic abstract class batchNbr : BqlString.Field<batchNbr> { }[PXDBString(15, IsKey = true, IsUnicode = true)][PXSelector(typeof(AMBatch.batNbr), typeof(AMBatch.docType))][PXRestrictor(typeof(Where<AMBatch.docType.IsEqual<Messages.move>>), Messages.MoveNotFound, typeof(AMBatch.docType))][PXUIFie

We are looking for a way to “turn off” items that are discontinued or sold out when gone once inventory is depleted. We’re not necessarily looking for an event to be triggered in Acumatica (purchase or transfer), but a way to identify and track when inventory is low for specific SKUs would be helpful so they can be set as Inactive. 

Hi allIs there a way to create GI with the Inventory balance? We need to create it with inventory transaction details such as receipts, Adjustments, etc and it should include dates and batch numbers, and ref numbers also. I have tried to create it with INregister and INtran tables. But it did not work as the landed cost variance details are also fetched to the GI. Thank you! 

There are times an invoice is created accidentally and we need to reverse it but, for customers with Credit card terms, if we try to reverse an invoice, we get the error in the screenshot attached stating the customer does not have a braintree method set up. We do not want to refund the customer, just to reverse the invoice. This customer in the example screenshot pays with cc but he does not store his cc when he places orders, so we cannot set up a braintree profile for him. In these situations, how do we reverse an invoice for a customer with credit card (BPP) terms without having a braintree profile set up?  

Hi All,I want to add a condition to a generic inquiry to filter timecards created on last week. To do that I think that I would need to compare EPTimeCard.WeekID with current WeekId. Is there a way to populate Value field of GI with current WeekID ? Thanks

I am writing a custom DAC that uses the GLTran table.  The default GLTran DAC will filter on the FinPeriodID field in the format MM-YYYY, however stores the field as YYYYMM.  When i try to use the field directly in GI conditions I have to specify the financial period ID as YYYYMM to get the results.  What do I need to do in my DAC for that field to operate in the MM-YYYY form like it does in the stock GLTran DAC? I tried working with something like this:  #region DB Calced Formulas using FinPeriodIDLeft4 = Use<Left<GLTran.finPeriodID, int4>>.AsString; #endregionHowever, I do not know how to swap the first 4 and last 2 of the field value in order to make it work like the stock DAC does. Thank you in advance!

In the latest version of Acumatica does it allow for me to have multiple companies in the same tenant, each with separate GL Chart Of Accounts?For example, if I have one tenant but two companies, can each of them have their own separate GL and Chart of Accounts.  Or do they have to share the GL Chart of Accounts?Thank you,Netadmin

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