Discussion Forums

Hi All, I have a scenario where GL journals have to be exported and imported in another ERP system. after the export we would like to mark these lines as being imported so they can be obvious on a GI. I can’t work out how to get the import scenario work using the same key module, batchnumber and line numbers. any hint would be much appreciated. What am I missing here ? error is not telling me muchThank you 

Users should be able to: Hover over text Select words or sentences Capture selected text for mapping to field Currently: The PDF loads successfully using PDF.js But it behaves like a static image Text hover/selection is not properly aligned or does not work correctly

Hi, I am trying to update the numbering sequence for the Projects screen, but I am running into the error shown below.  Here is what Segment 1 looks like. Is there anything that jumps out at you to justify why the above error was complaining about the format? Also, if I was to make a change to any of the attributes in the segment grid, I get the error that is shown below. Does this mean that I can’t make changes to this without making changes to the children first?  Let me know if you need any other information. Kind regards,Andrew

Has anyone built out a Toast Integration in the marketplace?

Hi,  I am adding a pop up note in one of the customer.  Should this pop up note can also be displayed when creating project?Currently it does not show the pop up note and wondering if this is just normal not showing up in creating project.  Thanks 

Had a subcontract that was of closed status with a remaining unbilled amount of >15k (this went back to the variance amount at the time of closing. A user then did a Change Order with the remaining variance that was left on the cost code at the time (around $600) to reopen the Subcontract.When the Change Order was created the Subcontract went to status over budget immediately and the cost code budget went to -15k. As the unbilled amount value returned to the Subcontract from the cost code. Is this expected behaviour? How do I fix this? All buttons as admin are now disabled on the Subcontract and the subcontract does not display when trying to do a Change Order if we were to try fix it this way. 

At summit I seen a few cool examples of people using business scenarios/recurring tasks for month end checklists etc. I am not finding a lot of guidance on the web or in the documentation.Anyone have good examples and/or a good place to go learn more?Anyone using these for sop’s?Screens WZ201000/WZ202000.   

The prepare tax button and process/release was done mid month on accident. Now our GL is off and our generated AP bills are incorrect. Not capturing the second half of the month. The only solution I can come up with is creating a manual AP bill to pull the rest of the sales tax due in, but is there any other way to reverse what has happenned in order to just start over? Is there a way to capture the remaining tax due for October besides a manual AP bill? What would the ramifications be of creating an additional AP bill to pull in the rest of the sales tax due? How does that transmit into next months Sales Tax Prep in ACM? Does it mess anything up if our generated Tax due in ACM does not match what we actually file and pay?Thanks for any help!

Hi, I’m trying to create a current time with =Now() and =NowUTC() for the UK time zone but GI gives me the same result for both functions. system not calculate daylight savings.I ran the GI at 11.40 am local time but GI gave 10.40 am for both =Now() and =NowUTC(). Please help to fix this.Thank you.Desh

Hi Community,I created a custom Acumatica screen, and I wanted to restrict users from deleting records.However, in my custom screen, the Delete action was not listed, so I couldn’t control it through access rights.

Hey everyone! 👋Quick question — what's the exact navigation path to access the tool Customization Project Editor in Acumatica?For context, I need to open and edit my customization projects, manage access rights, generic inquiries, and other project components.Could someone share the step-by-step menu navigation?Thanks in advance! 🙏

Hello Experts, I am unbale to figure out how to view the total number of production order with ageing category. I Tried creating GI but still facing problem how to group .Please let me know where am i missing .So my output result should look like:- 

Dear All,We are following the consigned inventory process in this articlehttps://www.acumatica.com/blog/how-to-implement-consigned-inventory-part-1/ the default setting for the transfer receipt is transferred type 2-step, which means we have to create a Purchase Receipt for that transaction.is it possible to change it to 1-step? It means skip the step creating Purchase Receipt and auto release transferThanks in advance.Yên Chi

We are experiencing issues with push notifications firing successfully but not being received on the mobile app. This was first identified when our clients wanted to enable multi-factor authentication, and upon investigating, we found that in our demo environment we could successfully create notifications but we didn’t receive them either. Here is a test notification I created that fires successfully, but no notification is received. We tested with multiple mobile devices, all with the notifications turned on for the Acumatica app, but nothing is received and the system shows no errors??   

I’m trying to pull in the date and time a Sales Order was created for some metrics for my shipping department.  They have a cutoff time, where and order entered before the cut off time should be shipped same day.  When I look at the SOOrder table, it looks like I should be able to use SOORder.CreatedDateTime, but in the GI, I only see the date, not the time.  Is there a way to make the time exposed.  And maybe even better, a way to split the date and time?

I recently created a pivot table off a GI that shows unit inventory and sales. The inventory piece is a bit challenging in that the Qty Available is correct, but on some lines it’s showing up as two separate numbers - always double what the actual available amount is.I’ve checked the GI and it shows the correct value, so I’m wondering why it’s doubling in the pivot table.not all records are like this. only a few. see below. Is there something wrong with the inquiry or is this a bug in the system?thanks!Joseph

It's great that we have such a vibrant Acumatica community to get quick answers to questions and gain product knowledge! We have very active members jumping in to help others out all the time. The goal of the community is to respond to every member’s question so that no one goes away "empty handed".Connect, Learn, Share Congratulations to our 2026 Acumatica MVPs!The Acumatica Community is filled with customers, partners, and creators who are just as passionate about ensuring our ecosystem thrives as we are. Our Community members go the extra mile to serve each other, and one of the ways we like to show our deep appreciation for their efforts is by honoring those who selflessly share their time, expertise, and knowledge with the Community.Read the Blog Here Acumatica User GroupsNew! Piloting our first industry user group! Construction Customer User Group Request to join today!The Construction Customer User Group is a place for customer networking around construction-specific ideas, ques

Tags have gone missing and ticket opened with Gainsight. This post will be updated when issue has been resolved.

Hello morning guys,Is there a way to configure the access right by screen by disabling the delete button in header document and enabling the delete button in the line document? Is that possible?The screen ID is CA304000.Thank you in advance.  

Issue Description: We have locked down the Stock Item screen to prevent users from adding/modifying vendors on inventory items. However, we've discovered that users can bypass this restriction through the Purchase Order workflow:User creates a PO with a Stock Item and adds a vendor that isn't currently associated with that item When the PO is received, the system automatically adds the vendor to the Stock Item's vendor list This circumvents our intended security controls on Stock Item vendor managementCurrent Setup:Stock Item screen access is properly restricted for regular users Users have appropriate rights to create and receive POs This appears to be happening during the standard PO receipt processQuestion: What's the recommended approach to prevent vendors from being automatically added to Stock Items during PO receipt when users don't have direct rights to modify Stock Item vendors?I've considered:Purchase Order Preferences settings (but haven't found the right option) Stock Item

In 25R2, I have exposed custom generic inquiries via OData, set up a connected application, and can call the OData endpoints from Postman.  I handed-off the initial collection to our MS dev lead so that he could wire them into a custom application.  He is attempting to generate T4 templates against the v3 metadata using a VS extension tool, but the metadata is not well-formed according to the schema referenced.  First, all of the standard GIs exposed via OData have naming validation errors with dashes or spaces in the names, so I removed the OData checkbox and republished them.  Second, it appears that Acumatica does not add Nullable="false" to the fields in the Keys sections, no matter what the underlying field definition is, and thus there is a generation error for every key field indicating “All parts of the key must be non-nullable.”.  So, he is downloading the metadata file, scripting the addition of the attribute to every key field and then generating against the local copy of th

Hello, is there a way to change the Shipping destination Type under Requests? Currently it seems to default to Branch, we’d like it to default to Warehouse. Is this possible?” Thank You!

I am building a GI to track OutOfStocks from sales orders, but have gotten stumped on the inclusion of the sales order pop-up notes. (We track our OOS via notes, since the backordered SKUs get removed from shipment and then cleared out so the backorder status etc is not able to be tracked for just those SKU as it gets completed still.) It seemed like I only need PX.Objects.SO.SOOrder + PX.Data.Note, but when I access those note text fields it is not correct. When I use “inspect element” it doesn’t work on the open popup, only clicking the note symbol which only gives me “NoteShow”  Per the screencap above, I’m trying to get “OOS 183889” to show in the GI, but I can’t seem to target THAT note field.Note.NoteText pulled in the origin sales order notes from the external system and/or AP, not the notes in the pop-up record in Acumatica.Note.NotePopupText found no text to display, even though I can clearly see them on the sales order.Is this the wrong table? Here are my settings: Thank you

Acumatica does not allow us to apply a 2nd Prepayment against a Balanced Invoice if a Prepayment  already transferred to the Invoice from the Sales Order.Here is our process:Create SO Apply Prepayment of 10% to SO Create Balanced Invoice (do not release, we have to wait until our customer picks up the product to release the invoice) - Acumatica automatically pulls the SO Prepayment over to be applied to the Invoice. When customer makes final payment prior to picking up the product, we want to apply a 2nd Prepayment against the Balanced Invoice - Acumatica does not allow this (I found a quirky workaround that if you temporarily unapply the SO Prepayment from the Invoice, apply the 2nd Prepayment, then reapply the SO Prepayment, it will allow you to apply both Prepayments).  The reason we use a Prepayment for the final payment prior to pickup is because we have situations where a customer makes a final payment but doesn’t pick up until the next month.  If we would use a ‘Payment’ type tr

I have created a Daily Order Entry report to compare January 2025 and January 2026 side by side.My requirement is to group the data only by Day (1–31) and combine both years into a single row per day.In the report I have attached when I apply the year filter then in 2025 section I am getting the 2026 records as well and vice versa for 2026I have already: Updated the grouping conditions Modified the date field formulas Adjusted sorting Has anyone faced this issue? What is the correct way to group by day only and compare two years side by side without getting duplicate rows?I am attaching the screenshot and report file for reference.Thanks.