Financials

Does Acumatica offer a basic Expense Management Module instead of the Advanced Expense Management?  We are looking to implement a third party Expense Software and would like to simply import the transactions into Acumatica.  Our current understanding is we need to use AP Bills but we would prefer to have a way to capture/track employee expense transactions separately from our vendor transactions. 

Trying to import AR Invoices from old system using out of the box import scenario.  When running the import, the first line of the spreadsheet imports and then I get an error on the rest.  Screenshot of the error below.  Any ideas? 

Hi  May i know if anyone know how the acumatica system auto send customer statement to individual customer on every month?Can share with the step of this automation?

How to remove employee credit cards from the bank feed? We have several credit cards that have been disabled and do not have transactions for at least 45 days because employee no longer works for us. Our bank does not have it listed as an account either because as soon as employee leaves the company, we disable and delete that corporate card. Thanks in advance. 

Hi everyone,Several of our main large volume invoice vendors are paid once a month (i.e. 10th of month, 15th of month, end of month). The problem is, they are all paid on the second following month (i.e. Any invoice in January is due March 10th, March 15th, March 31). Any suggestions on how to best handle this in Acumatica which only has options for day of next month but nothing for second month.

I created 4 donut widgets showing sales mix between locations.  However, some locations dont have all the types of sales that other locations do so the colors don’t align between the widgets.  How do I have each donut widget show all the sales types so that the colors align?   Thank you!! 

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 

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.

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) 

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,

Does Acumatica have integration with Stripe Payment Systems? Thanks

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

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? 

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

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.

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!

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. 

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.

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

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.  

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.

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

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

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

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