Discussion Forums

Hi All,I’m trying to get more granular detail behind the discounts that we’re running through the system.The idea is that I should be able to report on discounts by Customer, Warehouse, InventoryID, DiscountCode (Line Level) , DiscountCode(Group Level). We are currently running multiple concurrent group level discounts with quite specific conditions so there are some instances where a single SO line has 3 group level discounts applied to it. Is there a table/ query that would allow me to see which lines on the SO a single group level discount code/ discount sequence has been a applied. Ideal Outcome:  Thanks in advance

I need to handle a new status on ARIncoice for legacy reasons and added therefore a custom field called cegEStatus in a DAC extension of ARInvoice.  [PXCopyPasteHiddenFields(typeof(cegEStatus))] public class ARInvoiceEIExtBase : PXCacheExtension<ARInvoice> {     #region CegEStatus     [PXDBString(50, IsUnicode = true)]     [PXDefault(PersistingCheck = PXPersistingCheck.Nothing)]     [PXUIField(DisplayName = "Electronic Status", IsReadOnly = true)]     [EiStatuses.List]     public virtual string CegEStatus { get; set; }     public abstract class cegEStatus : BqlString.Field<cegEStatus> { }     #endregion } This field was also added to AR301000.A new DAC has then been created to store the values assigned to the status of a given ARInvoice over time.    public class EiInvoiceRegisteredStatus : IBqlTable    {        public static bool IsActive() => PXAccess.FeatureInstalled<FeaturesSetExt.cegEInvoicingOutgoing>() || PXAccess.FeatureInstalled<FeaturesSetExt.cegEInvoi

are there any ways to reverse and apply memo multiple released invoices at once using Import by Scenario. Thank you.

Hi, is there any way/workaround to put in SO for customers on Credit Hold? We want to put in the orders as status “Credit Hold”, so our Shipping Dept. will know not to ship items until customers balance is cleared. If we won’t put in orders for customers on Credit Hold we’ll for sure not get their order, rather to put in their order as on Credit Hold and then collect their balance?! 

I’m trying to get the Warehouse name from Details in the SOShipment.  I was able to get the integer ID using this:SOShipLine firstLine = Base.Transactions.SelectSingle(); The firstLine.SiteID has the ID but how do I get the SiteCD (name)?

I have been asked to set the default sort for the Inventory Transaction History screen to sort by Descending Date order.  I found the following which does the job.  The only problem is it breaks the hyperlinks for Reference Nbr.  Clicking on Reference Nbr used to open the relevant Adjustment or Receipt but after adding this code they don’t work.  They still look like hyperlinks and accept the click but no page pops up.  Does anybody have any ideas why this happens and if there is a work around? Or if this is the wrong way to do this and there is a better way please let me know. namespace PX.Objects.IN{ public class InventoryTranHistEnq_Extension : PXGraphExtension<InventoryTranHistEnq> { #region Event Handlers public override void Initialize() { Base.ResultRecords.OrderByNew<OrderBy<Desc<InventoryTranHistEnqResult.tranDate>>>(); } #endregion }} Thanks for any help or advice, Phil

I had 3 error messages, and it cannot create invoice as below:1.The sales order line has no active link to a line of a purchase order.2.Lines with zero-unit cost and lines that are marked for dropship are not included in the calculation of margin for sales orders.3.Order SO 000077.Thanks so much for your help and sharing.

I tried this but I just get “Object reference not set to an instance of an object”:public PXSelectReadonly<SOOrder, Where<SOOrder.orderNbr, Equal<Required<SOOrder.orderNbr>>>> findOrder;        [PXOverride]        public void PostPersist(Action baseMethod)        {            baseMethod();SOOrder order = this.findOrder.SelectSingle((object)this.Base.OrderList.Current.OrderNbr);}

i want to add a doctype here in my Book but its not displaying whats wrong with my relationship  

 Hi, I’ve tried to adapt the instructions shown in this example for controlling access to releasing Journal Transaction to AP Bills & Adjustments, but I’m not having any success.How to set up Release button for certain users only? | Community  When I look at the user’s access none of their other roles are changing these values, but the user still has access to the Release button on the Bills & Adjustment screen.Am I missing another element that needs to be revoked?Thank you!

Hello @everyone,I would like to create a customization where I link sales orders of different types together and have this relationship accessible by displaying the related/linked order.I have created a custom order type PL which will be linked to the order type SO such that 1 SO order can be linked to more than 1 PL order.I have created 2 custom fields: a checkbox will appear to indicate that a SO order is available for linking and a selector field for PL orders to select the SO order to link to.I have also created a custom tab which will appear only if the order type is SO to display all PL orders linked to that specific SO order.This issue I have is a behaviour I have noticed where after I have linked the orders and selected the SO order that has a link, some parts of the screen show the most recently linked PL order  while other parts show information on the SO order. When I refresh the screen, that PL order will be in focus. I have attached screenshot of this behaviour.  I have al

Hi,I need to create a sales order invoice report below like that.Payment Reference and Advanced Payment Reference need to get from same field in ARPayment table.When Sales Order Invoice has Payment type I need to get ExtRefNbr field into payment Refernce column and When Sales Order Invoice has Prepayment type I need to get ExtRefNbr field into Advance payment Reference column How Can I get data from Report Builder.

I am try to get the customer portal site to not automatically check this box, so that anyone who comes into the cases page sees all the cases, and not just their own. I assume it is something I have to change in the Customization Project Editor, but I’m not sure where the specific change needs to be. How can I automatically uncheck this box?

When I go to the “Where Used in BoM” for a specific item, it says that 1 of this item is required for all of the listed BoMs. This is inaccurate and I’m wondering if maybe I don’t understand what this column is used for.For example the highlighted line: it says that 1 Bone Char 50 lb 50 ct is needed to make 1 3G Garlic Grower Bulk (my interpretation) The BoM for 3G Greener Garlic Grower Bulk The highlighted line is a product of the Bone Char 50 lb 50 ct which is 1/50th of the original item. SO my math says that the BoM (3G Garlic Grower) should require 0.00012 of the original item (Bone Char 50 lb 50 ct)

I have a consolidated trial balance report in Acumatica that combines my consolidated US tenant in a ledger, another CA tenant in another ledger as well as an elimination ledger.Is there a way to link this report to an excel so I just need to click refresh in excel instead of redownloading the file. Also, in the case of having a new GL, how do I ensure the report captures the changes?     

After setting up everything within DeviceHub correctly, clicking ok results in the logs resulting in this error. What is the solution to fixing this issue?Error when trying to run device Hub

Hi All,How do you enter a note in to the printed version of a Credit Memo for customers?The same way we have that on the Invoices? 

Does anyone know if the guest pass for the Celebration dinner will also get you into the marketplace?  My nephew will be there and wants to only go to the marketplace on Monday and no sessions.  He leaves on Tuesday.

Hello!I hope someone could help me with this issue:I’m working on a solution that creates a kit specification. I haven’t done any extensions for the kit specification DAC or Graph, I’m working with an stock 24R1 instance. However, when I save the record, I get this error:Cannot insert the value NULL into column 'NoteID', table '24R1.dbo.INKitSpecHdr'; column does not allow nulls. INSERT fails. The statement has been terminated.I haven’t came across this issue before… Usually, when I save a record I don’t have to care about genereting the noteID. Specially if its not a customized DAC and graph.Is there something I’m Missing? private static void ACUCreateKit(INKitSpecMaint kitGraph, USRMXCBOMSProduct productToSync) { kitGraph.Clear(); INKitSpecHdr kitSpec = new INKitSpecHdr(); kitSpec.KitInventoryID = productToSync.InventoryID; kitSpec.RevisionID = "WEB"; kitSpec.Descr = productToSync.MPlaceName + " - " + productToSync.MPlaceT

 I encountered an issue where the tax amount is getting removed from the document total whenever I select a check as the prepayment method.

Hello,This has happend to us twice in the past two months and need to figure out a resolution.   We have a shipment that has been confirmed and our shipping team realizes they need to make a change, they click the “Correct Shipment” and receive the following Error message as shown below:  We are unable to correct the shipment and are now “stuck” and unable to fix the issue.    I have been unable to put my finger on any commanality between the two shipments this has happend to,  and I don’t see anything unique with this shipment that makes it stand out from other shipments we have been able to correct without error.

Hi folks, I’ve been trying to solve an issue where creating sales order via the REST API can be very slow. To diagnose this issue, I enabled the request profiler and used it observe that--in addition to very large SQL counts and CPU time--the slow requests are generating exactly three exceptions per detail line: two System.InvalidCastExceptions and one PX.Objects.IN.PXUnitConversionException. Not exactly a smoking gun, but it does seem suspect to me (I don’t think we should be generating these exceptions, no?). Perhaps some data was stored in the wrong format (i.e. a string being sent where an integer is expected)? Drilling down into the exception details, it looks like the source of some exceptions may be from PX.Objects.IN.PXQuantityAttribute.CalcBaseQty; but I’m not sure where to go from here. Is there a way I can determine exactly which attributes are being set? Maybe that will help me locate the offending data format mismatch. Failing that, anyone have tips for tracking down the c

Hi everyone, I was following the suggested solution in the Report Designer Parameter relation customer id and customer location id | Community to create the parameter. I was able to output the Location parameter which is dependent to the Customer. However, it seems that the filter is not working. Output in report is still printing everything.  I tried adding the filter to the table that’s created relationship with. (Note: I cannot output this in the paramater as location the field is SOOrder.CustomerLocationID,CustomerID ) Do I need to create relationship now for the ARPayment? I have attached the report in question. Thanks a lot in advance. 

We just upgraded to 2024 R1 from 2023 R1 and in our last version the Pacejet customization added a “Shipping Services” tab to the Shipments screen with a field named “Pacejet Workstation ID” which our deployment department used to send lables to different printers.  I can’t seem to find that in 2024 R1, can someone point me to where to find that or similar functionality?Thanks!

Has anyone encountered this issue in 2024 R2? I have a sales order marked for production, and after completing the associated production order and moving the inventory into stock, Acumatica doesn’t pull that specific inventory when creating the shipment. Instead, it pulls inventory using FIFO or location priority, ignoring the production order inventory.Example:Sales Order 123 has one line marked for production, with the Production Order linked - XYZ. Production Order XYZ is completed, and the inventory is moved into stock to location ABC (via the Move Transaction on the Production Order). When creating the shipment, Acumatica pulls inventory from another location, even though the sales order’s line details so the associated move.I don’t recall seeing this issue in 2024 R1. Has anyone else experienced this?