Skip to main content

Financials

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

  • 2,528 Topics
  • 8,282 Replies
2528 Topics
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 

2243
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. 

3355
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.  

361
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  

2853
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.

13464
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: 

1942
A
Jr Varsity II
Y
Freshman I
yansiongyu54Freshman I
asked in Financials
Invoice discount auto rounding

Hi, I have met an issue when creating a discount in a sales order invoice, how can I avoid the discount automatically rounding? I setup the discount with 2%, but the system automatically rounding the discount to 2.077922%770 * 0.02 = 15.4 / 770*0.0277922 = 16  

1212
Laura02
Captain II
E
Freshman I
enriqueyFreshman I
asked in Financials
Location ID

How do I create a location ID?

4504
M
Acumatica Employee
K
Jr Varsity III
kmckenzieJr Varsity III
asked in Financials
Discovery Endpoint Address not set in AP Incoming Documents

Every invoice that I try to “Recognize” in the Incoming Documents screen generates the error “Discovery Endpoint Address not set”.  I am manually dragging and dropping the invoices onto the screen and they do display but that’s all other than the error.

4219
S
Acumatica Employee
R
Captain I
raphrfCaptain I
asked in Financials
Customer Statement including unposted transaction

Hi, is there a way to include unposted transaction in Customer Statement ? or creating a alternate customer statement which include unposted transaction?

633
Laura02
Captain II
Q
Freshman I
quentincarterFreshman I
asked in Financials
Linking PO to Bill once closed(paid)

Hello,I’m having an issue where AP did not link the PO to the bill when it was entered. It went through the whole process and was paid.I know it can be reversed if the status is open, but since it was paid and now closed is there any way I can link it to the PO?I don’t understand either.. if it can be reversed, how would you apply the payment again without it thinking it was paid twice? Reverse the bill and payment and then enter it all again?It’s causing a lot of extra work when I’m in the project close out report, the costs are allocated to the project but finding out what costs belong to what PO manually with a ton of bills and PO’s on a job…it’s very time consuming.Not sure if there is a way to do a project transaction like entry where it can hit the PO but not be posted to the GL? but..Any help would be appreciated.

3321
Laura02
Captain II
J
jmcginley
asked in Financials
Amount paid to vendor over time including the expense GLs used for that vendor for each payment

How do get the amount paid to vendor over time (YTD or over 12 month period) including the expense GLs used for that vendor for each payment

1631
Laura02
Captain II
M
Freshman II
mdyerFreshman II
asked in Financials
Account Type Entered Incorrectly as "Asset", where it needs to be Expense

Hello - In one of our tenants, we had an account incorrectly added with an Account Type of “Asset”, and it wasnt caught until transactions had already been processed. Now when attempting to change the account type to Expense, I get an error message stating that I cannot change the account type because transactions already exist. Is there any way around this so that we can change the account to Expense and it populates on the Trial Balance and reporting correctly?Thanks!  

1244
M
Freshman II
C
Freshman I
cherleneFreshman I
asked in Financials
Net income in balance sheet vs P&L - elimination column

Hello, My Consolidated P&L report is eliminated but the consolidated net income under my balance sheet does not match with consolidated income statement. The net income figure that the balance sheet report pulls is a combination of parent and subsidiary without the elimination of interco transactions. It is drawn from the account class NETINCOME from respective entity.  I need help on how to make them tie under the report definition. Thank you in advance. Thank you. Regards,Cherlene

3022
J
Semi-Pro I
StevenRatner
Varsity I
StevenRatnerVarsity I
asked in Financials
Pending Approval -> Business Event Email Reminder

Im looking to set up a Business Event to send an Email reminder if the AP Bill → Approver hasn't approved the bill within 2 days.  I'm not sure if this is possible through a business event and how to join APInvoice to EPApproval. Has anyone ever done anything like this?

6072
R
Captain I
A
Freshman I
amy81Freshman I
asked in Financials
How to numerically sort subaccounts on ARM report

I have report where I note the account and it’s balance on one row, expand by subaccount on the next row set exampleThis is working great for obtaining the subaccount activity that makes up the account balance. However when printing the report, I would like to sort the subaccount string numerically. Currently, segment one is sorting largest to smallest while segment 2 is smallest to largest. Does anyone know of a custom expression for either the column set or row set to be able to sort the string smallest to largest? example of report output (exported to Excel), same behavior in the Acumatica screen and when exporting to PDF​​​​​Thanks for any and all help on this!

1613
A
Freshman I
N
Freshman I
NaingAungKyawFreshman I
asked in Financials
Purchase Receipts and Bill Creation

Hello Community,I have a query regarding the “ADD PO RECEIPT” button at the Bills Form and whether there's a way to display only the correct receipts.Let me illustrate the scenario: sometimes, a user may create a receipt but inadvertently input incorrect information and then proceed to release it. In such cases, the user needs to create a Return form, reopen the PO Line, and subsequently re-receipt it correctly. This results in the “PO HISTORY” tab of PO containing two receipts - the first one, wrongly released, and the second one, which is the correct receipt. Additionally, there's the entry for the Return form.Now, when we create bill for the receipts through “ADD PO RECEIPT” button, we want to see only the correct receipt (the second one) to choose in the Bills Form. This would help avoid any confusion and ensure accuracy in our billing procedures.I would greatly appreciate it if anyone could provide insights or suggest any methods to achieve this, allowing us to effectively filter

1582
N
Freshman I
J
Semi-Pro I
jwarrenSemi-Pro I
asked in Financials
Why is variance column on Balance Sheet blank?

I can’t seem to figure out why this balance sheet variance column is blank - any suggestions?Here is row set:Here is snippet from statement: 

442
Chris Hackett
Community Manager
H
Freshman I
Hiax15Freshman I
asked in Financials
Closing an Invoice that was Paid but then Reclassed

I need to know how to close a AP Bill that has already been paid and closed, but reopened due to its Account being reclassified. I have listed the full process the Bill went through below.Billed Entered Approved Released Paid in full by a check, closing the Bill Bill was then reclassed using “Reclassify Bill” functions and specifically the Account was changed during the reclassification.The bill is still linked to the check and it shows that it was paid and the amount paid, but is in open status.The check that it is tied to still shows the full amount as well 

2555
Chris Hackett
Community Manager
A
Freshman II
adharmawansha22Freshman II
asked in Financials
Recalculate Account History (GL509900) is not showing on Finance workspace.

Hi AllI am experiencing an issue where Recalculate Account History (GL509900)  is not showing on Finance workspace. It would be grateful if anyone could help on this case.  Thanks 

641
Laura02
Captain II
J
Freshman I
JBlas2023Freshman I
asked in Financials
Sales Tax Management

We are working with Acumatica to get started but are still going there the demos and final questions stage.  Today the sales tax rates came up because in Acumatica they are manually entered and updates.  We are currently using QuickBooks and those rates automatically get updated. We only sell within California and only file one return.  Is there a software that would take care of just automatically updating the rates? Or is there a solution within Acumatica to help with this??Help/advice is greatly appreciated!

491
C
Jr Varsity II
J
Freshman II
jorgep17Freshman II
asked in Financials
Our Acumatica AR Customer Credit Balances are not correct. 

Hello,Our Acumatica AR Customer Credit Balances are not correct.  Example:Customer 169523000 - Vis****, has a $3000 credit limit, with a $69.30 Open Orders Balance, but then shows a -$6,260.70 Remaining Credit Limit. It then puts a Credit Hold on the Orders. Screen AR.30.30.00, Financial. Any idea where should I start looking? Workflows? Code? I am clueless.   I also saw this message when just digging around. Not sure if has something to do with anything of this. Please help.  

1322
J
Freshman II
K
Jr Varsity II
kristybrooks83Jr Varsity II
asked in Financials
AP Credit Terms

Can I change terms from N30 to an installment code on an open AP Bill?

391
Laura02
Captain II
M
Freshman I
MVirtusioFreshman I
posted in Financials
error. currency rate

hello, Can not close debit adj against credit adj because i have this error? i need to close the ap account because the correct currency is chf not usd  

1173
Chris Hackett
Community Manager

Badge winners

  • Easy talker
    nadiyahnatyuk58has earned the badge Easy talker
  • Easy talker
    mkochhas earned the badge Easy talker
  • Product guru
    ray20has earned the badge Product guru
  • Integrations and Web Services | APIs expert
    Kandy Beattyhas earned the badge Integrations and Web Services | APIs expert
  • Easy talker
    mindwebhas earned the badge Easy talker
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