Skip to main content

Financials

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

  • 2,451 Topics
  • 8,073 Replies
2451 Topics
J
Freshman I
jparvezFreshman I
asked in Financials
AR Invoice Due-10 days late reminder

Hello Community, We want to setup some reminder email to customer when AR invoice due date passed 10 days.  Can anyone guide me how to achieve this? Or Have anyone setup similar kind of business event? Regards,Jewel ParvezLead ERP ConsultantAlliant Rigserv LLC 

2552
J
Freshman I
charliefitzgerald13
Freshman I
charliefitzgerald13Freshman I
posted in Financials
Financial Planning in Acumatica

Are you using Acumatica to perform financial planning for upcoming projects?Do you find Acumatica has sufficient tools to adequately perform scenario planning? Do the existing forecasting tools need additional functionality to fulfill these use cases?Our team is interested in learning how other partners perform financial and scenario planning in the Acumatica environment, and whether the existing functionality is generally considered sufficient.

270
charliefitzgerald13
Freshman I
A
alejandromatta
asked in Financials
Account Migration Sage 300 to Acumatica

Hi! We are currently migrating form Sage 300 CRE to Acumatica. We are wondering how can we best translate to Acumatica our Sage 300 CRE Account definition. In Sage 300 CRE, we use a suffix for example: 31000.001 The first 5 digits (31000) - Account The last 3 digits (001) - is our suffix (department, company, project, etc) 

682
C
Semi-Pro I
M
Freshman I
Mle45Freshman I
asked in Financials
Where to update user access on the GL Accounts Tab

I’ve been updating the user access to the GL Accounts tabs (view-only) on the Customers, Customers Classes, Stock/Non-stock item, etc. I was able to find most of the GL Accounts and Subaccounts fields on most screens except for the Customers screen.Under the Access Right By Screen > Receivables > Customers > Customers, I can only find the Cash Discount and Prepayment fields listed. Where can I find the rest of the fields?  Thank you,

542
M
Freshman I
D
Freshman I
dvanacore17Freshman I
asked in Financials
Stripe Payment Systems

Does Acumatica have integration with Stripe Payment Systems? Thanks

164510
Doug Johnson
Acumatica Moderator
kristianharianja
Semi-Pro I
kristianharianjaSemi-Pro I
asked in Financials
Credit Terms - Due end of 2nd Month

Is it possible to create the above credit terms?Ex: Doc date 10 Feb 2023, it is due at 30 April 2023.  

1695
M
Jr Varsity II
M
Jr Varsity III
mna10Jr Varsity III
asked in Financials
Bill Approval for only certain users

HI, I’m trying to create an approval map where a manager will need to approve the AP bill for POs enter only by certain users. It doesn't look to be working. However if I uncheck the active box for the 2 employees in the conditions tab, the approval does work. I only need it for these 2 employees though. Any Thoughts? 

13110
M
Jr Varsity III
S
Jr Varsity III
srengdahlJr Varsity III
asked in Financials
Percentage of sales column set

How do I create a column that calculates % of sales for each row?  

1291
Laura02
Captain II
H
Freshman I
hmukundanFreshman I
asked in Financials
Opex at Warehouse level

Can you report on operations expense at a warehouse level or does it need to be a branch in order to meet the requirement. I am referring to capturing and reporting non product cost, like your payroll, building maintenance etc. We are trying not to have move sub accounts to keep it simple on the number of accounts and activities to be configured.

231
Freeman Helmuth
Varsity III
C
Freshman I
chacalawaganFreshman I
asked in Financials
How to release payment using Petty Cash Fund

Hi! May I ask anyone on how to release payment using Pettycash Fund? Petty Cash account is already setup. I just do not know what module to use in releasing payment. Also, is releasing payment using Petty Cash fund affect the GL entries?Thank you in advance!

1374
A
Freshman I
H
Captain II
HarshitaCaptain II
asked in Financials
Generating Period after Shifting Financial Year

Hello Community,I have a scenario where I would be importing some invoices of the year 2019. Initially, I had defined 2020 as the first financial year in the system. So, now to import these invoices, I have shifted the first financial year to 2019, created periods, but i am not able to Generate Calendar nor even open the periods of the same year. Is there anything i am missing out here?  Thanks in Advance. 

1293
Chris Hackett
Community Manager
F
Jr Varsity III
frankfiorentino81Jr Varsity III
asked in Financials
Project Name in Financial Report Title

I am using the financial report writer to build a project P&L for my client. I am having trouble getting the project name to appear in the title since there does not seem to be a parameter available.In my column set, I have added:=@StartProject + ' - ' + THIS IS WHERE I WANT THE PROJECT DESCRIPTIONThe project code is an auto-numbered ID and without the name makes it difficult to identify the reports.Thank you in advance.

1157
F
Jr Varsity III
G
Freshman I
garcimig09Freshman I
asked in Financials
What's the best way to upload detailed GL activity?

I got this out Quickbook’s.I just want to  know what are people thoughts on tackling this. I just have to do a detailed upload from Jan - June of 2023.

891
Robert Sternberg
Captain II
N
Jr Varsity III
nasirh85Jr Varsity III
asked in Financials
ARM Report

How to print Billing and Bookings Amount in ARM Report?Below is the screenshot for reference: The Billings I manually grab the total sales from the P&L report. To only provide the weekly number of billings or sales. The report would look like this : Start Date: 7/1/2023End Date : 7/8/2023 Bookings : $598,477.13Billings: $476,910.84 The Next week it would look like: Start Date: 7/9/2023End Date : 7/16/2023 Bookings : $488,263.00Billings: $517,963.02

985
Laura02
Captain II
J
Varsity III
jwarrenVarsity III
asked in Financials
Can you perform a secondary function on an already aggregated function with GI?

Trying to sum multiple lines on a GI - and then use that sum within a secondary calculation. Is this possible in Acumatica? I seem to be getting varied results when attempting this per below.  

581
Y
Jr Varsity I
H
Captain II
HarshitaCaptain II
asked in Financials
Credit Note Creation without payment

Hello Linkies,I have been stuck in a situation where I have an AP Bill created in the system (Xero). But without capturing the payments Credit Note has been applied on it. How can I record the same in Acumatica?Thanks in Advance.

592
C
Semi-Pro I
D
devakumarrajkumar34
asked in Financials
Intercompany Billing

How to do an Intercompany Billing Process for Employees (Salary using Foreign Currencies)? 

200
D
L
Freshman II
LungileNjakazi37Freshman II
asked in Financials
Inventory Adjustment -specify sub account on a case by case basis

Hi Everyone.I recently had a question posed to me and I am still researching possible options. For inventory adjustment, the subaccount can only be specified through the reason code. Is it possoble to specify the subaccount outsdie of the reason code (directly on the adjustent)? Thanks

631
dcomerford
Captain II
B
Freshman I
boremFreshman I
asked in Financials
Prevent Wrong nonsense Year being entered on Documents

Acumatica allows for nonsense years to be entered such as 2222 and 2044 on AP and AR documents. How can this be prevented? 

798
B
Freshman I
H
Freshman I
helpdesk37Freshman I
asked in Financials
Assignment and approval

How do we create Assignment and approval map? On the Assignment and approval map we only have option for adding approval and assignment separately and there is no place for adding assignment and Approval map  

441
Laura02
Captain II
pandachan48
Jr Varsity II
pandachan48Jr Varsity II
asked in Financials
Can a purchase order created with a cash discount generate GL transactions?

 I applied a 100% discount to the purchase order, but the discount didn't appear in the Journal Transactions. However, this issue doesn't occur with the Sales order, as the Sales order cash discount is properly reflected in the Journal Transactions.please check the screenshot belowPurchase Order   Sales Order  

652
Laura02
Captain II
T
Varsity I
travislawson
asked in Financials
Is there a way to prevent back dating?

Is there a way or method in Acumatica that can prevent people from backdating documents? I know closing periods prevents posting in past periods, but our Controller wants to prevent the dates from changing.  He does daily reconciliation and it’s messing him up.  For example, in AP.  AP created a check on August 8.  They did not process the check until August 14.  When the controller runs the ending cash account balances on the 8th that check isn’t in there.  Then it throws off his numbers when she posted it on the 14th. 

2104
Laura02
Captain II
L
LJakupovski
asked in Financials
Outgoing email permission

are user rights required for outgoing email permission?  if so, what are the steps to assign rights to user?

380
L
B
Jr Varsity III
bernadeth58Jr Varsity III
asked in Financials
GL Error: Cannot update the record. The record InventoryItem (251-071) has been marked as deleted. Your changes will be lost.

Hi everyone.May I know what to do in this error? GL Error: Cannot update the record. The record InventoryItem (251-071) has been marked as deleted. Your changes will be lost.Scenario: sku 251-070 is wrong; it needs to be 251-071. However, 251-070 is linked to BigCommerce, so I don't want to create a brand new sku from scratch.Thank you.

2144
Irina
Community Manager
B
Freshman II
bduprey19Freshman II
asked in Financials
AP Incoming Document Security

Does anyone know if or how I can restrict what documents a user sees in “Incoming Documents”.  I need to restrict based on what company they are for.  I have different ap email addresses set up for each compay.

270
B
Freshman 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