Solved

Here is my use-case: a user changes a drop-down value (UsrShipStatus)I need that value to update another field (UsrDfltWarehouse), this field will then create a dialogue box where I need to select “OK”This then calls the function private void setWarehouses(POOrder row).Below is the code in use here, I’m just lost on how to even interact with a dialogue box, or if I even need to (see comments below).    public class POOrderEntry_Extension:PXGraphExtension<POOrderEntry>  {      protected void POOrder_UsrShipStatus_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e, PXFieldUpdated InvokeBaseHandler)    {      if (InvokeBaseHandler != null)        InvokeBaseHandler(cache, e);      var row = (POOrder)e.Row;      if (row == null) return;      POOrderExt pOOrderExt = cache.GetExtension<POOrderExt>((object)row);      if (pOOrderExt.UsrShipStatus == "POE")      {        const string CUSTOMER_TYPE = "C";                        /* PORT LB - Port Long Beach */        const int PORT_

I’m trying to create a report designer that contains data for specific measurements from multiple different periods, (such as monthly, quarterly and annually.) Is there a way to filter for these time periods within a equation since the overall worksheet seems to be going off of one time period?

Hi, We created an attribute as a DateTime control type. This is attached as a user defined field to the PO Receipt. I am trying to print a report that is sorted by Item & then by the PO Receipt attribute. This is not working. If I sort by the PO Receipt Date, the sort does work. I saw an AUG forum post about using the CSAnswers table.but the data is not in that table. Is there a different table we should be linking to? Can a DateTime attribute be used to do the sorting?  

Hi. We have a client requiring setting up of company tree for 156 branches.We believed we can expedite by either using import scenario or, worst case scenario,do a direct SQL.Anyone encounter such experience before?Thanks in advance.

We would like to be able to have two additional columns in a Daily Sales GI. This GI will eventually become a pivot table. One column will have the sales in the US column if the ARInvoice RefNbr starts with an INV, the other will be an INT if the RefNbr starts with INT. My initial thinking for the formula is:=IIF(LEFT([ARInvoice.RefNbr],3) = 'INV', ([ARInvoice.OrigDocAmt] - [ARInvoice.FreightTot] - [ARInvoice.TaxTotal])) for the U.S. and =IIF(LEFT([ARInvoice.RefNbr],3) = 'INT', ([ARInvoice.OrigDocAmt] - [ARInvoice.FreightTot] - [ARInvoice.TaxTotal])). Both of these formulas would be in their own columns which I have as U.S. in one caption, and INT in the other caption.Date          U.S.                 INT             Total09/01/24    $12,345.00   $460.00      $12,805.00etc.The pivot portion shouldn’t be that difficult, just the part separating the U.S. from the INT.

Hi all,I am trying to figure best way to handle the following.Let’s assume that a new Project (related to construction edition with Progress Billing) is opened to manage the installation of HVAC and electrical installation. This project needs to monitor both costs related to equipment and labor. It would be ideal when new equipment is to be delivered and installed on site, a Service Order and related appointment is created to manage both the issue of the equipment from store to site and also to manage the time it takes to install the equipment and employees who are doing such service and capturing all related costs directly on the Project. The question I am trying to resolve is how best to record the issue of equipment  and capture all costs on the Project as there seems to be 3 possible optionsThrough a Sales Order linked to Project - Seems strange and not logic to use this especially since billing of both equipment and service will be done directly through the Progress Billing functi

Is there a specific security access required to enable the “Enter PO Receipt” button on the Purchase Orders screen? I have some user roles with full delete access to the PO and Receipts but they don’t see this option...  

We received some special pricing for an inventory item that we also carry some stock on hand.  The special pricing is for a certain project and it’s a onetime deal at a much lower cost level.  I had assumed that by using mark-for-po functionality on the Sales Order line, it would carry the cost layer to the PO receipt and ultimately through the Sales Order and not affect Avg Cost once inventory is shipped/invoiced.  After testing, I was wrong.  It looks like the Acumatica is using FIFO for managing cost layers, regardless if some of it was mark-for-po and linked.  This is now impacting our current inventory on-hand by updating its cost even though the lot of inventory that was received has been physically sold already. Does anyone know of a way overcome this without changing it to drop-ship?  I’m trying to protect the current costs on the inventory that is on-hand since this is a special situation for lower pricing.  Thanks

I have a list of accounts and sub-accounts that flow into the Finance/Admin line item on the FS. It is accounts 63000 to 71300 (sub account 700-000) as well as accounts 72300 to 72303 (sub account 000-000).How can I set up the Data Source in Row Sets to include both of these in the same line?  

Is there a way in Acumatica to create a Shipment without a Sales Order? For example, we want to create a shipment for a personal item - could be a nonstock item or stock item but no sales order just a request to ship to a location. 

Hello all,I am experiencing weird behavior with “DailyFieldReportEntry” graph events. When we have a CacheAttached Event in a graph typically it is the first one triggered by the platform to override DAC properties. As you can see in the below code on the same DAC I have two events. Acumatica triggers the RowSelected Event and everything works in my code as expected but oddly the CacheAttached Event is not triggered at all. But logically it should have been triggered before any other event. In fact, when I put a break on it to trace, it never is been hit at any point. Any idea why this is happening?namespace Test{ public class TestDailyFieldReportEntryExt : PXGraphExtension<DailyFieldReportEntry_ApprovalWorkflow, DailyFieldReportEntry_Workflow, DailyFieldReportEntry> { public static bool IsActive() => true; protected virtual void _(Events.RowSelected<EPActivityApprove> e, PXRowSelected baseHandler) { //My Stuff } //My P

I have an incoming document that has a negative amount equal to the freight from the original document in the Detail Total even when I remove all the items in the Details Area. Is there something I can do to fix this? I’m not sure where it’s getting this amount from. 

How do I change the associated email with this forum account? I’m swapping companies and wish to move it to my personal email. I went into account settings etc and didn’t see anything about changing the email.

Hello, can we integrate the PageCount and PageIndex/PageOf variables into a Subreport? We aim to develop a Footer-Subreport for inclusion in all our reports. However, we encounter a challenge where the Page-Count consistently shows as 1 of 1, regardless of the actual number of pages in the report.So Main Report => Subreport  Inside of the Subreport: = Switch( [@Locale] = 'de-de', 'Seite'+' '+[@PageIndex]+' '+'von'+' '+[@PageCount], TRUE, 'Page'+' '+[@PageIndex]+' '+'of'+' '+[@PageCount] )  

Hello.Is there any way to eliminate by import scenario the warehouses whose source is none?I'm not familiar yet with how to delete things.Regards.

Hi there, We wonder if anyone successfully set up gmail with OAuth2 method?  We have created the gmails credential, got the Client ID and the Client Secret. However, we get this error when sign in: Not sure, what step(s) we have missed?  Any advice would be greatly appreciated.  Thanks….

I have this customized selector attribute to filter Projects to the current customer on CRActivityMaint:public class DSRestrictActivityProjects_CRActivityMaint_Ext : PXGraphExtension<CRActivityMaint>{ [PXRemoveBaseAttribute(typeof(EPProjectAttribute))] [CustomerProjects] protected virtual void _(Events.CacheAttached<PMTimeActivity.projectID> e) { } public class CustomerProjects : PXCustomSelectorAttribute { public CustomerProjects() : base(typeof(PMProject.contractID), typeof(PMProject.contractCD), typeof(PMProject.description), typeof(PMProject.status)) { SubstituteKey = typeof(PMProject.contractCD); DescriptionField = typeof(PMProject.description); } public virtual IEnumerable GetRecords() { CRActivity activity = (CRActivity)_Graph.Views["CurrentActivity"].Cache.Current; if (activity is null || activity?.RefNo

Hello community. I had a question on a customization project I am working on. I have the code below where I am joining to quite a few other tables. When I am working in the code, am I able to reference the joined data or only the primary table? When I try to get Orders.Current to work it is only for SOOrder. Hoping I can somehow reference the data from the joins in my Orders view.        public PXFilteredProcessingJoin<SOOrder, RecertificationFilter,           InnerJoin<SOLine,               On<SOLine.orderType, Equal<SOOrder.orderType>,                   And<SOLine.orderNbr, Equal<SOOrder.orderNbr>,                   And<SOLine.orderType.IsEqual<SOOperation.receipt>>>>,           InnerJoin<SOShipLine,               On<SOLine.orderType, Equal<SOShipLine.origOrderType>,                   And<SOLine.orderNbr, Equal<SOShipLine.origOrderNbr>,                   And<SOShipLine.inventoryID, Equal<SOLine.inventoryID>,     

Hi.. new user to Acumatica. Does anyone know if Acumatica can print item labels and that sort of thing? I’m not talking shipping labels but something more like a tag for a product. Example… we have a part number for a product and we want to print a custom label that would have the part number, maybe a bar code and the price on the label… stuff like that. Is this possible? I have been looking all over the place in the software but can’t find anything like this.

Hi, I am using cstr() function on Document column in generic inquiry as filter is not working on the column, but when I use cstr() GI is showing rows with a null value in the column. Below is the screenshot for reference of cstr() followed by GI screenshot Kindly suggest to resolve.  Screenshot of GI without using CStr()  

Any ideas how to prevent invoice from printing unless it is released?

Hello.We are having issues with barcodes generated from Report Designer.While we are able to scan these barcodes locally, the client cannot consistently scan them.For instance, on the production order form, they can scan some, but not others.And in General, the barcodes being printed are not crisp and clean.The client does not like the aesthetics of these slightly blurry barcodes.We have played with all of the barcode settings.  The image below is not the current settings, I am just including it here to show where we have been working. Are there any other settings/properties in Report Designer that could allow us to improve the quality of the barcodes being printed?

Hi,There is a way to enter multiple value in a filter?I tried , and ; without success..Thanks!

I have processed a PO Receipt via WMS and released it. I have exited the app and returned later to perform the Put Away transaction. This is not working for me. While in Put Away mode, I am prompted to enter the PO Receipt number. I do that and the system recognizes the number successfully. It prompts me for the item number so I enter it.When I enter the item number, I get the error below.  On the other hand, if I move to the Put Away transaction immediately after receiving, everything works appropriately. However, if these could happen sequentially in the receiving process, why would I not just receive to the final put away location?

Hi there,We can’t release AP retainage due to error message of “Error: Inserting  'AP Transactions' record raised at least one error. Please review the errors.Error: 'Subaccount' cannot be empty.”Below is the retainage image from original invoiceThe journal entry from original invoice. Could you please advise? Thank you.