Discussion Forums

Hello, We have successfully set up the Exchange server integration with acumatica.However, in order to synchronise everything with outlooks such as tasks, contacts, events, we need to run this processing screen.Which gets stuck every time returning one error message with no details:Can someone asssit? 

Good day,I reused an import scenario to create new stock items.  I assumed it worked when it was used in the past however, I can be sure.  The error (as researched) states that my Inventory ID is over 30 characters.  However, I checked them; all less than 30 characters. Anyone have any suggestions?  What I should look at next?  Attached is the XML.We upgraded to 2023R2 last week.Thank you. 

Hello everyone,I need to create many purchase orders for a production order.How can I do that because the system only allows to create one purchase order and if I change the quantity, it does not suggest to create another purchase order. Thank you in advance. 

In our warehouse, only one lot/serial can be stored in a location at the time. In Acumatica is there a feature or method to limit the location to store only one lot/serial number?

After adding grid columns in code and getting them to keep their column position after moving (see this post → Keeping grid column position for a column added in code), these columns will not sort or filter.   If I click on their header cell, and choose Sort Ascending or Descending, there’s a flash of the sort icon arrow, but then it disappears and no sorting happens.  Similar for filtering, if I enter a filter condition in the same context-sensitive popup, it is ignored.  When I add the grid column in code, I do set the SortField, AllowSort, and AllowFilter properties appropriately.  Any idea what I’m missing?

Hi,i am creating a customer invoice and have a problem. It happens in the field “Project Task” under Details. After I pick one of the task from the list, the selected task disappear and the field remain blank. I can’t save the invoice when the project task field is blank. Not sure what goes wrong.Raymond   

Hi,Attached is the Bills and Payables screen for a new bill in my company version of Acumatica. I recall i can add the project field in the top part of the screen. But I forget how to do that. Could anyone kindly advise?Thank you.Regards,Raymond  

How would I correct a Subaccount on an existing Deferral scheduled item?  I am new to this role and would appreciate detail instructions if possible.  Thanks for any help I can get.    

In the below screenshot, I am attempted to override the Release Hold button the Bills and Adjustments screen using a graph extension:I am running into an issue where I receive the following error: This error seems to happen due to the use of the WebDialogResult, while the purpose of this change was to include the dialog, when it is removed and we just either A) throw the exception or B)invoke the base the functionality here seems to work. When the dialog is initiated, that is when the error appears.Here is the trace log: PX.Data.PXActionDisabledException2024-05-28 16:37:58 UTC   Exception Ty

.

Hi everyone,We are currently in the process of configuring Acumatica and haven't gone live yet. Our reseller has informed us of a potential issue in the Service Contracts / Unearned Revenue module that we wanted to address early on.The problem arises when a service contract expires while we are waiting for information from the sales rep or customer. If the contract expires before we have all the information to rebill the contract, we are unable to bill/renew the contract. The solution presented is for us to change the system date to allow the contract to be billed. This solution however creates an invoice date in the past. If we change the invoice date then the deferred revenue schedule is created based off the invoice date and not the se

Hello, I need to specify total hours and fixed rate instead of employees ID and shift Is this option available in labor screen (AM301000) version 2023 R2 ? 

Are you a thought leader in the Acumatica space? If so, submit a session idea for the upcoming September acuCONNECT virtual conference happening September 13-14!  We’re looking for educational content to help your fellow users and partners make the most of their Acumatica system (no sales pitches, please).Submit your idea here:

Looking for a Template for Land/Sea and Air DGN (Dangerous Goods Note) Templates to Import into our Tenant.  I have located PDF version of the IATA official forms, but I can not find something that can be uploaded to the Report Writer in Acumatica.If someone has some advise or know of a way to accomplish this, I would be grateful for any help!  :)

When clicking Create Production Orders from a Sales Order, can the pop up screen be modified to include the item description line as well as the ID? 

This is the use case… Our company creates many appointments using the Services Contracts in the Equipment Module.  There are times that even though we have an appointment already created for a customer location, a new appointment will be called in and will require dispatch as well.  What we would like to do, if those two appointments are within the same month, we would like to combine the appointments and dispatch all of the services on one appointment.  Has anyone attempted this?

Hello,I am passing a variable from a subreport back to the main report.This is working with one problem.If the subreport has no records to report, the variable being passed back to the main report is wrong.The variable should always report the value from the subreport for the current record.The subreport itself prints correctly, but the variable appears to be from the previous record’s subreport value. 

I have a question on MRP Types.  I have certain stock items that are managed on a min/max basis.  Screws, for example, I just want to maintain an inventory level but don’t really care which unit of production they go in to.  The screws are on the BOM, so when I run MRP these items show up to purchase twice.  One purchase suggestion is triggered by the Reorder Point, which is what I want.  However, another purchase suggestion is triggered by Production Material, which I don’t want.Is there a setting within the Stock Item or possibly MRP Preferences that allows me to only use Reorder Point for MRP and not Production demand for items with a Min/Max replenishment method?  

Hello, I created a large report that required row codes, hidden calculated columns, and summed columns. Unfortunately, I am having trouble being able to SUM the percentage and division columns in my second image. Is there a certain formula or way to be able to SUM the calculated percentages? I think I’m having trouble because these are “Calc” columns. Any assistance would be very appreciated!! Column SetNeeding SUM**​​​​​​Regards,Brandon McIlhargey

Is it possible to pull in the currently selected report template into the report designer? Goal is to dynamically set the exported excel\pdf file names to the selected template\date. Any idea if this is possible?  

Is there anyway to access VS code on production instance? Wondering this because i currently built out a plug in in an extension library so how would i deploy this and modify this in production if need be?

My new GI has a calculated numeric value which the view displays as a decimal (19,4).  I would like the value to display as a currency with 2 decimal places and comma separators.Probably because I am new also, I can’t figure out how to alter the presentation in the view.Thank you! Tom Morris  

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 Sam Kabiri - Acumatica Community Featured Member for May 2024Meet Sam Kabiri our Acumatica Community Featured Member for May 2024. It’s great to have you as part of the Acumatica Community @hkabiri! Upcoming May and June

Hello community, my name is Ghyslaine Philie, I work for a Quebec Municipalities Association named UMQ. The UMQ was founded in 1919 and represents the interests of its members to governments.We also offer a growing range of commercial services and privileges.We are in the process of configuring Acumatica to support our purchasing and professional consulting services offering. As we are not live yet I thought I would join the community to ask question and benefit from your experience!  Ghyslaine