Solved

I created a Row & Column Set for a custom report.  I need a % of Salaries & % of Revenue to show in each column.  Below is the result.  T&B % should calculate off Salaries & % of Revenue calculates from Total Payroll Expense.    

I need to access the highlighted grouped values in one of the report. But I am not able to find a way through that. Can anyone help me here regarding this ?  

Hi expert.In this screen, When I choice Customer in Price Type Dropdown then Price Code Field will be visible, opposite I choice All Pricees in Price Type Dropdown then Price Code Field will be invisible. Now I want change flow, Price Code Field always visible. I try code below, but not effect. I forecast my code conflict with base function this screen. Please show me some suggestion. Thank you so much. var row = (ARSalesPriceFilter)e.Row;            InvokeBaseHandler?.Invoke(cache, e);            if (row != null && row.PriceType != null && PriceTypes["All Prices"].Equals(row.PriceType.Trim()))            {                PXUIFieldAttribute.SetVisible<ARSalesPriceFilter.priceCode>(cache, null, true);            }

Hi, we have customized the SO641010 (Sales Order) report. We are accessing attributes from the Stock Items Screen according to the inventory item in the sales order line. There is a new requirement, that if a Sales Order is in open or closed state then these Attribute Values can't change (should be the previously set value) if that particular Stock Item's attributes are changed to a new value. How can this requirement be satisfied?The join used is attached below.

Hi every one. I added new field UsrETA to PO screen but in Project Code it not exists.can i miss a step?Thank you so much.

Hi guys,I am currently developing an integration to pull data from Acumatica ERP. I am trying to implement an OAuth 2.0 flow using the Authorization Code Flow.From reading through the resources, I have gotten this flow to work for my local Acumatica ERP instance. However, I am struggling to understand how to expand this to other Acumatica ERP instances, such as those used by our clients.I understand that a key part of the OAuth flow is creating a record in the Connected Applications form, and being issued a Client ID and a secret. I’ve seen that I can export this Connected Applications form as part of a Customization Project, but when I import this Customization Project in another Acumatica ERP instance, it loses the record in the Connected Applications form. I suspect this may have to do with the tenant name being different in the other instance, but I am unsure how to get around this.Even if I do get this Customization Project approach to work, it doesn’t seem logical to me to have e

When I tried to open IN61500 in the report designer I get the following error.  We are on 2022 R1.************** Exception Text **************System.InvalidOperationException: Data at the root level is invalid. Line 1, position 1. ---> System.Xml.XmlException: Data at the root level is invalid. Line 1, position 1.   at System.Xml.XmlTextReaderImpl.Throw(Exception e)   at System.Xml.XmlTextReaderImpl.Throw(String res, String arg)   at System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace()   at System.Xml.XmlTextReaderImpl.ParseDocumentContent()   at System.Xml.XmlTextReaderImpl.Read()   at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace)   at System.Xml.XmlDocument.Load(XmlReader reader)   at System.Xml.XmlDocument.Load(String filename)   at PX.Reports.Design.ReportDesignerLoader.ReadReport(IDesignerSerializationManager manager)   at PX.Reports.Design.ReportDesignerLoader.PerformLoad(IDesignerSerializationManager manager)   at System.Component

We want to create a new case when the Send button is clicked on the email activity.  We have setup Incoming mail processing for delivery@barefootspas.com.  This works if we send an email from an external source to delivery@barefootspas.com a case gets created.In the email activity screen we have setup a template that includes delivery@barefootspas.com on the CC of the email.  the TO: is the customers email address.  (see screen shot included).In this scenario, the email is received but the case is never created.   We have tried to put the delivery@barefootspas.com email address in the TO field along with the customer email, in the CC field and the BCC field.   The case does not get created with any of these settings when sending the email from the Email Activity.Any help is greatly appreciated. 

Hey everyone, I keep trying to troubleshoot this issue and I’m coming up short. Anyone have any ideas?Error: SO Error: Carrier Service returned error. USPS:Wrong parameter type.  Send   Raised At: 3/6/2023 5:48:04 PM Screen: SO.30.20.00      Details: 3/6/2023 5:48:04 PM Error: SO Error: Carrier Service returned error. USPS:Wrong parameter type.    at PX.Objects.SO.SOShipmentEntry.ShipPackages(SOShipment shiporder)    at PX.Objects.SO.SOShipmentEntry.PackageDetail.ShipPackages(SOShipment shiporder, Action`1 baseMethod)    at PX.Objects.SO.SOShipmentEntry.<>c__DisplayClass57_0.b__0()    at PX.Data.PXLongOperation.<>c__DisplayClass18_0.b__0()

Hi, Some users are receiving the below error message when attempting to open up a new receipt in Acumatica, does anyone know what could be causing this issue?  

Hi all, I was just informed we still have allocated inventory from orders that were completed back in 2020. How do we ‘release’ this so we have correct inventory levels?Our inventory allocations jump from the end of 2020 to February 2023 so it looks like something happened 2 years ago that caused these allocations to become “stuck”? 

does anyone know what the character limits for the following areas on the on the change order/requests forms: Change Request Detailed Description Tab & Summary Level descriptionChange Request Estimation Tab - line level descriptioni am also curious to know the character limits on the change order form for the same areas (summary description, line level description, and detailed description also, if there is an easy way to find out myself, i would love to know :) Thanks!

I am trying to use Google Translate APi to translate an custimized form.Or can you guys tell me how to translate the DisplayName of a control using this API?

Can another Shipping Destination Type be added for Purchase Orders?   I’ve been asked to add “Custom” as another Destination Type but I don’t see where these are defined or where I can add a choice in the drop down list.  

Hi, I’ve had a request to expand our purchase order unit cost from 3 to 5 decimal places… is this possible? The only place I see for precision is in Currencies.  My concern is that even if I could expand from 3 to 5, all our other costs are 3 decimal places, would this cause an issue?  

Does Acumatica support using a manual card reader through Authorize.net or is using a third party app like Repay or EBizCharge required?

How to delete a check delete action endpoint through rest api.  

I am getting the below error when trying to post an AP invoice. This is not a new item or new purchase type. It has been done numerous times in the past so not sure what is causing the issue now and how to fix. I am not seeing anything on the Posting class that looks “off”. Any thoughts on how to fix?   

How to call a check delete action endpoint through rest api​​

Hi all, we’re having issues with our Bill & Adjustments excel export… it seems it’s only exporting fields based on one column (Vendor name) and not another (Description). Any ideas? You can see B&A shows 10 records, but only 6 were exported into Excel. Thanks!

We sell oil by the litre however we transfer to our warehouses by the bottle (5 litres/bottle).  How do we set replenishment up so that it will transfer in 5 litre lots?  

Hi, I created a custom smart panel to add data into my grid in my customized form. In my smart panel, it loads data from  both POOrder and POline DAC’s. But the issue is when I select one item  based on the orderNbr and click add  button in my smart panel, all the values of same orderNbr get selected automatically and inserted into the grid.I  have no idea about this. Can someone help me to solve this ?thank you.below code snippet for the reference which I have defined to select and assign them into the fields of the grid.public virtual IEnumerable InsertSelectedLines(PXAdapter adapter) { if (POrdersView != null) { int lineNbr = Base.APProformaItems.Select().Count + 1; foreach (PXResult<POOrder, POLine> result in POrdersView.Select()) { POOrder order = result; POLine line = result; if (order.Selected == false) continue; {

Hi experts,In the Sales Prices screen column Price Type only show Price Type = Customer. Now I want show  Price Type = All. I have two solution:Customize attribute PriceType Update logic Select data when init screenCan you guide for me or sent me relating topic. Thank for your help. 

Trying to enhance the AM613000 report to include our Legacy Part number on the report (this was implemented as a usr field on the InventoryItem table) It won’t let me join InventoryItem to AMMultiLevelBomData as I gather that AMMultiLevelBomData is a dynamic “table” based upon the answers to the questions on the AM413000 screen So how can I extend that to add a simple field?  I assumed it should be as simple as adding the InventoryItem table to the report and joining on the InventoryID columns, but that errors.  

I have 2 accounts in Acumatica Portal, one is with previous company. Both email ids are same, so I could not take the learn and certification pages. This error is showing “Sorry, that email address is already used!”. How to remove account with previous company profile. Thanks in Advance