Financials

In the Chart of Accounts Screen. How can we add a fifth ‘Type’ as ‘Equity’ ?  

This Invoice has a payment linked to it so the balance should decrease by the paid amount.  When i was trying to create a payment for the remaining amount the below error arise;  Is this something to do with that bad debt reason code, but there is no write off amount.  I tried to reverse the payment done as well but it wont allow me to do it. same error occurs.  Could you please help if you’ve experienced same issue. 

How can I get the QR code with a customer payment link onto the printed form of the statement?

Hello Acumatica Community,Is there a way in Acumatica to default or prefill User-Defined Fields (UDFs) on the Invoices and Memos screen with values from Attributes defined on the Customer Contract?Specifically, when a Contract ID is selected on the invoice, can the system automatically pull the corresponding Attribute values from the Customer Contract and populate them into UDFs on the invoice?​​​​The Values below have been filled manually; I would like the system to prefill the attribute values from the customer contract screen? Kindly suggest if there is any way if it is possible. 

Hello,       We have two customers who share the same boss. Customer A has a payment with some remaining balance, while Customer B has some open invoices. The customer has informed us that they no longer want to issue checks and have asked us to use Customer A's remaining balance to offset Customer B's open invoices.     I cannot simply void Customer A's payment because it has already been partially applied to some of Customer A's own invoices.     What is the best way to accomplish this?

We have some vendors that were incorrectly marked as 1099.  I can update the bills to remove the data in the 1099 Box column, however I can’t do this on a cash purchase.  How can we clear the box on the cash purchase so a 1099 doesn’t generate? 

I have received this error with currency translation worksheets :  Line #1 has an unexpected CurrencyInfoID or the wrong CuryID of the linked CurrencyInfo entry and cannot be saved. Please report this situation to your Acumatica support provider.

Hi Team.I am inquiring about Parent-Child Customer accounts. We have some customers that are part of our endorsing artist program. We track their orders through their own accounts, however for some of them, we actually send the product to their local distributor which is a different customer. The confusion we have is the customer that we send the product to is not connected to the document for invoicing purposes.We want to track the product sent to each individual artist through standard customer sales reporting, but also have it connected to the distributor that we “sell” it to. Can you confirm if the Parent-Child feature is correct for this? I would like to do testing in our test tenant, but I would like to confirm I am on the right track before I proceed.

Hi everyone, so i want to create user and role by Import Scenario, i successfully import the username for the user but when i try lo login with the username and password, i can not login and also the role that i already set up/mapping it not read it by system, there is a wrong mapping for my import scenario? I put my mapping bellow, please help me to look it out, i really appreciate your helps.Here is the user that successfully imported but not for the role 

I would think it would be a standard feature but I had to have my check stub customized to display the project ID.  The issue I am having now is that the project I and reference number are not in sync. Does anyone have any experience with this?

Good afternoon,I was curious if there is already an option or if its at possible...to be able to enter the invoice number of a customer directly on the payment screen to pull up their information to enter a payment?If there isnt, has there been discussion about possibly adding that feature to make it even easier to access a customer’s account on payment entries?  

Hello, I have just started exploring commissions in ACU. As a first step I wanted to clear out all prior period commission calculation since you cannot calculate when past periods are open. I have noticed that my commissions calendar does not extend to current periods and ends in a prior fiscal year. I looking to understand how to extend the calendar to current periods and beyond?  

After the upgrading to Acumatica 2025 R1, on the Bills and Adjustments screen, when we enter a Vendor and Project ID and click Add Receipt Line, the system shows all the receipt lines for that vendor across all Projects.Earlier, it used to show only the receipt lines related to the selected project.Is this a change in 2025 R1, a setting/ configuration issue, or a bug? is there a way to restore the old behavior?

Is there a way to reclassify a posting date rather than reversing the transaction and creating it again in the correct posting date period?

Hello, I want to close 1099 for 2025 but we started Acumatica in May. how can i add all payments from January through April?thank you

I’m trying to delete an unapplied credit memo, but the system won’t allow it. I’ve already moved it to a Rejected status, but I still can’t release an HB to the invoice that’s linked to this credit memo.If anyone has encountered this before or knows what steps are required to resolve it, I’d really appreciate your guidance.

Has anyone found a workaround that would allow you to default to the prior month for the financial period when you run a P& L statement?  

I have a customer that needs to import a BAI2 file - actually it will be quite a few files.  Does anyone have any experience in creating an import scenario for the BAI2 file?  It will include multiple bank accounts in one file.  I know that Acumatica does not support BAI2 files using the Import Bank Transaction Process, but at this point it is all that the bank will provide.Any help would be appreciated. Coleen.

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, How can I change the account under details under Bills and Adjustments? 

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 

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?

If I print AP Aging MC (summary or detail) as of December 31st, it does not show vendors paid on January 2nd. They are included in the final total but are somehow hidden(?) from showing up on aging. Our Implementation consultant (thru Support team) had said this was fixed with 25R1 but I still see this issue happening.Has anyone else come across this for Canadian localization? Have not tested this with AR aging but I will once I enter January cash receipts. Both reports must show documents OPEN on the “as at date” so I am not sure why they are hidden. It is very important for the auditors.Thank you!

Good day,I have a client in commodity trading who relies heavily on short-term loans (often referred to as gap funding) to finance their operations. They would like clear visibility into these loan accounts and how they are progressing over time.After reviewing options, we determined that using AP Accounts would provide the cleanest and most easily reconcilable setup. The loan providers are set up as vendors. However, when funds are received, Acumatica does not allow processing a receipt directly from a vendor to the bank.As a workaround, we currently do the following: Create under bills and adjustments a document type Credit Adj with the contra account set to a bank suspense account. Record a bank receipt in Cash Transaction using the same bank suspense account as the contra account to clear the balance. While this approach works, the client is asking whether there is a more streamlined method that avoids this two-step process.Is there a better way to handle this scenario natively i

We have filed discontinued operations and closed one of our companies.  This company is has active intercompany mapping.  There are no gain/loss on sale as we plan to absorb these through the other entities retained earnings. What is the best process to close out this company/branch?