Community
Discussion Forums
Financials

Financials

General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Deferred Revenue, Taxes, Currency Management

2,064 Topics
6,914 Replies

When you subscribe we will email you when there is a new topic in this category

2064 Topics

Recently active

Most replies Most views Newest first

Laura02Captain II

asked in Financials

Mixed Years in Balance Sheet Drill-down to GL Details report

We are running version 2021 R2 in a multi-company, multi-branch environment. The quarterly Balance Sheet shown below has been printed for periods 01-2022 through 12-2022 for one company, “Company C”. There is no unit set, just Row and Column sets.When I click on Total Intercompany receivables as shown, the resulting GL Details report has multiple years included. The total is correct, but the presentation is confusing to the users. Why does the drill-down show records from the previous year? Thank you.

1 year ago

ashleybVarsity I

asked in Financials

AR Aged Period Sensitive by AR Account

Hello - Does anyone have an AR Aged Period Sensitive report that subtotals by AR Account?? We are looking for this to easily tie back to our TB.

1 year ago

DonGreenFreshman II

posted in Financials

Multi EIN Company - Divisionalized under one Instance ? - or Multi Instance Multi Company ?

We JUST started implementing Acumatica and have 3 similar companies operating under separate EIN requiring separate P&L, Tax returns, etc.Interested to know if ANY options exist other than separate Tennants/Companies and if there is a viable solution to have a single Tennant/Company with separate divisions.Any suggestions are greatly appreciated.

1 year ago

StaceyReitz23

posted in Financials

Webinar: Essential Sales, Marketing, and Support Solution for Increasing Revenue and Customer Satisfaction ( October 5, 2022 at 11AM PT)

Essential Sales, Marketing, and Support Solution for Increasing Revenue and Customer Satisfaction When: October 5, 2022 at 11AM PT Attend this webinar to:Gain an understanding of the unique power of CRM software. See how a CRM workflow maximizes leads, opportunities, and case management. Get an inside look at how Acumatica’s CRM solution performs.Register now to imagine what your business’s life could be like with integrated workflows that automate processes, keep key tasks moving, and share KPIs in real time. https://event.on24.com/wcc/r/3942368/B6BF10D69C6C8489EEB954200E8C1B8F

1 year ago

nithyashankarJr Varsity II

asked in Financials

AP Document Recognition

Hi Team,Currently, I am testing AP Document Recognition. I need some clarifications regarding the PO invoice. Once the PO and Receipt are posted in the system. By using the Incoming Documents, I am pushing the invoice to the system. Here, my query is related to the inventory price update during the process. Awaiting for your replies.

1 year ago

myoungFreshman I

asked in Financials

Deleting a released expense claim

I realize expense claims cannot be deleted once released so how do I get rid of the claim that was put in incorrectly but not caught before claim was released. Tried making a negative receipt but that doesn’t work.

1 year ago

JerryMonahanFreshman I

asked in Financials

Can you add % of Sales column to a P&L financial statement?

I’m trying to add a column to my customer’s P&L that will show the % of Sales for each row on the report (e.g., Sales = 100.0%, COGS = 36.2%, etc.). I can add calculations between columns (e.g., (F-E)/E), but not within the same column. Is this possible with the standard financial reports?

1 year ago

jessicaASAVarsity I

asked in Financials

How do we add Entry Types to the Receivable Payment screen?

Is there a trick to getting entry types to show up on the Receivable Payments screen, Charges tab? We are considering using that to record wire fees.On the Entry Types screen, I checked the Deduct from Payment box, but the entry type does not show as an option on the Payments screen. Is there another step I should take? We are on 2022 R1. Thank you.

1 year ago

byates

asked in Financials

How are you using Charges on AR Payments

Curious how anyone is using the Charges tab on the AR Payments & Applications? I am wondering if these can be used in claim management when processing AR payments in lieu of creating Credit memos for all the deduction claims on a AR remittance. So I wanted to get thoughts. I can’t seem to test as charges on my end are just blank with nothing to select under entry type so I am not even sure where to configure.

1 year ago

alicia23Jr Varsity III

asked in Financials

Cash Basis P&L

Trying to create cash basis P&L in Acumatica. Has any one been able to do this without using a 3rd party add on?

1 year ago

louisagooding69Acumatica Sr Business Development Manager

posted in Financials

Solver's CPM VAR Training

Please join Solver on March 1st at 1:00 PM EST to learn about https://www.acumatica.com/acumatica-marketplace/solver-corporate-performance-management/ and how your customers can benefit from this Fulfilled by Acumatica solution. Here is the link to the event:https://events.teams.microsoft.com/event/8e360595-5afe-44f6-9ebc-8d47c9e50ce2@0cc9806c-44f8-445b-87c9-709c71ad38b0

1 year ago

angelakarcher78

asked in Financials

Transactions for Period Timing out

I’m needing a detailed general ledger for all accounts and all transactions for an entire year to present to our auditors. The transactions for period report keeps timing out. The best I can do is run the report by quarter. Any suggestions?

1 year ago

tswartFreshman I

asked in Financials

AP Bill Recognition with Purchase Orders for South Africa

Good day Could someone please indicate if this type of product is available in South Africa. We queried this from our seller and he they indicated the following: “We are waiting minor changes for the AI engine to work as we have experienced a challenge with the process in S.A. due to the date format S.A. use compared to US. US work on month day year and SA work on day month year. This is causing error for SA currently. We are monitoring the update to the AI engine frequently as we have other clients also interested in this functionality. This module is currently only available in US and Canada.” I am no developer, but this does not seem to me as a problem because I am able to edit the date format on Acumatica. So why can't the AI also take this into account. We could really use a product like this to cut our AP Billing time as we do a lot of transactions and is wasting time if it can be done quicker and more efficient. Are there any South African companies that may be using something s

1 year ago

Fie

asked in Financials

Name Format of Log in User

Hi Acumatica,May we ask your assistance if there is a settings on how the First name and Lastname will reflect in Acumatica. The client wanted to set as Lastname, Firstname Middle Initial. Is this possible? Thank you!

1 year ago

sweta68Semi-Pro III

asked in Financials

Error on displaying Payment hosted form on Custom Action

Acumatica Version Build Number: 21.220.0010 We have a requirement to display a payment hosted form to enter credit card details on custom action.We have tried to extend graph and replace piece of code of CreateCCPaymentMethodHF action from PaymentProfileGraph.cs.Action is getting displayed on screen but not able to get hosted form on screen as facing issue while calling HTTP request. As per Error, We have added HTTP NuGet package but it does not worked.We would need your assistance in displaying Hosted form on custom action to enter Card details.

1 year ago

saiful murad

asked in Financials

2020R2 AP Automation - Incoming Documents screen

Hi,Eagerly downloaded the SalesDemo snapshot for 2020R2 and searched high and low for the Incoming Documents screen, which was demo-ed by Doug in the launch. Found it in Site Map (AP.30.11.00) but its not appearing in the default Payables Workspace.Are there any additional settings or configurations for it to appear and immediately use?

1 year ago

jsparks62Freshman I

asked in Financials

dashboard - year over year sales

I am trying to create a GI to show this years sales data compared to LY sales. Any ideas how to get started with this? I have pulled the data since @yearstart and for where docdate >= @yearstart-1 and docdate<= @yearstart-1. How can I show those on the same line graph?

1 year ago

ashleybVarsity I

asked in Financials

Period Parameters on P&L

Hello! Does anyone know if there is a way to change the default Start Financial Period on the P&L Financial Statement to always default to 1 month prior to current month? I have looked at the Default Data Source Settings and could not find a way:

1 year ago

ashleybVarsity I

asked in Financials

How to run Transactions for Period by Company Group

Hello - Does anyone know how I can get the Transactions for Period report to run by a Company Group? I can run the TB reports by Group but for some reason not the Transactions reports.. I have a feeling it has something to do with the Org fields but I am not sure how to correct.Transactions for Period:Trial Balance Detailed:

1 year ago

jbuddecke71Jr Varsity III

asked in Financials

Inter-Tenant Consolidations

I would like to create a consolidated P&L for two tenants, but exclude sales between tenants. More specifically, tenant A sells to tenant B, but that revenue shouldn’t be considered. Can the row set exclude revenue for a specific customer?Any suggestions are appreciated.

1 year ago

TechtehtechFreshman I

asked in Financials

Combining Vendor Payments

I pay vendors by Job, I go to ‘Prepare Payments’, select the job and pay vendors from there, then I ‘Process’ once to compile them in the ‘Process Payments/Print Cheques screen. So I do this for multiple jobs. I do this so I only have to print cheques once, instead of going to the printer 5+ times. But what this causes is, if I pay the same vendor in multiple jobs, it puts those cheques separately and does not combine them. So if I Pay that vendor over 2+ jobs, that vendor gets 2+ cheques. Is there a way to combine those into one cheque from that screen, or is there another way I can achieve the same outcome but where the cheques are combined?

1 year ago

jwarrenVarsity II

asked in Financials

Bank reconciliation with multiple cash accounts and one bank account

We have two companies in Acumatica, but both use the same bank account. We have created two cash accounts (one representing each company) in Acumatica, both using the same GL account but different branches/companies. Are we still able to use the bank reconciliation feature?I would expect both bank recs to have a large difference but should net each other out (in a perfect world) once fully reconciled - However seems like the reconciling task will get confusing/complicated as you are not sure whether a transaction is truly missing (& requiring a payment/invoice) or whether it was posted to other company. Does anyone run bank recs in a similar situation? Does it work for you?Or should we go down the path of opening a separate bank account for each company account?

1 year ago

enriqueyFreshman I

asked in Financials

Event - Project tracking & Statements

Hi all,I am trying to figure best way to handle the following:I work for a non-profit organization where they have fundraisers and miscellaneous events a year. I want to keep track of all activities (Revenue and Expense) for each event. My company did not purchase the project management package and do not have it in our budget.How can I keep track and analyze all the activities for each event? I would like to run statements for each event.Many Thanks,

1 year ago

allyFreshman II

posted in Financials

Working ACH Export Scenario for multiple vendors with multiple invoices

Thanks to @matthewbeebe for the nudge in the right direction of object was being used. I eventually found it myself but they saved me a lot of time.These were the two key parts of the Export Scenario for payments with Addenda including the Vendor Reference Number. All of the information about the entities used in ACH Payments is in PX.Objects.dll file and using dotPeek I was able to see how they were being built and from there go to PX.Objects.AP to figure out the field to use. To get the Vendor Reference Number, I used Matthew’s suggestion of APPaymentApplications.InvoiceNbr and that eventually led to finding how to get the Payment applied to the Invoice which is APPaymentApplications.CuryOrigDocAmt whereas the default Export Scenario has APPaymentList.CuryOrigDocAmt which makes the same total amount repeat for each invoice which is not what we want.I’ve spent months working with multiple Acumatica Partners and people at our bank trying to get this to work. I do want to note that ther

1 year ago

Andrew1986Freshman I

asked in Financials

"exceptionMessage": "Error in action invocation

Hi Team,When I sent a payment via API to Acumatica, I receive the error message: "exceptionMessage": "Error in action invocation:\nAR Error: Application Date cannot be less than Document Date."This error does not always occur. Could you clarify how to fix it? I attached the example of the request.

1 year ago

Page 55 / 83

Badge winners

chameera71has earned the badge Distribution expert
michelle76has earned the badge Easy talker
DavidEichnerhas earned the badge CRM expert
wanizaidi27has earned the badge Easy talker
stephenbologna39has earned the badge Integrations and Web Services | APIs expert