Solved

I am trying to create a new instance from a large snapshot. I have to do it through the configuration wizard due to its size and am using this method which states that it does not import custom columns. How to import a large snapshot using the Acumatica ERP Configuration Wizard | CommunityI have additionally found this information which claims that using this method will allow you to import custom tables and columns. Using this method, I have been able to create and fill custom tables and create custom columns on existing tables. However, the custom columns on the existing tables are all filled with NULL values rather than the imported values from the snapshot. Does anyone have a workaround for this? I don’t understand why the values aren’t being copied over.Snapping the Acumatica Snapshot Restrictions | Acumatica Cloud ERP

Hello!I am required to view the items and Subaccounts which are not included any restriction group,but I cannot create the relationship to view those as a bulk (Standard inquiry shows individual items but not all at once)Is there any way that I can create an inquiry for this?Thank you in advance!

Hi everyone,I have a custom webservice-endpoint so user can access vendor locations via REST-API.This webservice-endpoint is part of our customization project.I wonder if there is any possibility to show or enable the custom webservice endpoint only if our feature (defined in the feature.xml) is activiated.Thanks in advance!

Is it possible to use PXDefault to make a Customers Primary Contact the default selection when creating Service Orders? If so, how?

We use non-stock items to create bundle items such as a lamp and shade. We are tracking inventory of these items by running a report to generate quantities and importing those quantities into an attribute. I would like to use this attribute to update the inventory level of the non-stock item in BigCommerce and I have mapped it to do so in the entity settings.However the numbers do not update in BigCommerce and remain as zero. I was wondering if anyone has any insight on why this might be the case or if they have another solution they are using that works. I could just map the attribute into a custom field, but I would rather that these stock and non-stock items are handled in the same way to prevent confusion. Mapping of attribute to inventory level on Entity screen I can see in event logging that Acumatica is sending the request to update the inventory level to the number stored in that attribute, but it remains 0 in BigCommerce.\"inventory_level\":40Stock quantity remains 0 in BigCom

Our team is preparing to upgrade our system. While reviewing some release documentation, we came across a licensing change that we are concerned about.Our question: We would like to confirm if this change applies to ALL generic inquiries or only those that are set for the Anomaly detection?We use this feature regularly and it would be very concerning if there is no flexibility with this. 

Hi Team,I am working with 24R2 Build 24.210.0019.And created custom table that has some data in it.But while snapshot creation getting error like: “An error occurred while importing data into the 'CustomerPriceRepository' table.”Can you please suggest the possible root cause and fix for the error.Thanks,

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(Search2<POOrder.orderNbr, LeftJoinSingleTable<Vendor, On<POOrder.vendorID, Equal<Vendor.bAccountID>, And<Matc

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?

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 quite figure out how to translate this exa

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? 

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?

In projects we have a business flow where the client receives money in and then pays a portion of that out. The difference is the Actual Income on the Project.  For a few reasons we didn’t want to show to AP payment in the Actual Expense. We created an Account Group of the Income Type and added the 2 GL Codes, the Income type GL code for the Income and the Expense type GL Code for the portion of the Income that is paid out. That means that the Revenue Cost Transactions always have an AR Invoice EG $20’000 and a AP Bill EG $5000 and in versions up to 2023.1 the Actual Income calculation calculates the income as $15’000. (AR-AP)Lovely solution and everyone was happy… then Version2024.1 and in Acumatica 2025.R1  with the new calculation to include the taxes, the Actual Income calculation ADDS the AP Bill to the AR Invoice rather than subtracts as it did previously.This effects all new transactions, and creates an incorrect actual income if an existing project is recalculated.Does anyone h

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 publish. I have atttached the package. Thanks