Solved

I am facing an issue with a customization on the Receive and Put Away screen related to automatically triggering the Set Qty action, and I would appreciate your guidance.ScreenReceive and Put Away (PO302020)Issue DescriptionI have implemented custom logic to automatically trigger the Set Qty action after scanning an item.In Receive mode, the functionality works as expected.After scanning the item, the Set Qty state is triggered automatically, and the system prompts the user to enter the quantity.In Put Away mode, the same logic does not work. Expected BehaviorIn Put Away mode, after scanning the item and location as per flow, the system should automatically trigger the Set Qty action and prompt the user to enter the quantity. Customization Code Referenceusing System;using System.Collections;using PX.Data;using PX.BarcodeProcessing;using PX.Objects.IN;using PX.Objects.PO.WMS; namespace PX.Objects.PO.WMS{    public class ReceivePutAwayExt_ASetQtyExt         : PXGraphExtension<ReceiveP

Hello all,The native Trial Balance Summary report (GL632000.rpx) does not have the options to show all the GL account. The option ‘Suppress Zero Balances’ does address the requirement. Has anyone developed a generic inquiry or report that has options that meets the requirements below?Include ALL Accounts (Including Zero-Balance)This is considered the best practice for completeness, auditing, and data consistency.Audit & Review: It confirms that an account should be zero and hasn't been omitted by mistake. Seeing a "zero" is different from not seeing the account at all. Data Consistency: When exporting trial balances to Excel or other software for consolidation or period-over-period comparison, having a consistent list of all accounts (a standard "chart of accounts" template) is critical. It ensures that rows align correctly for formulas and analysis. Completeness Check: It provides a full view of the entire chart of accounts, which is useful for end-of-period reviews.  

Hello Experts, I am getting stuck in one of the issue how to show all the warehouse qty  for an item in inventory planning display when MRP is run, is there any setup missing i have enabled inventory planning check box for the warehouse location which are there in item, but then after iam unable to get the all warehouse location qty when mrp is run.

Hi, is it possible to automate the copying of notes from revenue budget line of a project to Invoice when running project billing? Do you think this can be done via business events? Saw the post belowWant this note to appear on InvoicesNotes to appear here

Hello, How can I change the account under details under Bills and Adjustments? 

Hi everyone,I’m working on an Acumatica Report (Label printing) and I’m trying to achieve a layout where each row contains 2 label items side by side, instead of the default behavior where each item is rendered on its own row.What I have done so far I created a SQL View that: Expands Sales Order Lines by quantity (1 row per label). Includes barcode, customer part number, MAP price, etc. I exposed the SQL View to Generic Inquiry. I built the Report using that GI as the data source. In the Report Designer: I set detailSection.ColumnCount = 2 Adjusted ColumnSpacing, Height, and layout settings Each label (InventoryCD, Price, Barcode) is grouped inside the detail section     Expected result Row 1 → Item 1 | Item 2 Row 2 → Item 3 | Item 4 Row 3 → Item 5 | Item 6 (similar to standard retail barcode label sheets) Actual result The report still renders 1 item per row, even when ColumnCount = 2 Sometimes only the left column is used Layout becomes inconsis

Hi, I am trying to import bank transactions with a csv file data provider. I have established the import scenario, but my condition doesn’t seem to work. It is for the amount column in my CSV file where if it’s positive, it should be a receipt and disbursement if negative:CSV fileImport scenario condition This is my error when importing: An error occurred while executing the Abs(Identifier(Amount)) function. Type mismatch in the argument 1 of the Abs() function: Expected one of the Integer types. Looks like ABS function isn’t accept by the system. Can someone help please?

Hi All,Has anyone encountered this issue before where no customers are showing up when we add a new SO. I am using a demo dataset. I appreciate all the help.Thanks.

We are experiencing an issue where the selector magnifying glass icon is missing on all screens in Acumatica.The problem occurs system-wide and is not limited to a specific screen. As a result, users cannot open selectors using the magnifying glass and must rely on keyboard input only.

In the case where an employee sometimes is reimbursed for Employee expenses (Travel, Living, Lodging and Entertainment come to mind) but also provides services which are not part of their employment contract, i.e. Advertising.When entering the bills for these activities, is there a way to indicate for each item whether it is reportable as a 1099 reportableactivity as opposed to an employee expense re-imbursement, which would not be considered income, and should not be reported on a 1099.

Hi Acumatica,I am trying to display Serial Numbers on a Shipment Confirmation, but I am running into an issue. When I put this field under the Group Header Section4, it will only display the first number from the list. When I put it in the Details Section, it displays all numbers for all items. I am sure I cannot be the only one with needing this on a Confirmation. Any suggestions would be appreciated.  Thank you!

Do I need to build my own SQL query using the tables/relationship/filters in the Report Designer or is there a way to view the exact SQL query being used to output the report?

Hello Acumatica Community,I am trying to move the document level vendor notes up in report designer on the Purchase Order to display under the line details. Here is the ideal position.  I have tried duplicating the Group footer section, but then the notes duplicate for each line item Please advise on how this can be completed. Thank you!

Hi CommunityI have just created a simple Import Scenario (just batch numbers to be reversed) but when I Prepare the scenario, the results are blank.I have done it several times and I have also created a new scenario - no difference.Has anyone seen this before?I have attached the .xml file. Any help would be appreciated.RegardsBarbara 

Hi everyone,I’m trying to import rate tables using the import scenario and getting the following error:I have configured the Sequence for each Rate Table and Rate Type under the Rate Lookup Rules screen.Note: The same import scenario worked for a client on 24R1, but I'm experiencing this error on 24R2.I've attached the XML file for the import scenario I'm using. I’d appreciate any insights or suggestions to resolve this issue.Happy to provide any additional details if needed. Thanks in advance!Regards,Raj

Hi All,When we tried importing the above demo snapshot on our test environment it doesnt show any data.I wonder if anyone have encountered any of this issue before.Looking forward to any help.  

Is there a way in Acumatica to automatically default a specific Destination Warehouse on the Sales Order screen when a certain Order Type (for example, TR) is selected?

When creating a shipment from a sales order, is there a setting or configuration that does not automatically populate/allocate the Warehouse location? We would like to leave that blank/unallocated and give the picker all the qty on hand on the pick list.Once they pick, then they choose the location before confirming. 

Hello, I am required to export an excel from the Acumatica system and save it in my local folder or even in my drive. I tried to get this done using the Synchronization option on the file maintenance, but it gives me an error. Below is what I have configured.When I select Export File action, it gives me the below error. Is it possible to export files and kept save it in a folder or a drive, or this is not something can do within standard Acumatica?Thank You!

A client recently noticed that they’re unable to tab through DateTime parameters in reports. I tested several reports / sites / versions and it seems to be consistent.Is this standard behavior? And/or has anyone found a workaround for it?

Hi All,I am wondering where can I find the field for Allocation for GI in Sales Order screen? (Please see below highlighted area in screen shot):I am trying to create a GI that show how many are allocated for an item in Sales Order. I tried using SOLineSplit (which is Line Detail in SO screen) but it gave me the amount I should allocate and not what is currently allocated. I have try to check for the element but it just show me SOLine when I click on it.Kind regards,Calvin

 We have a project with multiple tasks from initiation to signoff. For this project, we’re creating Production Orders for multiple Finished Goods. Labor Transactions: When labor transactions are created for a production order, they generate a GL transaction that posts to the WIP (Work-in-Progress) account. Upon closing the production, the labor costs move to the Finished Goods (FG) inventory. Shipping/Issuing Finished Goods: When the finished goods are shipped or issued, the costs move to COGS (Cost of Goods Sold) and update the Material account group in the project. Is this flow and my understanding correct? The main challenge I’m facing is tracking the production labor costs that have been reported back to the project, particularly when there is a budget allocated for labor costs. Labor Budgeting: How can I ensure that the actual production labor costs are properly tracked against the budget that was allocated for labor within the project? Linking Labor to the Project: How do I m

Hi,We dont understand why we have an amount here , all the commitment are closed/clompleted ?ssssws   What is the condition in order to be part of this total?Thanks

We have a problem in configuring work center. A work center is configured with ‘basis of capacity’ set to crew size, and three shifts are added, each with a different calendar. The calendars are configured with 8 working hours in a day, but the timings are different. When the MRP runs, the action date calculates based on the crew size and calendar in the first row of shifts but we thought it would consider all the shifts. If all the shifts are considered, the action lead time should be reduced to one-third, as the total working hours of the work center are 24 hours.We are not sure why Acumatica considers only the shift details in the first row

I’m trying to create a simple AP Bill via the Rest API, but am running into an issue where it appears Acumatica is validating the Subaccount field and producing an error even though I have valid accounts in the account and subaccount.  Below in the UI screenshot when I enter line 1, the account and sub default from the vendor record.  In line 2 I have manually entered the account and subaccount from the payload that are valid.  In line 3 shows as I first update the account, the subaccount is showing an error just like the API payload response.  I can’t use PATCH because this is the initial PUT to create the bill.  I have also tried creating a non-stock item with no expense account or sub to see if that helps, but it does not.Right now, the only solution I can see is to delete the account and subaccount from the vendor so it doesn’t default into the line.  One thought is to turn off the commit on the Account field in a customization, but that doesn’t feel right.Are there any other solut