Skip to main content

Financials

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

  • 2,392 Topics
  • 7,917 Replies
2392 Topics
K
Freshman I
klenigFreshman I
asked in Financials
Cash Purchase 1099 Box

We have some vendors that were incorrectly marked as 1099.  I can update the bills to remove the data in the 1099 Box column, however I can’t do this on a cash purchase.  How can we clear the box on the cash purchase so a 1099 doesn’t generate? 

393
K
Freshman I
P
parita
asked in Financials
No Placed-In Servica Date

If we have purchased the asset, but will be put to use (placed-in service) in some future date, then how can we record it it Acumatica FA module? As Placed-in service date is a mandatory requirement in Acumatica.

291
Laura02
Captain II
S
Jr Varsity II
stoner7mattJr Varsity II
asked in Financials
Process Bank Transactions - Expense Receipt not showing up

We are using Expense Management, we are not using the bank feed to create receipts. When I attempt to match the bank feed to receipts that have already been submitted, they do not appear. I can see the transaction in the bank feed, i can see the transaction in Expense Management, how do I get all available expense receipts to populate so I can match them?

988
M
Acumatica Employee
D
Jr Varsity III
DawoodJr Varsity III
asked in Financials
Adding Entry Type to a Payment Processing Center

Hello,Does anyone know how to add an entry type for a fee to an existing payment processing center? We have created several entry types, and unfortunately none of them are showing up in the list.  Here is one of the Entry Types 

553
M
Acumatica Employee
D
Jr Varsity III
DawoodJr Varsity III
asked in Financials
Generating Trade Reference Report

Hello,Is there any report form in Acumatica to generate trade references for customers? We are new to Acumatica, and our old ERP had a prebuilt report for trade references. 

223
Manikanta Dhulipudi
Captain II
G
Freshman I
gracefFreshman I
asked in Financials
Sales Tax Report release

Hello, Would like to know how to handle these issues. #1 I Prepared a November sales tax and release too early. how can i reverse? or do i need to…#2 October was not showing up to release yet. So i have Transactions for November but no transactions for October…

220
G
Freshman I
cmoreland
Semi-Pro III
cmorelandSemi-Pro III
asked in Financials
Updating Posting class on a part with open sales lines

I want to update the Posting class on about 3000 parts. Many have open Sales Orders. When completing these orders i want them to post to the new accounts. Do I need to recreate those lines? or will it roll up at the time of invoicing? 

343
cmoreland
Semi-Pro III
B
Freshman I
bbonduraFreshman I
asked in Financials
Commission Views between Sales People.

Hello all! I'm looking to limit viewing of commissions between our sales people. For example, I don't want john seeing Jodi's commissions and vice versa. However, I want them to see their own commissions. This is mainly on Sales Orders. Has anyone encountered this and how was it remedied? ThanksBrent

402
B
Freshman I
M
Freshman I
MuhammadAzeem04Freshman I
asked in Financials
Customer Credit Hold

We are facing a scenario where a user needs to process a credit note while the customer's status is on Credit Hold. With EDI integration and automated warehouse processes in place, it is not feasible for the user to temporarily remove the customer from Credit Hold, process the credit note, and then place the customer back on hold.Are there any workaround for this situation?

480
M
Freshman I
Varsity I
vib1980
asked in Financials
Bank feeds - Import transactions from a currency different to Base Currency

Hi Team,Any thoughts on how Acumatica handles the scenario for Importing transactions for Bank Feeds when the transaction currency is different from Cash Account currency.   

231
S
Acumatica Employee
N
Freshman I
NaveedFreshman I
asked in Financials
Assistance Required for Acumatica Batch Number Sequence Issue

 Hello,We are experiencing an issue in Acumatica (Batch Number Sequence), and I’ve attached a screenshot for reference. Can you please help us address this?  

15421
Chris Hackett
Community Manager
B
Freshman I
brutherford
asked in Financials
Cash Account Reconciliation Issue

Hi,We have a cash account that needs to be reconciled. It has been sitting on hold since 1/31. When clicking on it in Reconciliation Statements it times out and won’t load the transactions. I checked theCAReconEntry.CATranExt table and there are over 7400 unreconciled transactions. Is there a max number it can reconcile?Also, there is a clearing account tied to the cash account. Could this be causing an issue? The clearing account does not have reconciliation required checked but the cash account does. Only one of the two charges methods in the clearing account are listed in the cash account also. Could this be causing the issue?Last question, the periods are closed since the last reconciliation date was 1/31. Do we need to reopen the periods in AR to get these reconciled? Could this be the issue? Thanks so much! Your wisdom is appreciated!  

1072
B
Freshman I
S
Freshman I
sbhattaraiFreshman I
asked in Financials
Month-End Closing Process/Checklist - Acumatica

I am currently looking to streamline our month-end closing process in Acumatica (Manufacturing Module) and was wondering if anyone could share their best practices or a checklist, they use to ensure a smooth and efficient closing process.Key steps/checkpoints for month-end close.Any modules or features in Acumatica that you find particularly helpful.Recommendations for reports or reconciliations to run during the process.Common challenges and how you address them.If you have a checklist or process flow that you can share, I would greatly appreciate it.

1673
M
Acumatica Employee
P
Jr Varsity II
PatrickBaconJr Varsity II
asked in Financials
How Many Sub Account Segments (business unit, department, line of business, customer vertical) is Practical?

 Our accounting staff want to slice and dice our financial reports by:     -department    -customer type (customer, reseller)    -line of business      -customer vertical     -business unit (sales staff are associated with one of a number of business units)We have set-up a sandbox environment which has two segment subaccount (business unit and line of business), but our account staff have articulated adding sub accounts (or whatever feature) will allow us to slice and dice financial reports by the above areas.From a “leveraging the defaults” (e.g. default posting group), we were able to set-up our sandbox so that our transactions would default for the right line of business and business unit when we had two segments.If we go to four segments, I suspect we might not be able to really leverage our set-ups to really achieve the financial slicing and dicing as required. Have you set-up more than 2 segments and how did your default posting code set-up work for you (were you able to acheive

1053
Laura02
Captain II
M
Freshman II
mdyerFreshman II
asked in Financials
Ability to change the order of Financial Statements to alphabetical order?

Hello - Under the Finance Module, we have Financial Statements with all of our properties Profit & Loss statements and Balance Sheets. Now, whenever I create a new one, it just adds it to the end of the list on the main finance module screen, instead of sorting in alphabetical order. Is there a way that I can change the order of the list?Thanks! Any new statement I create gets added to the end of this list, and I would like the ability to dictate where it gets added to the list. ​​​​​​

1033
jyounes
Jr Varsity II
C
Freshman II
cecileclep09Freshman II
asked in Financials
Customer Invoice - translation with local set in customer screen

Hello,   Two languages are set and active in my Acumatica instance : English and French.I currently log with french localization.Several of our customers need to receive their invoice in english version.I thought that set the local field on the customer screen would provide the correct the result but no : The printed invoice is always displayed in french version.The only way I found to get the english version is that : The user who clic to print/ send the invoice is logged with english on the logging page The user set “En-US” of parameters besore executing the repport .Is there any other way to send to english customer, english version of their invoice ? 

332
C
Freshman II
N
Semi-Pro II
NetAdmin42Semi-Pro II
asked in Financials
Does latest version have multiple GL CoA support?

In the latest version of Acumatica does it allow for me to have multiple companies in the same tenant, each with separate GL Chart Of Accounts?For example, if I have one tenant but two companies, can each of them have their own separate GL and Chart of Accounts.  Or do they have to share the GL Chart of Accounts?Thank you,Netadmin

746
P
Jr Varsity II
J
Jr Varsity II
jvarughese23Jr Varsity II
asked in Financials
Issue with Email Processing: Only One Email Attachment Getting Downloaded into Acumatica

When scanning 3 different documents, the scanner sends each document as a separate email with its own attachment. However, only one of the emails and its attachment gets downloaded into Acumatica. The other two emails remain on the email server and are still visible in Outlook.Could you help identify why Acumatica is not processing all the emails and attachments? Are there specific email processing or configuration settings I should check to resolve this issue?

140
J
Jr Varsity II
S
Jr Varsity III
suemackeown13Jr Varsity III
asked in Financials
How to link company to company groups in a Generic Inquiry

I am running a GI which shows all GL Transactions from a particular ledger. These branches belong to one of three company groups. I need to be able to show the company group for each branch on the line on the GI.Is there a way in which one can link the branch to the organisation company groups? Many of the ‘related’ tables are hidden.Any suggestion would be appreciated. Thank you.

422
S
Jr Varsity III
G
Freshman I
GordonMicallef71Freshman I
asked in Financials
Credit Hold and project management

Is there a way to block project insert when a customer is on credit hold status?

1858
C
Freshman II
R
Freshman I
RHarrisonFreshman I
asked in Financials
apply debit adjustment to bill in pending approval status

Can a debit adjustment not be applied to a bill before it is approved?  This seems backwards for the approval process.  I’m asking a reviewer to approve a bill that they know is wrong because a debit adjustment has been issued.  They have to approve the bill and HOPE that I correctly receive, process, and apply the debit adjustment.  It seems like the reviewer should see the bill with the applied DA.Do I have something set up incorrectly or am I missing something in my thought process?Thanks.

934
Laura02
Captain II
L
Jr Varsity II
lorachJr Varsity II
asked in Financials
Account Details Not Matching Historical the Inventory Valuation Report

Hi Everyone,We are comparing data from the Account Details and the Historical Inventory Valuation Report for specific accounts, but the figures never match. In this case, the Historical Inventory Valuation Report showed a zero ending balance for the account, while the Account Details reflected a balance of 47,069.30 for the same period. Does anyone know the cause of this discrepancy and how to resolve it? 

502
L
Jr Varsity II
cwilliams23
Freshman I
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?

737
K
Freshman I
H
Freshman I
hjosephdcmFreshman I
asked in Financials
Intercompany AR/AP

We have one tenant, 3 companies and 4 branches. Is there a way to create a AR invoice in one branch and have the system automatically create the AP bill in the other? Due to tax and legal constraints we cannot use due to/from general ledger accounts. 

3454
A
Jr Varsity II
A
Jr Varsity II
apallawala21Jr Varsity II
asked in Financials
Automate Generate Intercompany Documents screen

Hello!We create intercompany documents using “Generate Intercompany Documents” screen and require to automatically process the documents without user processing them manually. I’ve tried creating Automation Schedule, but it does not process any transaction. Amanda

433
A
Jr Varsity 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