Discussion Forums

Hi Guys, i want the Field CountryOfOrigin in the Soorder Detail Section. i tried it with a User Defined Field , but PXFormular is not working. namespace PX.Objects.SO{  public class SOLineExt : PXCacheExtension<PX.Objects.SO.SOLine>  {    #region UsrUrsprungsland    [PXDBString(200)]    [PXUIField(DisplayName="Ursprungsland")]    [PXFormula(typeof(Selector<SOLine.inventoryID,InventoryItemExt.CountryOfOrigin>))]      public virtual string UsrUrsprungsland { get; set; }    public abstract class usrUrsprungsland : PX.Data.BQL.BqlString.Field<usrUrsprungsland> { }    #endregion      }}   Hope u can help me.

I have a large import scenario that I need to amend, to prevent any issues while I do this I would ideally like to be able to duplicate the import scenario and then rename it to something unique so I have a backup essentially.Is this possible to do? I know I can export to XML but when importing I can’t see anyway of renaming / duplicating. 

Hi,While running Automation script on Virtual machines, accessible through Remote Desktop, facing Timeout Error at random places but it is working fine at In-house machines. However virtual machines were able to run the same scripts few days ago.    

I want to edit this bar at the bottom of the details tab of the sales order page. Is there a way to do this? I didn’t see anything in the Customization Project screen. 

I need to fill data in View 1 times when page is open. Not to reload it multiple time

In the current Shopify connector, it doesn’t support the custom mapping in the Entity mapping screen for the Refund entity, but if you want to have some custom mappings in the Refund order, you can do it in the customization project. In this topic, I want to share how to create a custom mapping in Shopify refund entity through the customization package. You can make a mapping to the original field or custom field. I tested it in 2023R2 and it works well. Create a new customization project Create a new code file, and extend the Graph from SPRefundsProcessor.     Override the method CreateRefundOrders     public class SPRefundsProcessor_Extension : PXGraphExtension<PX.Commerce.Shopify.SPRefundsProcessor> { public static bool IsActive() => CommerceFeaturesHelper.ShopifyConnector; #region Event Handlers public delegate Task CreateRefundOrdersDelegate(SPRefundsBucket bucket, MappedRefunds existing, CancellationToken cancellationToken); [PXOverride] public Task CreateRefundO

Hello,Created some custom boolean fields, but they are not displaying as checkboxes in the sales order, despite the control type being checkbox…. They are showing as text edit fields, then if you put anything in there they change to 'true'

I have added a field called ‘Production Order No.’ which is meant to pull the production order number for the given line in Inventory Lot/ Serial History screen without having to click on reference number → go to manufacturing tab on issues screen → view production number. Field Production Order No. in Inventory Lot/ Serial History ScreenManufacturing Tab of Issues ScreenAccess Production Order NumberI have added the code however it pulls incorrect details for some inventory SKUs.namespace PX.Objects.IN{ public class InventoryLotSerInq_Extension : PXGraphExtension<PX.Objects.IN.InventoryLotSerInq> { #region Event Handlers protected virtual void INTranSplit_RowSelected(PXCache sender, PXRowSelectedEventArgs e) { if (e.Row == null) return; var row = (InventoryLotSerInq.INTranSplit)e.Row; if (string.IsNullOrEmpty(row.RefNbr) || string.IsNullOrEmpty(row.DocType)) return; PXTrace.WriteInformation($"

Hi all - I'm only new here and to the product.  Just hoping I could get some assistance with this.We have several filters for different things in our Invoice/Memo and Bills/Adjustment areas.  Just wondering is there a way we can get a total to that filter - screenshot below.  Thanks heaps.  

We are looking to restrict visibility to non project invoices.Looking for best practice on how to accomplish this as we are just rolling out Acumatica. Since the default “X” allows anyone to see the transactions we were looking at creating an “SG&A” project and restricting that project to only accounting / executives. Thinking we’d then have to put all our SG&A GL accounts into an account group.  But would there be a way to limit that account group to only be valid for this specific project? Maybe some sort of restriction group? Thanks!    

When assembling stock kits using items that have lots assigned, is there a way to more efficiently do the lot assignment? Currently it seems like you have to go into the line details tab for every single item in the kit. We have some kits that may contain over 50 different items, all lot tracked. It is exceptionally tedious to have to click into line details for every single item to enter the lot.I understand that Acumatica is designed so that you could use multiple lots for an item where you have multiples of the item in the kit, so you can’t have the lot assignment field on the main kit assembly page. There is also no upload button on this page for doing the assignment more efficiently in a spreadsheet and uploading.

Hi Everyone,I joined the Acumatica forum as a resource for my external Acumatica application extensions using REST and the ScriptBasic application web server. Any good links to REST interfacing would be appreciated. John Excuse typo in the title., 🙄

while creating formula in the formula master screen, qty in prod. volume unit and material type, qty. in prod. wt. unit, weight %, volume %-these fields are not auto filled. can someone help me how to fix this issue.

I modified our Historical Inventory report to get average consumption data for a group of periods.I’m having trouble with getting the correct averages. Here are the formulas I’m concerned with:=Sum(IsNull([ItemHistCurr.FinBegQty], [ItemHistLast.FinYtdQty])) Not getting the correct ending quantity. (See “4148.000”) =Sum(([ItemHistCurr.FinPtdQtyIssued] + [ItemHistCurr.FinPtdQtySales] + [ItemHistCurr.FinPtdQtyAssemblyOut] + [ItemHistCurr.FinPtdQtyTransferOut]) / Count([INItemSiteHistByPeriod.FinPeriodID] )) Not getting the correct average (See “1,019.7143”) =Count([INItemSiteHistByPeriod.FinPeriodID] ) Not correctly counting the periods (See “20.00”)  In the header: number of periods, Average Consumption, and Ending Quantity is incorrect.  

hello all,I was wondering if its possible without customization to fetch the Sales A/c from the Employee record instead of hard coding it to replace (Account origin)? 

Paylocity offers customized reports that can be created and exported. Those reports can then be used in a import scenario to upload into Acumatica the needed payroll information.Looking to automate the process more, has anyone had success in API connection or using other systems like Celigo to get what is needed for payroll processing?

I’m trying to group in a GI by Lot/Serial Number for Stock Items, however, there are a few items without a serial number, and these are all being grouped together, despite being different lines (this is not a issue on Inventory Valuation for some reason.) Is there some way to do a conditional grouping? I tried =iif([InCostStatus.LotSerialNbr] <> ' ', [InCostStatus.LotSerialNbr], null) but the grouping happens even if the field is blank. Is there some way to do this?

Im facing a issue with community login with my laptop after logged out. Is there any issue with the login. After entering the user id and password system still refreshing to same login page.

Hi, I am using Acumatica 25R1enabled with SSO, so SharePoint user can able to login in Acumatica by click on ‘Active directory‘ on login screen and put their SSO credential. I am trying from my Acumatica Instance to call Graph API to get data from SharePoint of login user but not find any way to do.In the this code I can get the loin user name, but I am not able to get the access token of graph API to get data, please check this code and help me what I am missing var httpContext = HttpContext.Current;if(httpContext != null && httpContext.User.Identity.IsAuthenticated) {ClaimsPrincipal user = httpContext.User as ClaimsPrincipal;var accessTokenClaim = user?.FindFirst("access_token");                // Ensure this claim exists                if(accessTokenClaim != null) {                    return accessTokenClaim.Value; // Return the access token if it exists                }} Regards,Abhishek

Hi! For items with fifo costing, is there a way to see what the actual margin would be on a sales order? The margins on sales orders screen use average costing so it's not helpful for my client. Also, I'm looking at Inventory Summary report and same thing it provides the average. Does anyone know where to find the current fifo cost before the items have been issued/shipped?

Hi people,we are looking for a condition that works for both sites, main site and portal. This condition would restrict the access on portal by the user linked to the PMProject when it is a guest account.Something like this: I couldn’t find why it does not work for both.I can only make it work for one at each time. Thanks

HiIs there a way to change the login page of an Acumatica system please? I did navigate to Customization Project , created a project and then went to Customization Project Editor and selected Files, however I do not have the option to upload my own image onto the system and I think it is because the system isn't locally stored on my machine. How do I go about this?

       Hello,  we previously were using ItemCustSalesHist table to run some reports. This table is very useful. It has the sum up data with Item and Customers by each period. So we don’t have to count from the ARTran to reduce perfermance issue.     I don’t understand why this table is obsolete in 2024R2 or even earlier version .Is there a replacement for it?   I Know there is a ItemSalesHist table, but we need to group or exclude some customers.  So I need some data form like customer ,item ,sales qty (already counted) , period, something like this.    Can anyone help?

 I was discussing activities with a coworker and he mentioned that users should be able to enter TIME SPENT on an activity or task --  I see the fields on the form – but I could not figure out initially how to “update” or edit those fields. In the Tasks – it did not allow for it – can you confirm that the type of activity has to be a WORK ACTIVITY to allow for the time entry?