Solved

Good morning! My company needs to place a purchase order that will give us enough stock of an item until April 2026. We have been in Acumatica for less than a year. Below is my proposed method of approach and I’m looking to see if the method will work.Manually enter monthly forecast data for February 2025-April 2026Increase “days of supply” for my purchased items to “453”Should MRP then give a PO recommendation of how much inventory to purchase?

Good afternoon fellow developers,I’d like to get assistance from community with the customization of the SO Shipment.I need to add SOShipLineSplit with partial allocation - identical to what I am doing via LINE DETAILS dialog (see on screenshot) Doing it via below code (with Qty set to 1,500.00) actually creates SOShipLineSplit, but it is always fully allocated, and Qty that I provided gets ignored. I’ll appreciate any recommendations Best regards,Andrey

I have a custom processing screen with two filter fields.The filter for the screen id works.  The filter for the file extension does not.Ignore the first filter field.  I was trying to use a selector to get UploadAllowableFileExtensions, but the value returned includes a “.” in front of the extension.  So I created a DDL with just the last three characters of the extension.  I could not figure a way to trim off the “.” in the value of the selector. When just the screen id is provided, it shows three files for that screen: As soon as I choose PDF from the File Extension2 DDL, the view is refreshed and attempts to apply the file extension filter.  Here is the code for the applyfilters method:protected virtual void ApplyFilters(PXSelectBase<UploadFile> shCmd, RecordsToProcessFilter filter){ if (filter.ScreenID != null) shCmd.WhereAnd<Where<UploadFile.primaryScreenID.IsEqual<RecordsToProcessFilter.screenID.FromCurrent>>>(); if (filter.FileExtension2 !=

  Hi everyone, this might be something really simple but I tried adding a new column (YTD Prev) and it’s only the lines in the headers that are getting cut off.  What I did is put the next column in the column range but that doesn’t seem to work. Any input would be much appreciated. Thank you.  Thanks so much in advance. 

Is there way we can flow the Phone number from ACM to Customer/Company in shopify via custom mapping? Thank you in advance

Good day CommunityI have a customer who creates an internal sales order to move stock for exhibition purposes. They do not want to create an invoice but the stock needs to be moved.Is there a way to close the shipment and ignore the “Prepare Invoice” step?Is there a way around this please? These shipments remain as confirmed, not complete.RegardsBarbara 

Good day CommunityI have a real mystery. I have deleted budget in the GL but when I run an ARM report, the budget is still there.It has also been deleted in the database by the administrator. Is there another table holding the budget information?GL Budget Edit:ARM Report:This make no sense to me. Can anybody assist please?Many thanks

Good Morning Ladies and GentlemenI have a bit of a problem regarding dead stockI am trying to add the Location field to the dead stock screenThis is what I currently have: Non filtered by locationFiltered by location Now the problem I am facing is with the dead stock calculationsAcumatica stores inventory history in INItemSiteHistByCostCenterD, but there is no table that has it based on location, or includes the locationid field (like INItemSiteStatusByCostCenter vs INLocationStatusByCostCenter) Would there be a nice work around, or would I have to build a custom view/DACTo be honest, I just want more advice ;)

Hi,One of our clients has many items with a base of UOM and a Purchase Unit of M2. These items are set up with conversion factors (as shown in the first image below) to correctly convert based on their formulas.This conversion setup seems to be causing some confusion in the PO History tab of the Purchase Orders screen, as a Purchase Receipt was processed using the M2 UoM, but the PO History tab in the Purchase Order is displaying the Receipted Qty in the EACH UoM, which is a much larger number after the conversion (second image below).After looking into the makeup of this field, I found that this PO History tab field is set up to use the Base Unit. Is there a way to ensure that this field always shows what was processed in the main Purchase Receipt record instead of converting to the Base UOM?Let me know if I can provide any other information.Kind regards,Andrew This is the conversion set up for the item shown in the PO and Purchase Receipt belowPurchase Order displays receipt in Base

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

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

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

Good,The issue is that when you create a quote with the same item number, say three times with different costs and then create the project the items are aggregated on one line.  (Operations has set a reduction protocol that reduces the the rate based on the amount of tools runs; 1st run at full price, 2nd run at half off, etc.)  I know I can make additional items numbers based on the protocol or make a discount code based on the rate.  We have over 10 different types of tools. The quote is provided to the customer based on the number runs.  This might change when the project begins either adding of deleting some. Questions,  How do I make the conversion to quote keep all the duplicate items on separate lines?  I don’t want them to aggregate.  Is this a billing rule?  Or Allocation update.  I am sort at a loss who to make Project Quote to Project conversion keep the lines separate without aggregating them.Thank you for your assistance.Evan

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.