Solved

How to get stock items which are checked by custom checkbox using $Filter parameter.

We use Template Items in Acumatica with Matrix items by Condition (New, Used, Refurbished, etc.). We really only have one attribute but we are required to use two in Acumatica in order to generate the Matrix items:  However, when the products sync to Shopify they sync both attributes as two different variant options: The 2nd variant option (in our case, “Condition Level”) is not necessary for us and shows up on the product page, which we do not want. Is there any way to unmap this specific variant option in the connector? Or another method to prevent this from syncing to Shopify?

We want to create a report with item mages and send the report via a busines event.  The report would have a customer’s prior item purchases with the each item’s image from the item’s “attributes”.  Is there a way in the same report to have an item’s description, the item’s purchase history, and the the item’s image from item attributes in the same report?  

Hi,Need to know how to clear existing error and warning messages in the UI. As per my screen example, I set some exception messages based on the logics inside the Verify Vendor Button event. So, I need to clear the existing validation error once it’s filled correctly. Thanks

Im trying to click on a simple command button on the SOOrder screen that sets another bound boolean field on the form. The comman button seems to fire but I cant seem to get the checkbox boolean field to set and update the database? Please help!! PXAction logic after clikcing ASSEMBLE KITS REQUEST (exception gets thrown “Request Sent”) public class SOOrderEntry_Extension : PXGraphExtension<PX.Objects.SO.SOOrderEntry> { public PXAction<PX.Objects.SO.SOOrder> UsrKitsAssembleReq; [PXButton(CommitChanges = true)] [PXUIField(DisplayName = "Assemble Kits Request")] public virtual IEnumerable usrKitsAssembleReq(PXAdapter adapter) { SOOrderExt1 soOrderExt = Base.Document.Current.GetExtension<SOOrderExt1>(); Base.Document.Cache.AllowUpdate = true; Base.Transactions.Cache.AllowUpdate = true; soOrderExt.UsrKitsAssembleReq = true; throw new PXException("Reques

HI All,I want to add a side panel to showing list of activities related to specific SO on SO3010PLView from SO3010PL Activities has been taken from SOList of activitesDoes anyone know how to do?

Hi, need some explanation.. sometimes we will randomly encounter this error. Any ideas what’s causing it?  

Hi All,How Can I fix below error ?Unable to cast object of type 'PX.Data.PXResult`6[PX.Objects.SO.SOShipmentPlan,PX.Objects.SO.SOLineSplit,PX.Objects.SO.SOLine,PX.Objects.IN.InventoryItem,PX.Objects.IN.INLotSerClass,PX.Objects.IN.INSite]' to type 'PX.Data.PXResult`7[PX.Objects.SO.SOShipmentPlan,PX.Objects.SO.SOLineSplit,PX.Objects.SO.SOLine,PX.Objects.IN.InventoryItem,PX.Objects.IN.INLotSerClass,PX.Objects.IN.INSite,PX.Objects.SO.SOShipLine]'.

Hoping someone can assist. I have created a business event to send Shipment Confirmations once the Status of the shipment has been triggered from Open to Confirmed.  The Business Event is working as there is a history of them firing, but the emails are not being sent:  this is the Email Notification Template:  Ive read other questions on here and the answer has been in the To: Field.. but I need to send it to the overridden Shipping Contact Email and there is no options for that: “If anyone can help me that would be much appreciated.CheersLara

What is the best way to handle delegation of permissions for time card approvers so that an approver can modify the timecard entries, such as change the billable time or change the assigned cost code?I have the approval map setup and it’s assigning to the user correctly. However all they can do is put it on hold then resubmit it. Seems odd that when they put it on hold, that removes the pending approval status as well. So if they happen to put on hold, not make changes at that time, and go back into Acumatica, they’ll no longer see that time card under their Approvals.is there a couple specific permissions I can tweak so that they can just modify the time + cost code then resubmit? Is that the proper sequence to modify? Put on hold, change, submit, then approve?We do have company tree’s setup so that User A can enter time for User B, C, D. But the approver is not in that tree.

Hello, Can anyone help me to figure out how to edit the time card regular hour ? It is set to be 8:30 a day which is not correct.Thanks 

How can I turn on File Attachments Drag and Drop functionality on custom Data Entry Documents(Header)?

We would like to be able to show a more formal description for each Matrix item on the BigCommerce site. Right now when you select a template on the BigCommerce site and then choose your variant options, the only fields that are displayed about the selected Matrix SKU are the image, the price and the SKU ID. The description for the item is simply a reiteration of the variant options selected on the checkout page, and nothing more. We would like to have the fill item’s description shown in Acumatica for that Matrix item displayed along with the SKU ID on the main page and the cart. When looking at the BigCommerce backend, we do not see a specific field for the description on the SKU columns. There are Bin Picking Number and UPC/ISBN as fields to be displayed, yet nothing in Acumatica found syncs to those fields.Does anyone have any suggestions on how to show a more detailed description of the SKU when the variant options are selected on the template?We are using Acumatica version 2023R1

I have read a variety of the posts on here and don't think I saw a clear answer on forecast consumption logic….. I am currently testing to understand the consumption logic before we launch forecasting.  I have created a weekly forecast of 6 pcs/wk for 6 months and then entered sales orders for 5 weeks that are both under and over that weekly qty.  It seems like the logic is to ONLY consume forecast within that week and not backward or forward consume forecast - Is that correct?    Is this a setting we can modify to set the # of weeks/days forward and backward to consume?  Our customer orders are not as consistent as a weekly forecast would assume and this would cause us the need to constantly reforecast or clear individual weeks each week forecast wasn’t matched or potentially overplan our demand when forecasts are not met, which is why consumption logic is often an MRP setting.   

Hi All, I have created a projected DAC as follows.   [Serializable]  [PXCacheName("ProjectedSOLines")]    [PXProjection(         typeof(Select2<SOLine,        InnerJoin<SOOrder, On<SOLine.orderType, Equal<SOOrder.orderType>,            And<SOLine.orderNbr, Equal<SOOrder.orderNbr>>>>>), Persistent = true)] public partial class ProjectedSOLines : IBqlTable  {        public abstract class orderNbr : PX.Data.BQL.BqlString.Field<orderNbr> { }        [PXDBString(15, IsKey = true, IsUnicode = true, InputMask = ">CCCCCCCCCCCCCCC", BqlField = typeof(SOOrder.orderNbr))]        [PXSelector(typeof(SOOrder.orderNbr))]        [PXUIField(DisplayName = "Order Nbr.", Visibility = PXUIVisibility.SelectorVisible, Enabled = false)]        //Other attributes like PXSelector        public virtual String OrderNbr { get; set; }    #region Status    public abstract class status : PX.Data.BQL.BqlString.Field<status> { }    [PXDBString(1, IsFixed = true, BqlFiel

Greetings all,I’m struggling with this Import scenario and hoping for some help.  I’m trying to create records in Stock Items > Vendors for every unique Vendor/Location/Item/Subitem combination that has been used on Purchase Orders.I can get everything working except for the Vendor Location field.  If you don’t define it in the import, it will pull in the Default Location.  When I try to populate it though, it’s just blank.I’ve tried both Location and Location -> Location ID, and POOrder.VendorLocationID, Location.LocationID, and Location.LocationCD. Thanks for looking!

Is Acumatica storing last Sales Order created date for a Customer?

Hi there,I’m working on Sales tax/HST report. one of the exempt tax sales item (-bank interest income )was not showing in the report. Could you advice how can we add the total to exempt sales total line item? Thank you. interest income bank entry -->stated exempt tax Tax report do not include interest income in exempt sales items:   reporting Group for exempt sales;  

We include within the BOM an Outside service process where the cost is billed on PO as not stock item. Is there a way to included the cost from non-stock items with the BOM and Production Order.

Hi everyone,I have been assigned to create a new order type for Purchase Orders screen and do use a custom numbering attribute for a certain type.So when I created a new numbering sequence and the necessary code below, but when I try to select a vendor from the selector I get this error:the code looks like this:for the POSetup’s DAC Extension: for the new numbering Sequence:And for the POOrder Extension: For the POOrderTypeExtension: For the CustomNumberingPOAttribute:So if you guys can possibly point out something that I might have been missing, I would really appreciate it. Looking forward to reviews from the amazing community.

I want to add an additional side panel to MRP display.One exists already.When I create a new action, Navigation: Side Panel is not available to select.Any thoughts?THANKS!

Hello Community,I have been trying to create a report where I would like to display the vendor name (of the subcontracts) in the details section on the basis of the project ID selected. I have implemented the following on GI level and it works fine. But not able to replicate the same in report:GI: Report: Have used the same as that of GI What is it that I am missing here?Thank you in advance.​​​​​​​

Hello Community,I wonder if anyone had experience translating check amount, that’s represented on Check form AP641000 by field [APPayment.AmountToWords] in to Spanish?Localization was completed for the system, and everything is being translated fine, including the rest of the fields on this form. Thank you 

Hi,we would like to show the service appointments and service orders we have created from a project in the project itself. Similar to the project orders for the matrerial which can be seen in a tab we also would like to see all service related orders/appointments in a tab to have the overview directly in the project. Does anybody has an idea for this?

Error: “The account is on a credit hold. Remove from credit hold?” When I am creating a new sales order, the following error has occurred.