Solved

Hello,The cost statistics within our Stock Items and Item Warehouse Details are not updating at all.  We are on average cost.  Receiving/adjusting/selling/Recalculate Inventory/Update Standard Costs don’t have any impact on the statistics. I can look at our valuation reports and work out what the average cost of something is, but where is this value actually stored?  Can I get it on a report or inquiry anywhere?Additionally, we allow our inventory to be sold negative, but when that happens, it uses this “Last Cost” field.  Problem is, this thing looks like it was only populated from our initial imports into Acumatica and hasn’t updated since (and many part #s have $0 for the Last Cost).We’re on an older version of Acumatica, but I’ve been testing our environment on 2024 R1, and it doesn’t seem like this works there either.Any help is much appreciated!  

I am trying to figure out a following scenario for Fixed Assets using DV as Depreciation method.I have Assets With Following details:When I perform the First depreciation it has posted negative value which has essentially increased the net asset value from its last depreciation amount before migration.Is this Normal to have a negative value posted to the depreciation ?Please also note the client has currently amended from AUS financial year to US financial year.           True 1 10 141.43 01/07/2020 01/07/2020

We have customers that approve a stock item; however we may have similar item that could be picked when entering in an order. This similar item should not be used as the customer has not approved it. Is there a set up in the system currently on stock items were we can pick the customer that has approved it.Or on the other side in customers is there something in place that we can add the stock items that are approved for that customer.Ideally, I would like to have a table on the customer account were you could add stock items that are approved, date of adding item, with a note field. And then if the customer is added to a sales order and an item is used that is not on this table it couldn’t be used. 

Good day, I developed the the below approval condition and maps.The user enters the bill and then releases it and that point the Status should be pending approval.  It is not working.  I thought it was a timing issue related to the date but I tested that; still not working.  it is not inactive and put back the old version which did work.Your assistance is greatly appreciated. 

I am calling a REST API and receiving the error “Form key or value length limit 2048 exceeded”.The body of the request is about 75KB.This seems to be controlled by a setting in IIS. Is there anything I can do to get around this? 

We handle the 10x10 frame and various colored covers separately in Acumatica. When a customer orders a tent, frame and cover is bundled manually and shipped together. (a) I have included all covers in the template item using color as a variable attribute. How can I add the frame to the matrix item?(b) If I want to use the 10x10 frame in a second template item, can this stock item be utilized across different template items?Thank you!

Dear Experts,I need to insert “Upload Excel file button” on  Requisition’s detail screen, It’s always showing all requisition detail at details tab, when create a new Requisition doc. Below is the Code, In Aspx:AllowUpload=true for details gridIn Graph Extension:namespace PX.Objects.RQ{  public class RQRequisitionEntry_Extension : PXGraphExtension<PX.Objects.RQ.RQRequisitionEntry>  {        [PXImport(typeof(RQRequisitionLine))]        [PXViewName(Messages.RQRequisitionLine)]        [PXCopyPasteHiddenView]               public PXSelect<RQRequisitionLine, Where<RQRequisitionLine.reqNbr, Equal<Current<RQRequisition.reqNbr>>>,         OrderBy<Asc<RQRequisitionLine.reqNbr, Asc<RQRequisitionLine.lineNbr>>>> Lines;    }} Can anyone suggest on this to import / update all lines in detail grid. Thanks in advance. Cheers,Iko

Hello - We currently have custom Start and End date fields on the sales order screen and also on the AR invoice screen. However now we would like to be able to send values from the SO fields to the AR invoice fields. Can someone please tell me how we can achieve this?

We recently upgraded to 24R2 and when I was trying to complete a move transaction on a lot of material, it would throw the below trace error. I was able to successfully complete both labor and material issue transactions with out any issues, but it seems like the move function is simply no longer functional.  

Hi, Client has raised a scenario where the current approval workflow is set to require approval by the project maanger. However, due to the high transaction volume, they are seeking an alternative solution. Specifically, they want a shared approval process where some AP bills can be approved by the Project Admin, while others can be approved by the Project Manager.Essentially, they are requesting a shared approval mechanism where either the Project Admin or the Project Manager can approve transactions.I have reviewed the system settings and, aside from the option to reassign approvals, I couldn’t identify any other configurations to accommodate this scenario. Is there a system setting or alternative approach we can implement to support this approval workflow?  

Hello everyone,I’m exploring the idea of integrating ChatGPT with Acumatica to streamline workflows and enhance system interactions. For example, I want to enable employees to interact with a chatbot for tasks like uploading vendor invoices pics. The goal is for the chatbot to process these invoices and update item details in Acumatica automatically.I’d like to know:Has anyone implemented a similar integration? What APIs or tools would you recommend to facilitate this connection between ChatGPT and Acumatica? Are there any best practices or challenges I should be aware of?Looking forward to your insights!

Hello,Is there a way to set/show expiration date on the sales order of type “QT (using order template Quote)? There is a way to setup a “Days to Keep” but looks like cannot be shown on the sales order screen.

Template items is working just fine on first attempt. How to create color swatches for items with color variants synced to Shopify? Thank you!

I've encountered a couple situations recently where I needed to extend an action where a PXLongOperation was running and do something after it was completed. I can use PXLongOperation.WaitCompletion(Base.UID) to wait for it to finish, but it seems to break the operation (the processing indicator doesn’t appear until the operation is complete). I think this makes sense, since it's blocking the UI thread until the background thread is complete.What is the proper way to execute additional code after a PXLongOperation is “finished” without blocking the UI thread?

Hi All,Is this possible to setup for user only see the transaction and info belonging to the company that they sign in to?There is 2 companies in my tenant, and user have access to both companies. When open the generic enquiry such as Sales Orders SO3010PL, I can see transactions of both companies in a place even I sign in to Company A.I expect that can setup for user to see only the transaction of the current company that they are working on.Are there any way to set it up?Thanks in advance.Yên Chi

Hi, We want to create a new Purchase Order type in the system i.e. Group Outlet PO, so instated of adding new PO type can we rename the existing PO type Standard to Group Outlet PO. Please find the below screenshot for reference and advice.  

 I am wondering what could have caused this. I have a Sales Order with Inventory reference number but do not have an Invoice. I found no audit history enabled.how is there no invoice but there is a inventory ref number?  

I am assuming that this exists.

Hello,  Is there a way to restrict sales order type to a certain type? For example, we want a project manager to only be able to submit sales orders that are type ‘PJ’. Is there a good way to do this? Thanks!Brent

Hi, I have active currencies (other than the base currency) in a system that are not ticked to “use for accounting”. They cannot therefore be used in Customers or suppliers. The currency record option is not greyed out, but it will not allow the option to be ticked (no error just won’t hold the tick). The currencies have not been used and even if I create a new currency record the option use for accounting option cannot be turned on. Have I missed something?

Hello,One of our customers (only in one test tenant) is having this error populate when we try to go into the customer account via AR. It is only one customer and only in one tenant. All other customers in the tenant do not have this error.We usually do most transactions against this dummy customer account. I can’t be certain when this started occurring since the system has thus far allowed us to use the customer for sales orders/invoicing/payments/etc. Any help resolving this error would be greatly appreciated! 

is there a way to add the field tip into the mobile screen when entering a expense receipt??

Hello! Is there a proper way for setting up Gmail as system email account in Acumatica? I followed the instruction here Using Gmail With Acumatica and read through this solved post Gmail setup issue | Community but was still unable to test connection successfully. We mainly want to be using this to process incoming documents for the AP document recognition service.    Thank you!!

Hi everyone,I’m new to Acumatica and trying to understand how the system manages invoices that exceed their expected amounts. Specifically:Is there a way for Acumatica to flag or stop an invoice if it exceeds a pre-set threshold or budget? Are there any settings or workflows I need to enable to make this happen?I’d really appreciate any guidance or tips on where to look in the system. Thanks in advance for your help!Best regards,Ray Tussing

We are unable to print Paystubs (PR.64.10.15) after upgrading to 2021R2 build 21.209.0034. I cannot find this as a known issue, but assume that anyone using Payroll on this version would be impacted.Error: Cannot resolve the table name: [PX.Objects.CR.CRLeadContactValidationProcess+Contact2]  Trace: empty