Solved

We currently have consolidated financials setup so that company’s BLC and BBLPMC are included when running financial reports for company BLLLC. We also need company BLLLC to be included in these financial reports, but they are not being included.  I took a look at how the Unit Set is currently defined and it shows the following:Do I just need to add the parent company to the value to include it withing the consolidated reports like so? Am I going down the correct path with these changes or is there more that I need to do have data from all three companies within the consolidated reports?

We are currently implementing Acumatica and transitioning from NetSuite. In NetSuite, the "Created By" field is easily visible on most forms, which helps our users quickly identify who created a record.In Acumatica, I see that the "Created By" field exists in the Audit History, but not directly on the form itself. We would like to have this field (and possibly "Created On") visible at the form level for ease of use.Has anyone implemented this? What is the best way to display the "Created By" field directly on a form in Acumatica?

Can someone let me know what the logic of the conversion of units of measure is. I have read the help area about 10 times and I must have a mental block as it seems to be the reverse of what I would expect for converting from one unit to another. i.e. I would think converting a box of 10 bottles to a base of 1 bottle would require the instructions to divide by 10 but the operand is multiply. I am feeling quite stupid about this so please be gentle.. 

Despite the fact that there is a built-in “Westpac Business Credit Cards” option in the Financial Institution field on the Apply for Bank Feed screen, the credit cards cannot be found in the drop-down bank account field on Westpac website. Our client called Westpac and the reply was “credit cards can’t be set through Bank Feeds”. I put a question mark on this reply and am wondering if there is anyone setting up Westpac credit card bank feeds before?

Hi there,Which Role do I need to grant a user so that they can use the Product Configurator in a Sales Order to configure an item? When they click the Configure button to launch Configuration Entry, they get this “Error: You have insufficient rights to access the object (ConfigurationEntry).” Thank you!Jon 

On our dashboard, we have data that shows production labour vs planned labour and a variance number - however, the number comes out as an absolute number. To solve this, i was wondering if anyone has created a colour coding for a column for those that are over planned and those that are under planned - on the dashboard table.?  

I have a grid that looks like this:When I click + to add a new line item, I want to default the value in the Greater Than field to the Less Than value in the previous line.I can get it to work, but no matter which event handler I use, it only will do the update to the field AFTER I leave the line.Enter 6000 in the less than field Tab out of the line and the 5000 gets populated.I am using the FieldDefaulting handler to get the previous line and update the newvalue for the row being defaulted.NOTE...this code WORKS, but it only fires AFTER you leave the line.  When the current row has a SortOrder of zero, this tells me that this is a new row and to get the previous row. protected void ICSPricingMatrix_FromPrice_FieldDefaulting(PXCache cache, PXFieldDefaultingEventArgs e) { var row = (ICSPricingMatrix)e.Row; if (row == null) return; if (row.SortOrder == 0) { ICSPricingMatrix prevItem = SelectFrom<ICSPricingMatrix> .Where<ICSPricingMatrix.priceClassID.IsEqual<@

Does Acumatica offer geolocation tracking in field service to fill the project automatically based on the location when employees are entering their time or equipment time?

Hello, I am trying to export account details for the whole year 2022 by a specific branch for all accounts. on the Account details inquiry (GL404000) we have to include an account, so I was trying to recreate the screen as a GI where we do not have to include an account. I can get all the information in the GI besides the Beg. Balance and the End. Balance, any suggestions on how to get that information?Data class: GLTranRData field: SignBegBalance Screenshot of Account details screen:Thank you,KT

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

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 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!

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.