Discussion Forums

Anyone know if it is possible to filter by the most recent record at the relationship level? For example: In the above join between the Customer and the CRActivity tables, is it possible to add a condition in the active relations to limit to the most recent record? I’m trying to get the last activity date, and I know I can group the records by the Customer ID and set the Aggregate Function to MAX on the results grid to display the last activity date, but that is causing some other unwanted issues with other calculated fields.

Hello,I got question on how to set checkbox value for a custom field in gridview on Sales Order screen? Here is my DACpublic class SOLineExt : PXCacheExtension<PX.Objects.SO.SOLine> { [PXBool] [PXUIField(DisplayName= "Is Restricted")] public virtual bool? UsrIsRestrictedField { get; set; } public abstract class usrIsRestrictedField : PX.Data.BQL.BqlString.Field<usrIsRestrictedField> { }}and here is my graph extension public class SOOrderEntry_Extension : PXGraphExtension<PX.Objects.SO.SOOrderEntry> { #region Event Handlers protected void SOLine_RowSelected(PXCache cache, PXRowSelectedEventArgs e) { var row = (SOLine)e.Row; if(row != null) { ClaLimitInv.SOLineExt itemExt = PXCache<SOLine>.GetExtension<ClaLimitInv.SOLineExt>(row); itemExt.UsrIsRestrictedField = true; cache.SetStatus(row, PXEntryStatus.Updated); } }}in Custo

Our client is using Estimating module and create estimate from Opportunity.The Amount on the opportunity header however is not populated from Estimate, only from items added in tab Details. Example below: only standard item priced at $1000 gets added into Amount.Is this by design and is this correct?How can I see the correct potential sales of my opportunity of the Amount does not include my Estimate?   

Hi Acumatica Community,I’ve set up an import scenario to handle contact records using a CSV file exported from Shopify.The goal is to either update an existing contact (based on the email) or create a new one if the contact doesn’t exist. However, I’m encountering an issue where the scenario always creates new contacts, even if a matching email with the contact exists in the system.I am using <Key: External> in the first row.  My understanding is that this is used to identify records in the system, but it does not look like the whole import is updating any existing contact at all, instead, creating new ones.Is there something wrong with how I’ve configured the <Key: External> mapping or could there be another setting or mapping I’m overlooking that might cause this issue?Any help would be really appreciated!Will 

Can you help me? It's duplicating the batch number in my record. 

We are going live in 2025 with Acumatica.  Any experience/advise how to use API to transmit our receving and shipping to our 3PL?  Any suggestions who to contact at Acumatica?  This is beyond me, but our 3PL is ready to go. 

I’m testing out MYOB Acumatica and I had inserted some Time Activities as below, but they are displaying under the wrong week. I assume it’s got something to do with timezones, as the timezone is in Melbourne which is UTC+11, and the week cut-off point appears to be 11am as shown in the example pictures below. How do I fix this so that the cut-off time is midnight of the chosen timezone instead of UTC? It’s strange to me that time activities dated 20/01 is in the previous week period. I could be wrong entirely and it’s got nothing to do with timezones, but I can’t find the related settings for this 

Hello,      We’ve designed several inquiries and dashboards. Some of which are with multiple parameters.Currently, the changing or selection of every parameter would start the search immediately.Like below, if “Date from” is changed, the search would start.  However, in some cases(for some inquiries/dashboards) , user would like to start search only after several parameters be chosen at the same time, please noted, not all the fields are required , how many and what parameters depend on the user’s wish.    The reason behind this requirement is due to performance issue. For some inquiries/dashboards, it would take a longer time to retrieval data, and that would make the system “freeze” a while. And user think that freeze doesn’t need.    The desired steps would be looked like, user select all the parameters he wants, can then click a search button, and then the system start to do search work            This is not really an urgent question or something must have. But I am just wondering

In Service Orders (or appointment's) I have found that when I add an item that has a new stock item + warehouse combination the Item Warehouse Detail for the new warehouse is not added to the stock item..This is causing it to not appear on my Prepare Replenishment screen.If I manually add the warehouse detail to the stock item, I will have to also have toggle the Override Replenishment Settings for the Replenishment Source & Replenishment Warehouse to load from the defaults outlined on the Stock Items screen.I hope this makes sense, I can provide screen shots if needed for more explanation.Acumatica 2023R2 Build 23.212.0024

I was hoping someone could explain how to achieve this in leave approval scenario. Organisation has multiple teams. When an employee applies for leave, the notification should go to 2-3 senior members of the team although there will always a primary approver who is the manager/supervisor of the team. This is so that if tje manager is away someone else can be notified and action the leave approval/rejection. Subsequently when the approval/rejection is actioned all the people who were approvers would also get a notification verifying that it has been actioned. Is this configurable at all? 

Hi All,Currently we can GRN any amount at the purchase request other the quantity specified in the PO. It only displays a warning that we are GRNing a quantity higher than PO quantity. We need to restrict this to a percentage of 10% of PO at the receipts.Is there a way to do this (Using current settings) without going for a customization.Your valuable ideas are highly appreciated…Thanks in advance.  

I want to use the Default/Shipment API to create a shipment for a sales order line that isn’t due to ship yet. In the UI, this produces a warning on the SO line saying “Scheduled Shipment Date greater than Shipment Date”. See this topic for a description of the behavior:When this request is sent via API instead, the warning prevents the Shipment from being created. Is there a way to overcome this warning and save the Shipment anyway like you can in the UI?

Hi everyone, how come in the actual Sales Order we can put the status to WO Pending when removed from Hold but it doesn’t seem to show in any filters or parameters?  

On the Request form RQ301000, we would like to limit the number of characters in the RQRequestLine description field.  The default limit is 256.  Is there a relatively simple way to limit to 100 characters?

Hi can i ask i think there is no error on my report but it only display reports from 2014  

Hello , I am getting stuck in the business event which can auto create purchase receipt here is my business event and import scenario. Is i am missing out something? 

We received money from customer in advance and unused money needs to pay back to customer at the year end, how to record prepayment and then how to apply prepayment to invoices?

Hello,Not a C# developer, and very new to acumatica.Using the below code I was able to figure out how to add the CustomerOrderNbr and ShipmentNbr to the package ex custom reference nbr 1 & 2. The label is generated using the UPS Rest carrier.My issue is the the very lengthy prefix as seen in my attached image. How do I remove the custom reference prefixes “Reference No.1” and “Reference No.2”Also below is my code. Please let me know if I need to add anything like cache updating. Currently the code works but other examples included some cache update code I did not understand.  protected void SOPackageDetailEx_RowPersisting(PXCache cache, PXRowPersistingEventArgs e, PXRowPersisting InvokeBaseHandler) { if(InvokeBaseHandler != null) InvokeBaseHandler(cache, e); var row = (SOPackageDetailEx)e.Row; SOOrderShipment shipment = PXSelect<SOOrderShipment, Where<SOOrderShipment.shipmentNbr, Equal<Required<SOPackageDetailEx.shipmentNbr>>>>.Se

I’ve read through a bunch of posts here and on Stack Overflow but haven’t found an answer that works.  I want to extend Customer with a form on a custom tab using a set of fields from a custom table, rather than the user field approach which will add fields to the BAccount table and thus the other entities that share that definition.  I created a custom table then a customization project with the DAC schema definition, extended screen AR.30.30.00 with a new tab, added a form to the tab, and then bound my view for the custom DAC to the form.  Now for starters, I want to make the tab conditionally visible on customer class ID using the RowSelected event.  Based on the T210 training, I assume I need to get a reference to the extension then set the tab to visible if it’s set to not visible generally.  I can’t seem to get the syntax correct for the extension variable.  I either get the CS0120 (Object reference required...) error or the CS0311 (Type...can’t be used as type ‘TNode’...) error

After inserting an image into a column, the gap between the column and the grid increased. Can I manually change the gap between them?   

Is there a way to do an excel upload of the exact SKU list of inventory IDs we wish to have counted? (that do not share the same ABC code, class, or otherwise – Just a literal list of which ids we wish to have counted)I have read around and seen articles on importing the sheets of the inventory count totals, how to set up inventory counts by code or class or warehouse – However, this is about uploading the actual list of requested specific SKUs to count. 

It's great that we have such a vibrant Acumatica community to get quick answers to questions and gain product knowledge! We have very active members jumping in to help others out all the time. The goal of the community is to respond to every member’s question so that no one goes away "empty handed".Connect, Learn, Share Josh Wright - Acumatica Community Featured Member for January 2025Meet Josh Wright our Acumatica Community Featured Member for January 2025. It’s great to have you as part of the Acumatica Community ​@jwright! How to Answer Questions on Acumatica Community - We need everyone’s help!Active Participation is needed from every Community user; everyone can provide valuable input using their individual skills and interests.  When more people participate, all members benefit - - we need diverse backgrounds, cultures, experiences, opinions, values and perspectives. Announcements, Hot Tips, Known Issues and BlogsProfessional Services EditionHow to set up earning type codes when

Hi I have a UDF (APRegisterExt.usrMAINMAINAPKynectionRefNo) which I need to this field’s value under the Supplier Details UDF (APDocumentResultExt.usrMAAPSDKynectionRefNo)   I have added the logic below but receive the following error:\App_Code\Caches\APDocumentEnq.cs(31): error CS0246: The type or namespace name 'APDocumentResult' could not be found (are you missing a using directive or an assembly reference?) public class APDocumentEnq_Extension : PXGraphExtension<PX.Objects.AP.APDocumentEnq> { #region Event Handlers protected void APDocumentResult_RowSelected(PXCache cache, PXRowSelectedEventArgs e) { var row = (APDocumentResult)e.Row; if (row == null) return; var docResultExt = cache.GetExtension<APDocumentResultExt>(row); var apDoc = PXSelect<APRegister, Where<APRegister.refNbr, Equal<Required<APRegister.refNbr>>, And<APRegister.docType, Equal<Required<

I am receiving the error below when I try to process a refund from Shopify into Acumatica:SalesOrder.Details[0].WarehouseID: 'Warehouse' cannot be empty.Inserting  'Sales Order Line' record raised at least one error. Please review the errors.

Im trying to think of a creative way to get around an issue we currently have, we’re implementing having sales order confirmations as we load a customers order, but a range of products that we make show up on Back Order.To take a step back, its mainly things we have to either make or decant. For example, 5L of alcohol. We store it in 1000lt tanks, decant as needed. This is a specific for a lot of stains for pathology use. Internally we send a copy of this to the warehouse or lab to be made, then kit assembly to build the item > create shipment ready for a picking slip.There could be a delay here though, sometimes a few hours, sometimes a day or two.Very rarely do they actually goto back order by the time the sales order is invoiced. Majority of the items where it would happen are critical to the order the customer is placing, I don’t want them thinking there is a delay with these products. But I don’t want to confuse all customers with a disclaimer in the body of the email sending t