Solved

Hello,I am trying to remove a lot of my Sales Prices that has an expiration date 01/31/2024, I am trying to create an import scenario to expire them unfortunately not working. Any tips on the above would be greatly appreciated. 

We are transferring inventory from a non-project to a project within the same warehouse (same location). The quantity is moving correctly, but the cost is not following — instead, it's being posted to the PPV (Purchase Price Variance) account.Later, when we invoice the project (sales invoice), revenue is booked, but no cost appears, resulting in inaccurate margin reporting.Has anyone faced a similar issue? Could this be related to how the project account groups or inventory posting classes are set up? The  cost is not getting capitalized into the project correctly during the transfer.Would appreciate feedback or best practices for handling inventory transfers into projects to ensure costs are correctly posted and reflected in project billing/COGS.

hi Guys, I am working on report and everything looks perfect the only problem is when i exporting into excel the Order QTY values disappeared from the column.  I am only tring to export two Columns other is working fine but this OrderQty is not showing any data in the excel but present in reports.  Before that it was like this i only changed the order columns  

I have been given a request to add an extra field to a “Production Order Material Summary” GICurrently the GI will display a summary of all the materials that were used in a Production Order. But my coworker wants, on that same GI, to also have a link to that Production Order number that the Material was created from. For example, we blend powder through a production order, then that powder is used as material for a Packaging Production Order. And they would like to have a link back to the creation of the material.  I attached my current GI, I have seen duplicate Data Sources before, but I have never used them myself. I assume I would need a second AMMTran to pull the creation transaction. But I have no idea how to relate it to the material instead of the Production Order that the material was consumed in. Any Help would be much appreciated. 

We have a repair facility where we need to start with a repair quote (RQ) and move to an Repair Order (RO) once we receive authorization to proceed with repair from customer.  I need to open a production order on the Quote as I need to post labor right away for the evaluation.  When I start in quote, the mark for production box is grayed out. We are currently on release 2024 R2. Do I have a setting wrong?  Is this even possible?  Will the production move from quote to order properly?  Anyone doing something similar that has come up with a way to do this or a work around?

Hello, Is their an easy way to automatically calculate a 20% surcharge on the sales order / invoices in Acumatica.  We do not want to update our all prices if Trump reduces the Tariffs soon.Currently we created a item called SURCHARGE and manually calculate the 20% tariff surcharge. Thanks!

Hello,I am able to successfully log in after setting up the new system email and external application in Acumatica.  They have 2 factor authentication and as I said, I was able to do the initial sign in from Acumatica.  When I hit TEST of the system email it fails with this message. Any thoughts?  

We are receiving this error after upgrading from 23r1 → 24r2.  I have removed the device associated to the user and reinstall the mobile app.  No change…Thanks,Brett  

As Controller, I am looking for credit memos to hit a different GL than my sales.  I have been informed that Acumatica cannot do this.  I don’t believe it.  Can someone please direct me how to do this?  Second, I have items that are not inventory related and would like to direct those sales to ‘Other Sales’.  Can someone help with that?Regards,

I created a template for adding specific line items to a sales order. When the line items are added, I want the Manual Price flag to be unchecked. I marked the manual price flag as False in the template. However, when the template is applied, the manual price checkbox is marked as true.  

Hi All,Could you please advise on the best approach to transfer Generic Inquiry data to the customer’s external SQL Server database? The data needs to be transferred and synchronized periodically.Thanks 

 Hi Acumatica Community! anyone know how to best handle this scenario? Item A is stored as a kitted item. But it's sold as component as Item B. When looking at on hand qty, is there a way to count Item A's inventory as part of Item B? 

Hi, I have a customisation that is attempting to prevent duplicate lot numbers from being scanned on the mobile App (IN301020) and Receipts (IN301000)  INReceiptEntry is overriden to throw an exception whenever:There is a lot number already persisted to the database, or The Lot number already exists on the unpersisted receipt.Condition a. works as required.  The screen shot below shows the outcome of attempting to scan lot # 1234 which already exists in the database.The error message is in the header, and this is visible when using the mobile App.However condition b. behaves differently,  1234z doesn’t exist in the database.  On fist scan it gets added.No problem there.  However when scanned again, the error messaging is appearing on the line, instead of the header.The issue I have is that this error messing isn’t visible on the Mobile App.  What I’m looking to acheive is to have an error message display on the header when condition b. ocurrs.In terms of the cusomisation, there is a Fe

Hi everybody,our customer rents out heavy machinery and it regularly happens that he receives a sales order from a daughter company of a big client. Our client then creates the shipping order and ships out the item to the daughter company.At the end of the billing period, our client has to create the invoice NOT for the daughter company, but to a specified leasing/financial company (also owned by the big client).One way would be to just change the billing address, but that is not what our client wants (for various reasons).Is there any possibility to do that in Acumatica without a customization?Thank you for your help!

I have view which is used with 2 grids on different tabs and showing different columns, like view have total 12 column, first tab grid show 7 columns, second grid show 5 columns.we are doing same, in classic UI, where we define grid in aspx, but in modern UI we do not have option to define the grid, how can achieve this case.Grid1 Grid2 Modern UI <qp-tab id="tab_0" caption="LOT/SERIAL DETAILS"> <qp-grid id="lotNumbersGrid1" view.bind="BatchLotDetails"></qp-grid> </qp-tab>  <qp-tab id="tab_3" caption="LOT/SERIAL DETAILS"> <qp-grid id="lotNumbersGrid2" view.bind="BatchLotDetails"></qp-grid> </qp-tab> 

Hi everybody, do you know if one can add a subreport in another subreport? (And then have both of them in main)  or as alternative solution: add on the main report a second subreport in the same section type (second reportfootersection)?

Hi I have created 2 selectors in material wizard 1 screen (AM300010) as belowIf the selector gives one record after putting the production number in the filter it should automatically press the Select All button.How can I achieve this, I have tried using  Base.Actions["SelectAll"].Press(); but i get the error:System.NullReferenceExceptionMessage: Object reference not set to an instance of an object.using System;using PX.Data;using System.Collections.Generic;using PX.Objects.CS;using System.Collections;using System.Linq;using PX.Objects.IN;using PX.Objects.AM.Attributes;using PX.Objects;using PX.Objects.AM;namespace PX.Objects.AM{ public class MatlWizard1_Extension : PXGraphExtension<PX.Objects.AM.MatlWizard1> { #region Event Handlers protected void AMProdItem_Selected_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e, PXFieldUpdated baseHandler) {baseHandler?.Invoke(cache, e); var row = (AMProdItem)e.Row; if (row.Selected == true) // Only i

Hello all,I am finding ways to display the cash at the beginning of the period in Acumatica ARM report - Cash flow statement?  

I’m working on setting up the Fixed Asset Module in Acumatica, and we are deciding on if we have value in using the Department filed.  Currently it is a mandatory field:I am trying to figure out how to disable the mandatory attritube on that field inside of the Customization Project, but not having any luck.  Any insight would be nice.

Hello Community,I need to add two nearly identical actions to the move screen. Each one points to a specific printer. I am then going to have a business event execute the action. I am having issues with getting both to show up. I have tried a few different ways to make it work and they arent both posting. Only one will post. i tried separate customization projects (with different names) and i tried putting them both in the same project but only one will be available. Could someone tell me what i need to do so that both will show up? Code is below.  Any help would be greatly appreciated. Im pretty sure its something simple that i am just overlooking.using PX.Data;using PX.Objects.CS;using PX.Objects.AM.Attributes;using System;using System.Collections.Generic;using System.Collections;using PX.Objects;using PX.Objects.AM;using System.Threading;using PX.SM;namespace PX.Objects.AM{            public class MoveEntry_Extension2 : PXGraphExtension<PX.Objects.AM.MoveEntry>  {    #region E

Has anyone seen this error before? We use the Acumatica Native solution for Ground Collect. I have some shipments that will release while others get this error. I cannot find where the issue lies on this one.  

How can we remove the “Create Payment” button for Sales users while still allowing our users (Salespeople) to create pre-payments?   Our goal is to allow prepayments, but prevent the team from using the standard payment processing flow.Thanks!

I am currently doing a number of changes on a report in report designer.One of those changes was to remove a subreport that was two pages long. First I tried simply hiding it, setting visible to false. But that did not work.Next I tried deleting it completely.Once deleted, the report is no longer showing the 2 pages, but I now have 1 blank page at the end with only header/footer displayed - how do I get rid of this? 

Hi Team  hope you are doing well, POST /Release i’m trying to release refund type in the payment object using rest api  { "entity": { "Type": { "value": "Refund" }, "ReferenceNbr": { "value": "000077" } }}the response is {  "statusCode": 202}  but when i check the page in Acumatica the refund the release button is still there Thanks

We are working on updating our Business Continuity Plan and the question came up about Acumatica’s treatment of our system and how backups work, where they’re stored, etc. Where is the best place to go to understand all of the mechanics of how our data is stored, how often it’s backed up and what the process would be to retrieve in the event of an incident?