Community
Discussion Forums
Financials

Financials

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

2,082 Topics
6,979 Replies

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

2082 Topics

Recently active

Most replies Most views Newest first

dianegrayson

asked in Financials

FP&A Integrations: Jirav, Mosaic, Amacum, Vareto

Is anyone using any of these FP&A packages, and do you have integrations with Acumatica? Jirav, Mosaic, Amacum, Vareto

1 hour ago

yehchernchan93Freshman II

asked in Financials

Fixed Asset Approval

Hi,Is there a way for me to set us fixed asset approval flow in the system? Currently there is no approval in that I can assign approval map in Fixed Asset Preferences. If I would like to set up approval map in General Ledger for Fixed Asset Depreciation, is there a way to set up in the system? Or it can only be done through customization? Thank you. Regards,Chern

102

12 hours ago

rafaelcolonFreshman I

asked in Financials

How can I improve load time in Bills and Adjustments screen?

For some time now the bills and adjustments screen is taking a long time to load. It takes around 8 - 10 seconds. We have 31k records on there. What can we do to improve this load time?

294

1 day ago

DanaNicholsg2oFreshman I

asked in Financials

Budget update each quarter

We have 4 budgets each year. Original, F1, F2 and F3. For example, in April we create a F1 budget to enter actual results for Jan - Mar, and then adjust April - December for current forecasting. The problem is we have to open all the closed Financial Periods to get the revised budget amounts to import. Is there a work-around?

112

1 day ago

MComan62Freshman I

asked in Financials

Landed Cost Purchase Order

We are being tasked to create a Purchase Order for Landed Costs. The customer has to call in subcontractor to use a crane. They would like to able to track those costs to the items them are pulling off the truck and would like to make sure that the subcontractor is following the PO

1365

1 day ago

BarbaraPietersen23Jr Varsity II

asked in Financials

Update GL with FA batches

Hi CommunityI imported some assets with GL Update off, but now need to post these transaction to integrate with GL. Plus the asset is showing unreleased transactions and I can't calculate the depreciation.I can't see any transactions to release although they are displaying as unposted. Is there any way I can correct this please? Many thanks

1 day ago

jzhuJr Varsity III

asked in Financials

GL Error: Actual Ledger " must be defined in base currency USD only

Hello! Does anyone know what is causing this error while trying to release an invoice? The system only has one currency set up which is USD; all chart of accounts has USD listed as currency; the ACTUAL ledger also has USD listed as currency. Am I missing anywhere to check for this?

5112

1 day ago

BarbaraPietersen23Jr Varsity II

asked in Financials

Complex change in depreciation method

Good day CommunityMy client is looking to change the life if a Class if assets from 36 months to 60 months from the end of a financial year.The challenge is they want to depreciate to remainder of the (extended) life of the asset over the remaining time (60 months - age to year-end) but depreciation now calculated as (NBV at year-end / remining life) and NOT (Orig.Cost / remaining life), e.g.Orig. Cost 07-2023 100 000.00 NBV 12-2023 86 111.11 remaining months 55.00 New Month depr 1 565.66 (86111.11/55) Does anyone have any idea how I would set the deprecation for such a calculation please?Many thanks in advance.

202

1 day ago

jorgep17Freshman I

asked in Financials

Error creating a Subaccount

Hello,I am trying to add a sub account 15-0000 as the Main Branch in ANT3 and this is the error message I get. Where do we set up the branch of the subaccount to fix the error? Hoping the acumatica community can help?

182

2 days ago

lwang13Freshman II

asked in Financials

AR Aging Based on Invoice Date and Net 30 Term

Hi, I am building a report for my client. They want to see the AR aging based on invoice date, not due date. For example, the current column shows invoices created during the past 30 days; 1-31 Days column shows invoices created during the past 31-60 days. I copied the standard AR Aging report and edited formulas on it. I used Iif(CDec( DateDiff( 'd', [ARInvoice.DocDate], Today()) )<61 AND CDec( DateDiff( 'd', [ARInvoice.DocDate], Today()) )>30,iif([ARInvoice.DocType]='CRM',-1*[ARInvoice.DocBal],[ARInvoice.DocBal]),0). It works for details. However, when it comes to totals, I used =sum(Iif(CDec( DateDiff( 'd', [ARInvoice.DocDate], Today()) )<61 AND CDec( DateDiff( 'd', [ARInvoice.DocDate], Today()) )>30,iif([ARInvoice.DocType]='CRM',-1*[ARInvoice.DocBal],[ARInvoice.DocBal]),0)). This sum function only works for invoices don’t have credit memos/partial payments applied. When there is document applied to the invoice, the total doubled (for1 document applied invoice) or trippl

216

2 days ago

ketillerJr Varsity III

asked in Financials

Invoice & Memos - Send Email function - Not attaching report

Hello,We are currently using the Send email function and selecting a notification template to build out the email body and file attachment. The body and to/cc from the notification template are working correctly just not attaching the invoice.Notification template:Email activity: no file attachment Thank you,KT

AP Vendor data for D/B/A field

When setting up a 1099 Vendor where do I put the D/B/A info to correctly print on a 1099 form? Thanks!!

1675

6 days ago

sspencerJr Varsity III

asked in Financials

Connecting Velixo to Sales Demo Database

We have setup an AWS server per Acumatica’s Instructions, we have our sales Demo installed and working. Now we are trying to connect velixo to the salesdemo data and recieving this error. What changes do we need to make to get this working?See Attached picture.

224

6 days ago

cwilliams23Freshman I

asked in Financials

UPDATE ERROR to Purchasing Receipt Form

This is the screen prior to the October, 2024 update of our Purchasing Receipt form. The TOTAL COST - was included and we used it to verify the invoice amount. They have since removed it from the Sandbox - does anyone have a fix. There is no way to verify the amount of the entered invoice(receipt)- some our invoices have over 100 lines and not all the lines on the PO are included - backorders, etc... I understand why they might think that it was helpful to remove it - but for those of us who require it to balance the cost of goods it is a real problem. Any solution?

Security Settings for Printing Check Signature

Hello. We are struggling to get the embedded signature to work when printing checks. It appears to be set up correctly as the Admin users can print a check with the signature. However, the AP Clerk responsible for this is not able to print a check with the signature. It just prints the check, but not signature. I suspect there is a security setting I am overlooking somewhere. Any help is much appreciated!

6 days ago

iqraharrisonCaptain II

asked in Financials

Banks compatible with plaid

Hi!Does anyone know the easiest way to check if a bank is compatible with Plaid prior to setting up bank feeds? Thanks!

152

6 days ago

vineela95Freshman II

asked in Financials

AM Error: Document on hold and cannot be released

What does this AM Error mean? I am receiving it with trying to release receivables transactions in Acumatica.

608

6 days ago

AndrewAVarsity I

asked in Financials

Can the Accounts Payable report display by Financial Period?

Hi, For the AR Aging report, there is an option in the Statement Cycles screen shown below that allows this report to display by Financial Period. Is there a way for this same setup to be used for the AP Aging report? If not, is there another way this can be implemented in the system, or would it need to be done via a customisation. Kind regards,Andrew

401

6 days ago

william3Freshman I

asked in Financials

GL Account Reconciliation

One of the key financial differences between Acumatica, Netsuite and Intacct is that the latter of the two have account reconciliation modules. Of course, everybody has bank reconciliation which is one type of GL account that has to be reconciled, but many companies are required by banks or auditors to explain many other balance sheet accounts and this can be a real headache to members of the financial team. To help win over the finance department to Acumatica, we need to offer a competent reconciliation module to stay competitive.The essence of an account reconciliation module is that transactions that make up a balance sheet account at the end of a period are traceable to specific documents on the company side, and most importantly reconcile these against a statement or other documents from a third party. This could work in conjunction with the AP automation in that a PDF can be brought in and items on that PDF can be tied to the account balance. Some likely accounts are loans and no

New 1099 regulations for 2024

There are new regulations for determining 1099 filing, etc for 2024. I was wondering how Acumatica is working to accomodate these changes.

281

7 days ago

Doug JohnsonAcumatica VP, Product Management

published in Financials

AP Document Recognition

Benefits of AP Document RecognitionAP Document Recognition streamlines processing of vendor bills that you receive in PDF format. AP Clerks spend less time re-typing data so they can focus on higher value tasks. Worker productivity: spend less time entering documents Accuracy: reduce data entry errors which may result in incorrect vendor payments Approvals: integrate with existing approval and workflow processes AI/ML: extracted data accuracy (vendor ID field) improves after manual correctionWho can use AP Document Recognition?Prior to April 1, 2023 Acumatica offered a promotion for up to 1,000 pages/month for free. After the first year, customers could purchase the feature.Starting April 1, 2023 all new and existing Acumatica subscription customers (does not include perpetual licenses - PCP) get 50 free pages so they can try the feature. Customers who already paid for the service get an additional 50 free pages. A vendor bill with a front and a back counts towards 2 of your 50 monthly

195614

7 days ago

nhatnghetinhCaptain II

asked in Financials

Transfer Customer A's debt to Customer B's debt in Acumatica

Dear ALL,Is it possible to transfer Customer A's debt to Customer B's debt in Acumatica? Best Regards,NNT

283

7 days ago

nawanjanahansamali50Freshman II

asked in Financials

How restrict the editing access of invoices (SO303000) in open status

Hi, I need to restrict access of editing invoices in SO303000 form which were in open status. It means they were already released invoices. But still, users can edit the data in the line level in “details” tab.Thank you

1268

7 days ago

jdreselFreshman II

asked in Financials

Sales tax report setup questions

Hello,I am working on my first sales tax report and i can’t get the report the way I need it. We are on 2022R2 with fast track implementation.We are setup to have zones that pay multiple rates. Base MN 6.875 plus county of .25%. On the report the tax amount due is correct, but the taxable amount is doubled up and broke into multiple groups.. I need to report the taxable amount for each group. 8k to state @6.87% and 8k@.25% to the counties. and the state website calculates the tax amount due (which it should match) I have tried multiple settings and groups, but can’t get the settings quite right. Thanks,Jeremy

3806

8 days ago

aizzatFreshman I

asked in Financials

WHAT IS THE MAIN FUNCTION SELECTED BRANCH IN SUMMARY AREA ON DATA ENTRY - JOURNAL TRANSACTIONS

I realyl appreciate for any explanation in detail for this question. May i know what is the main function of the branch that we select on summary when doing data entry for Journal Transactions, where it will affect ? on the report part ? the rest i know like approval it may go the workgoup which assign to that branch, but for other purposes of selecting branch ? my concern was on reporting part. if anybody can explain in detail on other part also i appreciated very much.I mean as per below screenshot, Branch section .

222

8 days ago

Page 1 / 84

Badge winners

ramyaravichandran80has earned the badge Innovator
GavinWorsleyhas earned the badge Easy talker
Michaelhhas earned the badge Reports and Generic Inquires expert
asnell64has earned the badge Easy talker
andrewmhas earned the badge Manufacturing expert

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.