Financials

I’m encountering an issue with the Purchase Accrual Report in Acumatica. I have a Purchase Order (PO) with multiple Purchase Receipts (PR) and some returns against it. However, I noticed that:The returns are appearing in the accrual report. The purchase receipts (that were not yet billed or returned) are missing from the report.Has anyone experienced this issue before? Any insights on why the receipts are not showing and how to correct this?Appreciate any guidance!

Good morning, we receive the following error when entering a record for a vendor. The Vendor was recently created on on 1/17/2025. We were able to add a record on the 17 but then it didn’t let us add a second record. We were able to workaround this issues by changing the record date to 2015 and then once the record was accepted we changed the it back to 2014 date. Is there any settings that may be preventing us from entering Bills from 2024?     

Hello,We have seen that for 2024R2 build 24.204.0004 and 24.208.0020, the quick search for the Vendor field on AP reports parameter tab does not work.  Additional testing shows that it works in 2023R2 (23.208.0026) and 2025R1 (25.093.0036). Therefore, we assume that it got broken in 2024R2 and then corrected in 2025R1.Acumatica, will this be corrected in 2024R2?Someone had posted about this 2024R2 issue sometime last year but I have not been able find the article. It referenced that the =Report.GetFieldSchema('VendorReportParameters.VendorID') may have an issue in the DAC.The backdrop to this has to do with an upgrade we are looking to do for a client, from 2023R2 (23.208.0026) to 2024R2 (24.204.0004). We discovered the issue during sandbox testing.Below are some screen images of the parament screen for the AP Balance by Vendor

Good afternoon,What has been the best approach you have found to add a finance charge to certain invoices or customers accounts based on age of invoice?If I was looking to add finance charges to invoices older than a year or a customer that severely past due...what approach do you use?

I would like to Automate Opening financial Periods, I have tried setting up a schedule but there is something I’m missing. My setup is as below,Can someone help😊

How can I use Customer Invoice to pay for a Vendor Bill?I saw the option to "Extend as Vendor"  on customer screen and "Extend as Customer" on vendor screen but I didn't find how do I apply a vendor bill to a customer invoice...I would appreciate any suggestion.Thanks

I am trying to create a report with a blank column to divide out actual vs budget columns.  When I run the report there are zeros on some rows but not others.  I can’t figure out why it is pulling the zeros.  Everything else looks correct for the actual columns.

Do the Generate intercompany document (AP503500) is supposed to generate AP/AR for a interbranch timecard ?Thanks

How can a mass update of Vendor payment type be done, if at all?  Import Scenario? Generic Inquiry?Several vendors were set up with this informaion missing and instead of opening and updating one by one hoping a mass update can be done.  I am new to working with mass updates in Acumatica so any and all help/instructions is greatly appreciated.

Hi,I created Sales Order 01 last month for a customer with the credit term A (the customer's default credit term is A). This month, I created another Sales Order 02 for the same customer with the credit term B (the customer's default credit term is now B). I created separate shipments for both sales orders. When creating an invoice that includes both sales orders, which credit term will be automatically selected by the system? I observed that the system prioritized the credit term from Sales Order 01 instead of the customer's default credit term. Is this correct?Regards/Prasad

When I click ‘Add PO’ or ‘Add Receipt’ nothing shows up even when there are received POs for this Vendor and Stock Item.

My client would like to use Acumatica AR Invoices and Sales Orders and then have the tax calculated right in Acumatica. It would work just like to normal Acumatica / Avalara plug in but it would be for telecommunication tax not sales or use tax. I’ve checked with Vertex and Avalara and neither do telecom tax with their integration with Acumatica.   Also ideas?

Hello,Our controller asked me to post this question on the community. Can you please let me know what he is questioning? Why does Acumatica AP module put a BL as a prefix to the AP ref number?  This is a system generated number that is not manually entered.   

1. Truncated Module Menu DescriptionsSome of the module menu names are too long and get chopped off, making it hard to figure out where to go. Right now, you have to hover over them to see the full text, which is kind of annoying. It’d be so much better if the full names just showed up without needing extra clicks or hovering.2. Misleading Validation in Generic Inquiry FormulasWhen you’re setting up formulas in Generic Inquiry, the validation check isn’t always reliable. It might say everything’s fine, but then you run the inquiry and—bam—errors pop up. That’s frustrating because you think you’re good to go, but you’re not. Fixing this so the validation actually catches problems before saving would save a lot of time and headaches.3. Complex Procure-to-Pay Process and Billing InaccuraciesThe whole Purchase Requisition > Purchase Order > Receipt > Invoice > Payment flow can get confusing, e

When our company was moving into ACU supposedly we were told that Acumatica could use per-determined rules to disperse specific expenses into each of our branches.For example:Any marketing expenses will be dispersed via the followingBranch A 29%Branch B 30%Branch C 41%I could not find a way to do this so I am assuming I may need to do this manually?

Hi there team, We have wondered why the Company Financial Calendar doesn't default to the same current open financial year? Rather annoying that we have to scroll to the actual year, rather then just open screen and the open/close periods.  

Hello All, Anyone have the basics for an Import Scenario to do a mass update to the Cash Account on the Default Vendor Location Record they would mind sharing?  Thanks in Advance.

I am having one heck of a time configuring a clearing accounts to use them for bank deposits. I’m using the guide from here: https://fedcoseeds.acumatica.com/(W(29))/Help?CompanyID=Test+March+2nd&ScreenId=ShowWiki&pageid=323644f1-ea34-4377-92bc-c1fcb4a86d05 But I must be misunderstanding something. I created the clearing account: I did not put any entry types.I made sure the clearing account could be use in the Payment Methods 

Question from client:For the charges that are left after Auto-Match is complete under Process Bank Transactions, every single line will go to the Create Payment tab and I have to click on the Match to Payments tab and click on the Match to Multiple Payments and Match to Receipts and Disbursements options for the leftover charges to show up. Can we set this up to where it will stay on the Match to Payments tab? I will never use the Create Payment feature and when I’m clicking off 400+ charges manually, it gets really annoying that I have to click on so many things just to match the “bank” charge to the “payment”. I looked into this and could not find a way where unmatched transactions don’t default to the Create Payment tab. I looked at Bank Transactions Rules but that did not seem to help. Any suggestions? Thanks,Frances   

HI All, As per best practices  and its Normal and Simple  Process   as per my Knowledge across during the years the following is the Transaction entries which will clear the Purchase Receipt and return Purchase receipt Inventory Account  Dr.Purchase Accrual Account Cr. Return Before Invoice / Bill Created Purchase Accrual Account Dr.Inventory Account  CrBy this  both the account get cleared  and reconciled as well. if its Partial return Yes the balance remain  and  which can be cleared by Bill as its not retuned  As per the Functionality of Acumatica we need to create a AP Bill and a Debit adjustment for any return ?? though both PR and return has been Processed both Transaction remain uncleared in the accrual Account why this is required  and the logic behind this Functionality ?   

I have a PO that was setup with the wrong Vendor.  I received an invoice for the PO and created the PO Receipt before I realized that the Vendor was wrong. I did a Return of the PO Receipt (essentially nullifying the POR).  This Return actually created a second POR which reversed the first one, so all items on the PO are back to “un-receipted”. I want to correct the Vendor on the PO but since there is a link to to the “received” POR and the “returned” POR, the system won’t let me change the Vendor.  I get an error message saying - “You cannot change the vendor for this purchase order because it has purchased receipts linked.”Is there a way to remove the link to these two PORs to the PO?

Please kindly advise how can set up Tax type from VAT-to-VAT INPUT and GL Account Mapping has 2 Types to only Tax Claimable Account Requirement in System.Thanks for help and supporting. 

Is there an issue with copying fields over to an asset when converting from a purchase? The only information that gets pulled over is the receipt number which is not even going into the correct field. Do end users have to go into every single asset to manually enter the receipt type, PO number even if they create the asset through the Convert Purchases to Assets process?   Your input is greatly appreciated. Thank!

Does anyone have experience integrating Procore Pay with Acumatica?  I’m interested in hearing other people’s experience with the implementation.

Please kindly give me the sample to customize the Report P&L Actual VS Budget has add more Variance Amount. Thanks for your support and sharing