Skip to main content

Financials

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

  • 2,497 Topics
  • 8,160 Replies
2497 Topics
W
Freshman II
williamq178Freshman II
asked in Financials
Workflow issues

We have an Issue with a workflow, when the payment gets posted is supposed to change the status to closed, but it stays as open. Has anyone had this issue before? Or those anyone knows where to check to get this corrected? Thanks! 

767
J
Freshman II
rcreasy
Varsity I
rcreasyVarsity I
asked in Financials
Prevent Invoices from Being Emailed

I need to prevent some sales invoices from being emailed. I have tried clicked the “Don’t email” checkbox on the Financial tab. But, this action seems to have no effect.Is there a configuration that needs to be set? Or, is the checkbox just informational for users?If it makes a difference - I plan to check this checkbox via the API.

14511
dcomerford
Captain II
A
Varsity I
ashleybVarsity I
asked in Financials
AP Aging as of a certain date

Hello - Does anyone have an AP Aging that you can backdate and it produces all open invoices as of that day? Our AP Aging currently ages all invoices as of the aged date, but reflects all payments as of the current day. 

892
Chris Hackett
Community Manager
F
Freshman I
Fie
asked in Financials
Project Accounting - Committed Cost

Hi Team,On the current behavior of Acumatica, The only transaction that can track the committed cost are based only in Purchase Order and Subcontract.Is there a way to consider either the Expense Receipt or Expense Claim as included in the Committed Cost in the Project Screen? It seem on the expense receipts, we already tag the project id and project task?Thank you! 

1091
Laura02
Captain II
L
Freshman I
lori00Freshman I
asked in Financials
Recalculate customer balance is changing status of closed invoices

When running the recalculate customer balance.  We have noticed that it is changing the status of closed invoices to reserved.  Is there a reason why this is happening?

723
L
Freshman I
F
Freshman I
Fie
asked in Financials
Mass Deletion of Account in Chart of Accounts Profiles

Hi Team,I just want to confirm if there is a way for mass deletion of Account in Chart of Account Screen?I tried to map this in Import Scenario but there is no action for delete.Please let me know if you have other recommendation.Thank you!

1932
F
Freshman I
H
Captain II
HarshitaCaptain II
asked in Financials
Recording Opening & Closing Balances

Hello Community,I wanted to clarify if we can record the opening balance for a particular year manually by creating a GL transaction instead of importing them (in case if someone doesn’t have the previous records to be imported). If yes, then what would be GL entry. Also the same scenario for a closing balance.Thanks in advance.

2231
Laura02
Captain II
H
Captain II
HarshitaCaptain II
asked in Financials
PnL Balances displaying Incorrectly

Hello All,I have been trying to create a PnL sheet where the starting year is 05-2022 and ending as of 04-2023. Have been trying to setup the values under Column Sets but it only displays the values for 05-2022.If I select any of these values in the hyperlink it displays the values only for the period of 05-2022 instead of 04-2023.     Kindly guide me out as to what I am missing here?

401
Laura02
Captain II
K
Freshman I
kstockmanFreshman I
asked in Financials
Expense Reciepts on Corporate Card Posting to GL

Questions regarding using Expense Receipts & Bank Feeds for Credit CardsDo expenses receipts have to be claimed in order for those expenses to hit the GL? It seems like if the Expense receipt is matched in the bank transactions prior to it being claimed then the system doesn’t allow for this expense to be claimed and then it never hits the GL.  Is this correct?If someone can give proper steps when working with expense reciepts on a corporate card, that would be helpful.   Thank you!

1001
Kandy Beatty
Captain II
V
Freshman I
venukakaushalya43Freshman I
asked in Financials
How to create bills and adjustment entry for VAT and Withholding tax

Hi all,Can anyone help me to create multiple taxes such and withholding and vat tax into single Bills and adjustment form. please RegardsVenuka 

2947
V
Freshman I
M
Freshman II
mdyerFreshman II
asked in Financials
"Require Receipt" Check Box - Non-Stock Items

Hello - Someone on my team is attempting to cancel two lines in a Purchase Order, but they want to leave the line on there as “0” amount for our records. When they attempt this they get the below error message:“To be able to process the line with zero quantity, clear the Require Receipt checkbox...”, and I cannot find that anywhere. Can someone please help let me know where this lives?Thanks!!  

2334
Manikanta Dhulipudi
Captain II
J
jmcginley
asked in Financials
Salvage Value showing on report

I can’t seem to find a report that shows the salvage value, and I don’t know enough about report writing to do that. Is there a F/A report that has the salvage value on it?

201
Laura02
Captain II
P
Semi-Pro II
podonnell11Semi-Pro II
asked in Financials
Reverse ENTIRE FA Depreciation Batch

Hello Everyone,Is there a way to reverse an entire FA depreciation batch? Let’s say there are 100+ fixed assets on the batch, is there a way to reverse the entire batch?  I do not see any options here. Thanks

1992
M
Freshman I
T
Freshman I
tdunewoodFreshman I
asked in Financials
System Created Credit memo

Our system generate credit memos that are not valid how do I get rid of them in Acumatica?

1202
M
Acumatica Employee
Jp89
Varsity I
Jp89
asked in Financials
Trial Balance Multiple Viewing range periods

Currently when viewing the Trial Balance (detailed) you can only view one financial period at a time.It would be beter as accountant that I should be able to select start period and end period. So I could e.g. Say show the the Trial Balance and movement from 1 March 2020 to say 31 May 2020. The trail balance should therefore show the Opening balance as at 1 March 2020, the accumulated Debits and Credits for the period (3 months), and then the final closing balance as at 31 May 2020.Currently we are limited to only obtaining a trial balance for one financial period at a time. It make analysis of financial results cumbersome to work with, and each financial period needs to be exported and then summed and grouped in excel… very time consuming unnecessarily so. 

10834
R
Freshman II
K
Freshman I
kstockmanFreshman I
asked in Financials
Schedule AR Invoices

I have added AR Invoices to a recurring schedule.  Will they always show in GI “Invoices and Memos” as scheduled as long as those invoices are on that schedule?  Thank you!

1693
K
Freshman I
ricoybanez
Jr Varsity III
ricoybanezJr Varsity III
asked in Financials
Approval for Blanket PO

Anyone tried creating approval for Blanket PO, I tried creating with a condition:But its not working. 

332
ricoybanez
Jr Varsity III
F
Jr Varsity III
frankfiorentino81Jr Varsity III
asked in Financials
Fixed Asset Disposals Appear on FA Balance by GL Account

I have a client that has disposed of fixed assets however they still appear on the FA Balance and FA Balance by GL account Report.  Since these assets are not longer in use, I am not sure why they would still be showing on the reports. When the client reconciles their fixed assets to the GL using the FA Balance by GL Account report, they are out of balance by the amount of this disposals. I know I can build a filter to remove them from the report but I don’t think they should be there. What am I missing?Thank you in advance.

1704
A
Freshman I
J
Freshman II
jorgep17Freshman II
asked in Financials
Error message when adding price to a new customer

Hello,We are getting this error when adding price to a new customer. I am very new to this, but to my understanding the price is unique with customer number, inventory code, start date and end date if one exists.  This combination can not be in any other customer because the customer numbers are different.Can you guys please point me in the right direction?  

503
J
Freshman II
R
Freshman I
ReddyFreshman I
asked in Financials
Error: String was not recognized as a valid DateTime.

When processing non stock item the following error has occured Error:String was not recognized as a valid DateTim 

2203
Naveen Boga
Captain II
M
Semi-Pro II
michaelhoSemi-Pro II
asked in Financials
Authorize.net sandbox processing center setup error

We are trying to set up our Authorize.net sandbox account as a processing center on our Acumatica sandbox tenant, however we’re getting the below error message. I created a brand new Signature Key and Transaction Key and still when I try to test credentials I get this error.Any ideas how to get around this? I’ve played around with TESTMODE and VALIDATION parameters and that hasn’t helped. 

3205
Chris Hackett
Community Manager
B
bleis22
asked in Financials
Acumatica intergration with Paymode-X

Has anybody else integrated Acumatica with Paymode-X. I know that there are others doing electronic AP payments with Acumatica but we are looking to use a specific vendor. (AvidXchange) was one listed.https://sourceforge.net/software/compare/AvidXchange-vs-Bottomline-Paymode-X/ I see that Paymode-X does integration with a few other ERPs.  Sage, NetSuite but says it has a open API intergration with any ERP. Just wanted to see if others have used it and solicit and feedback.  

341
Kandy Beatty
Captain II
L
Freshman I
LeeRoy57Freshman I
asked in Financials
Add field to Sum time card hours

Good dayI have a customization that I am working on in Acumatica and was wondering if anyone might help me or cab just to tell me if something like this is possibleOn the employee timecard screen I am trying to add a label in a row just beneath the days to so that day's current date. Can be a label or any field but just to display the date of the current day that they are entering.And then with that I would like to add at the bottom either as a column or a label to display the total of hours that has been added to the specific day as the user enters them.Does any of that sound possible?Please see my screen shot  

2833
meganfriesen37
Captain II
L
Freshman I
lori00Freshman I
asked in Financials
customer refund

Is there a way to print a check for a customer refund that is not tied to the credit memo process?  The GITHUB package is not an option.

13244
T
Freshman I
A
Jr Varsity II
afranklinJr Varsity II
asked in Financials
Allocations - Contra/Offset account based off value of other accounts

Each month we do an allocation entry where we allocate all of the expenses in our corporate branch to our other branches based off a fixed weighting. The problem is, rather than all of the accounts in our corporate branch being $0 after the allocation, we want the total to be posted to an offset/contra account that would making the overall balance in the corporate branch be $0.Ideally it would look something like this: 

1892
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