Solved

Understand they implemented a new feature but it’s virtually broken. Even the signature captured has an “error” and can’t be upload.Please rectify any workarounds, this update has greatly distrupt operations. 

I’m trying to do an Import Scenario to my INLIGHTIND Attribute which is Multi-Select Combo where I select multiple values. Below is what I have going. I tried importing as a comma separated list, but it didn’t recognize it and I added the values to different lines, but it just overwrote the first one and took the second. Ideally I can use the Value Description rather than the Value ID too. Any ideas? 

Is there a way to partially bill a customer from contract management? For example, the contract is setup as a monthly contract that bills the 1st of each month. Sometimes, the contract may be started mid-month and there is a need to bill the first month at a prorated amount. I can’t seem to find an option for this. 

Hi everyone, When exporting file attachments, in this case the Shop for Rates excel export, it downloads to my computer in a strange way. It says its an Excel file, and the file size is 5 KB.  After I open the excel document and save it, the file size jumps up to 9-10 KB.  The main issue I’m having is when trying to import these export files into Power BI (or even Jupyter notebook and Python). If I try to import the file into Power BI before saving it, I get this error: Does anyone know what the file type really is when it is exported from Acumatica? And is there a way to have this change to a “Valid excel document” without having to open up every file, save, and close?  Thanks in advance!

Receiving the following error when trying to release a payroll batch.“no suitable employee earning type has been found acumatica”Just started happening during the new fiscal year. same employees no recent changes.

We have a report that we want to highlight the last billed date if it is six months or older, but I’m having trouble getting the correct coding to make it happen. I know that I’ll have to have two overlapping fields, one visible for the highlighted dates, and one visible for the non-highlighted dates. For the highlighted dates, everything I’ve read has lead me to believe that =[ContractBillingSchedule.LastDate]>=Today(),'m',-6 should work, but it doesn’t. I’ve tried adding additional parenthesis, apostrophes, etc., but always get the same error: Syntax error in the expression. Context: TextBox 'textBox53' property 'VisibleExpr'  Any ideas? I’m sure it’s probably something simple that I’m missing. 

After the upgrade to Acumatica ERP 2023 R1, I cannot open or print a custom Check Form with Remittance (AP641000) form due to the “The report cannot be opened because it includes a table (ROUTINGNBR) or a field (AccountID) that does not exist” error message as shown in the following screenshot. 

I have an external  mobile application which I I’m intergating with acumatica. I  I’m using a look up field where a user has to select from and can also input keywords to get the desired customer.Below is the endpoint Im using;https://XXX.acumatica.com/entity/Default/20.200.001/CustomerNumber of customer in acumatica: 30,000However it is taking around 15 min to get the customers and be diplayed on the selector for the end user to choose or in getting the desired result if the user is using a keyword.How can I improve the speed of fetching to be in seconds and not this many minutes. 

In other systems we have setup a Tiered PTO schedule for time off. Which is directly run off of your hire date. Example:0-4 years gets a total of 2.7692 Accrued Hrs per week (per pay period)5-9 years gets a total of 3.5385 Accrued Hrs per week (per pay period)10+ years gets a total of 4.3077 Accrued Hrs per week (per pay period)So when Payroll is run it validates the years from your hire date - and then gives you the correct accrued vacation time per pay period. I cannot seem to find a way to set this up in Acumatica Payroll. Is this doable? Or does anybody know of a good way to set this up in any way shape or fashion to get this accomplished - preferably not just having the PR person verify employees tiers and manually update them as they cross into another tier. Thank you! 

Hello All,I have been running allocations but it gets nullified in the Project Transactions part. Why is it so? I have the allocation rule as follows:How to get my project transaction of the allocation type not to be nullified?Any ideas?

I have a slight performance issue on the Generic Inquiry I am running. The inquiry is looking at expediate/priority jobs for my organization but the way I am doing it, it seems to cause a performance issue for on the database. At this time it’s nothing major but I would like to improve it so as the organization grows it doesn’t become a larger burden.  Attached is the XML of the Generic Inquiry, any advice would be helpful!

I have added the header Notes to the body of our Project Invoices and that works fine.  However when the doc type is Credit Memo, the Notes get duplicated in the body of the printed form.  How do I fix this?  

Hi,I am receiving error “The given key was not present in the dictionary", when I am trying to make request to Purchase Receipt entityHere is URL of my request:  https://aiimy.acumatica.com/entity/ARTSDocAlphaEndpoint/20.200.001/PurchaseReceipt?$expand=Details&$select=VendorID,ReceiptNbr,Details/POOrderNbr,Details/InventoryID,Details/LineNbr,Details/ReceiptQty&$filter=OrderNbr eq 'PO001283' and VendorID eq 'AAVENDOR'This request worked previously, maybe something has chnaged in AcumaticaI checked endpoint for fields availbality and they are all presentHeader section Footer section I attach full stack trace, maybe it helpsIts Acumatica 21.211.0033

I am trying to create several planning BOMs using the current visual BOM for our products that we manufacture.  When generating the visual BOM there are several sub-assemblies that do not have their parts listed underneath them.  When I check their BOMs everything is active in them and nothing is on hold. In the below example the assembly RPH1-01000-03 should have an exploded view with all the parts associated with it underneath it. 

Hello, I have a released AR invoice that had the incorrect date entered. I have tried to correct the invoice date, which moved from July into June period, and when trying to release the corrected invoice I get an error;“Inserting 'Applications' record raised at least one error. Please review the errors. Unable to apply the document because the application period precedes the financial period of the document.”So it appears it is due to crossing to a prior period. How can I correct this AR invoice and get it in the correct financial period? 

 On the Print Invoices and Memos screen in Acumatica, is there a way to create individual PDFs for each invoice during bulk printing?

so, basically I have 2 different pages, both with a (vip checkbox) data field. one page is a customerClass and the second page is a customer page. the customer page is kind of an instance of the customerclass so when a record for customer is created, certain fields are already populated with information from the customer class. the vip checkbox is a custom field that i created and i want to know how i can link them so when the checkbox on customerclass is ticked, the customer records created take that value and tick its own vip checkbox. im new to acumatica so please explain in detail if you canthis is customer class,see the vip box on the right? if i tick that, when i generate a customer record, its vip box should already be tickedthis is the customer page. when i create a new record, the vip box should already be ticked if the customerclass vip box is ticked

I am trying to email a file created in a process screen.  The file must first be attached to a record before I can send it.  I am trying to attach it to a setup screen in the module we added for this process and the code runs just fine, there is no error but the attachment is never put on the email. Also when I look at the records for UploadFile and UploadFileRevision  the Primary screen is null.  Also adding the file did not make the file option on the menu show.  This is the code to upload the file (runs without error but nothing happens, email created and no attachement): byte[] filebytes = Encoding.ASCII.GetBytes(fileContent.ToString()); ;FileInfo myFileInfo = new FileInfo(Guid.NewGuid(), operation.Trim() + ".txt", null, filebytes);UploadFileMaintenance fileUploadGraph = PXGraph.CreateInstance<UploadFileMaintenance>();fileUploadGraph.SaveFile(myFileInfo, FileExistsAction.CreateVersion);PXNoteAttribute.AttachFile(this.Caches[typeof(JMSetup)], Setup.Current, myFileInfo);//PXNot

Seeing as Snapshots are stored in the Acumatica database structure it would seem to me that the additional records not only take up storage space but also affect performance when running reports, generic inquiries, etc.   Has anyone found that to be the case or can anyone share some knowledge about why this might or might not impact performance for DB queries?  

Hello! I’ve created a business event to send out an email with an attached form (AP payment remittance) whenever it is triggered (or payment is issued). I’ve created this same exact event and form in another tenant and it works perfectly! However for some reason in this one, it will send the email and form, but the fields appears blank. I’ve tried recreating the event and form several times and nothing seems to be working. Does anyone have any idea how to fix this?  

I’m trying to debug Acumatica 23r1 source code but am unable to get the symbol files to load so my breakpoints are hallowing and say “The Breakpoint will not currently be hit. No symbols have been loaded for this document.” I’d like to figure out how to get the source code debugging to work. Also has anyone else been able to debug the Acumatica 23r1 source code?I was using Acumatica 22r2 and I was able to debug that just fine. I also installed Acumatica 21r2 and I could debug that without issues. I tried 2 different builds of 23r1, 100.0138 and 103.0013(making sure to check the box to install the debugging tools), but both had the same issue.I’ve tried clearing my symbol cache via Visual Studio and deleting the TemporaryAspFiles folder where the files seem to get put but I still get the same issue. I’ve also tried installing fresh instances of Acumatica and creating fresh customization projects but that has not worked either. I used hyper-v to create a windows 11 VM(my PC is windows 10

Hi All,I am running into an issue while importing check payment transactions to the AR payments and application screen. My scenario setup is given below along with the error I am getting. I have Integrated CC processing enabled under 3rd party integrations and I suspect that is what is causing the problem but it really shouldn’t since this is a check payment and not a CC payment. Let me know if you guys have any ideas. Acumatica version: Acumatica 2023 R1 Build 23.111.0019   

hi all is there a pdf somewhere which list all the new features that the 2024 r1 version will have ?

when I setting up a connection to the BigCommerce store in Acumatica ERP the following error has occurred.Error: Test connection failed: Content: {"status":403,"title":"You don't have a required scope to access the endpoint","type":"https://developer.bigcommerce.com/api-docs/getting-started/api-status-codes","errors":{}}Status: Forbidden. 

Hi Team,We are working with Build 23.112.0032 and have a requirement to not copy field (attribute) values present under USER-DEFINED FIELD tab while creating new document from existing ones. Can you please suggest the best possible way to achieve it.Thank you!