Financials

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

  • 1,460 Topics
  • 4,847 Replies

1460 Topics

coleenmcnally22
Jr Varsity II
coleenmcnally22Jr Varsity II
asked in Financials

Journal Transaction Approval Map

Hi,I am trying to configure an approval map for journal transactions, where the approver is the supervisor (reports to on the employee profile) of the user that entered the transaction.  Here is the conditions tab On the Rules Action tabI have tried drilling into the owner option, but nothing is working.  I have the reports to field populated on the employee profile.Any help is appreciated.

9
coleenmcnally22
Jr Varsity II
4 months ago
R
Semi-Pro III
rosenjonSemi-Pro III
posted in Financials

LIFO Inventory valuation module - any interest?

Our company uses LIFO accounting, which is generally only used in the United States, however it is GAAP compliant.I am just curious if there is any interest out there for a LIFO accounting module in Acumatica? We will probably write some software to calculate the LIFO reserve for our own purposes. We use dollar value LIFO. Thanks, Jonathan

9
R
Semi-Pro III
2 months ago
F
Freshman I
Fie
asked in Financials

Account Class Column in Journal Transaction (per line)

Hello Everyone, In standard journal transaction window we can’t see the column of account class.Is there a way to make it visible upon creation of journal transactions? Thank you !  

9
aaghaei
Captain II
11 months ago
kratzert
Jr Varsity III
kratzertJr Varsity III
asked in Financials

Add/Expose Vendor Reference Number on AP Approval Screen

Business case:  Get multiple invoices from same vendor with same dollar amounts. Approver has to click into each invoice to see invoice number. If you click into the invoice, it then reverts the invoices you marked as approved back to blank. Very tedious and time consuming. The vendor invoice number field is NOT available to select in the Column Configuration screen. 

9
darylbowman
Captain II
1 month ago
A
Freshman I
angelineFreshman I
asked in Financials

How to pull the take from profit and loss report EBIDTA into Dashboard

Hi, all. I need to take the amount for EBIDTA from profit and loss report into the Dashboard (generic inquiry). Can anyone have idea how and where to take the data into the dashboard?

9
aaghaei
Captain II
10 months ago
B
Freshman I
bclarkFreshman I
asked in Financials

Putting Expense Claims on Hold

Hello, For our company, we have two employees with the same roles in Acumatica that need to be able to edit expense claims before they get approved. To do this, they put them on hold first, which I believe to be the correct process. However, one of the employees has the on Hold button available while the other does not. Does anyone know where/how to set up the users to have the same options available for expense claims?  Thank you!

9
B
Freshman I
8 months ago
M
Freshman II
Malinda278Freshman II
asked in Financials

Trial Balance not suppressing zeros

Hello there I am trying to run the TB without suppressing zero balances so that I can make an excel sheet mapping to all my  accounts (regardless of the balance)  to build my own P&L and Balance Sheet. I have never managed to get this done within the application and don’t like the look of it anyway.So I have done this for the first month of our accounting year and have unticked suppress zero balances and yet accounts which have no entries are actually suppressed. What is going on I feel as if Acumatica is always trying to trick me! Is it only the Balance Sheet that this tick box responds to…? Best Regards All 

9
M
Freshman II
25 days ago
Jeff96
Captain II
Jeff96Captain II
asked in Financials

Import Settlement Batches - Pending Review

I’m having an issue with a Import Settlement Batch that is in the pending review status. It seems that everything is correct on it, but I can’t create a deposit.

9
Chris Hackett
Community Manager
2 months ago
B
Freshman I
bclarkFreshman I
asked in Financials

Unposted GL Transactions

Does anyone know why journal transactions from the AR Module wouldn’t automatically post to the GL if it’s set up to do so?  We have noticed that 3,666 transactions from a one week period in December have not posted to the GL. I’m relatively new to the position and at a loss as to why this would have happened.  Any help is greatly appreciated!  

9
B
Freshman I
6 months ago
martingaxiola
Varsity I
martingaxiolaVarsity I
asked in Financials

How to explain Unposted Journal Transactions

Team, I am struggling to explain Unposted Journal Transactions. I know there are some issues and some scenarios explained, but for normal people, why there is unposted transactions on the system? They are random, and can have a good explanation for my client, every now and then, when closing the month, there will be uposted journal transactions, and there will be no good answer for those. I have put a schedule to post every night unposted transactions to see if the problem goes away, but still want to have a good answer for them. Thank you. 

9
martingaxiola
Varsity I
8 months ago
L
Freshman I
LbruniFreshman I
asked in Financials

AR Payment application

Correct me if I’m wrong, but in AR payments and applications, after you selected the line items and put in the payment amount, when you would go to release it, it would automatically delete the other line items that you didn’t use.  It doesn’t seem to be doing that now.  Any thoughts?  We’re using 2022 R2.  

9
Chris Hackett
Community Manager
5 months ago
coleenmcnally22
Jr Varsity II
coleenmcnally22Jr Varsity II
asked in Financials

Audit vendor profile

I would like to setup an audit on the Vendor name.  Does anyone know where I locate the field on the Audit Setup?I am working in 2020R2

8
Naveen Boga
Captain II
2 years ago
E
Jr Varsity II
erinJr Varsity II
asked in Financials

Reccuring Transaction

Hi Sir I have set a recurring transaction , start date is 1 Nov , run at every month and end of the day.However , i did not see any recurring transaction generate on 30 Dec 2020 for the below, does it mean i  need to go recurring transaction to “ RUN NOW” instead system can run it for us?  

8
E
Jr Varsity II
2 years ago
M
Jr Varsity III
mlupro87Jr Varsity III
asked in Financials

Printing an actual check for a customer refund in 2021 R2

There is an old video on the topic of Customer Refunds where the user goes through about five or six steps to issue a refund to a customer.  And it works great!  However, there were too many steps and Acumatica appears to have simplified the process in subsequent releases.So now, in my 2021 R2 demo database, when the credit memo is on the screen, there is an option on the ...More menu to REFUND the amount to the customer.  I’ve done that and I see a JE that shows AR was debited and Cash was credited but I don’t see where a check was actually issued to the customer.  I can’t find a pending payment in payables but the JE looks like is was processed as a check.The whole point of this exercise is to issue a refund check to the customer and I’m just not seeing it.  What am I missing here?

8
M
Freshman II
24 days ago
saiful murad
Jr Varsity II
saiful murad
asked in Financials

Upload Approval Maps instead of setting up on screen

Hi. We have a client requiring setting up of approval maps for 156 branches for 12 modules 2 tier (preparer → reviewer) 3-tier (preparer → reviewer → approver)with conditions and rule actions. We believed we can expedite by either using import scenario or, worst case scenario,do a direct SQL.Anyone encounter such experience before? Thanks in advance. 

8
saiful murad
Jr Varsity II
1 year ago
W
whitneyhearn02
asked in Financials

Project integration issues

When a GL account is assigned to an account group, the GL account will be required to have a project associated with it. Some forms do not allow for project number input which prevents use of that form. For instance, attempting to utilize the create adjustment tab in the reconciliation statements is not possible because the quick transaction screen does not allow the user to input a project number (there is no project field available.) Other areas where this is a problem for companies that utilize projects is in the fixed assets module and in the allocator process.

8
L
Freshman I
1 year ago
A
Jr Varsity III
alicia23Jr Varsity III
asked in Financials

Cash Basis P&L

Trying to create cash basis P&L in Acumatica.  Has any one been able to do this without using a 3rd party add on? 

8
M
Freshman II
9 months ago
R
Captain II
ray20Captain II
asked in Financials

Where is the AR line TaxAmt be kept in DB/DAC?

Hello,     I am writing a report to customers and would like to show the AR line amt and line taxamt.however,  The ARTran.TaxAmt is empty, and also the ARTax.TaxAmt is empty.   We do have TaxAmt on TaxTran, but is is not single line, it is the whole AR document.  Can somebody tell me where I can get the line TaxAmt directly?  Or I have to calculate it by myself? 

8
M
Varsity I
1 year ago
jgress
Jr Varsity II
jgressJr Varsity II
posted in Financials

Financial Reports by Week/Date

Several customers have requested Financial Reports (P&L, etc.) by week.  In some cases they would like to look historically to compare a week in the current period to a historical period for trend analysis. In other cases they budget by week and revise their budget for next week based on last week.  A good example is a hotel chain where they look at room nights to determine staffing and supply requirements.  We are looking at Velixo and Power BI but would prefer to have an easy solution that is more out of the box and built with standard Acumatica tools.  Has anyone tackled this and can share their experience?  Anyone else need this functionality?

8
Gabriel Michaud
Captain II
2 years ago
Doug Johnson
Community Manager
Doug JohnsonAcumatica VP, Product Management
posted in Financials

Focus Group: Cross Company Re-invoicing and Sales Orders

About: We would like to gather your feedback on cross company sales features for our upcoming release.  We held our first focus group in November 2019, but want to dive deeper into re-invoicing expenses and selling goods.Providing services to related companies (launching in 2020 R2 - automatically create a matching AP Document when you create an invoice for related company). Re-invoicing expenses to related companies (focus group topic) Selling goods to related companies (focus group topic) Selling goods from a related company warehouse Transferring goods with a profit marginAudience: Customers and partners who need this feature or have knowledge of workflows and how it can be delivered.Date/Time: Aug 26 @ 9am PDT / 12pm EDTRegistration: https://webinar.ringcentral.com/webinar/register/WN_qMl1oU97S-uBb4vA0j5nAA

8
andrewh22
Freshman II
2 months ago
bnaumann
Freshman I
bnaumannFreshman I
asked in Financials

Prices being cut in half on SO

Why does the Invoice for the 100pcs on IN0563852 shows a sell price of $271.23, but when you print the invoice the price comes in at $135.62? It is cutting the price in half. Does anyone know why? 

8
Chris Hackett
Community Manager
1 year ago
A
Freshman I
ASamson21Freshman I
asked in Financials

Restrict Visibility of GL Account and Subaccount by Company/Branch

Hi All, How can I restrict a GL Account and Subaccount to specific company/branch?Any help will be highly appreciated. Thanks, Anne Samson

8
A
Freshman I
1 year ago
R
Pro II
RoyceLithgoPro II
asked in Financials

New Actuals Ledger

Is it possible to add a new Actuals Ledger and configure the system such that postings are directed to the new Ledger only?We want to retain the original Actuals for archive purposes but essentially start with a clean book in the new Ledger.

8
kandybeatty49
Captain II
1 year ago
E
Jr Varsity II
erinJr Varsity II
asked in Financials

Historical Inventory Valuation : How to adjust out the inventory without do the adjustment transacation

Hi SirWe have encountered a problem about the inventory , we make mistake do receipt in a part # where that should be use existing 5 parts to do kit assembly into one part # . Currently , our system have extra 5k in inventory history valuation but in financial inventory account is correct . We cannot do adjustment transaction as it concern about double entry where it will affected financial account figure.May i know if there is any way to do offset the extra 5k in inventory but not affected the financial inventory figure?  Hope to hear from you soon.Thank you

8
C
Semi-Pro I
2 years ago
B
Jr Varsity II
bgreene87Jr Varsity II
asked in Financials

AP Bill not editable in Balanced status when AP Approval activated

My client recently began using AP Approvals. Specifically, they added an AP Approval Map to the AP Preferences form under the Approval tab and activated it.  Since doing so, when an AP Bill is entered and saved and taken off hold, it moves to a Balanced status as normal.  However, we’ve noticed that they are no longer able to add new lines to the Bill, change dates or vendor locations, etc….all things that can normally be done for a Balanced AP Bill.If we deactivate the approval map on AP Preferences, we can go back to the same Bill whose fields were greyed out and no lines could be added or changed or deleted, put it on hold, then take it back off hold, and now all those fields are available for editing again and new lines can be added, etc.If we reactivate the approval map and do the same thing - put the Bill on hold and then take it off hold again - we are back to the fields being greyed out and no lines changes are allowed.If it matters, this Bill is not subject to the approval map

8
B
Jr Varsity II
1 year ago

Badge winners

  • Financials expert
    marina25has earned the badge Financials expert
  • Easy talker
    aiwanhas earned the badge Easy talker
  • Easy talker
    tveldhas earned the badge Easy talker
  • Product guru
    sweta68has earned the badge Product guru
  • Easy talker
    KseniaBurtseva61has 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 — 2023  Acumatica, Inc. All rights reserved