Solved

I have a grid where two columns are colored in Classic UI, and this works correctly there.However, in Modern UI those same two columns are no longer colored and appear with default styling. Is there a supported way to apply styling to specific grid columns in Modern UI? I also tried applying custom CSS like this qp-grid#grid [data-field="UOMSelect"] { color: #0078d4; } qp-grid#grid [data-field="UOMCost"] { color: #d40000; }but it didnt work

Hello all, we have the following problems in the GI “SO3010PL” (Sales orders):The total sum of some orders are multiplied by a factor, for example 2 or 4 and thus show the wrong order sum in the GI. In the Sales order itself the Order Sum is totally correct but not matching with the one shown in the GI.Example for wrong Sales Order (Total 8,068,20):In GI false: Example for right sales order (Total 2570,40): In GI correct:Screenshots of GI:     Please let me know, if you need more information. Thank you.Greetings

Hi,I have a list of dropship orders in a csv (downloaded from a 3rd party app) that contains everything I need to create a Sales Order with an import scenario, except our customer’s details. If all the orders in the spreadsheet are for the same customer how do you recommend I proceed?could add column to spreadsheet - but want to avoid that manual step.  Could write something in Excel to ask for the customer and create a new csv, but this is the 2020s. hard code the customer id into the import scenario - possible but there are many of these and that creates a burden on maintaining the scenarios (if one for each customer). Is there a way to ask the user to choose a customer as part of running the scenario? Can the import scenario link to a Generic inquiry that could be filtered to the correct customer? Any other ideas? Thanks in advanceSimon

I’m looking for instructions or an example on how to set the “Apply Retainage” checkbox on an AR Invoice via an API.  It’s very easy to do in the UI and works exactly how we’d like.  We’ve enabled the Retainage features, and extended the Invoice endpoint to include RetainageApply and RetainagePct fields; however, they’re not not being triggered when sent as “:true” etc. through the API.  Checking other sources online has lead to solutions that didn’t actually work, or were related to AP bills. Any help would be appreciated! 

I have a custom screen with a custom grid.  On that grid, the user can lookup the customer.  In my current DAC field, it is restricting the customers to be returned based on whether the current user is linked to the Salesperson.For the customer nbr field in either the header or the grid, I am restricting the selector to only return customers where the current user is a salesperson on that customer.Thie is the DAC field for the grid. #region UsrCustomerID [CustomerActive()] [PXUIField(DisplayName = "Customer Nbr.", Required = true)] [PXSelector(typeof(Search2<Customer.bAccountID, InnerJoin<ICSCustomerSalesPersonLinksSQLView, On<ICSCustomerSalesPersonLinksSQLView.customerID, Equal<Customer.bAccountID>>>, Where<ICSCustomerSalesPersonLinksSQLView.userID.IsEqual<AccessInfo.userID.FromCurrent>>>), typeof(Customer.acctCD), typeof(Customer.acctName), SubstituteKey = typeof(Customer.acctCD))] [PXDefault] public virtual int? UsrCustomerID

Hello,I am trying to create order with payment details, but I am getting error “Inserting 'AR Payment' record raised at least one error. Please review the errors.\nCashAccountID: 'Cash Account' cannot be empty” even I am sending payment method to my payload. In my acumatica, I have two branches- BLASTLINE and STANIOS. For blasline, I didnt get any error when I am passing payment details. But when I am changing the branch with Stanios, it start giving me above error. Please help me in that. order creation payload- Thank you RegardsNamrata

Hello Acumatica community 😀I'd like to know the best practice for creating a custom field on screens (Customer Payments and Supplier Payments).I need a boolean value that can be modified even after a payment has been closed.However, a custom field on the corresponding tables doesn't allow modification once it's closed.What's the best practice? Should I create a new extension table with the same key as the payments table?Or is there another solution?Thank you for your feedback.Have a good day everyone 😁

Has anyone been able to create a generic inquiry that can include both actual and budget numbers by period, account, and sub account? I can’t seem to find the right combination of relationships to get this to work properly.

I want to set this screen to the Modern UI. How can I set 4 columns in each row? Is there an original Acumatica screen example like this?

I'm trying to download JournalTransaction data. I'm following the documentation to Retrieve the List of Records in Batches, using the $top and $skip parameters. I've tried different values for those.But I can see that as the $skip parameter grows each request take increasingly longer to finish.Finally, after ~1 hour of processing, it fails with a ReadTimeout. Even if I retry, after 60 secs or more, it keeps failing with ReadTimeout. It is not a session expiration issue: I tried with logout/login.Besides it is not consistent. For example with a $size of 500 it typically fails on $skip=115500. But sometimes I get up to the next page ($skip=116000) until it fails.And I can't get over that.Any ideas?

i.m currently on an older version of Acumatica, testing in the sandbox for version 2024R1. I am using the Construction module and crated an invoice for a project. The invoice appears in all of the modules correctly, however, the issue i am having is with the Project WIP Report and Project WIP Detail Report. The Project WIP Report headings Revenue Recognized and Billings in Excess of Costs is showing the correct amount but the Period Billings and Billings to Period are showing credit amounts.In the two test scenario billings created and posted for the two projects, there were no debit or credit memos to cause a credit balance. It appears the credit balance is equal to the tax amount on each billing. In reading through the notes this is a known problem after the 2023R1 release. The proposed solution to run Recalculate Project Balances doesn’t seem to be working.Any ideas as to whatelse i could try?

Our company typically has 1,000 projects open at any time.  We also have over 1,000 stock items at our warehouses.  Any of these stock items can be used on a project.  How do we issue a stock item to a project where the inventory at the warehouse is relieved and the item quantity and cost are captured on the project?  This seems like a very basic scenario that is difficult in Acumatica.  Thanks for your comments.

I have a problem in Modern UI. In Classic UI I have 2 grids inside SmartPanel: Top grid: BZItemQuantityInq Bottom grid: BZItemLotInq When I click any row in the top grid, the bottom grid refreshes automatically and shows related data. Everything works fine there.  <px:PXSmartPanel runat="server" ID="CstSmartPanel1" Caption="Item Quantity Inquiry" CaptionVisible="True" LoadOnDemand="True" Width="1100px" Key="BZItemQuantityInq" AutoRepaint="True" AutoReload="True" ShowAfterLoad="True" CancelButtonID="CstButton8" CloseButtonDialogResult="No"> <px:PXGrid runat="server" ID="CstPXGrid2" AdjustPageSize="None" AllowPaging="True" SkinID="Details" Width="100%" DataSourceID="ds" SyncPosition="True" KeepPosition="True"> <Levels> <px:PXGridLevel DataMember="BZItemQuantityInq"> <Columns> ...... </Columns></px:PXGridLevel></Levels> <AutoSize Enabled="True" /> <AutoCallBack Enabled="True"

I’m new to Acumatica, does anyone know how it handles multiple approved manufacturers/part numbers per inventory item?Thanks in advance!Kathie

Does anyone know how often Acumatica backs up our instances when they are hosting them?Do they keep any historical backups or just the most recent?Nothing wrong, just a general inquiry. (see what I did there?)

Hi everyone,Have a client looking to send and manage surveys using Acumatica, perhaps with a Surveymonkey integration. Everything I’m seeing (including the latest GitHub package) is about 3 years old. Does anyone have info on a current option?

Has anyone run into the following vague error when trying to connect Shipstation.  I have followed the Shipstaion documentation here: https://help.shipstation.com/hc/en-us/articles/360026140871-Acumatica#UUID-8a29acb6-2284-4383-9cd4-9d8042e2a078_UUID-5a36552f-1c4a-47ff-a8e5-3a9c8e296fd4 But get the following error shown below.  Any ideas on what the issue maybe?

I intend to add custom fields to the Payment Summary section of the AR302000 screen. These two custom fields are intended to appear specifically when the View is set to "Document." However, it seems that despite having implemented the code, the changes are not taking effect. Where might the issue lie?

I have a tenant with 3 companies; Company A , B, and C.  I want to move Company B to its own tenant.  In a SaaS environment, what would be the steps to do that?

Good day,See the attached GI.  I want to set up the Navigation to open the Subject/Email associated with the subject on the Customer Activity tabs.  (Trying to avoid having to open the Customer Profile).I can get the hyperlink on the field, but it does not open the email. See example.Any ideas?  I had to publish today but I want to add this feature so the user can review the Note on the generic inquiry.Thank you.  

Hello all,I have been trying to work on Shared Column Configuration, but it is not getting applied. Kindly let me know if i am following the correct steps:Setting up the list of the columns, to be displayed, using Column Configurator → Selecting Shared Column Configuration.I am looking to hide the Currency field for all the users except for admin. And there would be some other fields too that will be made visible/invisible on regular basis.Moving them  to the list of Available columns:Selecting the table under Shared Column Configuration:And at last selecting the users for whom the columns shouldn’t be displayed:And clicking on Finish.The columns are getting invisible but after logging into the bernia’s account, I am able to change my columns:How can I restrict the user to not be able to add it again.Thanks in advance.

Is there a way to display qty on hand on the PO line for stock items by warehouse?  This way the user can decide how they would like the product shipped to them based on inventory available.  I am thinking it will be an enhancement but what would be the best approach here to make it seamless.  Thanks!

Can we add columns (user and date file upload) to attach files form? 

Hi everyone,I’m trying to customize SOLine.AlternateID, but the original Acumatica logic is interfering with my functionality. Specifically, I need to remove the AlternativeItemAttribute from SOLine.AlternateID.Here’s what I tried so far: #region AlternateID [PXMergeAttributes(Method = MergeMethod.Merge)] [PXRemoveBaseAttribute(typeof(AlternativeItemAttribute))] [PXDBDefault(null, PersistingCheck = PXPersistingCheck.Nothing)] [BZAlternativeItemAttribute(INPrimaryAlternateType.CPN, typeof(SOLine.inventoryID), typeof(SOLine.subItemID), typeof(SOLine.uOM))] protected virtual void SOLine_AlternateID_CacheAttached(PXCache sender) { } #endregionHowever, this doesn’t seem to remove the attribute completely. Has anyone successfully removed or replaced the AlternativeItemAttribute from AlternateID? Any guidance or best practices would be greatly appreciated.

The client has a large number of non stock kits with stock components. They require allocation before the shipment is created. I was wondering if this was a setting in Acumatica itself, or if it requires customization to achieve.