Skip to main content

Financials

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

  • 2,534 Topics
  • 8,301 Replies
2534 Topics
U
uvam33
asked in Financials
has any of you change the currency decimal places at a latter stage of the system?

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

1213
Kandy Beatty
Captain II
L
Freshman I
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?

1113
B
Freshman II
kristianharianja
Semi-Pro I
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.

1954
Laura02
Captain II
H
Freshman I
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.​​​​​​

3162
Laura02
Captain II
D
Varsity I
dsenevirathne54Varsity I
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  

7005
B
Freshman II
J
JMcKenzie
asked in Financials
Merge Duplicate Vendors

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

5482
Manikanta Dhulipudi
Captain II
H
Captain II
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.

3543
jyounes
Jr Varsity II
nithyashankar
Jr Varsity II
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.

802
nithyashankar
Jr Varsity II
T
Freshman II
trenton78Freshman II
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)

6417
T
Freshman II
kristianharianja
Semi-Pro I
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? 

4042
Kandy Beatty
Captain II
K
Freshman I
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,

1122
Kandy Beatty
Captain II
R
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?

3353
A
Freshman I
F
Freshman I
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 !

1731
Manikanta Dhulipudi
Captain II
S
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

3754
S
Freshman I
S
Jr Varsity III
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!

1001
Laura02
Captain II
A
Jr Varsity I
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? 

1702
A
Jr Varsity I
K
Freshman I
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!

3996
K
Freshman I
G
Jr Varsity III
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

640
G
Jr Varsity III
S
Freshman I
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.

9227
YasasWithanage76
Acumatica Employee
T
Freshman I
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 

934
T
Freshman I
H
Freshman I
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! 

3086
H
Freshman I
A
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

2611
R
Freshman I
J
Freshman II
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

2336
J
Freshman II
L
Jr Varsity II
lwang13Jr Varsity 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. :( 

4985
R
Pro II
R
Freshman II
RafaDiazBAIFreshman II
asked in Financials
Can you close a PO Receipt without doing the AP Bill?

If we have a Purchase Receipt for which we will never create an AP Bill. What can I do so the ENTER AP Bill button is not shown?  

2923
Robert Sternberg
Captain II

Badge winners

Show all badges
Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved