Financials

Hello!I want to generate expense analysis report from report definitions and I’m required to view YTD as well as average value for a period. For an example, if I’m taking YTD values for 7th period, I want to view the average value for a period (YTD expenses / 07). I can take the YTD values (Ending Balance) and couldn’t find a way of taking average value. Is there anyway that I can do this?Thank You! 

Hi, I've created an import scenario to import customer payment methods, and the import completes successfully. However, the imported payment method is not appearing under the Payment Method tab in the Customer Master screen. Could someone assist me with this issue?For reference, I have attached the Data Provider and Import Scenario.Thanks 

Any know where this column value comes from?  It is used on Visible settings in the remittance area. When I this field is printed in the Balance Due column,  The DAC is APPrintCheckDetailWithAdjdDoc and there are no incoming or outgoing references.  Looking at the data the only value is A.wnen not I this field is printed in the Balance Due column   

Hello.  We are struggling to get the embedded signature to work when printing checks.  It appears to be set up correctly as the Admin users can print a check with the signature.  However, the AP Clerk responsible for this is not able to print a check with the signature.  It just prints the check, but not signature. I suspect there is a security setting I am overlooking somewhere.  Any help is much appreciated!

Hello everyone,Starting from version 23R1, in a multi-company tenant, are data (GL transactions and commercial documents) automatically filtered based on the working company? Or is it still necessary to customize the queries by adding the Branch Access Info and Branch tables?Please note that my question is specifically about data visibility based on the current working company — not about access roles, company groups, or data restriction settings.Thank you in advance for your feedback.Best regards,

Hi,I am looking for any end point that can help me create landing cost entry in ERP. I could not find anything in the documentation. I have anyways created a custom end point with all the necessary data points but not able to get the right result. Can someone help me if they have come cross a scenario where in they have to create a landing cost via API.Regards,Nawaz, Mohammed 

On the reconciliation statement CA302000 for a credit card statement, should the Statement Balance field be a negative as the credit card is a liability and the GL balance is a credit?  My client is starting a reconciliation, and I wanted to verify that the balance should be -100,000.00 for the reconciliation.Thank you!

We currently have consolidated financials setup so that company’s BLC and BBLPMC are included when running financial reports for company BLLLC. We also need company BLLLC to be included in these financial reports, but they are not being included.  I took a look at how the Unit Set is currently defined and it shows the following:Do I just need to add the parent company to the value to include it withing the consolidated reports like so? Am I going down the correct path with these changes or is there more that I need to do have data from all three companies within the consolidated reports?

Can someone let me know what the logic of the conversion of units of measure is. I have read the help area about 10 times and I must have a mental block as it seems to be the reverse of what I would expect for converting from one unit to another. i.e. I would think converting a box of 10 bottles to a base of 1 bottle would require the instructions to divide by 10 but the operand is multiply. I am feeling quite stupid about this so please be gentle.. 

Client has a utility vendor with the pay separately box checked.  When the client goes to select the AP bills for payment, they show with the pay separately box unchecked and all the AP bills come out on one AP check.  They have a workaround to check the boxes, but would like to have the functionality work for this.  I have attached an example.This has been happening with several of their vendors.  I do not see this as a known issue for 2024 R1.Does anyone know why this would be occurring?Thank you!

 Error: Inserting 'Purchase Order' record raised at least one error. Please review the errors. Tax Zone should be..ON. The warehouse and branch are both located in ON and the vendor is location in BC.  Error appears from create PO from requisition. Anyway to turn off taxes completely or the work around this for a company with multiple different tax zones per warehouses/branches. 

Our company purchases trees from farmers. These farmers require 25% deposit or prepayment upfront and then the remaining balance is due 2 weeks before shipment. I’m wondering what the best way to set up these credit terms are? All of these payments will occur BEFORE we receive product into Acumatica. Thanks!

I am trying to hide or disable the Return option in Purchase Receipts for our users since it is often used in error. I was really hoping I could figure this one out myself by using access rights by role in user security but am struggling to find the proper section. On another note, I am excited that they finally added the option to either cancel/correct a receipt in 2025R1!  

Hello Community, While exploring the Controller dashboard I tried to modify the Cash Position widget to display the Account Description instead of the Account Code.  I took at look at the underlying GI, CA0002DB, which has the Account Description selected, active, and visible. However, when you view the GI results the Account Description does not appear and it is not available in the Column Configuration window.I have tried removing the field and then adding it but there is no change.What am I missing?  

Hi All,In some instances, we have to move AP invoices to other projects. This is something we were able to do in our old system but cannot seem to do this in Acumatica.For some reason, you can still move the purchase order to another project but the AP invoice does not move meaning the figures are incorrect against the projects.This is mainly for part-billed or closed invoices. Thanks 

Hi,I need to get a list of unreconciled fixed assets in the system. I tried building a generic inquiry but the system says the data class “GLTranFilter” is not available in the system.Further, I tried running Unreconciled Transactions for the Period report and it gives only transactions which are credited to the Fixed Assets Accrual account. Does not show any assets created manually and not reconciled. Kindly expect your assistance.Thank You,Dulanjana

Hi all,We're on Acumatica 2024 R2 (Build 24.206.0014) and have a scenario we’re unsure how to handle:Use CaseWe need to pay a single AP Bill to multiple vendor payment locations (e.g., 70% via ACH to LOC A, 30% via Check to LOC B).Splitting the bill is not an option – we need to preserve the original bill detail for 1099 reporting and analytics.Questions Is there a native way to pay a single AP Bill to multiple locations? Has anyone implemented or used a custom payment allocator for this? If customization is needed, what’s the best approach ?

Anyone know how to prepare a positive pay file to upload to the bank?

I am trying to create a GI for unreconciled assets as follows:All fixed assets, with a left join to FATran, only for TranType = “R+” (Reconciliation).  I’m assuming that the assets that have no FATran record will be the ones that were never reconciled.How do I add a condition statement that allows only fixed assets with no reconciliation transactions?

Hi,My mater financial calendar is designed in a way that start and end is not according to the general calendar. Example is as below. And I’m setting up fixed assets and when creating a fixed asset with acquisition date 27/10/2021  it gives me below error. “ FA Error: The document cannot be released, because the 05-2022 period in the posting book does not match the financial period in the general ledger for the SFT company. To amend the periods in the posting book based on the periods in the general ledger, on the Book Calendars (FA304000) form, click Synchronize FA Calendar with GL.” Then I tried the process but it gives me below error. Can you please anyone help me with t

Hello! I am running into this error when trying to process a payment for a prepayment invoice.I tried looking everywhere but I cant find what the below is referencing. I thought it was the Prepayment GL Account on either the customer class or customer profile, but neither were able to get rid of the following error. Does anyone know how to solve this? Thank you!

Hi CommunityI have ha this issue before but I cannot remember how I resolved it.Client wants to reverse application on a payment but cannot release the document. It gives the error “The document is out of the balance.”They do not want to allocate another invoice immediately.Please remind me of the solution.regards 

We are trying to reverse a payment application on an AP Bill through Checks and Payments on the Application History tab. We get an error of “SO Error:  the document is out of balance”. Any idea why? The “Reverse Application” works fine on the AR side, but it is not working on our AP side.Thanks!  

We are currently looking into how to best integrate credit card expenses into Acumatica. Do any of you know how to do this?

Is anyone transacting foreign currency payments in the real world in Acumatica?If so, I’m curious how you’re handling the difference between the rate on the AP Payment record in Acumatica and the rate that your payment provider uses, assuming that you process the payment in Acumatica before processing it with your payment provider. Here’s an example:1. The Base Currency ID on the Companies (CS101500) screen is USD  2. Enter an AP Bill in the Bills and Adjustments (AP301000) screen on April 01, 2025 for 100 EUR at a rate of 1.11111111  3. Here’s the journal entry that gets created when releas