Community
Discussion Forums
Financials

Financials

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

2,009 Topics
6,678 Replies

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

2009 Topics

Recently active

Most replies Most views Newest first

uvam33

asked in Financials

has any of you change the currency decimal places at a latter stage of the system?

1 year ago

linettesommererFreshman I

asked in Financials

DR Adj with Unreleased Retainage

Our construction company recently went through implementing Acumatica. I have Bills and Debit Adjustments that have been closed but still show on my AP Aging because there was retainage that was unreleased when the Debit Adjustment was applied to the bill. Is there any way to undo this?

1 year ago

kristianharianjaSemi-Pro I

asked in Financials

How to retain percentage format when exporting ARM report to Excel

Report: Exported to Excel: I currently use P as format in column set.

1 year ago

hauleFreshman I

asked in Financials

How to create a prepayment from Bill & adjustment with a project showed in AP Aging.

Hi all,We create a prepayment from Bill & adjustment with project. (Document A) at this time It Does not generate any transactions to GL and not on the aging after release.When we pay prepayment, we do in Check & payment with Check type and Apply the prepayment number A. We also update Project in financial tab, At this point the PP is on the Aging, and update transaction to GL.But when we run the aging report, it does not show the project.Does any one have any ideas, please share with meThanks in advanced.

1 year ago

dsenevirathne54Jr Varsity II

asked in Financials

ARM Reports - Unit set by sub account Segment

Hi,I’m working on a ARM report. The report shows the data expanded by sub accounts for some accounts. I need to add unit set to the report. the unit set should be triggered by a on segment of the sub account (the report should be filtered by the segment of sub account)Example - Sub Account 1 - ORG-DEP-000. in here, in the middle shows the expense category. there are multiple expense categories which is the second segment of the sub account. How can I create a Unit set to filter the report using that middle segment of the sub account. Thanks,Dulanjana

1 year ago

JMcKenzie

asked in Financials

Merge Duplicate Vendors

Is there a way to merge duplicate Vendor accounts that carry PO and PR transactions?

1 year ago

HarshitaCaptain II

asked in Financials

Company not getting displayed

I have created a new company- TESTCOMP on the Companies (CS101500) form and activated it. But its not getting displayed in the company selection menu. Kindly let me know if I am missing out here anything. Thank you.

1 year ago

nithyashankarJr Varsity II

asked in Financials

Low value assets concept in Acumatica

Hi Team, Do we have the concept of “Low value Assets” in Acumatica. Which means if an asset has minimal cost then it should be considered as low value assets and it should be depreciated within a year or less. Even though it has useful life more than a year. Any threshold limit is available for the assets are considered as a low value asset. Awaiting for your replies.

1 year ago

trenton78Freshman I

asked in Financials

Apply Customer Overpayments

I am having several issues when applying customer payments as they come in.One issue is where a customer might issue us a check for $50.00 more than the invoice was created/open for. I cannot apply the $50.00 overpayment as I get the error stating the payment must be less than the balance.Customer mistakes like this are extremely common. How can I receive the check in and keep my customer’s balance correct (I should show them a $50.00 “credit” for the overpayment when all is said and done)

1 year ago

kristianharianjaSemi-Pro I

asked in Financials

Change on Currency Decimal Precision

I understand that it’s suggested to not changing the decimal precision of a currency once transaction created and released. But, I just like to know what the problem exactly is. There are indeed transactions have been made on the currency (this is not base currency setup in the system) but most of them are having two decimal places on the amount, only one AR invoice has 3 dps. If this invoice is reversed and the decimal precision is changed from 4 to 2. What might be the impact?

1 year ago

Nancybielke83Freshman I

asked in Financials

Export Scenario ACH Unbalanced for Chase Bank Configuration

Does anyone have an export scenario to accommodate Chase Bank’s Nacha File Format? We are struggling, We are missing :Your Chase account is missing from the file.Find the company identification field and enter 0000000000 (10 zeroes).The company identification (shown in the batch control record) doesn't match the batch header record. We are close but need to be able to export on Monday.

1 year ago

kemeryFreshman I

asked in Financials

Deferral Schedule

I have a prospect that receives payments for a scheduled training session i.e. month-1- payment is received however training can be scheduled to take place in month-3- but very often training classes are not yet full so they push training out again say to month-4-. How flexible is our deferral codes or deferral schedules in these instances? I.e., if a scheduled month or two months are missing and do not get ‘run’ or posted, what happens? Can they just skip months as necessary, then run the applicable month and update the schedule somehow? Thanks,

1 year ago

Ram

asked in Financials

How to reconcile or Apply different Vendor and Customer Invoices?

Hi Guys, can you give me an idea how to apply an Customer AR Invoice to another Customer Payment document? although both customer does not have parent child relationship.or how include Vendor/Customer ID in Journal entry document?

1 year ago

Fie

asked in Financials

PDF File Naming Convention

Hi Everyone,Is there a way to set a naming convention for a pdf file upon exporting? Thanks !

1 year ago

SharonConkey00

posted in Financials

How To Export Acumatica Financial Report Data into Separate Tabs in Microsoft Excel

When generating financial reports, users have long requested the option to export consolidated reports and unit sets to separate tabs in Microsoft Excel. Instead, Acumatica publishes financial report data to a single Excel tab requiring significant manual copy and paste work to create the desired report. It is possible to make changes to the report and use the power of Excel macros to accomplish splitting the report into multiple sheets. For details on how, see the following article:Solved! Exporting Acumatica Financial Reports Data to Multiple Excel Tabs - Dynamic Tech Services

1 year ago

shuang57Jr Varsity III

asked in Financials

Is it possible to generate carry forward transactions automatically?

Hi guys, in some countries (e.g. Germany) the accounting regulation requires corporates to carry forward the balances of the general ledger to the new fiscal year. It’s basically like a reversing entry, to take every account balance out from the last year’s ledger and record the exact balances into this year’s ledger. Is it possible to do this in Acumatica automatically? Thanks!

1 year ago

abeckerman65Jr Varsity I

asked in Financials

push a change of default to existing profiles

If I change the default cash account for AP on the Payment Method and Vendor Class level, is there a way to push that change to all existing vendors?

1 year ago

kstockmanFreshman I

asked in Financials

AP Check Register

I’m trying to generate a report to submit to the bank for positive pay. The check register has everything I need except it only shows 10 characters of the Vendor Name. Is it possible to show all of the characters? Thank you!

1 year ago

gpineda64Jr Varsity III

asked in Financials

Unable to Link Project Invoice to AP Bill after upgrade to 22R1

Prior to 22R1, we were able to display AP Bill Line data linked to a Project Invoice.The joins to get from ARTRan to APTran are:ARTran Left Join PMTran on RefNbr = ARRefNbr AND TranType = ARTranType LineNbr = RefLineNbr PMTran Left Join GLTran on BatchNbr = BatchNbr OrigLineNbr = LineNbr 'AP' = Module GLTran Left Join APTran on RefNbr = RefNbr TranLineNbr = LineNbr Module = 'AP' TranType = TranType Acumatica used to populate both he orig doc number and the line when posting the GLTran row, but they stopped doing that in 22R1.The Tran Line number is NULL now.Our clients need to see the AP Bill details related to the Invoice.Is there another path to join ARTran to APTran with project invoices?Thanks

1 year ago

saheed ridwan domain plusltd cFreshman I

asked in Financials

Fixed Asset

Hello All,Trust you are fine.I was about running disposal of fixed asset and it complains of UNRECONCILED ASSET CAN NOT BE DISPOSED. However, The depreciation has been calculated up to the month of disposal Please, any help on how to reconcile under the reconciliation tab and what is meant by that. Thanks in anticipation of swift response from the community.

1 year ago

tswartFreshman I

asked in Financials

Profit and loss - Expenses sorting high to low

Good day I am seeking assistance on how to sort my expense items on the Profit and loss report high to low. This needs to sort automatically each time the report is generated. Is this at all possible? Help will be appriciated. Regards

1 year ago

hauleFreshman I

asked in Financials

How to apply different Customer or Vendor

Hi allDoes anyone know how to apply an Customer AR Invoice to another Customer Payment document? or vendor bill to vendor prepayment document.Thanks so much!

1 year ago

afookes

asked in Financials

Balance Sheet accounts closing balances By Month in General Inquiry report

I’ve been trying to create a GI report listing all the Balance Sheet account code closing balances at each month end across multiple years. The aim is to export that via API to Power BI in a kind of clean CSV state i.e. no grouping, just rows and columns.So I want one row for each account code and each month end date. My first attempt generated 3,600 rows so it’s not that large a set of data.My attempt is 95% right but it’s missing key values and on reflection I think I’m using the wrong set of tables (or in the wrong way) but the documentation isn’t good enough to work that out.The reason it is wrong is when I compare the output to the Balance Sheet Financial Statement report I get some differences, but I can’t see why they are different. I have realised that the report doesn’t give me balances at a month end if there are no transactions in the month. I can fix this through a Power Query custom function but sadly I am still getting some errors. My model is as follows:tables: GL.Accoun

1 year ago

juneterris87Freshman II

asked in Financials

Nominal Trial Balance GI with subccounts

Trying to get a GI that shows the requested period trial balance with subaccounts. Managed to devise one but it only shows the nominal account/subaccount if there has been movement in the selected period. Has anyone managed to create one successfully that could share the details

1 year ago

lwang13Freshman II

asked in Financials

Create A Filter for Current Month

Hi guys, I have a GI listed ending balance for current assets and current liabilities accounts by period. To create a dashboard KPI weights based on this GI, I need to create a filter for current month. Is there a way to define that “FinPeriodID = Current Period” ? Or is there a way to convert FinPeriodID to Month or Date? Because I know I can do a formula on filter for Month and Date, but not Period. :(

1 year ago

Page 56 / 81

Badge winners

tarashas earned the badge Easy talker
hkabirihas earned the badge Import and Export Scenario expert
aiwanhas earned the badge Acumatica expert
rfrantzhas earned the badge Easy talker
WillHhas earned the badge Easy talker

Show all badges

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Social Login

Login to the community

Social Login

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.