Financials

Hello all,Where can I find or how can I calculate the cash at the beginning of the period?Thanks.

In a perfect world where dreams come true, I envision my trial balance screen having arrows at the top where I could just click to advance or go back one period at a time. Does anyone know if something like this is possible? 

Is there an option to run the trial balance summary report for the entire year rather than one period? 

Currently, we have a cash flow statement that works for the current year. The client wanted to add a column for the previous year which is easy enough to create the second column within the Column Set with and offset of -1. However, in row set they have created, there are two lines that also has an offset value to -1 as they need balances from previous year for the current year Cash Flow statement. When I created the Column set with an offset of -1, it will get the data from last year, however, the two lines within the row set still retrieves last year but I need it to pull 2 years back. Is there a way to do this in ARM?  Basically, if the offset within the Column Set is set to -1, I would need for the offset value within the row set to be -2. 

We have created an extra Credit WO transaction and I am not having any luck zeroing it out.  I have tried to apply it to a debit memo without success, When I try to reverse it, I get a zero transaction and it remains on the statement.  What would be the best way to get rid of this?

I’m getting this message when trying to do our first VAT return. Anyone got any ideas as to where to look to correct this. I don’t seem to be able to prepare any VAT returns without this being configured. Thanks in advance a tax report cannot be prepared for the selected company and the tax agency because the report version for the tax period has not been found in the system

Is there a way to set a cost on an item being sold intercompany/branch based on a percentage, similar to the margin feature in Acumatica? I see where I can set a Sales Price or manage pricing based on costs. The problem is with intercompany sales; you start with a Sales Order in the Customer-facing branch, which pulls the item cost, which really is different from the intercompany cost. Take this example: Company2 sells a widget to customer1 The widget is added to the line, and the “cost” is pulled from the item at that time. The problem is we want to sell the widget from company 1 to company 2 at a 5% markup (for example). All of the features only work at the pricing level so the intercompany order might be able to add a correct price of cost +5% the original order does not reflect that costing rule and shows cost.(I hope that made sense) I am sure others do similar things. What do you do to manage this? 

We have set an approval map for the PO owner to be the approver for an AP invoice, but on some occasions we need to approve so require to set individuals with overriding capability.So far, we have not been able to set this up either with creating steps within the approval maps which seems to duplicate the AP invoice in the Invoices and Adjustments list, creating a workgroup in the company tree, or delegation under employees.This is the current approval map set for the PO owner:  

I would like to set up subaccounts for our business and have been testing it in our test tenant but I’m not seeing that these sub accounts show up on any financial reports like our P&L. Does this require a form customization or am I utilizing the wrong report?

Is there a way to view unposted Journal transactions in ARM reports? I tried searching the community forums but all the posts are 5 years or older so I am not sure if this feature was ever added. We would like to put expenses into the GL as unposted and see how it affects our finances overall in these reports so our team can make informed decisions.

Hi Folks, I am new to Acumatica and loving it so far.  I am going through the classes with my team and I didn’t see this exact topic in the community (my apologies if I missed it)!  Is it possible to apply a debit memo to an invoice to INCREASE the amount of the invoice? Thank you! Jason

We are currently using Acumatica Payments.  We have some charges that we are running directly on the gateway that we prefer to handle as a Cash Entry (as it will never connect to an AR document-it is a reimbursement to offset an expense). When using the Import Settlement Batch function, we have the option to “Hide” the missing transactions from the deposit.  My question is, will those “hidden” transactions need connected to something eventually?  Will they prevent us from closing a financial period or year end?  I do not believe they should as there is no GL impact but want to confirm before continuing to “hide” the missing transactions.  Additionally, once the deposit is released, will these hidden transactions move to “transactions excluded from deposit”?  

Does anyone know why the Bank Field Import date isn’t adjustable after you setup? For some reason our bank feed only pulls data as an example from 11/22/24. I like to do daily bank reconciliations but for some reason I can’t edit and pull in posted transactions from 11/23 to 11/25.For one other account, it can’t seem to get past 10/31/24 and I can’t edit.See below. 

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?