Discussion Forums

I am attempting to use PXForeignReference on a DAC extension to ensure the field is set to null when the referenced document is deleted. It published fine but doesn’t work. Is this possible?(NOTE: at the moment, ReferenceBehavior is ‘Restrict’ which should throw an exception upon deleting)public class DSDPMCostBudget_Ext : PXCacheExtension<PX.Objects.PM.PMCostBudget>{ public static bool IsActive() => true; #region UsrPDPOType [PXDBString(2, IsUnicode = true)] [POOrderType.List()] [PXDefault(POOrderType.ProjectDropShip, PersistingCheck = PXPersistingCheck.Nothing)] [PXUIField(DisplayName = "PO Type")] public virtual string UsrPDPOType { get; set; } public abstract class usrPDPOType : BqlString.Field<usrPDPOType> { } #endregion #region UsrPDPONbr [PXDBString(15, IsUnicode = true)] [PO.RefNbr(typeof(Se

If you have recently upgraded your Windows to 25H2 or Build 262x0.xxxx,and discover that your IIS Manager has no icons whatsoever in it. Whether this is a new install or upgrade to 25H2, beware that the IIS server configuration file isn't correctly filled out.Root Cause The Windows update corrupted the administration.config file by failing to replace token placeholders with actual values. Specifically, %WINDOWS_PUBLIC_KEY_TOKEN% tokens were left unreplaced instead of being converted to the correct value 31bf3856ad364e35.Solution Step 1: Create a Backup Before making any changes, create a backup of the configuration file: 1. Navigate to: C:\Windows\System32\inetsrv\config\ 2. Copy administration.config to a safe location (e.g., Desktop)Step 2: Edit the Configuration File 1. Open Notepad as Administrator: Right-click on Notepad Select "Run as administrator"2. Open the conf

Hello, I’d like to automate the SOPickingWorksheetProcess processing screen, from the SOShipmentEntry screen. The idea is to programmatically set the filter fields, then loop over the shipments returned, select some based on certain conditions, and hit the Process button. I’m able to do everything up to the point of ‘pressing’ the Process button. I’ve read various article which suggested that programmatically click Process might be possible but no clear method of actually doing it. The main suggestion is to find the method which Processing calls and simply call that. The issue with SOPickingWorksheetProcess is getting access to these methods. The main method is ProcessShipmentsHandler, but this is private, so I cannot call from outside the class.A more promising method is called ProcessShipments, but this is protected virtual, so I cannot call from outside the class, or a derived class. I have attempted to create a wrapper class around SOPickin

Hi Community,Your help is needed. In 25R1 Numeric type of Attributes was introdused. When enter the value for such an attribute, it really shows up as numeric.However, in DAC PX.Objects.CS.CSAnswers Attribute Value is stored as VARCHAR.This results in fetching an attribute value in GI as Text. When you use it in formula, you get a correct value but it shows as Text value (General type in Excel spreadsheet) instead of Numeric.I can get the same attribute value from the correspondent entity DAC (PROJRATE_Attribute) where it is represented as num

Is there a way to add the Case Packaging Dimension by UOM in the Packaging Tab under Stock ItemWe have full cases at a specific dimension and weight then we have single items at its own dimension and weight.

I’m working on some testing of the fixed asset module and have come across a scenario that I can’t figure out.We have a handful of assets that we disposed this year and are looking to bring them into Acumatica with its correct disposal information.  When running my import scenario, it does not allow me to modify the disposal date, disposal method and disposal amount.  I have already done GL transactions directly for the disposal of these assets, so I do not want to post again. Has anyone does this before?

Hello,I’ve gone through so many readings and videos and i still do not understand how relations work and how to see which parent childen to use.Example: when i enable INSite, it breaks all of my SO objects. and vise versa. I get get them to show on their own, but never together. Which relations would i use to get SO to talk to SO and print the warehouse its assigned to?Is there a resource that’ll explain relations and how they work together? I’ve used the Merged DAC Relations page and the inspect elements to match them up. This worked to get the SOOrder to stop duplicating..but i cannot figure out this INSite portion..The DAC relations are pages and pages long with no explinations

There are orders that contain non-stock items that get fulfilled right away before syncing to Acumatica the Shopify connector. These orders get the status of filtered. We would like to sync them to Acumatica using import scenario or API.Is there a way to import archived orders or modify Shopify orders to archive after 7 days? How do we prevent this from happening?

Is there a way to print a check for a customer refund that is not tied to the credit memo process?  The GITHUB package is not an option.

For example: A pay-in-advance Medical deduction of $150 was deducted from the employee paycheck for the upcoming month of coverage. The employee quit or was terminated.  We need to refund the $150 on the next/final paycheck. What is the best approach to accomplish this refund? 

I’m trying to do an import that will support updating existing records and creating new onesNew records only is pretty straight forward using the Auto Number KeyWe want to use Auto Numbering because we do not want to make the Serial Number the primary key because there are other factors down the road where the same Serial Number could be used multiple times across multiple customers/vendors, etc.  We are only importing records with a unique serial number right now.  But they will need to be updated.I’ve done some searching which seems to be involved with the concept of simulating the UI where you would use the Lookup Selector for the Reference Number and try to find a record with a matching Serial Number but I can’t get the right syntax down specifically for the Field Service Equipment FS205000The example from the training references a “CurrentCustomer” in the Source Field Value in the first line.That seems be an internal reference and I can’t quit

We have had this issue with 23R1 and it is still happening now that we have upgraded to 24R2. We have some products where we introduce new versions of them with new SKUs while keeping the product name the same.To do this, we have to delete the old product from BigC before we are able to sync the new product since BigC does not allow multiple products to have the same name.When we do this, we sometime run into an issue where if we include the deleted product as a related item on that new product, then it causes a syncing error that is unrecoverable. Essentially, Acumatica just keeps trying to sync the product, gets the same error from BigCommerce API that the product doesn’t exist, and keeps trying to sync without updating anything or giving an error message to the user.Has anyone else run into this issue?

Good day Is there a way to add a condition to a style in the Sales Order screen or a similar screen where the Sales Order gets highlighted if there is not enough stock available ship completely.  

Hello!I”m having issues implementing relations to support my results in a GI.I can list out all my sales orders, which type of order they are, warehouses and customers list no problem. However, once i implement an “address” feature, it breaks my GI and duplicates everything. I’ve read and reread the join type explanations and it seems that i want an “inner” join type. But i’m thinking i may not still understand this. anyone have an idea on how i can stop these duplications? 

How do you have a distribution addition and not include DRP in it? I find it curious that if this is such a need functionality, why is it not core to the product? Thoughts?

I have a report where I am trying to use the [PageOf] formula, but it only shows “1 of 1” on every page.From searching the forums, I’ve found the following:[PageOf] must be in the pageFooterSection Page footer ProcessOrder must be set to Always Textbox containing [PageOf] must have ProcessOrder set to WhilePrintAll of these criteria are met with my report, but I am still getting “1 of 1” for every page.

How do you set up Direct Deposit to receive payments from customers?

I am trying to create production orders from a sales order, but I keep getting this message:   Thank you

 I want to extend a new customers from business account, but while i try to extend there is error like this and also I can’t add a the new customer or account class. Can anyone help try to solve this?I really appreciate, thank you

Dear Supporters, I don't know why my set up approval have problem the user approval can't approval on the bill. Please kindly advise and Thanks in advance for support.  

Added this formula in the generic inquiry This error appears when trying to view generic inquiry. not sure what does this error means

Relatively new to Acumatica--we would like to make a change to the Profit and Loss financial statement to sort by Account Class then by Account Number.  Can this be changed and if so, what is the procedure to do so.  Thank you in advance.

Hello Community,I need advice regarding a customization we applied on the InventoryItem DAC. Initially, we had a custom field UsrUnitCost defined as [PXDBString], so in the database it was nvarchar. Later, I changed it to [PXDBDecimal] and republished. This altered the DB column to decimal. Recently, I changed it back to [PXDBString] because I wanted to show values like 20.33 BOX. Now in production, I’m seeing errors such as:The entry form (ID: IN202500, title: Stock Items) cannot be automated. An error occurred during processing of the field Unit Cost: Specified cast is not valid. How can I unpublish only one customization to check whether the error goes away or not? This works fine in sandbox but in production this issue occurs 2 days after pu

Is there a user group conference for the Southern Region of the USA coming up in the next few months?We have a couple of users that are wanting to attend a conference.

Hello, We are running Acumatica 2025 and Shopify Advanced with the  standard Acumatica<>Shopify connector and are experiencing a lot of issues. We have two(2) retail stores, one e-commerce site and an industrial sales division. Our ERP is Acumatica and our online store and POS run on Shopify.We have been unable to get real-time sync of orders. Everything goes through a schedule - orders, item availability, payments, etc. When we do flash sales/promos, we oversell product. We have been unable to to implement BOPIS. The Shopify statuses (Ready for Pick Up and Marked as Picked Up) is not transferred to Acumatica. We have automatizations that close the orders in Shopify automatically. For POS orders, we are ONLY able to do exchanges or returns for original form of payment. Gift Cards or product exchanges are not updated because of a order does not allow modification errors. If a customer buys in store A but returns or e