Discussion Forums

We did a mid-year Acumatica implementation. How do I load the vendor payments by branch for 1099 reporting purposes? Our branches have different EIN#s.

Hello!I was wondering if anyone had this issue when using this setting on the Production Order Types screen.I turned this on to better track our subassemblies so everything can be categorized under the parent production order #. But what’s weird is that it causes the Production Order # to skip a bunch of iterations, seemingly at random.See below for a screenshot. These were all Production Orders that were created within the last ~5 days. And I am certain that there is no way that someone created around 7000 Production Orders only to delete them in that timeframe.For some reason it jumps from POP027009-000 → POP027746-000 all the way to the most recent which is POP037933-000. And i

Hi Everyone,In the GL620500 Report, I have added the variable in the DetailSection1 and would like to display Total Amount and Total Count in the Header but it is not working. Can you please review and provide your inputs.  

How to filter records by current user branch GI

Hi everyone,We’re running into recurring issues in our Distribution Center related to lot-tracked inventory and availability for shipping. We are semi-new to Acumatica, having gone live in March, so we’re still ironing out some processes.Our Lot/Serial Class is set to “User - Lot Tracked”, meaning the system does not assign specific lot numbers when generating pick lists - only the location is specified.Here’s the problem:The picker is directed to a location (e.g. F-A01-) to pick any available lot. However, the lot they select is often showing an error (Something like “lot unavailable” or “inventory will go negative”), even though it physically exists in that location. Other times, picking and packing go smoothly, but at Confirm Shipment, we get an error saying the inventory will go negative - even though nothing appears to be oversold or misallocated. When we double-check the Inventory Summary screen, it shows more than en

We recently migrated all our SKUs from average to standard costing due to average costs getting all mixed up. We did this by issuing out all of the inventory, updating costing to standard and entering a receipt back in. I am running the inventory valuation report but continuing to see the inventory valued at average cost rather than the new standard cost of the SKU for many items. One example is the following SKU:L175:Standard Cost - $42QTY on Hand - 425Expected Cost - $17,850 Cost per Valuation ReportAverage Cost - $235QTY on Hand - 425Cost on Inventory Valuation Report - $99,875 This appears to be an issue for all SKUs with an INCost ValMethod of “A”.Any reason why this INCost ValMethod would remain as average despite the SKU having

i need to add buttons on mobile app. In web version i have this. How i can do this in mobile app?

Hi is there a method in acumatica where I can set the cursor to be defaulted to a specific field on a screen in Acumatica once the page is loaded?I have investigated and found a link to this idea post but could not locate more information regarding this:Thank you!

I have a custom smart panel with a grid inside it, and I need to focus the cursor on a specific field in the first row of this grid when the panel opens, as if I had clicked on that field. Does anyone know if this is possible to implement?To be more specific, let’s take the grid on the TASKS tab from the PM301000 screen as an example. Is it possible to make it so that when this tab is opened, the system automatically behaves as if the first row’s Rate Table column has been clicked, just like in the screenshot? 

Hello!I’m looking for some help resolving an error I am seeing with a customization project I created that adds new fields to the Stock Item screen > Packages tab.The error I am getting is: An error occurred during processing of the field Freight Included: Specified cast is not valid..Here is what the Trace specifies: Error: An error occurred during processing of the field UsrFreightIncluded: Unable to cast object of type 'System.Decimal' to type 'System.String'.. Below is part of the code giving me the issue. public class InventoryItemExt : PXCacheExtension<InventoryItem>{    #region UsrFreightIncluded    [PXDBDecimal(2)]    [PXDefault(TypeCode.Decimal,"0.00")]    [PXUIField(DisplayName = "Freight Included")]    public virtual string UsrFreightIncluded { get; set; }    public abstract clas

Hi All,Is it possible to add a line number as a field item and use it to format the output of the GI? For e.g., I have a GI that lists 10 rows but I had like to use the line number to change the background color of each alternate row, which is not based on any conditiion. Since, the Row Number is available only for display, how to get a row number for any GI (not a report)?Manish

I have had a Generic Inquiry to pull back Construction data, including information from the top level Project, SubContracts and SubContract lines, which has been working fine for quite some time.  I made a small change to it, and now, for any newly created Projects and/or Subcontracts on an existing Project, they are not showing up in my Generic Inquiry.I did add one new field to pull back Retainage from the Project level, but these tables are already joined. I tried reverting back to my known good, 2025R1 certified version of it, and still am not seeing the new data.I tried clearing the application caches and restarting the application.Has anyone run into anything like this before?  

 Why do I receive this error when patching 25 R2?[13:16:35 ERR] Could not find file 'Y:\Sites\*site*\Bin\Addon.csproj'.System.IO.FileNotFoundException: Could not find file 'Y:\Sites\*site*\Bin\Addon.csproj'.File name: 'Y:\Sites\*site*\Bin\Addon.csproj' at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share) at Patch.Common.CryptographyWrapper.SHA256CheckSum(String filePathName) in C:\code\UpdateService\Patch.Common\CryptographyWrapper.cs:line 13 at PatchTool.Wrappers.AcumaticaPatch.FetchAndDownloadPatchedFiles(AcumaticaPat

Hi! For the calendar board in field services, is there a way to easily block off certain time slots for field service employees? The example is I have an employee that needs to block off 2 hours in the calendar board because they have a personal appointment.

Hello,trying to copy an existing report by rebuilding it so i understand. My parameters do not seem to be working. I can fill the data fields out with variables, but it seems to just default to how the GI is configured. For CustomerID i’ve tried to use ARInvoice.CustomerID which is what i have declared; but doesn't work. the string in the screen grab works on the reference form even though INTran was not declared anywhere.  For date; that’s a pure copy pasta. It works on the reference report and google fu told me this would be one way to go about doing it, but it doesn’t seem to work. i guess i dont understand, I was thinking report designer would use my reference GI and need data sets that that GI uses. 

Hi there,We have a client who completes a monthly material stockcount, but they have distributed sites and often the stock count sheets aren’t received until the midway through the next morning or even a day later i.e., 1st/ 2nd.When the PI Counts are entered in Acumatica, it is hard-set to force the day of the count being the system date i.e., the current local date, and there is no way to adjust this from my understanding, unless going down the customisation route. This obviously causes issues because the count sheets will all be say the 31st of the month, but Acumatica will be calculating the balances as at the date of entry i.e., the 1st/ 2nd, which can causes Acumatica to attempt to incorrect adjustments.Is that correct, and/ or has anyone seen any way to handle the above scenario?  Thanks in advance.B

After importing the PO into the AP Bill I want to compare the unit cost provided in the import to the PO unit cost and mark the AP Bill in some way,  However, the Transactions.CuryUnitCost is not populated.For example,the import file has $100 as the unit cost but the PO unit cost is $80.00.  The problem seems to be the Transaction columns are not populated and the condition is true every time,The formula is =IIF([Transactions.CuryUnitCost]<>[Unit Cost],Concat('Unit Cost of ',[Unit Cost],' Not the same as PO Cost'),'')Where [Unit Cost] is the source data being imported, 

I need to correct a quantity in a RO by returning some of the items on the same day but with no charge. When creating a return on the same day, it still charges for the day.How do I avoid this charge?

Hello All,I am in the process of attempting to pull the contents of Screen IN405000 via a postman request.We have other successful requests coming through our Web Service Endpoints setup, so i am not immediately concerned about our configuration at this time.We created a new endpoint, with a base endpoint version of 18.200.001, and created a new route, “InventoryHistory” viewable here in screenshot 1.We then went to request it in screenshot 2, but we receive nothing in response. Any insight into what we have done incorrectly would be very helpful,ChrisScreenshot 1Screenshot 2  

Hello everyone,I’m are trying to understand how Acumatica handles different Customer Status values: Active One-Time Inactive Our concern is that we cannot find any documentation explaining whether One-Time is just an informational flag or if it actually triggers different behavior in AR, Sales Orders, or any other module. Does One-Time behave differently from Active in any workflows? Is One-Time intended by Acumatica as a special-use status (e.g., guest/occasional customers), or is it simply an available label with no system logic attached? Are there recommended best practices for organizations that want to classify customers who are still valid but rarely used? Thank y’all for any insight or guidance!

I’m trying to create a Import Scenario that updates a Automation Schedule for Turnover. I’ve produced this import scenario, but I’m getting a “System failed to commit the fill rows” every time. Any advice on how I could achieve this?  

I have a sales order that i have processed through into shipping and invoiced. the shipping and invoiced status both show completed/closed  but going back to the sales order it shows as ‘Open’ and not ‘completed’. I have put the order on hold and clicked off the check box under the completed column and have also clicked on ‘complete order’ under processing and still will not change the status of the sales order to ‘complete’.How can this be resolved in order to show status ‘completed’. Please help. 

I’m working on a customization for a Process Screen in Acumatica and ran into an issue related to correct pagination when using a View Delegate.Here is the goal:I need to build a View where for each Equipment I calculate the maximum Appointment date. This part works fine using a Projection.Next, I need to calculate the difference between the Business Date and the Max(AppointmentDate) for each Equipment.Then I need to filter records where this difference is greater than 10 days.Since filtering by a computed value cannot be done within the Projection, I implemented the filtering inside a View Delegate.The problem is that when I filter the records in the Delegate, Acumatica receives fewer records than expected. As a result, the StartRow and pagination logic break, because the system still thinks the dataset contains more rows than what I actually return.What is the correct way to implement filtering based on a calculated value (differenc

I added a custom GI using SO invoice and AR invoice tables and created a custom column for past due invoices:=IIF([ARInvoice.DocType]='INV' AND [ARInvoice.Status]='N' and [ARInvoice.DueDate] + Day( 5) < Today(), 'Past Due','Current')Then I created a business event trigger by schedule to send an email on any invoices that became past due.The schedule is running, but no email is generated from the business event.Below are the screenshots: 

Hi everyone, We gt files from a remote server with syncronisation feature of Acumatica.But we need to also export this same files we import in application to an other serveur destination.The same fields in sm202510 Screen (file maintenance) are used to store the information serveur.Is this any way to perfom this?Thanks a lot.Cécile