Discussion Forums

I am currently working on making a dashboard to monitor automations that we have built. We were wanting to add in the system monitor to that as well but it seems that the dac for that screen is PXHidden. only admins will be able to see the dashboard, so is there any reason that we shouldnt/couldnt make it available to be used in a GI? and how would i go about removing the PXHidden. i cant seem to find it to remove it. even looking through the folders in a local version.

i have create an instance with mysql and do step by step → then when i launch site on perform application maintenance it show error "Your tenancy ip not found”

I have a simple GI showing production orders and all I want to do is add some color to it based on the status. This formula is currently not coloring anything and I tried a couple other ways too, the system seems to not recognize the Status ID as the actual words that I have in my condition. Here is my formula:=IIf( [AMProdItem.StatusID] = 'Released', 'green20',     IIf( [AMProdItem.StatusID] = 'In Process', 'blue20',        IIf( [AMProdItem.StatusID] = 'On Hold', 'yellow20',            IIf( [AMProdItem.StatusID] = 'Completed', 'green', 'default' ))))  Can a second pair of eyes show me what is wrong with this?

I am trying to add an action to a custom screen. I want to add another view to be used in that action, but for some reason, The pxselect is not referencing my table. anyhwere that i write my table name, it doesnt recognize it. i do have a class in the dac with that name, but it doesnt recognize it for some reason. without the action, the screen works fine using it but if i try to create another view for the action it doesnt work and will error out. Can anyone tell me how to fix this? I created the initial screen following along to the T200 series videos. 

The region setting in the Shopify connector for Acumatica is set to French, and the default language in Shopify is also French. When I sync a template item from Acumatica to Shopify, the product title appears in French as expected. However, the variant option titles show up in English, even though both English and French versions are present in Acumatica. Why is this happening? If I create an order in Acumatica and receive a deposit from the customer, once after I send the order details to Shopify, can i collect the remaining balance from the customer through Shopify, for example by sending them a payment link via Shopify?  We’re using 2024R2—does it support 2000 variants, or is that feature only available in 25R1?Thank you! 

Does anyone know if it is possible to sync related items under a product in Acumatica to a single, list-type metafield?Example:Product A has Products B and C selected as Related items in Acumatica.  Product B and Product C are synced together to a single list metafield as “Product B, Product C” (or something along those lines). Later, Product C is removed as a related item in Acumatica and replaced by Product D. Now, Product B and Product D are synced together to the single list metafield.

I am having a tough time relating my GI that I am using another GI as a data source. I have a GI that is pulling All Move Transactions, I also have formulas that tell me if the transaction occurred on Day or Night shift, and if it was on Overtime or not. I wanted to duplicate this GI and then pull the duplicate in as a data source, to minimize the amount of formula I need to use. Because instead of writing the formula again, I can pick [overtime] from the data source and continue with the rest of my expression. It should be simple to relate, because it is literally the exact same information. I figured it should be related by batch number and maybe doc type, but no matter how I relate it, I get “cannot be bound” Can anyone help me relate these tables.  Another thought I had, my main GI has a bunch of conditions to limit which transactions to pull into it. But the data source GI, I removed the conditions so that I could hopefully use it for other screens as well. Could this be an issue?

I setup some code for copying both row level and split custom fields from a Purchase Receipt to a Receipt. More about that linked here: This code currently results in a duplication of the first split line’s custom field value. The correct result would show (in the Receipt’s Line Details) “1” in the first row and “2” in the second row for the Vendor Lot/Serial Nbr.using System;using System.Collections;using System.Collections.Generic;using System.Linq;using System.Text;using PX.Common;using PX.Data;using PX.Data.BQL.Fluent;using PX.Objects.CM;using PX.Objects.CS;using PX.Objects.GL;using PX.Objects;using PX.Objects.IN;using PX.Objects.PO;namespace PX.Objects{ public class INReceiptEntry_Extension : PXGraphExtension<PX.Objects.IN.INReceiptEntry> { #region Event Handlers protected void INTran_RowInserting(PXCache cache, PXRowInsertingEventArgs e) { //the table to place Purchase Receipt values into, and the usual null check INTran inTran = (INTran)e.Row; if

Does anyone know how to use Styles to show color for invoices that are past due? I have the below formula.=CDec( DateDiff( 'd', [ARInvoice.DueDate], Today()) )Thank you. 

hi everyone,I set up different languages in Acumatica. It’s working well. But how can I use different languages on mobile app? I can’t choose language when I login. 

Hi everyone,We're currently setting up EFT payments using TD Bank and need to generate files in the 80-byte (.txt) formatting standard. Has anyone successfully configured their EFT exports from the ERP system to output correctly in this format?Any guidance or examples would be greatly appreciated.Thank you in advance for your help!Best regards,

Autofill is not working on any report parameters in 24R2, as far as I can tell:  

Hello, Is it possible to make field names in the mobile app with bold font? So for example: Date May 19, 2025 Where “Date” would be bold or at least the same font as the value. Field names are rather small in Mobile app. Thanks,

I’m running my test SDK on 2024R1.  I am using the sample data.When I run my tests, the business date is causing errors because we are now in 2025 and the majority, if not all, the data is in 2023 and earlier.When Chrome is opened, it defaults the business date to my current date.I cannot find a way in code to change the business date to a date in 2023.Does anyone know how to access the page toolbar? 

Hello,We are planning to implement HubSpot and integrate it with Acumatica. However, we require more than the standard out-of-the-box integration, as there are additional fields that need to be connected.Could anyone recommend an implementation partner with expertise in integrating Acumatica with HubSpot? Preferably based in the UK or Europe.Thank you.

Whilst the Generic Inquiry definition has a “Show Archived Records” option, this is not as flexible as the “Show Deleted Records” option.With the Show Deleted Records option you can then use a parameter to include/exclude the display of these records.  This was because there was a field on the records that indicates if the record was deleted.  This is useful. With Archived Records, no such field - unless someone can inform me of some magic way of filtering.  A end user cannot be expected to go in and toggle Show Archived Records on and off.   Thus you are left with show only non archived records or show all with no user control when running the GI.  Thus not useful.  For most users they will need to have 2 Generic Inquiries.  One quick GI that does not include Archived Records and another GI that includes Archived records.  Clearly not efficient and confusing for end users.Solution?  Unless someone can inform me of some magic way of filtering which would be the most efficient approach,

We are trying to get the number of days an invoice is outstanding.  I am trying to use  =(([ARInvoice.DRSchedCntr]) - Today()) to get the numbers of days, but I get an error.  What would be a better formula?

I have a situation where kits will be produced in one warehouse then transferred to another warehouse using at transfer sales order.  However, when I plan replenishments and don’t have a replenishment method assigned to the kit items in the production warehouse, I cannot get an amount to process in the prepare replenishment grid.I could set up bogus replenishment parameters, but want to avoid that.  Any help on planning replenishments for kits?  I think maybe there is a gap here. Thanks,Dennis

Hi Community,We have a requirement from a client to display additional file-related details such as File Name, Comment, and Last Modified Date in the Files section on the Acumatica Mobile App. These columns are visible in the web browser under the Files popup, but we’re unsure if it’s feasible to expose them in the mobile interface.As we know, the Files popup area cannot be directly customized. So, before exploring workarounds, I wanted to ask:Is it technically possible to show these specific fields in the Files section of the mobile app? If not directly, is there an alternative approach to display file metadata in the mobile experience?Any guidance or insights would be greatly appreciated!Thanks in advance!

I want two custom fields from Purchase Receipts (PR) to copy their data into two correlated custom fields on Receipts when the PR is released. Both fields on both forms are simple TextEdit fields.I am trying to adapt the pseudocode from this post: This is the error I keep getting: Here is my code so far, my annotations might not be accurate:using System;using System.Collections;using System.Collections.Generic;using System.Linq;using System.Text;using PX.Common;using PX.Data;using PX.Data.BQL.Fluent;using PX.Objects.CM;using PX.Objects.CS;using PX.Objects.GL;using PX.Objects;using PX.Objects.IN;using PX.Objects.PO;namespace PX.Objects{ public class INReceiptEntry_Extension : PXGraphExtension<PX.Objects.IN.INReceiptEntry> { #region Event Handlers public PXSelect<POReceipt, Where<INRegister.docType, Equal<Current<POReceipt.receiptType>>, And<INRegister.refNbr, Equal<Current<POReceipt.inventoryRefNbr>>>>> correlatedReceipt; protec

I get this error when I am trying to add files on customization project and publish it.I am able to run npm run build-dev it gives no error. But if i run just npm run build it gives this error

I’m trying to run a business event with a import scenario, however, when I try to run the following IS, I get the error “Phone 1 cannot be empty.” Any advice to fix this issue?This is the Import ScenarioThe Error 

Would like to create a Customization to populate a Customers Primary Contact in the contact field of the settings tab on an appointment by default. Please help!

A Customer sent a check and we recorded the payment for $200. The check was deposited to the bank and a Bank Deposit in Acumatica which included the $200 check was created. A few days later the bank came back with a correction stating the check was written for $20 not $200. We voided the $200 payment then created a $20 payment and created a corresponding Bank Deposit. Is there a step we are missing? The original deposit with the $200 payment is still equal to the original deposit we created so our bank rec is off by $180. Please help me identify what step is missing

We are running into problems with creating a new task on the Tasks screen under Time & Expenses.From looking at the effective rights of the user in Access rights by user the user shows as having delete permission on the tasks screen. They can get to the screen and even click to add a task when an error message pops up saying ‘You have insufficient rights to access the object (Cst_CRTaskMaint).’How can I determine why this is failing?  Does this depend on the user being granted access to another screen first?  Has anyone else run into this issue?Thanks for any help,Phil