Financials

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

  • 1,461 Topics
  • 4,857 Replies

1461 Topics

K
Freshman I
KC2022Freshman I
asked in Financials

Disabling Control Account in Receivable Module

Hi All. Do you have any idea how to disable control account in Receivable Module? Our current version is 2020 R2. 

8
K
Freshman I
1 year ago
B
Freshman I
boremFreshman I
asked in Financials

Prevent Wrong nonsense Year being entered on Documents

Acumatica allows for nonsense years to be entered such as 2222 and 2044 on AP and AR documents. How can this be prevented? 

8
B
Freshman I
3 months ago
K
Jr Varsity III
ketillerJr Varsity III
asked in Financials

Time and Expense - Receipt errror

Hi, Some users are receiving the below error message when attempting to open up a new receipt in Acumatica, does anyone know what could be causing this issue?  

8
kandybeatty49
Captain II
8 months ago
D
Freshman II
DonGreenFreshman II
asked in Financials

Is there an Authorization.net Credit Card integration with Acumatica ?

Is there an Authorization.net Credit Card integration with Acumatica ? 

8
Omar Ghazi
Acumatica Moderator
7 months ago
J
Freshman I
jvinski71Freshman I
asked in Financials

AR Aging with retainage

I am looking for an AR Aging based upon financial period that would include the unreleased retainage in it as well. This should be pretty standard to have but the out of the box “AR Aging Period Sensitive Report” does not have retainage available in it. How can we get something or is there another report that I am missing.

8
BenjaminCrisman
Acumatica Employee
1 year ago
V
Jr Varsity III
vibindas
asked in Financials

GI navigation not working

Hi Team,For one of the GI’s in the Customer Portal we are having issues with the navigation. This is happening in the upgraded version of 2022 R1, the same GI navigation was working in the older version. When the row is clicked on the GI, it always redirects to the home page. 

8
iqraharrison48
Captain I
7 months ago
J
Freshman II
jddonnell55Freshman II
asked in Financials

Customer Import Scenario - BAccount

Using the out of the box Import Scenario for Customers.  The customer is displayed but when Import is selected, get the error:Here is the Import Scenario: The excel data file:Thanks. 

8
J
Freshman II
1 year ago
B
Freshman II
byates
asked in Financials

Changing Financial Periods

Hello all,Looking to see if it is possible to change future financial periods. Currently our Financial year runs from April - March and that is how the system is configured. One small change we would like to make is the financial year naming. ie currently in the system we are financial year 2022 with monthly periods running from 4/1/2022 - 3/31/2023. For these periods we would actually say this would be financial year 2023. we use FYE (financial year ending) 2023 for the year we are currently in, but acumatica is set up as year 2022. Understanding I likely can’t do much for current and past periods I was wanting to start the new fin year off correctly.So starting 4/1/2023 I would like to create a calendar that lists that year as 2024 with the periods running from 4/1/2023 - 3/31/2024. I believe this means in the system there would be no 2023 fin year as I have been told we cannot rename the current year/periods.  Hope that made sense, in the end we really just want to change the Year l

8
V
Acumatica Employee
8 months ago
J
Freshman II
jddonnell55Freshman II
asked in Financials

AP Check Form - Anyone already have a template with check in middle and remittances at top and bottom?

AP Check Form - Anyone already have a template with check in middle and remittances at top and bottom?Please see attachment sampleThanks.John

8
K
Freshman I
5 months ago
J
Freshman I
josephinecaFreshman I
asked in Financials

Purchase Order > Purchase Receipt > AP Bill

Hi Everyone, How to create a bill directly from PO not PO receipt?ExamplePO created - material + freight(non stock)PO receipt - only material When I create a bill, I can add the PO receipt details, so freight cost will not be added on the bill. If I manually add it in the bill, will there be a problem on the PO side? My boss doesn’t wanna add the freight cost in the PO receipt, since freight is not a material.  

8
kandybeatty49
Captain II
5 months ago
L
Freshman I
lmayse38Freshman I
asked in Financials

Journal Transaction by Period does not show beginning balances

I am uploading 2020 and 2021 Journal Transactions. Whereas, the 2020 entries were accurate, the 2021 entries do not appear to include opening balances. This is only happening on various Companies and GL Accounts.

8
meganfriesen37
Captain I
7 months ago
C
Freshman II
CCOMEAUFreshman II
asked in Financials

GL Error: Cannot insert the record. The record Customer (1981072ALB) has been marked as deleted. Your changes will be lost

Does anyone know what causes the error.  I am using the Change ID function in receivables and I get this GL Error when I go to save the chage.

8
kandybeatty49
Captain II
4 months ago
S
Freshman I
srengdahlFreshman I
asked in Financials

Trending financial report

How do I create the column set to have a column for each month and a total for the year?  I want to be able to select the year and then have the columns for each month.   

8
S
Freshman I
3 months ago
E
Freshman I
enriqueyFreshman I
asked in Financials

Accounts Receivable GL Mapping

How do I change the A/R revenue GL mapping? Some of our billings need to be posted to difference revenue accounts. I need the postings to be done at billing instead of reclasses.Thanks,

8
R
Varsity I
1 month ago
J
Freshman II
JonahFreshman II
asked in Financials

Balance sheet line contains data from another ledger

I am trying to understand how the Balance Sheet works on Acumatica so I can reproduce it in my integration project. From my understanding, Balance Sheets are generated based on a Ledger. However, it appears that the Inventories account in the Balance Sheet below contains data that has been posted to a different Ledger.This Balance Sheet was generated using the T100 demo data, using the ACTUALSOFT Ledger. Inventories amount of 440,480. In addition, I am not sure why this Balance Sheet does not balance. The Journal Transaction that I am confused about is shown below.As you can see, this journal was posted to the ACTUALCOMP Ledger, and not the ACTUALSOFT Ledger which I used to generate my Balance Sheet. However, it is still present in my Balance Sheet. You can see the calculation for the Inventories account below to see that it includes that transaction.419,000 + 21,480 = 440,480 -- the amount shown in the Balance Sheet Why is this transaction, that has been posted to a different ledger,

8
Laura02
Captain II
6 months ago
L
Captain I
ltussing03Captain I
asked in Financials

Sales profitability analysis reports - Documentation of calculations

Hello,I can find no documentation on the sales profitability reports calculations.Is there any documentation on what costs are included in the calculations?This is specifically being asked in a manufacturing environment.This is the specific request “I really need to understand is the sources of inputs to equal the cost field when then determining the customer margin value in the system. ” 

8
kandybeatty49
Captain II
8 months ago
A
Freshman I
ASamson21Freshman I
asked in Financials

Restrict Visibility of GL Account and Subaccount by Company/Branch

Hi All, How can I restrict a GL Account and Subaccount to specific company/branch?Any help will be highly appreciated. Thanks, Anne Samson

8
A
Freshman I
1 year ago
K
Freshman I
KBeckFreshman I
asked in Financials

Missing Transactions on Bank Rec

I can see transactions in my cash account and have the total I expect in the TB, but when I go to reconcile the same cash account I see transactions that I don’t see in the cash account detail and don’t see transactions that I do see in the cash account detail. When I run the reconciliation statement report, the transactions I’m missing show in the uncleared sections. But when I go to continue reconciling I can’t find them. Not a date issue, I’ve cleared all date filters and checked posting and cleared dates. I’ve trashed and restarted this recon a few times, thinking it might be a fluke. Same issue. We’re also on an older version of Acumatica, 2021 I think, with plans to update soon. Could that be causing this issue? 

8
K
Freshman I
9 days ago
J
Freshman I
jenniferyaholnitskyFreshman I
asked in Financials

Change Account Group Type

Is it possible to change the account group type? I set up an account group that was linked to all asset accounts, but the type was listed as expense, and now I am unable to change it to asset. Is there a way to adjust this?   

8
iqraharrison48
Captain I
4 months ago
M
Jr Varsity II
marilizevanzylJr Varsity II
asked in Financials

Over Application on Invoices

Hi Acumatica Community Hope everyone is well.I’m sitting with a few Customers where there is Open Receivables Invoices that have a Negative Balance. I need to know if someone dealt with this before and how you resolved it please:Kind RegardsMarilize van Zyl

8
Chris Hackett
Community Manager
30 days ago
T
Freshman I
trungrigshopFreshman I
asked in Financials

Denominated GL Account currency is different from transaction currency.

Hi, we are trying to release a bill and this error come up. For my understanding, it need a separate account to pay for US vendor ?How we can solve this one ?Thanks 

8
T
Freshman I
30 days ago
E
Jr Varsity II
erinJr Varsity II
posted in Financials

Stock item - Cost Stastic

HI SirWould like to check with you all about the cost statistics unde stock  item.My question :  is system auto generate the cost or we need to manual key in cost for the cost under Cost statistics ? 

7
Naveen Boga
Captain II
2 years ago
shmaryarichler
Freshman II
shmaryarichlerFreshman II
asked in Financials

GL Error

Hi, I am trying to Release an invoice but I get an error  that says GL Error Actual Ledger “ must be defined in base currency USD only. This is happening in our live environment but not in the sandbox (which was refreshed yesterday). This leads me to believe that a setting was changed somewhere inadvertently by a user.  Any help would be appreciated.TIA

7
M
Freshman I
1 year ago
gmercede
Varsity I
gmercedeVarsity I
asked in Financials

Bank Feeds

Where can I download the 2021 R1 compatible Bank Feeds Customization Package?

7
gmercede
Varsity I
1 year ago
E
Jr Varsity II
erinJr Varsity II
asked in Financials

Duplicate Dashboard

Hi Sir How do i duplicate a dasboard to another?

7
M
Jr Varsity I
9 months ago

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 — 2023  Acumatica, Inc. All rights reserved