Solved

I’ve created a Remittance report in report designer and added it to an email template. The template is subscribed to the below business event:  The GI is APPayments ← Vendors ← Contacts filtered for VendorClassID and DocType = Payment. All key fields are included. Despite this, when I bulk release payments from Release Payments, only the first record triggers and generates an email. Is this a configuration issue, or a limitation of GI based business events? 

My client is having two issues and I am not sure how to answer them. They are commenting that the WMS solution is causing them the same amount of work as if they did paper and pen. They are currently using pick sheets but testing paperless picking.  They do not do the Pack portion of pick, pack ship as their process does not need it.There does not seem to be an easy way to see which orders have a completed pick ticket ready to be shipped and invoiced. How can we see this information? With paperless picking and if the shipment is a partial pick and the user on the scanner confirms that the picking should be confirmed short, why doesn’t the shipment reflect the partial pick? Thank you in advance.

What would cause the quarterly 941 not equal the EFTPS report?  Where to look to reconcile?

Hi, I am trying to mass change the customer IDs via an import scenario. This works if run one on record selected at a time but it does not process if all records are selected. If I turn on Parallel processing than about 700 records process. I am not sure why.Any ideas?   

Hello Everyone,When i wanted to install the version 2023 R1 it returned an error and claimed that i must install IIS 7.0 or later, the problem is that i have indeed the latest version of it.Anyone can help?

Colleagues,Do any of you know if there's a setting that can be configured to make an expense receipt billable by default?Thank you! 

Hello ,  I want to display green background color to the status field with font color as white in the sales order screen. I Followed Two methods for that, 1)Method 1: By using below code in  this i obtained colour for status value not in the background, i need background colour for the status field and letters are in white colour.             <px:PXDataSource>           <ClientEvents CommandPerformed="changeStatusColor" />       </px:PXDataSource> <script type="text/javascript">        function changeStatusColor(sender, e) {            var edStatus = px_all["ctl00_phF_form_t0_edStatus"];            var edStatusControl = document.getElementById("ctl00_phF_form_t0_edStatus");            if (edStatus && edStatus.value == "H")                edStatusControl.background.color = "#FF0000";            else                edStatusControl.style.color = "#00FF00";        }    </script>Method 2: Using this method, I received no updates to the field. in this ca

I have added a custom action to the Field Service > Appointment scree (FS300200) to Print Service Order. Everything is working fine with it, except it isn’t saving before navigating to the report.Is there a way to get the action to save the record before navigating to the new screen? How it is set up. 

OK. As usual, this is a question that might be a little odd. I have a custom field on the production order called “JOB”. When creating an order that has multiple subassemblies I want to identify/filter the orders by “JOB” so. I am trying to figure out a way to show the “JOB” number from the product order on the same line as the associated subassembly. Something like this. I thought I might be able just pull in the AMPRODITEM twice once for the product and the other for subassembly and do some kind of IIF to pull in the “JOB” but hit a wall there. Thoughts? ORDER       ITEM       PRODUCT ORDER        JOB67890          TACOS      12345                     TACO MACHINE

hello everyone,I have extended a default endpoint to include users. I am able to fetch details from the summary area using a get request on postman. However, I have tried to pull roles of specific users but I’m just getting errors.Kindly assist on how I can fetch and manipulate roles of a specific user using rest api on post man. all responses will be highly appreciated. Thank you 

Hi-We have tons of sales orders created today (8/8/23): When I filter by ‘Created On’ equals 08/08/2023 I get the proper records:I also get the proper results when clicking ‘Today’ under the filter: However, I get zero results when filtering by Created On = @Today This filter is required in order to make a dashboard (same results can be seen by making a dashboard widget with the @today filter). Does anyone know why @Today does not aggregate results that pertain to todays date? Is there a change that needs to be made to the column in the GI setup? Appreciate any help!!

Hi There, I have to print a Box label section depending on the field value entered. If the value entered is 2 then second section in report to print twice, but first section to print only once.can someone please help me?  

public delegate IEnumerable OpenDelegate(PXAdapter adapter);        [PXOverride]        public IEnumerable Open(PXAdapter adapter, OpenDelegate baseMethod)        {            //    baseMethod(adapter);            //string orderNbr = Base.Transactions.Current.SOOrderNbr;                return adapter.Get();            }        } errorMethod System.Collections.IEnumerable Open(PX.Data.PXAdapter, OpenDelegate) in graph extension is marked as [PXOverride], but the original method with such name has not been found in PXGraphThe customization project must be published before the screen can be edited.

Can I Make Report Desainer Grup By Budget Code And Project ID , I will make Summry cost transakasi by Project ID and  Budget Code.This relasion one to many like this picture  And i need a Reprot like this : This a report view , total spending by budget code and spending by Project ID must not be the same this my gruping the report any one can help me ? make a report  

Once i have reversed a fully depreciated or overly depreciated asset , how can i delete it from the system so i can re-create the same asset ?

Hello everyone! We are converting our inventory into a template-matrix item using this customization: https://community.acumatica.com/retail-commerce-113/popular-retail-commerce-customization-packages-6934I am just facing some concern when there are some corrections made in the stock/matrix items in Acumatica that should reflect in BigCommerce.Consider an example of a template with attribute Size (Small, Medium, Large) and Color (Red, Green, Blue). Not all permutations are available. And the item was synced in BigCommerceNow, the business decided to change the color attribute name from Red to Rose, Blue to Navy Blue and Green to Lime Green. It was changed in Acumatica, but the variant details was not reflected in BigCommerce.Maybe one way is to delete the item in BC and resync the item. But that is not desirable especially if we made lots of changes in BC side of product details, and a transaction has already been made. Can you pls help how to fix the issue? Thank you 

Hi, I am creating a GI and I want to do a calculation with the data field with aggregate function. is there any possible way? the GI XML file in the Attachment. Thank you. The calculation should be SUM([curyLineAmt]) / SUM([curyRevisedAmount])After the use my formula with aggregate function, it shows this error.  

Hello,I have a 4 companies set as branches within one tenant. I need to use email templates specific to each company (branch) when emailing the employees their pay slips? Could you please provide me with a solution?Thank you

Hello: I would like to know if you have an example of how to carry out the replenishment having a general store that buys, for all the branches, but each branch has its own safety inventories, reorder points and that its method of replenishment for the branches is by transfer.For my part, I configured it but the demand in the branches is not recalculating, hopefully they have some support material.Thank you very much and greetings

Hi Experts.I want enable field Subaccount in the below image.I try: PXUIFieldAttribute.SetEnabled<APTran.subID>(cache, row, true); and set enable in worflow:but it not work (I try this solution for Sales Orders screen SO301000 and success).Can you help me?Thank everyone so much.

Good day,When a user enters a sales order and selects some stock items, the Marked of PO check is defaulted to check.  The scenario did not occur for all items; not verified. I tested a few; see below.  It this setting?  Or something I can turn off.  I causes order processing confusion and errors; also you can create a shipment without unchecking the box.  (We do Dropships and Direct Import orders that do require a purchase order to be generated.Thank you for your assistance.@EvanG  

Hi everyone!.I’m trying to add the “Inventory ID” to this report.Every “Job Code” have a different “Inventory ID” ( that can have ‘n’ Items),  I’m able to print the first Item of the Inventory ID, but then it repeats for others “Job Code” in every page.  There is something that I’m missing in the Relationships or Groups?.I attached the file below.Your assistance is greatly appreciated!.​

Has anyone found a way to get the Processing Status (ARPayment\CCPaymentStateDesc) to display in a GI?  It is always blank in the GI, even though if you go into the form there is data displayed for the field.  Would be EXTREMELY helpful to be able to see and filter for transactions that have declined, etc.  

Why we can’t check “Default Navigation” for field “InventoryCD_Description” in Generic inquiry?Is it a bug or normal ?

Where can I get amonthly GL expense and revenue report. I need it in the following format Account Subaccount Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23 4000 100-000 1000 2000 3000 400 5500 700 800 900 100 1000 6000 100 5000 125-000 1000 2000 3000 400 5500 700 800 900 100 1000 6000 500