Solved

Working an import scenario for BOM details which include both header BOM information and materials on the BOM within the same Excel. The Excel file is set up which row type 0 including header information and row type 4-8 including the materials on the BOM.   How do I set up the import scenario so I populate the header level information (for example the BOM description) based on information sitting within the row for TYP = 0.  I’ve tried some IF statements but not achieving what I need.

I have several supplier performance GIs that show outstanding items and due dates and would love to be able to set the GI to be extracted as Excel or CSV and emailed to a specific address each day. To be clear, each supplier has their own GI so it is not like i need to filter the GI based on supplier - all results in the GI can go on the same email.

Hey Everyone, If I have a stock item, HHH000BX0001, and there are multiple artwork version created (physically), how can I differentiate those versions in Acumatica while still keeping only 1 ID? I’d like to avoid using the LOT/PO function if possible.  Being able to use only 1 ID will allow to track cost under only 1 ID version having to filter and consolidate multiple ID’s. 

As a newcomer to the Acumatica environment, I'm currently navigating the process of transferring our locally hosted Acumatica Production data to our Test environment. The aim is to refresh the Test environment as part of our preparations for an upcoming upgrade. At present, the data in our Test environment is outdated, and we need to ensure that it aligns with the latest information from Production.While we have customizations in place, I'm seeking a comprehensive, step-by-step guide that can walk me through the backup and deployment procedures. My goal is to gain a clear understanding of the necessary actions to successfully transfer and deploy a fresh copy of data from our Production environment to our Test environment.Any guidance or insights into this process would be immensely appreciated. 

Hi,We have created two custom fields to get invoice numbers. These fields are not visible in the UAT environment but are visible in the production environment.  When I move the field to a different column, this happens.  But these fields remain visible in the Production environment even after we publish this customization project to Production. does anyone know what causes this and how to fix this?Thank you.

Hi All, I was trying to generate Custom Weeks for 2024 Year using the Time and Expenses Preferences Screen.  But when I save the above records, the below error is occurring. After investigating the issue, I found that there are already few records containing weekIDs of 2024 in the database(EPCustomWeek table) for previous year as below.   I suspect that this should be the reason for above mentioned error message. Any idea on this? How can I solve this issue? Thanks

Looking for a way to show a list of Sales Orders where the Production Orders tied to it all have a Status of completed. Does anyone have a suggestion on how to group/sort this? 

I want to list the roles for a specific user. I have modified the webservice endpoints to include “Roles: ContactRoles” under Users.I am able to get the user information, but I am unable to get the Roles. I have tried the $expand in the URL. 1) Setup for endpoint.Acumatica Setup2) Call in POSTMANPostman Call 

Hello Everyone, Recently we have upgraded to 22 R1 version but General Ledger Details report is crashed.When we are trying to navigate the report from Profit & Loss report to General Ledger getting this error.Can anyone help me on this?CC: @Irina  

Hello,I am trying to access OData to eventually pipe data to Excel but I cannot get my credentials to work.  I am using the URL http://<application site domain>/odata/We only have one company so there is nothing to add after ‘odata/’, although I’ve tried that as well.I am then prompted for credentials and I enter my Acumatica username and password, and the credentials are invalid.  I have checked the box for OData4 User for my username.What am I missing here?Thanks!

I’m using the default out-of-the-box AP bills import scenario. When I try to import more than 1 record, the first record imports successfully, but the next one fails with this error:If i import 1 at a time, it works. I have the key fields mapped.I have attached the import scenario. What change needs to be made to import more than 1 at a time? Thank you in advance for your help!

We are using several user defined fields with the combo control type. We just came across an issue where a value from the dropdown was incorrectly selected. We are able select another option in the dropdown, but cannot remove the data to change the field back to blank/empty. The weird thing is we have one UDF set up the same as all the others, that allows us to highlight and remove the data, but it’s the only one out of several. Has anyone else had this issue, or know what might be causing it and how to fix? 

Afternoon guys, Hope you’re all amazing! I am attempting to automate our ‘Add Order’ to shipment. I have got the Import Scenario and GI working but can’t seem to figure how I can get a business event to trigger when the GI is populated. The GI works by detecting items which have been manufactured (moved) and are allocated to a sales order.Below is the BE:BE history below too:If anyone has any suggestions, they are greatly appreciated and welcomed! Thanks in advance! Aleks

My local development with Acumatica ERP 23R1 (any version) does not display Trace detailsin the improved Trace window when opened on a page via the Tools » Trace option.It shows No records found.Has anyone else encountered this issue?The Improved Trace works fine on our development server, but not under localhost/iis. 

I’m creating testing in the TestSDK and one of my operations runs over 12 to 15 minutes.  I’m getting a timeout error:WaitTimeoutException: Timed out waiting for the WaitForLongOperationToComplete condition within the specified timeout: 360000msIf I only run the process for a few records, it works fine so it is not a problem with the actual code in my project.  Is there any way I can change this timeout limit or is this a “selenium” limitation?

My customize code working fine but when we use software more a week, this block of code stop working. But if we restart IIS service, it start working gain. Could you advice how to do it 

Hello,I can’t figure out how to populate this field through an import scenario. I’m trying to automate the closure of opportunities (Action: Close as won), but I won’t be able to do that until I can map to this field.any help? 

Hello, I would like to create a processing screen which will check a group of invoices, if an invoice has a file attached then the files will be added to a zip file. The user will download the zip file. I’ve found a document which explains how to use zip files in Acumatica, link below:https://www.acumatica.com/blog/zipped-up-acumatica-manipulating-files-part-1-zip/It suggests using an object called ZipArchive in the following way using (ZipArchive zip = ZipArchive.CreateFrom(zipStream, false)){ using (MemoryStream fileStream = new MemoryStream()) { fileStream.Seek(0, SeekOrigin.Begin); file.Write(fileStream); fileStream.Seek(0, SeekOrigin.Begin); zip.AddFile(fileName, fileStream.ToArray()); }}I cannot find the ZipArchive type, does anyone know which references and/or ‘using’ statements is required?The article suggests using PX.Common.Std, I have a reference to this file but I still cannot access ZipArchive.Thanks

I’m creating a business event that will notify our Payroll Department every time a job is marked certified, however I’m running into an issue getting the correct information in the “To” line of the email template. I created the GI with all the information that is needed, but there isn’t a field I can reference where the correct email address would pull from as it will always need to go to the same email address.I saw a video the other day where an extra column was added to the GI for the email address and set with a fixed result.  I’ve added this to my GI, but when I test, the email is not going through, and now I can’t find the video to troubleshoot. It would be great if I could just enter the email address itself into the “To” line, but from my understanding that is not possible. Any suggestions? Thanks for your help! 

Client is using Project / Construction.  Orders material and sets type to Project drop ship.  Issues is the commitment shows the order with Taxes.  But when receive the material it only adds the Item costs to the project and then writes the Tax portion off to an expense account.  How do you get the tax to get added to the cost of the project during receipt or Bill processing?  

Hi Team,How can we limit the number of hours an employee can work per week? For example, if Mark is supposed to work for 40 hours per week, how can we ensure that he does not work below or above 40 hours per week?How can we restrict an employee from taking more than 80 hours of leave per year? We want to ensure that the employee does not exceed this limit.

Is there a way to find out which account scanned which items using a mobile scanner, not an inventory tag? It would be really helpful for auditing if I could track exactly which account scanned what items and I figure it must be somewhere.

Hello all,i have been practising on creation of Wiki pages. I have not been able to get the table content displayed in a correct format. This is what i have been trying:And this is what I tried while practicing:And the table is getting displayed as:How can I format this in proper way?​​​​​​​Thanks in advance.

Happy New Year!!An incorrect AP invoice (status: closed) was posted in September but I tried reversing it with a debit adjustment (status: closed) posted in October.  I now try to reverse the incorrect debit adjustment with a credit adjustment (status: open).  Any ideas on how to close the credit adjustment, correct the AP invoice in September and correct the debit adjustment in October?Any help is greatly appreciated!Thank you!

HiAs mentioned in https://help.acumatica.com/(W(5))/Help?ScreenId=ShowWiki&pageid=c5e2f36a-0971-4b33-b127-3c3fe14106ffits possible to operate with odata uri conventions when querying entities (predefined or customized as well).however no odata metadata is available for all entities, which make it impossible to work with .Net OData clients packages, and require to build the HttpRequest parameters by myself.Am I correctly understand this, or there is a convenient way to do so ? (I do not want to define a GI for all entities I need)Thanks