Discussion Forums

I just wanted to ask to see if other people are having issues with the Partner Portal currently?  I can’t open a support ticket, it just spins and spins, and then it will time out. -RJ

Hello again,I have a custom field INPIDetailExt.usrAbsVarQty that gets populated correctly by both the PI Review and Scan and Count screens. However, a change to the field by Scan and Count does not reflect accurately on PI Review, even though Scan and Count changes the physical quantity on both forms.When I put in the data for serial number ---78109 into Scan and Count, this is the result:But later, on PI Review, the absolute variance quantity is still at 40: I figure this has something to do with how PXCache works, but even after looking at a lot of documentation and searching the business logic code for how the other fields are updated/saved, I haven’t gotten any of my ideas to work. I am also suspecting incorrect inheritance/extension on my part.  Here is my code for the various screens and sources I’ve tried:Hostusing System;using System.Collections.Generic;using PX.Common;using PX.Data;using PX.Data.BQL;using PX.Data.BQL.Fluent;using PX.BarcodeProcessing;//using WMSBase = Warehou

Hello,      We use Acumatica to send emails often, and the outing going emails are actually not needed. It takes me a lot time and effort to delete them twice on screen “All emails” CO409070.           But I happened to find these records, even if I have clicked delete twice on screen to delete(first time make processed to deleted, second time makes it disappeared from screen.)          The table space usage are NOT actually reduced. Because it is still in DB, just with “DeletedDatabaseRecord =1 ”.        I am not quite understand why this is designed this way. My question is,  if we just Delete * from SMEmail where CreatedDateTime <='2022-09-30 20:30:55.027' and DeletedDatabaseRecord =1 .        Would it be OK?

Hi Acumatica Team,I have a issue whit a GI, I detected that Data Sourse: PX.Objects.IN.INSiteCostStatus does not exist in the new version 24R1, please could you confirm me what is the similar object of PX.Objects.IN.INSiteCostStatus in 24R1 version of Acumatica?Best Regards,Karolina Ramírez

Hi,I have duplicated the Kit screen, and now I want to customize the new screen. We want to include the barcode number field, which is in the ItemXref table, but this table is not part of the existing screen. My question is: How can we add this table to the existing screen and populate the barcode field in the UI? Based on the barcode, we will then display the items but not with inventory ids. and after that we will remove some of the fields.Then data should be save in the same kit table. What technique should I use to accomplish this task? Please help, it's urgent

Hi,Im  trying to save some extra data to database on RowPersisted event. If Im using Base.Save.Press(); as I did in actions then my code runs into infinite recursion. So is there any way I can do without running into infinite recursion. Im saving extra data on RowPersisted event because some data have to be saved when new record is created. If there is other ways to do it outside the RowPersisted event then it would be great!Tried to use RowInserted event but ShipmentNbr is not populated there so it is useless

The 2FA instructions state Users can choose to trust a device for 12 hours or 30 days. Where is this setting?  Also… Our Users have to login with 2FA multiple times from the same devices. Why does that happen? 

Hi Team,  What is the best way to periodically mass delete import scenario files? We are seeing these add up in GB.  Best,Madison Clarke

Hello we have a bit of a unique scenario. We primarily dropship all our orders. Due to inventory restraints at times one of our vendors allows us to purchase inventory ahead and store as “virtual” inventory till we need it. We then submit a PO to this vendor for shipping and they return a 0.00 AP Bill (since we already own the product) for the items + freight charges and any serial numbers that may apply to the product shipped.We would like to be able to monitor our inventory at the vendor for proper financial reporting, but would also like to be able to process the order as a drop ship PO instead of a shipment from one of our warehouses as we also drop ship other items from this vendor in the normal drop ship fashion and depending on the combination of items the PO would need to be shipped from the vendor’s stock instead of our “virtual” stock switching SO lines between Drop Ship and Shipping from our warehouse will be difficult.Has anyone done anything similar to this?

I just had to approve 40 AP bills for commitment retention release.  It would be nice to create one retention billing per vendor when AP retention is released, much like AR got a single retention billing.

I want to add more fields (in the red box) into the customization field, but I can’t figure out how to do it? What’s a way to do this?Where I want to add more fields 

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

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