Financials

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

  • 1,471 Topics
  • 4,888 Replies

1471 Topics

B
bpartlow
asked in Financials

Unvoid a Check

I voided a check in Acumatica accidentally. The check has cleared the bank already, so I cleared it in the bank reconciliation. However, there was a void issued the same day for this check. Because of the timing, the check cleared the bank, and now I have a Voided Check that is “stuck” in an unreconciled status in Acumatica’s bank recon. How do I unvoid this voided check to clear out my recon? 

3
Laura02
Captain II
1 month ago
K
Freshman I
KakieFreshman I
asked in Financials

CURRENT COST / LAST COST / PENDING COSTS

I am having a hard time understanding exactly where these costs are coming from and how to adjust.Standard cost sectionPending costs - ???Last cost - ???Current cost????? - where can I update this?? Cost Statistics SectionLast cost - this is the last cost that it was moved into inventory at (looks to be actual cost of materials issued against production order)average Cost - this is the number that I just entered under Item warehouse Details, then rant updated standard costsmin/ max - looks to be actual cost from production orders my questions are 1. - how come EVERY time I update cost on the warehouse details, it automatically goes back to what I just updated it from?  7.67. updated to 8.30 and now it looks to be going back to 7.67 tomorrow- where and how do I update current Cost.  what is this number and where is it used? when I update standard costs, why does it go to the average cost, vs the standard cost last cost?am I missing something??? thank you!  

3
B
Freshman II
13 days ago
M
Freshman II
mdyerFreshman II
asked in Financials

Possible to Create a Mass Email for All Vendors of a Specific Vendor Class

Hello - One of our properties has a new procedure for invoices, and wants to send an email to all of the vendors for their property. They are all designated to a specific vendor class that only that property can see. Is there a way to generate an email that would automatically pull in all email addresses from each individual vendor within that vendor class, so we can send a mass email with the new instructions?Thanks!

1
DavidEichner
Pro III
1 month ago
rcreasy
Jr Varsity III
rcreasyJr Varsity III
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.

11
D
Varsity II
2 months ago
W
Freshman I
williamq178Freshman I
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! 

7
J
Freshman I
2 months ago
A
Freshman II
afranklinFreshman II
asked in Financials

Approvals for AP Bill to PO Discrepency

We are currently implementing Acumatica and just discovered from our consultant that there is no easy way to create an approval map to handle situations where an invoice doesn’t match the PO (i.e. price variance, freight charges added, etc...). In a perfect world, we would be able to replicate our current purchasing software which sends an automatic approval to the person who made the purchase order to approve the variance as AP has no idea if it is legit or not. Does anyone have any suggestions for possible workarounds to handle AP Invoice/Purchase order variances without us reverting to the old fashioned way of sending each invoice manually back to the buyer to ask for their approval?

6
Laura02
Captain II
1 month ago
Y
Freshman I
yashodhalakshini85Freshman I
asked in Financials

Reversing the Debit Adjustments

Hi Team,I have the following question regarding the reversals of debit adjustments. (Payable Module)I have created a debit adjustment & didn’t apply to any AP bill because I found out that the created debit adjustment is wrong. Therefore, in order to correct that I reversed the debit adjustment & it created a credit adjustment. In my GL accounts the balance is net-off & it is in order. But the question is, the credit adjustment & the debit adjustment is still in open status. How am I suppose to close those documents ? Please note that I don’t have any document to apply. Thank You & Best Regards,Yashodha  

2
Y
Freshman I
2 months ago
A
Jr Varsity III
ashleybJr Varsity III
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. 

2
Chris Hackett
Community Manager
2 months ago
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! 

1
Laura02
Captain II
2 months ago
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?

3
L
Freshman I
2 months ago
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!

2
F
Freshman I
2 months ago
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?

1
Laura02
Captain II
2 months ago
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.

1
Laura02
Captain II
2 months ago
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!

1
kandybeatty49
Captain II
2 months ago
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!!  

4
manikantad18
Pro II
2 months ago
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?

1
Laura02
Captain II
2 months ago
Ghazalshokrollahi
Jr Varsity III
GhazalshokrollahiJr Varsity III
asked in Financials

Is it possible to Change the financial year after client have at least 1 year history of data

hi All, I am dealing with a client to help them fix the financial year which had been set incorrectly and they have been transacting in the system for at least a year. the issue is where it has to show 2024 as a financial year for the year starting from 1/7/2023 it shows 2023.  ( we are using the MYOB Advanced Australian financial calender) , we are missing this tick box which should have been enabled at the start. has anyone dealth with this issue before or can this be fixed? it is just annoying for the client to always see the incorrect year. ThanksGhazal   

6
D
Freshman I
20 days ago
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?

2
M
Acumatica Employee
2 months ago
ricoybanez
Jr Varsity II
ricoybanezJr Varsity II
asked in Financials

Approval for Blanket PO

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

2
ricoybanez
Jr Varsity II
2 months ago
J
Freshman I
jorgep17Freshman I
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?  

3
J
Freshman I
2 months ago
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!

3
K
Freshman I
2 months ago
C
Freshman I
CJohnson15Freshman I
asked in Financials

Joint (OR) Payee

Does anyone know how to make a joint payee with the OR option where either party can negotiate the check?

7
kandybeatty49
Captain II
1 month ago
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 

3
Naveen Boga
Captain II
2 months ago
J
Freshman II
jpalyan1981Freshman II
asked in Financials

Bill Status 'Under Reclass' error

Hello,I have an AP Bill that I was trying to reclass. When I initiated the reclass and attempted to ‘release’ the bill, I received an error message ‘Updating the ‘PMRegister record failed because data in some field is too long’ (screenshot is below)How can I shorten the description so that I can release the bill?Thank you. 

6
J
Freshman II
1 month ago
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.  

1
kandybeatty49
Captain II
2 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