Financials

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

  • 1,480 Topics
  • 4,910 Replies

1480 Topics

B
Freshman I
BeverleyMFreshman I
asked in Financials

Standard Chartered Bank Export Scenario for Bank File

HiDoes anyone perhaps have an export scenario for the Singapore version of the Standard Chartered Bank payment file for Vendor Batch Payments?Or any tips on how to create one?Thanks heaps for any assistance you can give :)RegardsBev

5
C
Semi-Pro I
1 year ago
A
Freshman I
ataiFreshman I
asked in Financials

How to generate journal entries report based on user ID

How can I add the user ID column in the journey entry transaction reports by period or by account? And how can I inquire based on userID?Please advise. Thank you so much!Aaren

3
L
Freshman II
1 year ago
C
Varsity I
chidao
asked in Financials

Import Trial Balance - Account cannot be mapped

Hi All, when I import Interest Account (4212), the system show “account cannot be mapped”. Does it mean I cannot import the balance for this account or what’s wrong? 

4
C
Varsity I
1 year ago
M
Freshman II
mcovic70Freshman II
asked in Financials

1099-NEC 3 forms per page for 2022

Does Acumatica offer a 1099-NEC form with 3 forms per page? Is there any plan to release this?

0
M
Freshman II
1 year ago
S
Jr Varsity III
shuang57Jr Varsity III
asked in Financials

realized gain/loss from currency shows 0 amount in journal transactions

Hi guys, a question on multicurrency accounting.I transfered 1000 USD from the USD bank account to SGD bank account, I received 1350 SGD and there’s a gain of 1.16 SGD here (base currency is SGD). But in the journal transaction, the realized gain/loss from currency shows 0. Then I checked P&L, it actually shows the right amount of 1.16 gain in the statement. Anyone knows why’s it like that? Could there possibly be anything wrong with the journal transaction? Thanks! 

3
V
Acumatica Employee
1 year ago
I
Freshman I
isemida20Freshman I
asked in Financials

Hello. How to create adjustment invoice to debit customer for taxes that were omitted in error?

After running customer report, I found discrepancy in Tax code. Part of invoices had taxes included and other part not. Please help me to understand how I can crate adjustment invoices for taxes that needed to be collected.

0
I
Freshman I
1 year ago
D
Freshman II
dsenevirathne54Freshman II
asked in Financials

Posting prepayments for multiple ledger accounts receiving from the same customer

Hi,Our customer collects prepayments from the same customer for two different purposes. And these two different prepayments, they credit to two ledger accounts in the current practice. How can I post prepayments to two ledger accounts receiving from the same customer. Is there any possible way  ? Thanks,Dulanjana 

5
D
Freshman II
1 year ago
T
Freshman II
TracyVogtFreshman II
asked in Financials

Processing Bank Transactions

I imported my bank transactions and for the first time I’m trying to create missing transactions directly from the the right side of the screen and created rules for recurring transactions with specific criteria so going forward I won’t have to manually input them as they’re validated and I know what they are.  However when I click ‘Process’ it won’t process them because it says the ‘extRefNbr’ cannot be empty.  This field gets automatically populated from the bank’s Quickbooks upload file and I can’t modify it.  Is there an option I’m missing to allow that field to be null or is there something else I’m doing wrong?  Thanks in advance for any help you can provide! 

2
T
Freshman II
1 year ago
V
Freshman I
Valessa
asked in Financials

Advanced Cash to Employee

Hi,In case the employee needs to get some cash in advance to go perform a job. how this works in Acumatica if we will know how the money was used after the fact and we need to track it in the system? Thank you 

7
V
Acumatica Employee
1 year ago
E
Jr Varsity II
erinJr Varsity II
asked in Financials

How to take Profit and Loss report figure in Dashboard

Hi I would like make some Profit and Loss report (DPL)  figure in Dashboard for easy reference. example: revenue , gross profit , net profit.  Not sure who can share with me how to extract the figure to dashboard?  

2
N
Freshman I
1 year ago
B
Freshman II
byates
asked in Financials

Inventory Reval (How to ?)

I am wondering how to revalue inventory in ACU. I know I need to use the IN Adjust but still not getting the results I want. I have some items that have correct qty and the incorrect valuation. For these It would just have to remove all of the inventory at system cost, and when I add it back to I use IN Adj or IN receipt? I believe the issue I was having with IN adjust is the costing is tied to the receipt that you choose.We have a few items that have a value by no quantity. I am unable to do a IN adjust with a Qty of zero. The system does not create any transaction. How would I correct these issues?Thanks as always to a great community! 

3
B
Freshman II
1 year ago
bnaumann
Freshman I
bnaumannFreshman I
asked in Financials

Another process has updated the 'INItemPlan'

Trying to release an invoice and it keeps firing back the same error. We checked stock and all and cannot seem to find the root of the issue. Any assistance would be great! 

7
bnaumann
Freshman I
1 year ago
B
Freshman I
brettd36Freshman I
asked in Financials

Sending out statements using GMAIL gets error "Too many login attempts. Please try again later"

Yesterday our client informed me that there is an issue with using Gmail for sending large volume email-based communications from Acumatica. They were trying to send some 4500 statement emails when they encountered the following Gmail error: Too many login attempts. Please try again later.  From my reading up, this error is possibly caused by each statement email sent creating a login attempt to the Gmail account. 2 questions on this:Does Accumatica have a config SMTPKeepAlive, which will allow the already created SMTP connection to be reused (without having to re-login each time)? If it does, is this configuration switched on? Is this an issue you have encountered before with Accumatica, and if so how was it resolved?

5
A
Freshman I
1 year ago
S
Freshman I
sbhattaraiFreshman I
asked in Financials

Open Prepayment from previous year

We have open prepayment from last year. Check has been cleared from the bank. It looks like the accountant didn’t know how to adjust with bill and they adjusted payment without clearing prepayment. Now I cannot void, the check number linked is reconciled and closed.  How can i adjust this prepayment and cleared it from open A/P?  Thank you,Shankar

3
B
Freshman II
1 year ago
Jp89
Varsity I
Jp89
asked in Financials

Avoiding the possibility of fraud on Invoicing

I have a situation where Users create an Invoice and leave this in Balanced Mode, they are then able to print and email the invoice to the customer. Once done they subsequently receive cash payments from the customer, but then go and delete the invoice (because its still in balanced mode). This gives rise to fraud. How can I disable the ability to print or email an invoice in hold or Balanced mode, and only allow for the invoice to be printed / emailed once released into the system?

7
L
Freshman II
1 year ago
A
Freshman I
ataiFreshman I
asked in Financials

How to set up Release button for certain users only?

For internal control purposes, how to restrict certain users from having access to “release” button for journal entries and have all JE release thru specific user only?Thanks ahead. Regards,Aaren

3
Naveen Boga
Captain II
1 year ago
D
Freshman I
danielosheaFreshman I
asked in Financials

TimeCard correction problem - The Employee Labour Cost Rate has not been found

We have a problem when correcting time cards after they have been approved and released. It appears where we have work items associated with a task we get the error "The Employee Labour Cost Rate has not been found". So we cannot release the card. We don't have this problem if the work item is not associated with a task.Have you come across this before? Any ideas on a solution, please?  

5
S
Freshman II
1 year ago
L
Freshman I
lkohlenbergFreshman I
asked in Financials

AR Credit Memo stuck in "Reserved" Status

I have an AR Credit Memo stuck in a reserved status. It was initially created to process a refund but another AR credit memo was created in its place. The refund was processed and attached to the replacement CM and those two documents are closed.The AR Credit Memo is not applied to anything and all options on the actions, inquiries, and reports menus are grayed out. It is a part of a batch that was posted to the GL which makes me believe that the document was released before it was reserved. Any ideas on how to get this document out of reserved status? Our end goal is to delete it or close it out with a debit memo.

3
L
Jr Varsity III
1 year ago
D
Freshman I
dvertes
asked in Financials

AP workflow process

Hi everyone,We’re new to Acumatica and looking to implement an AP workflow that incorporates entering a vendor invoice and saving without posting to the GL i.e. we may need to edit the transaction lines prior to posting. We also need the process not to restrict us closing a period.Would the settings need to be following? Thanks and much appreciated 

6
kandybeatty49
Captain II
1 year ago
D
Freshman II
donna80Freshman II
asked in Financials

Import scenario to reverse AP Bills

I’m trying to create an import scenario to reverse some AP Bills.  I am getting this error “An error occurred during processing of the field Tax Calculation Mode value N TX Error: The Tax Calculation Mode field can have only the Tax Settings (T) value because the Net/Gross Entry Mode feature is disabled.”

3
V
Acumatica Employee
1 year ago
mpeck12
Freshman II
mpeck12Freshman II
asked in Financials

Basis of currency translation calculations

The translated values in one company are using Account Ending Balances to apply the exchange rate for translation.Is it possible to apply the exchange rate to the Period Turnover amounts, rather than end balance?

1
Laura02
Captain II
1 year ago
S
Freshman I
sbhattaraiFreshman I
asked in Financials

Purge Prepayment with vendor bill

How can we apply open prepayment with vendor bill? How can we adjust open prepayment created by mistake?  Appreciate your help. 

1
Laura02
Captain II
1 year ago
J
Freshman I
joycexu46Freshman I
asked in Financials

Deferral Schedule linked to a wrong Invoice

HI, guys. does anyone know how to cancel/terminate a deferral schedule? the deferral schedule linked to a wrong invoice, but has not start the recognition yet? is that possible to terminate the deferral schedule? If I just leave it and create a new deferral schedule, the old one(the wrong invoice) will not be able to link to a new schedule. thanks in advance

5
Chris Hackett
Community Manager
1 year ago
L
Freshman I
lbrown57Freshman I
asked in Financials

Error when processing invoices

We are receiving the error below when trying to Release invoices on the Process Invoices/Memo screen. We’ve tried processing these invoices individually and using Process All and receive the same error.  I do not see anything that stands out on the invoices that would be preventing us from releasing these invoices. Any ideas on this error?  Screen:  Error:  

4
Chris Hackett
Community Manager
1 year ago
A
Ayesha77
asked in Financials

How to create the cash register account?

While creating the company I have followed the steps that are mentioned in F100_Financial basics 2022 R1 and I have created company without branches but while coming at the step To Create Cash Accounts in that Step 1 : Creating the Cash Register Account Here while doing this step I got an error of branch id cannot be empty.So how do I fix it? 

1
Laura02
Captain II
1 year 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