Discussion Forums

I’ve discovered an issue with the way Acumatica is managing the `POVendorInventory.IsDefault` field We have a number of items that can be purchased in multiple UOMs which are set up on the VENDORS tab of the stock item. When removing we remove one UOM from the POVendorInventory table, the other purchase units are updated with the `POVendorInventory.IsDefault` field unchecked, leaving the item with no default vendor! This error happens whether we manage the item from the stock item listing or the Vendor Inventory (PO201000) table. The most confusing issue is that when you remove a UOM and save, the isDefault checkbox remains checked as True unless you refresh the page or hit Esc. This gives the appearance the the vendor remains the default vendor for the other listed Purchase Units As I’ve noted elsewhere, this is a very odd field as it’s critical to a lot of purchasing and yet it is listed as “Nonexistent in DB” and can’t be updated via the Vendor Inventory (PO201000) screen or adjuste

While modifying several AR Reports / Forms i.e. AR Statement / AR Invoice I needed to add a line in the address block, I did not want it to be a standalone textbox because I wanted it dynamically sized and to stay together with the other address rows. It was two pieces of data that we wanted to separate with several spaces, one space works just fine, but as soon as you enter two you get this result. After trying multiple approaches and finding no answer anywhere, I landed on this resolution, hopefully this will help you. The answer I implemented is to use HTML, start by setting the “ConvertHtmlToText” Property to True for the textbox in question.  Next change the Value to an HTML string below is the one I used in this example, it also has some parsing for USA +4 Zip Code formatting where a zip code is stored as numbers with masking in the UI, and would be shown here as numbers only but this inserts the dash, for better readability. ='<html><body>' + IIf([BAccountNoMask.Acct

Hi All,Has anyone had this issue before where amounts are not reflecting on the T4s of the paycheck adjustment created with the migration turned on?I appreciate all the help.Thanks.

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!

After hearing a lot of feedback around the number of scans and some confusion around the Set Qty feature during picking, we are designing an enhancement to the quantity entry for the Pick, Pack, and Ship screen. The following four sections are what we consider to be potential modes of behavior. Each section contains a Click Count which summarizes the actions required for each Mode. We will use an example of a shipment for five (5) units of one item.Legacy Mode: Quantity increases by 1 per scan. Using the Set Quantity button replaces the picked quantity with the number entered on the screen. To pick our example shipment, we would need the following steps: Scan the Shipment Number Scan the Location Scan the Item => (Quantity Picked: 1 of Quantity 5) Click Set Qty Enter 5 => (Quantity Picked: 5 of Quantity 5) Confirm Shipment Click Count: 6 actions total. 3 actions per line item. Incremental Qty Mode:  This mode is the same flow as Legacy Mode, only Quantity is Incremented rath

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.  

Hi Community,Many of our manufacturing clients are ETO shops who are incorporating Project Accounting (or Professional Services) with Manufacturing.  Do to the nature of the ETO manufacturing, the client is often required to recognize revenue using the Percentage of Completion method, per their CPAs.We love that manufacturing and (formally) project accounting are integrated, but from an accounting perspective it feels as though cost accounting for manufacturing and project accounting couldn’t be further apart, and I’m struggling as to the best way to leverage the best of each feature set to achieve the client’s accounting goals.  To illustrate, in manufacturing (and in a full-absorbtion cost accounting paradigm) the costs of each production order are capitalized to WIP Inventory on the balance sheet until the production order is complete.  Upon completion the accumulated manufacturing costs are placed in FG Inventory until the goods are “sold” and “shipped” to the customer.  Therefore

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!

The new legislation signed by President Donald Trump introduces temporary federal tax deductions for tips and overtime pay. Here's a summary of how it works.No Tax on Overtime PayDeduction Amount: Workers can deduct up to $12,500 in overtime pay ($25,000 for joint filers) from their taxable income on their federal tax returns. Income Threshold: The deduction is reduced by $100 for each $1,000 earned above $150,000 ($300,000 for joint filers). Effective Period: The deduction is retroactive to January 1, 2025, and expires on December 31, 2028. Reporting: Overtime compensation must be reported on Form W-2, Wage and Tax Statement.No Tax on Voluntary TipsDeduction Amount: Workers can deduct up to $25,000 in reported tips from their taxable income. Income Threshold: The deduction is reduced by $100 for each $1,000 earned above $150,000 ($300,000 for joint filers). Effective Period: The deduction is retroactive to January 1, 2025, and expires on December 31, 2028.Key Points to NoteImmediate P

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

Hello Experts, i am trying to create a business event in which the body contains an email to be shown of current logged in user . How to show that in the body ?