Discussion Forums

How to deploy the local instance in which i have created the generic Inquiry so that can access it globally 

I’m creating a vendor compliance workflow based on the Vendors (AP303000). However, I’m stuck with adding a conditional field (IsExpired) that’s related to the compliance documents on the Compliance tab of the Vendors screen. Please see the screenshots below..I need to add the ‘IsExpired’ field (found on the vendors screen - compliance tab) to the list of fields displayed. The yellow highlighted field (Expired) on the Compliance tab of the Vendors screen is what I need my condition to be based on. Please help to provide the steps needed to achieve this requirement.Thanks! 

We’re getting this error when clicking on the shipments tab of SOOrderEntry. This is an upgraded system, coming from 24R2, upgrading to 25.101.0153.Through the project editor we have added a state to SOShipment. We have a workflow that takes the new state into account. It’s been working in 24R2 from the beginning.Edit: In 24R2, the shipments tab does not display the correct status value, it’s showing the database value, not the text for that value:When I check the trace, the last line is: at PX.Objects.SO.GraphExtensions.SOOrderEntryExt.Status.GetValue(SOOrderShipment row)This error only appears if the order has shipments that have a Status value equal to the new status that we added.If I put the shipment on hold/off hold to change the status to Open, I can view the shipment on the Sales Order Entry’s shipments tab.I have unpublished all customizations and the error persists. This suggests to me that the issue is within the workflow somewhere but I have no way to debug it (that I know

hi! i am trying to create a business event to automatically create the receipt once the 2 step transfer is complete. i got the business event to create the receipt transaction but the transfer number isn’t populating so the details aren’t coming in.  is there something that i’m missing in my import scenario?this is what the receipt transaction ends up looking like: here are the results from the generic inquiry i am using in the business event: i have track all fields selected i appreciate your help!

Hi team, Is it possible to customize file dialog to add new column.  Thanks,Arun.

I am trying to alter a field on the payslip in the Report designer.  Does anyone know the report name/code? Usually we can go to the report then click on tools and it shows, however when clicking on the payslip it just auto downloads.

Hi guys. I am working on a report design in acumatica report designer.If a field is empty, how do i ensure that the white space left open is eliminated so that whatever should have come after that field, appears in the place of that specific field?

Hi,I need to develop new screen same as the existing standard sales order form.I’m checking the training videos and references in the acumatica openuni.But,I have some kind of problems when checking the videos.What is the best method to develop the project. ? Download and install acumatica ERP and develop project using visual builder and then deploy the project. My client already have an acumatica ERP hosted in cloud, Can I develop new screen using Customization Project Editor?I’m waiting for your answers.Thank you

Hi, can anyone help me ? $SubDPP=Format('{0:N2}',Round( Round([ARTran.CuryUnitPrice], 2)/1.11, 2 ))$SubTotalDPP = CDec( $SubDPP ) * [ARTran.Qty]I created a $SubTotalDPP variable in detailSection1, and I want to sum the variables in groupFooterSection1 =Sum( $SubTotalDPP ). and then when I run the report it always gives an invalid error Invalid field name $SubTotalDPP has been specified.   

We would like to add an additional Toolbar option “Printing and Emailing” to Screen ID PO302000.Created a new Customization and can see “Printing and Emailing” in the Form-Specific tree.How can I add another action here to point to and print a different report? 

Hello,I am building a GI screen specifically meant for our merchandising team to be able to review matrix/stock items of a certain status, to see if the item status needs updating. The main intent would be for archiving/deactivating products or otherwise moving them out of active status if they meet the criteria. The struggle I’m having is looking for a filter solution around attributes, since we only retire, reorder, etc full color or design lines as a group. The use case example would be:On a t-shirt product, which has “color” and “size” attributes– when all of the matrix SKUs of the same color under the same template id have sold out, that color line should be reviewed to see if that color specifically should be archived, reordered, not reordered, etc. (So if t-shirt BLUE size small is sold out, but t-shirt BLUE size large still has a lot of inventory, we don’t want the BLUE matrix/stock items to show up in the review. Only when the whole color line is sold out.) I am puzzled how to

I'm trying to target open AP invoices in a Generic Inquiry, but no matter what I try, the formula always defaults to the else condition. =IIF([APInvoice.Status] = 'Open', 0, 1) =IIF([APInvoice.Status] = 'O', 0, 1) =IIF([APInvoice.Status] = 'o', 0, 1) =IIF([APInvoice.Status] = 1, 0, 1)   =IIF([APRegister.Status] = 'Open', 0, 1) =IIF([APRegister.Status] = 'O', 0, 1) =IIF([APRegister.Status] = 'o', 0, 1) =IIF([APRegister.Status] = 1, 0, 1)I’ve also confirmed that my conditions are limited to open and closed invoices, yet the formula always returns the result for the else part.Any insight on how the status field is actually stored or how to get this to work would be appreciated Thanks!

Customer has defined their Easy Post carrier Shipper From address to be their warehouse.The From company name at the top left of the carrier label is then pulled from the Account name in the Warehouse record Our customer has asked that this From address show a different company name on certain orders where they are drop shipping for Home DepotIs there a solution for this ? 

I have a requirement to add an “Item Condition” field to the INItemLotSerial record. We need this because we offer Rent-To-Own contracts on our portable buildings. When the customer returns a building rather than completing the contract to ownership, we create a return order to ship it back and receive it back into our inventory as a “Used” building. Since all buildings are manufactured by us, all new records should have the “New” condition. I’ve added the below field to a DAC extension of INItemLotSerial, using the PXDefault attribute to set the value to “New” for new lot serial records. The SWItemCondition.List attribute is a custom string list attribute to provide options for “New” and “Used” conditions. Now; this value is only changed to used when a return shipment is completed for this item. I update it using the following code.  This “SetItemCondition()” method is called in an override of the “SOShipmentEntry.updateIN()” method, for return shipments only. This all works, and if I

Client has a utility vendor with the pay separately box checked.  When the client goes to select the AP bills for payment, they show with the pay separately box unchecked and all the AP bills come out on one AP check.  They have a workaround to check the boxes, but would like to have the functionality work for this.  I have attached an example.This has been happening with several of their vendors.  I do not see this as a known issue for 2024 R1.Does anyone know why this would be occurring?Thank you!

Is there any documentation on how to setup the dev environment for the Modern UI?The only thing I can find is the PDF of the slides from Andrew Bulanov’s DevCon 2023 presentation.- Install Node.js of the version 16.14 or higher- Open a command prompt window, change the directory to FrontendSources folder of the site- Execute npm run getmodules- Execute npm run build-devI installed the latest version of Node.js from the Node.js web site.I executed the getmodules command.I also ran this command to make sure typescript was installed: npm install -g typescriptWhen I run the last command I get a lot of errors.  Maybe these can be ignored?Using Node and Typescript is new to me and I was hoping there was a cheat sheet from Acumatica on how to get started. 

 Error: Inserting 'Purchase Order' record raised at least one error. Please review the errors. Tax Zone should be..ON. The warehouse and branch are both located in ON and the vendor is location in BC.  Error appears from create PO from requisition. Anyway to turn off taxes completely or the work around this for a company with multiple different tax zones per warehouses/branches. 

I am having a little difficulty getting my PowerBI Tiles up and running on the Dashboard.   I used the following link to set up my application on Microsoft Entre (Saw on another forum).  I followed the instructions and setup a Secret and registered the Redirect URI.   https://app.powerbi.com/embedsetup When I go to add the PowerBI tile it lets me put in the Client ID and the Client Secret, when I hit login it pops up a real quick page and then it disappears.  I do not have any additional options in the setup and I don’t receive any errors.   Any thoughts, I am very new to PowerBI and Acumatica, so I am sure it is something simple I am over looking.   ThanksChris

Hi everyone,I’m currently trying to create an AP Bill from a Purchase Receipt using an API (Postman), but I’m running into an error.Here are the details:Endpoint: POST {{BaseURL}}/entity/Default/23.200.001/PurchaseReceipt/CreateAPBill Request Body:{ "entity": { "id": "a256ce42-5b3b-f011-837f-0eddcec71d29" }} Response from Postman:{ "message": "An error has occurred.", "exceptionMessage": "Operation failed", "exceptionType": "PX.Data.PXInvalidOperationException", "stackTrace": " at PX.Api.ContractBased.EntityService.Invoke(ISystemContract systemContract, String version, String name, EntityImpl entity, ActionImpl action, CbOperationContext operationContext, Boolean throwOnError)\r\n at PX.Api.ContractBased.AspNetCore.CbEndpointFeatureServiceExtensions.Invoke(IEntityService entityService, ICbEndpointFeature feature, EntityImpl entity, ActionImpl action, CbOperationContext operationContext)\r\n at PX.Api.ContractBased.WebApi.Controllers.ActionController.InvokeA

I can’t figure out where the access rights to share a filter on a GI is located in the permission settings. 

I am looking for an ISV that can assist with functionality to help a manufacturer who takes batteries and extracts various metals from the batteries and resells those metals.   Any ISV or specific process anyone knows of? Thanks,Nirav Shah

Hi,I tried to create a Sales Invoice by adding sales orders with shipments as well as without shipments.Initialy I added sales orders without shipment through “Add SO Line” action icon in the Invoice and Then I tried to add Sales Orders with shipments through “Add Order” action. Howver, once I click the Add order action the popped up window didn’t show any sales orders. But if I added “Add orders” first and “SO Line: secondly, it has the ability to add both. What could be the possible reason for this.Thanks!

I have next problem. I am trying to add section to the right to blue section but it’s displayed on the bottom of the screen How I can make it correct? <template>  <qp-fieldset id="fsColumnD-Request" view.bind="Document">      <field name="UsrPOCreated"></field>      <field name="UsrConcatReference"></field>      <field name="UsrMotivationReason"></field>  </qp-fieldset><field after="#fsColumnB-Request [name='Description']" name="UsrRejectReason"></field><field after="#grid-Details [name='InventoryID']" name="UsrWarehouse"></field><field after="#grid-Details [name='UsrWarehouse']" name="UsrTaxCategory"></field></template>

Is it possible to make Acumatica Wiki pages accessible directly within the mobile app?Currently, some users have access to these pages through external links, which is not ideal for those who primarily use the mobile application.

HiI am trying to make a field required when a customer tax zone is specific on the SO order type. The problem i am having is making this field required when trying to create a shipment. So the field will not be required on SO creation, but rather when trying to invoice.