Discussion Forums

Hello,On December 1st, our GST number changed and we are wondering what would be the best way to manage our AR invoices to reflect this change : every AR invoice dated November 30 or before should have our old GST number, whereas AR invoices dated Dec. 1st or after should show our new GST number. We usually set up the GST number on the Company screen. The problem is that if we change it on the Company settings, it would also change the GST number on previous invoices. What would be the best way to proceed in your opinion?

Hi all, I need to change the Default Fin Period on the Reverse and apply action. Needs to default the the current open Period.  I developed this below and it works. Does it look right?  I have not made a lot of these changes.Thank you using System;using System.Collections;using PX.Data;using PX.Objects.AR;using PX.Objects.GL;using PX.Objects.GL.FinPeriods;using PX.Objects.GL.FinPeriods.TableDefinition;public class ARInvoiceEntry_Ext : PXGraphExtension<ARInvoiceEntry>{ [PXOverride] public virtual IEnumerable ReverseInvoiceAndApplyToMemo( PXAdapter adapter, Func<PXAdapter, IEnumerable> baseMethod) { var result = baseMethod(adapter); ARInvoice memo = Base.Document.Current; if (memo != null && memo.DocType == ARDocType.CreditMemo && memo.OrigDocType == ARDocType.Invoice) { string currentPeriod = PXSelect<FinPeriod, Where<

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 in this screenshot, the earliest production order (POP027009-000) to the most recent (POP037933-000) jumps over 10,000 iterations. Prior to turning this setting on the numbering sequence worked as intended. Is there something conflicting between this setting and the numbering sequence? Does anyone know why this

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 enough quantity available to complete the pick lists, yet Acumati

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 been changed to Standard Cost?

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!

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 class usrFreightIncluded : PX.Data.BQL.BqlDecimal.Field<usrFreightIncluded> { }    #endregion} Thanks in advance!

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?  

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. 

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, 

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’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 (difference of dates), but without breaking pagination on a Pr

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

Where do you guys download device hub? 

Hi Everyone,I'm working on version 25 R1 and have implemented logic to generate an auto-numbering sequence for a custom field (Batch Nbr) on a custom screen.However, when I apply the AutoNumber attribute to the BatchNbr field, the value gets cleared whenever I select any other field in the header section. The numbering is not being generated as expected.Note: The same code works correctly in 24 R1, so this issue appears to be specific to 25 R1.Could you please guide me on what might be causing this issue or if there are any changes in 25 R1 related to AutoNumbering? DAC Field: [Serializable][PXCacheName("NBBLCBatchLabel")][PXPrimaryGraph(typeof(NBBatchLabelMaint1))]public class NBBLCBatchLabel : PXBqlTable, IBqlTable{#region BatchNbr [PXDBString(15, IsKey = true, IsUnicode = true)] [PXUIField(DisplayName = "Batch Nbr", Required = true)] [PXDefault] [AutoNumber(typeof(Search<NBBLINSetupExt.usrNBBLNumberingID>), typeof(AccessInfo.businessDate))] [PXSelector( ty

Hello all, I am in the process of configuring integrated shipping. When I try to confirm the shipment for a UPS carrier, it returns “Carrier Service returned error. 120309:Missing or invalid ship from phone number”. What is causing this error? Thanks!

Is it possible in a Generic Inquiry to generate a result that lists every calendar day between two dates?For example, I have StartDate and EndDate, and I need the GI to show each date within that range, even if there are no records for those days in the underlying table.

Some of our items are defaulted to ‘Mark for Production’ and ‘Made to Order’.  When I manually create a sales order and add an item to it, the check box for “Mark for Production” is checked.  But when I create the order via the API, it does not mark the line item for production by default.  How can I set this correctly for each line item when creating a sales order with the API?

Hi team, I want a customization where, when a user creates a claim, the attachment in the Details tab becomes mandatory. I tried many events like persist, persisted, rowSelected, but I’m getting an error. I’m unable to attach an attachment because the error still appears. Is there any solution? using PX.Data;using PX.Objects.EP;using System.Linq;namespace PX.Objects.EP{    public class ExpenseClaimEntry_Extension : PXGraphExtension<ExpenseClaimEntry>    {        #region Event Handlers        /// <summary>        /// Validates that expense claim detail has an attachment when InventoryID is blank        /// </summary>        protected virtual void _(Events.RowPersisting<EPExpenseClaimDetails> e)        {            EPExpenseClaimDetails detail = e.Row;            if (detail is null) return;            var claimGraph = (ExpenseClaimEntry)e.Cache.Graph;            // Check if InventoryID is blank/null            if (detail.InventoryID == null)            {