Solved

Hello Community,I have been trying to create a report where I would like to display the vendor name (of the subcontracts) in the details section on the basis of the project ID selected. I have implemented the following on GI level and it works fine. But not able to replicate the same in report:GI: Report: Have used the same as that of GI What is it that I am missing here?Thank you in advance.​​​​​​​

Hello Community,I wonder if anyone had experience translating check amount, that’s represented on Check form AP641000 by field [APPayment.AmountToWords] in to Spanish?Localization was completed for the system, and everything is being translated fine, including the rest of the fields on this form. Thank you 

Hi,we would like to show the service appointments and service orders we have created from a project in the project itself. Similar to the project orders for the matrerial which can be seen in a tab we also would like to see all service related orders/appointments in a tab to have the overview directly in the project. Does anybody has an idea for this?

Error: “The account is on a credit hold. Remove from credit hold?” When I am creating a new sales order, the following error has occurred. 

Hi Everyone Is there a way to see the document LINE attachments in the Vendor Details Screen (AP402000) without opening the actual document?  Thanks 

I have a requirement to create a purchase receipt using Acumatica API.This is my code for that. RootObject obj = new RootObject(); obj.Type = "Receipt"; obj.VendorID = "GRI SL"; obj.VendorRef = "2131"; obj.Locatrion = "Main"; obj.ShipmentRef = "00028"; obj.Date = DateTime.ParseExact("10/10/2022", "dd/MM/yyyy",CultureInfo.InvariantCulture); obj.PostPeriod = DateTime.ParseExact("10/10/2022", "dd/MM/yyyy",CultureInfo.InvariantCulture); var jsonStrings = JsonConvert.SerializeObject(obj); PXTrace.WriteInformation(jsonStrings); var jsonString = JObject.Parse(jsonStrings); PXTrace.WriteInformation(jsonString.ToString()); var URL = "https://globalrubberindustrieslimited.acumatica.com/entity/CustomEndpoint/22.200.001/PurchaseReceipt"; var httpRequest = (HttpWebRequest)WebRequest.Create(URL); httpRequest.Method = "PUT"; httpRequest.ContentType = "application/json";

We have a client that has multiple production lines that they can choose from to perform the same operation. I am trying to use APS to automatically fill the capacity of these lines. As of yet I have not found a suitable solution to achieve this. Does anybody have some advice here?  

Hi,Does anyone know how to get data from a hidden table in Acumatica report designer? We have a reference number to get from, but it is not visible in Acumatica report designer. How to get to this table in the report designer?     Thank you.

Hi,I have already imported the basic fixed asset information. We are doing a FA implementation and the system is in migration mode. However, I am trying to do a second import only to update the Last Depr Period and Accum. Depr (see below) and my import is failing. The second screenshot is my import scenario. I have also attached a copy of my data provider. What fields am I missing in my import scenario or Data Provider.  Thank you,Frances   

Good day, I am trying to delete a Non-Stock Item from several BOMs, but the mapping that I have is giving me an error “Field: Operation ID, Value: 0020, Error: An attempt was made to add a duplicate entry.”, and I have the Line Number = 0, to not create any other lines, just to identify the material that needs to be deleted.Any ideas why this will try to create a record instead of following the mapping to delete the Material?Thank you so much! 

I have a customization project which includes a custom JSON object which i created.foreach (PXResult<POLine> result in polineview.Select()){ POLine line = result; if(order.OrderNbr == line.OrderNbr) { // Sample JSON object var sampleJsonObject = new { OrderNbr = order.OrderNbr, CustomerOrderNo = "CS0005", CusomterOrderLineField = new { PartNo = "P002", UnitCost = line.CuryUnitCost, InventoryID = line.InventoryID } }; string json = Newtonsoft.Json.JsonConvert.SerializeObject(sampleJsonObject); PXTrace.WriteInformation(json); } }JSON Data:{ "OrderNbr":"000453", "CustomerOrderNo":"CS0005", "CusomterOrderLineField":{ "PartNo":"P002", "UnitCost":367.640000, "InventoryID":18066 }}My API is http://testinstan

Hello Fellow Acumatica users! :)We need retainage to show up on all of the AP & AR agings?  Do any of you have ideas on how to make this happen?  (We had it in Sage300, and now don’t have the same visibility with Acumatica.)

Hello,I am trying to bold a description field of a particular row without also bolding the GL value. Is this possible to do on only one row and not all rows in a singular column?My goal is to get “REVENUE” to display on row 110: 

Hello All,If I am not mistaken, Acumatica introduced “IsInSubselect” & “IsNotInSubselect” with FBQL which is the Equivalent of “IN” and “NOT IN” of SQL. When we use these two functions it is translated to SQL correctly but they have a deadly flaw. This flaw impacts the whole result and when you expect to have thousands of records you get NONE. Look at the two below SQL queries (just logic, do not think what a stupid query). Please note I can NOT use Join//#1SELECT * FROM Vendor WHERE BAccountID NOT IN (SELECT DefPOAddressID FROM BAccount WHERE DefPOAddressID IS NULL)//#2SELECT * FROM Vendor WHERE BAccountID NOT IN (SELECT ISNULL(DefPOAddressID, 0) FROM BAccount WHERE DefPOAddressID IS NULL) Both queries are instructing SQL to return all vendors which do not have DefPOAddressID but the first query returns none while the second one in my case over 2,000 and this is what I expect to get. The only difference is the ISNULL wrapping. Acumatica translates its queries to the first one so I

Hi, Upon adding the same location in warehouses, upon saving the added location does it disappear?We want to tag a different project task in one location to process a transaction with project ID tagging.Thanks!

I’m trying to update an attribute value on appointments in Postman but the value will not update.Here is my PUT request:{{acuBaseUrl}}/Appointment?$filter=ServiceOrderType eq 'PM' and AppointmentNbr eq 'SV001280-1'&$expand=Attributes&$select=AppointmentNbr,Attributes/Attribute,Attributes/ValueHere is the body:{    "ServiceOrderType": { "value": "PM" },    "AppointmentNbr": { "value": "SV001280-1" },    "Attributes":     [        {            "AttributeID": {"value": "Is Inspection Complete?"},            "Value": {"value": true}        }    ]}I’m not sure what else needs to be done.  I’ve also tried using the Attribute ID of INSPECTED but it still won’t update.  I’m using the Default/22.200.001 endpoint.

As the title states, I am new to Acumatica.Where is the DACs documentation? I can’t find anything about BAccount, BAccount2, etc. In the same DAC extension, can I reference a different field in the selector query? For example, the user selects a customer and then I want to populate another field with that customer’s projects. Is it best practice to put each customization in its own “project”, i.e. I have a customization the SO screen and another for the PO screen. Should all customizations for the same screen be in the same “project”?

I’m trying to configure DeviceHub to connect to my local development instance and I’m getting this error: Failed to connect to http://localhost/siteName/signalr/hubs/deviceHub serverI can’t find any related posts or information.

I’m having the most trouble with PO approvals. I have a simple PO approval that is just checking for a particular project. While I get the approval task for the assigned person, the workflow continues on and doesn’t provide the “Approve” or “Reject” buttons. Any ideas?Side note: i just had this working a few weeks ago. It seems to randomly work and stop working. Not sure what is going on.  See below: 

Is there a way in which one can add vidoes to the customer portal visible to all cusotmers?

We have prepared and and released GST tax reports for the company using wrong period ( Monthly ) for the periods January to August. Now we want to update the tax period to the correct one ( Quarterly ) but the period type drop down menu is inactive , I think because we have released tax reports in the system.Is it possible to void these tax reports without financial impact?

Dear Team,Please let me ask about Contract Management in Acumatica.Does Contract Management in Acumatica only manage service contracts? This means that Contract Management in Acumatica only manages service contracts (Non-Stock Items)We currently sell Goods in stock (Stock Items). We have to make paper contracts for customers. Can we apply Contract Management in Acumatica to manage contracts for the sale of inventory goods? Best Regards,NNT

Hello everyone,I added the Shipments screen to the mobile app. There are only a few fields that we need in the mobile app. All of the fields show up in the app except Tracking URL. Here is the code: add screen SO302000 { add container "ShipmentSummary" { add field "ShipmentNbr" add field "Status" add field "Customer" add field "Location" add field "ShipmentDate" add field "Description" add field "Packages#BoxID" { special = AllowEdit } add field "Packages#TrackingNumber" add field "Packages#Carrier" add field "Packages#TrackingUrl" add recordAction "Save" { behavior = Save } add recordAction "Cancel" { behavior = Cancel } add recordAction "ConfirmShipmentAction" attachments { } }}Again, all fields show up except Tracking URL. I also tried changing the name to TrackURL and that didn’t work either. Any ideas?

Hi Community!!I’m trying to fetch details of users for that I created a new Endpoint extension with name “AppUsers1”I have added 5 fieds for it but Username was showing a warning. as per the document I310 web services Tried ti fetch the data Using GET with Key Field Valuesbut I’m not sure which fields are Key Fields tried with Username but is not working. POSTMAN Get callHow can I find the Key fields is there a standard way or does that differ?Thank you in advance.

Morning everyone,In previous version 2019, we were able to add printed forms in PO screen using automation steps. But somehow in newer version of 2023 R1 Build 23.107.0022, system says “This screen uses the new workflow engine. All automation steps will be ignored.”.Any possible workaround for this matter?Thank you.