Solved

I would like to get a clarification regarding inventory transaction data in Acumatica. We are currently trying to identify whether there is a single table or a recommended data source that can be used to retrieve all types of inventory transactions, such as inventory issues, receipts, transfers, and adjustments, in a unified manner.From our understanding, tables like INTran, INRegister, and INTranSplit are involved in storing inventory-related data. However, we would like to confirm the following:Is INTran the correct and complete source to capture all inventory movements (issues, receipts, transfers, adjustments)? Are there any additional tables or views that should be considered to ensure no transactions are missed? Is there a recommended approach (or standard Generic Inquiry structure) to retrieve all inventory transactions accurately for reporting purposes? Are there any specific conditions, flags, or transaction types we should consider when filtering this data?Additionally, we ha

Is there a way in the MFG BOM to have the Component flagged to only pull from Lot number?In other ERP systems ( like GP) , there is a single lot feature. Goal is have MRP understand that our component can only be consumed from one lot.  

Hi,I have a requirement to transfer the balance of the cash account in one company to a cash account in another company. For that, when Im trying to create the Inter Branch mapping the system does not show me the offset account in the search. What could be the reason ?Thanks!

When importing historic balances into the GL, one was imported into an Asset account with an incorrect branch.The asset account was subsequently used for a cash account and, after recalculating the balance, it was discovered that the offending transaction did not appear in the reconciliation.I am now unable to reclassify or journal the transaction out and replace it with one in the correct branch because the branch does not match the branch associated with the Cash Account.  We have already imported transactions into the Cash account so I can’t delete it and start again either.  It would appear that I am stuck between a rock and a hard place.Does anyone have any bright ideas on how to resolve or work around this? Thanks in advance…   John

We have a payment made in 2026 (application date 2026 also) but it was posted in 2025. We accidentally adjusted it to match a 2025 invoice that was reclassified and now we can't adjust it to the correct 2025 invoice in Acumatica to ensure the reporting is correct.

Hi everybody !  By any chance, does anyone have the AR631000.rpx in the Generics Inquiry?We’d like to add the AR value to our dashboards with the age date set to a specific date. Thank you in advance,

In Short: The issue I am having is upgrading in Trial Mode. I am wondering if my account just does not have access to the “Download Package” function (because I don’t have an account). Which would be an easy answer, but not good news for my pre-implementation testing scenario.Longer version for anyone interested in offering reply. I have been reviewing Acumatica software...in Trial Mode (pre-implementation). I have installed locally from Open University provided software. I have gone through setup, import data, set up some minor customizations (new columns that move data from SO to SO.Invoice...and created those same columns in AR.Invoice for customized reporting...I set up and tested the custom reporting...systems works great! But I wanted to test going through upgrades. I Snapshot’d the tenant, created new instance (sandbox), customizations tested fine, I turned off the customizations in the tenant, went to maintenance mode, downloaded the package in Apply Updates, and attempted to i

We use serial tracked products that sometimes get consumed into other internal orders but sometimes get sold as is to the customer. We are having a hard time finding a way to get a list of serial tracked items that have neither been consumed into other orders nor sold to the customer. Any guidance of how to best pull together this information into a GI that employees can check against? I’m thinking probably some combination of ARTran and AMMTran info

We have created a GI and we are calculating values in the Results Grid to come up with a Percentage Complete.  Formula is (ActualAmount / RevisedAmount)*100.   This should give us a Percentage Result.However,  The Calculation results are inconsistent.For Example, the Actual Amount is 2400 and the Revised Amount is 4800.  The Percentage Result is coming back at 100.  It should be 50%.Another Example, The Actual Amount is 52716 and the Revised Amount is 138000.  The percentage Result is coming back as 76%  it should be 38%.But then in another line example the calculation is correct.  The Actual amount is 7992 and the Revised Amount is 14800 and the resulting percentage is 54% and this is correct.We can not figure out why this calculation is incorrect and inconsistent.here is the actual line in the results grid.=CInt(IIF([BudgetRevenue.CuryRevisedAmount]=0,0  , ([BudgetRevenue.CuryActualAmount])/[BudgetRevenue.CuryRevisedAmount]*100))

Hi all,I’ve created a Generic Inquiry (GI) to capture the customer’s first invoice date, and I’m using that as the customer start date.What I’m trying to achieve is something like an annual reminder/email based on that date.For example:If the first invoice date is 1st August 2024, then every year on 1st August (like 2025, 2026, etc.), the system should pick that up and trigger an email.So basically, I don’t care about the year — I just want to match the day and month with today’s system date.If today is 1st August, the GI should return only those customers whose first invoice date is also 1st August (any year). Then I can use that to send emails like “you’ve been with us for X years”, etc.The GI I created is already working fine to get the first invoice date, but I’m stuck on how to build the logic to:extract the day and month, and compare it with the current system dateI wasn’t able to get that condition working properly in the GI.Has anyone done something similar or have any idea how

I'm working on creating a report that contains all of the contact information for the other trades we typically coordinate with onsite. Information would be found in the Construction module under Projects and the Contacts tab. I'm having trouble getting the coding to pull the correct information. Right now, it's pulling in a random contact that isn't associated with the project I am using for testing. I'm sure there is a table or relation that I am missing, but every time I make a change it gives me a new error. The other thing is each project could have several contacts associated with it that I would need to break out per role on the report. I would think that I could add some type of if/then statement for each role to pull to a different designated location on the report, but want to make sure this is even feasible before I invest too much time into trial and error.Element Properties for Contacts:Current Relationships: Current String: =[ProjectContact.ContactId_Contact_displayName] 

Hello, How can I solve this error when trying to create a generic inquiry and display the site, but encountering the message: "generic inquiry This field will not be displayed for the current user because the user has insufficient access rights or the required feature is disabled"? Thank you in advance.

When setting the OrderQty field to 0 on the SO Line, a popup is triggered as expected. However, once the popup appears, the Details tab disappears immediately. After closing the popup by clicking OK, the Details tab becomes visible again. <template>  <qp-tab id="tab-Dsco-SO301000" caption="Dsco Info" after="#tab-Addresses">        <qp-template id="form-Dsco-SO301000" name="17-17-14">            <div id="divColumnAB-Dsco-SO301000" slot="A">                <qp-fieldset id="fsColumnA-Dsco" view.bind="CurrentDocument" caption="Dsco Information" wg-container="CurrentDocument_Dsco">                    <field name="UsrBZStoreCode"></field>                    <field name="UsrBZDscoPuNumber"></field>                    <field name="UsrBZDscoOrderCancelAfterDate"></field>                    <field name="UsrBZAknowledgeStatusInDsco"></field>                    <field name="UsrBZShipmentStatus"></field>     

I upgraded my system from 25R1 to 25R2, and I have a snapshot of the old 25R1 system.In 25R1, on the Invoice and Memos screen, when I printed a report, it used the report ID from the Customer Class.Now, in the new version, it always uses the standard ‘AR641000’ and does not pick up any other report.I verified that my custom report ‘AR641001’ works correctly. It also works properly when printing from the SO Invoice screen.

I have a scenario where the several pieces of equipment that need to be serviced and all the equipments are company owned and all in company location not in customer location. We have created these machines as Equipment records. However, when creating a Service Order, I am able to select this Equipment anywhere in the service Order.Is it possible to perform service for company-owned equipment through a Service Order and Appointment?

Hello,             Previously, AP505000 (process payments/print checks) are sorted by Reference Nbr. field. Now, we find in 2024R2 ,it changed to sort by Vendor ID/Vendor Name.             Is there a way to overwrite the default sort ,can we change back to sort by “Reference Nbr.”?             I prefer the way without code modification, that just using the tool Acumatica provided. But, if code customization is a must, please help.

Why does Service Time get deleted from the log when reopened? Specifically, when a person other than the individual assigned to the appointment uncloses or reopens the appointment. Is there a way to keep this from occurring?

Hello Community,Have a small issue - when trying to send an AR invoice we have placed 2 email addresses in the Account Email Field under “Additional Account Info”.  The address are separated by a semi colon ;   I cannot change this to a comma, it defaults to a semi.When sending emails, it will only send to the first email and not both emails.  I have found a couple similar issues here:https://community.acumatica.com/distribution-6/send-po-to-multiple-email-addresses-8956?postid=31480#post31480https://community.acumatica.com/distribution-6/sales-order-notifications-not-sending-to-all-emails-listed-to-send-to-7564 I have looked into both of these solutions, however I’m not sure which BUILD is being referred to in thread one.  In thread 2 removing the field in the “TO” field results in an error saying there is no Email address to send the notification to. Hoping someone may have insight?Cheers,​​​​​​​K2

We are considering changing from Shopify POS to Clover.Is anyone using Clover for POS, and if so is there a preference for which 3rd party connector is used?Thank you

I’m trying to condition a GI to only show shipments that were confirmed yesterday.Originally I was using ShipDate and was able to achieve this by using the following formula:SOShipment.ShipDate Equals =DateAdd(Today(), 'd', -1)But using the SOShipment.ConfirmedDateTime does not give me the same results (it actually gives me no results). 

Good day, I have Generic Inquiry that pulls data from Customer and Activities including email subject.  I have ten different Branches for the time being.  I am going to have more than 100 as some point.  I don’t want to create a different GI and then set them to the individual branch security roles.  The customer are set to Restrict Visibility for the customer account.  We don’t the Branch manager to see the other branch activities.  Any ideas?Thank you.Evam  

I have the following issue with Modern UI:In one package I create a column.In another package I add a field / logic that depends on that column.Everything works fine when I develop Modern UI in Visual Studio — after build, all changes are visible on the screen and work correctly.But when I add Modern UI files into packages and publish them in another instance of Acumatica ERP, I get errors (field/column not found).I understand that this approach is not recommended, but I still need to make it work.Is there any way to handle this scenario? [2026-03-26 14:54:27.199] npm run build failed with output:> screen@0.1.0 build> cross-env node --max_old_space_size=6144 --optimize_for_size --stack_size=6144 --trace-warnings ./node_modules/webpack/bin/webpack -- --env production --env tenant=Company screenIds=AR301000,AR303000,BZ101001,BZ101007,BZ201520,BZ401005,BZ401022,BZ501011,BZ501012,BZ501013,BZ501014,BZ501015,BZ501017,BZ501041,BZ501066,BZ501071,BZIMAGES,CR302000,IN202000,IN202500,IN2030

I’m hoping someone can help us with a workflow hang-up we’ve run into several times. We are a contractor supply store and often place custom orders for customers or drop ship and/or ship material from our location to a jobsite.When we custom order products, we pass the our vendor’s shipping cost along to the customer unless we can add it to one of our normal stocking orders.When we drop ship, we add the shipping expense to the Sales Order.When we ship from here, whether it’s using the UPS integration within Acumatica or LTL freight, we add that expense to the Sales Order. What is the recommended workflow from Acumatica or something that works for YOUR company for charging customers before the exact shipping amount is known? I see a “create pre-payment” button next to the “create payment” button, and when we create payments there are options for “authorize” and “capture.” My understanding of these 4 is as follows - “create pre-payment” - pulls partial funding to be used toward the order

Hi All, Need help currently we are transitioning to the new 2025 R2 of Acumatica, by this I am trying to switch the Classic UI to the Modern UI, but the problem is when I am switching the UI to Modern UI all the customizations are not reflected to the modern UI, especially we have a customized button in Details tab of Opportunity, because we linked the Estimates on the Opportunities that whenever there is a created Estimated with the same inventory id on the details tab, after clicking the calculate price, the system will automatically calculate the price based on the margin code we specified.  Thank you

I am creating a purchase order approval workflow for a client. They previously used Purchase Requests with an approval workflow and are wanting to replace this with Purchase Order approvals.Their Request Approval Workflow conditions are based off Department and $ amount.  Currently it is not possible to setup Purchase Order workflows in the same way, as the Department Entity is not available.Can we add the department field to the Purchase Order header and add the department entity to the Purchase Order workflow?Additionally we would probably get the Purchase Order department field to default to the PO Owner (employee’s) department but they could select any department, as it will not always be the same department as the user who is creating the PO.Has anyone implemented a customisation like this before?