Discussion Forums

Good day,I am trying to figure out why Project Quote/Quote correction/edit function is not available to my users.  As the administrator, the correction feature is unavailable.I check my roles and access rights.  Where could this feature be hiding?Thank you.Evan 

I want to link the task created from this task template to an Opportunity but ((CROpportunity.OpportunityID)) doesn’t work because the help text says to use “Attach Activity”. Does anyone know where I can find the “Attach Activity Checkbox” that is mentioned in the help text for the Link to Entity field in Task Template is?  

Hello everyone.Today I want to share with you a step-by-step guide on how can you set up an Approval flow for your custom DACs or a custom Approval screen for standard DACs (which already support Approval flow).If you are using standard DACs - you can skip the first 2 chapters and go to Add approval views to your graph chapter right away.   Create Assignment MapTo make your setup DAC able to configure the approval process, you add the IAssignedMap interface and implement the required fields:  using PX.Data;using PX.Data.BQL;using PX.Objects.EP;using PX.SM;namespace Sprinterra.ApprovalHowTo{ [PXCacheName("Setup")] public class Setup : IBqlTable, IAssignedMap { // Approval configuration #region IsActive [PXDBBool()] [PXDefault(false)] public virtual bool? IsActive { get; set; } public abstract class isActive : BqlBool.Field<isActive> { } #endregion IsActive #region AssignmentMapID [PXDBInt] [PXSelector(t

Hi Acumatica community,We are trying to create an Import Scenario for an ‘Issue’ / Screen: IN302000I need to auto-create some inventory issues after running some queries which let me know that stock was used for a certain Item class. I am getting an error message ‘unit conversion is missing.’I am not sure if any one can share examples of this Import scenario or let me know what I can try to fix this error, or missing data possibly? Thank you in advance!! Import Scenario: Import Inventory Issue(Should be an auto-number for the Inventory Issue# / Ref Nbr. - Do I leave this blank?) Import Error: “unit conversion is missing” 

Hello all,I would like to know how can I make the field remain active till the Invoice Status = Open. I have extended the Default workflow, but not able to find the value where I can mark the required field as Active in Open. How to do this?  

Our use case: we house 5k+ products in our warehouse and need to perform daily cycle counting. Our goal is to count every product in the warehouse at least 8 times over the course of the year. In theory this should give us 150-200 products to count per day and products would get counted once ever 6 weeks.Does anyone have any suggestions regarding the best method to accomplish this? We have ended up creating 30 individual cycles and are rotating through these cycles in succession. However, this is not a great experience as it requires any new products to be added to one of the 30 cycles and there isn’t a great way to make sure they’re evenly distributed across all 30 cycles. 

We have two companies, soon to be three, setup on Acumatica and they do not share customers at all. We have been using the “Restrict Visibility” field to make it so that employees can only access customers that are a part of their company. Unfortunately, people forget to fill in this field all the time, leading us to have to go through manually figuring out what company they belong to every now and then. I looked into trying to auto-fill this field using customer classes, but the customer classes are shared between companies, so that’s not an option. I decided to turn to coding and try to use PXDefault to pull the branch/company from what the user is signed into, but I can’t get it to work and it just keeps throwing the following error. If anyone could give me a hand, that would be great.The multi-part identifier "Customer.COrgBAccountID" could not be bound. Here is my codenamespace PX.Objects.AR{ [PXNonInstantiatedExtension] public class AR_Customer_ExistingColumn : PXCacheExten

Once we match our transactions with the bank feed, is there any way on the transaction screen, to see if it has been matched to a bank feed transaction ? i.e. in the bank feed, we are able to see the AP document from the “Process Bank Transactions” page.However, on the AP document, are we able to see the corresponding bank feed item?

We have extended the StockItems endpoint from 23.200.001to include the following fieldsIt works great when filtering on AlternateID or InventoryID but when we try to filter on VendorCustomer we get a nil object unless we use substringof.Here’s an example:GET Request: ~/23.200.001/PartNumberXRef/?$filter=InventoryID eq '104175' and substringof('00250'%2CVendorCustomer)Returns: [{"id":"655f9396-3b5a-4796-8031-f18d8c447610","rowNumber":1,"note":null,"AlternateID":{"value":"3639541"},"InventoryID":{"value":"104175"},"VendorCustomer":{"value":"000000000250"},"custom":{}}]If we try this request, we get a nil object.GET Request: ~/23.200.001/PartNumberXRef/?$filter=InventoryID eq '104175' and VendorCustomer eq '000000000250'Returns: []Any thoughts as to why the equals query is not working or what we’re doing wrong?Thank you in advance.

Hi All,  I've gone through the I300, I310, I320, and I330 PDFs and have a decent grasp of the API. I am the only person in my Org who will be working on implementing functionality using the REST API.   Are there any features or modules that my admin should enable for development purposes? I have access to customizations so I can see the Element Properties when I hold down ctrl + alt. I have access to the DAC Schema Browser. I can see all of the Endpoints available. I have referenced the swagger endpoint docs. Is there anything else I should have access to or should review?  One example of a problem i’ve run into is understanding what arguments are required when hitting an endpoint.  For example the endpoint action bills/releasebills I was able to eventually figure out that I needed to pass the api call in this format:{“entity”: {        “Type”: {“Value”:”Bill”},        “ReferenceNbr”: {“Value”: “123”}}} Where can I reference what each endpoint is expecting?  Thank you  

Hello!I’m trying to import in test mode my excel. Everything seems good, I’ve been able to import one line while testing, but when I try to upload the whole file I can’t. I’ve read other posts about this error (not for bom but for orders and other items) but I didn’t understand how to solve it. No other user is updating same time and I don’t know how to use timestamp.Would somebody maybe help me? Thanks in advance.  

Hi Community,Our customers need line item taxing details for audits, and we use Avalara for tax calculations. We’ve heard that Acumatica doesn’t store line item taxing info, but we’ve seen this feature in other systems.Can anyone confirm if this feature is on Acumatica’s roadmap? If not, is there a workaround?Thank you.

I am trying to create a KPI widget on a dashboard from a GI that has parameters. Everything appears to be working fine, except that the KPI widget on the dashboard shows 0.   If i click the widget to go to the underlying GI, it shows the data filtered exactly as it should be, with the sum calculating correctly for the column i am trying to aggregate on the widget.    I tried re-doing a KPI with a similar GI with no parameters (i.e. hardcoded the parameter values into the GI result grid formula), and the total shows up in the widget. Which is confusing, because based on everything i could find on dashboards, having parameters on the GI doesn’t seem to be an issue?   Acumatica 2022 R2 (Build 22.212.0046) XML of Dashboard and associated GI attached  

I’m working on a modification on Payment Screen (AR302000) “DOCUMENT TO APPLY” grid. I need to to populate data into a another call when user selects Reference Nbr. What should be the best event to handle here?Please refer the image below:Thank you

I have custom data fields in my results grid that categorize my AR data into different timeframes.  I want to sort my data by the “Overdue total” data field, but it does not appear as an option in the sort order dropdown. I’ve tried to copy and paste the same formula into the sort order tab, but the data does not sort correctly. I have no idea what step I’m missing. 

By default, Json responses of a web Service end points looks bellow.{ "id": "9c089d8c-086c-ee11-8358-06c5a29671a4", "rowNumber": 1, "note": { "value": "" }, "BaseCurrencyID": { "value": "USD" }, "Branch": { "value": "GRITIRES" }, "ControlTotal": { "value": 14800.0000 }, "CurrencyEffectiveDate": { "value": "2023-03-15T00:00:00+00:00" }, "CurrencyID": { "value": "USD" },I need to format it as below { "id": "9c089d8c-086c-ee11-8358-06c5a29671a4", "rowNumber": 1, "note": "", "BaseCurrencyID": "USD", "Branch":"GRITIRES", "ControlTotal": 14800.0000, "CurrencyEffectiveDate": "2023-03-15T00:00:00+00:00"}and i need to customize the request body format also as above. is it possible in Acumatica ERP?

Our main aim is to receive the email notifications during MYOB actions such as purchase order approval and so on. For this activity, we are trying to setup a system email account. To do this, I have already configured ‘External Applications’ and ‘System Applications’. and I am using my own account to do the testing if i receive email or not. While clicking on this ‘Test’ button, Sometimes, I receive email, but some time i don’t. It shows error like ‘451-4.7.0 Temporary Server error’. Has anyone faced this issue before ? What am i missing? This issue is intermittent and can’t know the timing as well. happens randomly. will really appreciate your help.  

Good day team,I am trying to set the last period as default on a report designer report (in this case 07-2024) instead of current Period (08-2024), but i am having issues finding how to do it.The report designer has the From Period Value in the Parameters Tab of the Schema Builder the following formula: =Report.GetDefExt('OrganizationBranchReportParameters.FinPeriodID')I tried several things, but still no luck. Has somebody find a solution for this?I appreciate any help in this. 

I have set up a business event to perform the following:Auto mark items on the Prod Detail as Backflush On or Backflush Off based on an Attribute at the stock item level. Triggered by a Production Attribute (Attribute ID = PURCHVER) being checked off.My issue is that the Business Event only runs when there is one single item on the Prod Detail (and on GI), for some reason the system is not recognizing the business event when there are multiple items on the GI. See below. Business Event - Triggered based on Record Inserted of GI below Generic Inquiry - List of Material on Prod Detail with Prod Attribute as TrueImport Scenario is simply set up to mark the lines as Backflush on or off which I can confirm is working fine. In the list above, AM003535 was recognized and processed without issue. But all other orders do not get recognized in Business Event History when I toggle between the attribute PURCHVER True and False. In theory, each time I mark the attribute as False it falls of the lis

Hello,I am attempting to load BOMs.  All works well unless there are multiple materials on an operation.  Then it throws an error on the additional materials in the operation.  I am working with a VERY short data set to get this working but cannot move past this.  I started with the standard BOM import scenario. 

Hi ALL,With Report Definitions.  How can the account description only display 1 line?Even though I checked the "Suppress Line" in Column Sets, Accounts with descriptions that are too long still have their lines dropped.   Best Regards,NNT

We are using data from Acumatica in our BI (Superset) and Data Warehouse, but we are running into an issue. We pull the data via OData for each DAC. But, our number are off every time someone deletes a Sales Order, Return, Shipment, Refund, Payment, Invoice, etc. I looked at https://help.acumatica.com/(W(9))/Help?ScreenId=ShowWiki&pageid=4a1939a3-26aa-49e3-83c6-5bcc884e66b9, and tried adding the column to the SOOrder table, then deleting an order, and it didn’t work (I tried with and without the Usr in front) - It deleted the order, and it did not preserve the data as it says it would in the doc. I had planned to create a customization with a DB view to then use in a GI to then send push notifications to our Data Warehouse, but I can’t get past the part of being able to see what data is being deleted. I also looked at the Trace after deleting an order, which wasn’t helpful because it doesn’t show the deleted data either (that is below). Any pointers or suggestions here?SELECT COUNT

HiI have developed an integration using Odatav4 - to fetch(read only) from DAC based queriesI would like to know what the minimum User Role/Licence Type is needed in AcumaticaThe role is, I assume,  “Odatav4User”The Licence Type. “Limited API” , “Full API” ? Kind Regards

I am attempting to import a list of new contacts from an excel sheet yet when I run the import despite the import showing as Successful none of the contacts “processed” in the import show up in the All contacts GI. Is there something wrong with How I have this Mapped?  

Hello Comminuty,I would like to know how can we create variables in Acumatica Report Designer? Specially if a new datetime field is added on the screen and the user wanted to see the full format as 20 October 2023.