Skip to main content

Financials

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

  • 2,496 Topics
  • 8,153 Replies
2496 Topics
M
Freshman I
martin52Freshman I
asked in Financials
AR and AP Applications - Documents to Apply to include Payments and Prepayments in Doc Type list

In the use case of customers or suppliers having open on account or prepayment amounts it would save time and help keep customer accounts more tidy if these payments/prepayments could be allocated with a payment.For instance:Customer pays a deposit or stage payments prior to being invoiced eg $500Customer invoice is raised for products or services rendered eg $5000Customer payment to settle invoices is received for $4500 - It would help to be able to select both the above transactions during the application process leaving all transactions in a closed status.  Currently I don’t think payment or prepayments are available on the Doc. Type drop down list.I hope this makes sense.

1132
M
Freshman I
J
Freshman II
jddonnell55Freshman II
asked in Financials
Branch ID vs Employee

Is there a way to have a branch ID be the same as an employee ID?If not, is there a way to rename branch ID’s or employee ID’s en masse?Thanks.

941
meganfriesen37
Captain II
M
Freshman I
mburke21Freshman I
asked in Financials
Error on Profit and Loss Period Sensitive Statement

Error on Proft & Loss Period Sensitive Statement when date range goes from 2022-2023. So if I ran a P&L statement from April - November 2022 it would be fine or January - March 2023. But when I try to run a report across years this is how it shows up: 

735
Laura02
Captain II
H
Freshman I
helpdesk37Freshman I
asked in Financials
Stock items

Where do you enter quantity on hand for a stock item

352
Laura02
Captain II
aborisova37
Semi-Pro I
aborisova37Semi-Pro I
asked in Financials
Expense Receipt - Billable by default

Colleagues,Do any of you know if there's a setting that can be configured to make an expense receipt billable by default?Thank you! 

1153
Robert Sternberg
Captain II
T
Freshman I
tschneider40Freshman I
asked in Financials
PayFabric AR/credit card integration

We are in the process of switching from authorize.net to PayFabric’s integration for credit card processing and AR automation in Acumatica. Our main reasons for changing are to simplify the payment process for counter sales since their credit card reader will feed directly into Acumatica and to hopefully improve AR collections with their ‘click to pay’ links on invoices and automated sending of past due reminders.Looking for feedback from anyone who has used or is currently using them.

350
T
Freshman I
B
Freshman II
blaid27Freshman II
asked in Financials
Once i have reversed a fully depreciated or overly depreciated asset , how can i delete it from the system so i can re-create the same asset ?

Once i have reversed a fully depreciated or overly depreciated asset , how can i delete it from the system so i can re-create the same asset ?

1021
Laura02
Captain II
R
Freshman I
ritchiecarcido43
asked in Financials
Generated monthly periods are clumped into 1 period upon processing Master Financial Calendar

Good day!I just wanted to ask about this kind of unusual error upon processing Master Financial Calendar.  The table shows that the data for the 12 months of 2024, from January to December, was aggregated into a single financial period which is 01-2024 while having a start date and end date of 1/1/2024 and 12/31/2024, respectively. May I know any workarounds or what should I do to correct this? Would love to hear your opinions on this matter. Thank you. 

430
R
Freshman I
E
Freshman I
enriqueyFreshman I
asked in Financials
Monthy expense by GL/Subaccount

Where can I get amonthly GL expense and revenue report. I need it in the following format Account Subaccount Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23 4000 100-000 1000 2000 3000 400 5500 700 800 900 100 1000 6000 100 5000 125-000 1000 2000 3000 400 5500 700 800 900 100 1000 6000 500   

1075
dcomerford
Captain II
R
Freshman II
RHarrisonFreshman II
asked in Financials
Reports formated for printing on legal size papaer

I have a number of reports that are printing formatted for legal size paper.  For example, the bank rec report.  How do I change this (and likely others) to print on letter size paper?Thanks in advance.

311
M
Varsity II
M
Freshman I
MBillRJT050619Freshman I
asked in Financials
Advanced Expense Managment 2023 R1 Issue - Manual workaround?

Hello, we recently upgraded to 2023 R1 from 2021 R1 or R2. Our third-party support company did the bank feeds migration and we have set up all our cards, but it is still not working. I have been told that there is data missing from what our bank is sending through Plaid to Acumatica. I can import the bank transactions, but it is not auto creating expense receipts due to the missing data. Is there a manual work around to create expense receipts? We are going over 3 weeks without expense receipts hitting our books/project costs. We need to get those costs into Acumatica. I don’t even see a way to manually import a file into Acumatica to get it to create expense receipts.Our third-party software provider has submitted a Case to Acumatica, but that was two weeks ago. I am hoping someone on here has a workaround that would work for us.Our bank is Wells Fargo. We have one main control account and then several sub accounts. Each sub account does have its own account number. In the previous ve

1000
M
Freshman I
H
Freshman I
helpdesk37Freshman I
asked in Financials
Mark for PO is not visible on the sales order form

 

1084
H
Freshman I
H
Freshman I
helpdesk37Freshman I
asked in Financials
CREATION OF SALES ORDER FROM PURCHASE ORDER

When creating a Purchase order from the sales orders is it possible to mark for PO  Sales order which are backorders

651
dcomerford
Captain II
K
Freshman I
khowe86Freshman I
asked in Financials
1099 - TCC

Hello fellow Acumatica users! :)Do any of you know where to add the TCC code from the IRS to submit 1099’s? Thanks,Kay

493
K
Freshman I
M
Jr Varsity II
mluproJr Varsity II
asked in Financials
Invoice stuck in Pending Payment Status

Selected an invoice for payment.  Created an ACH Batch.  Decided not to pay that item.Deleted the item from the Batch.  Processed remaining items in the batch and uploaded to the Bank.The invoice is now stuck in Pending Payment status and I’d like to remove that status so the item returns to Open Status.  Cannot find a way to do that.  Suggestions anyone?Mike

3097
M
Jr Varsity II
C
cwinslow
asked in Financials
Is it possible to have an approval flow on a bank rec?

Currently bank recs are completed within Acumatica by a staff member and then reviewed by myself.We have a separate checklist where the staff member notes when it was completed, and then when I review it. I’m looking for an efficiency gain……………Is it possible to either set up an approval flow or possibly utilize the Task feature to accomplish a similar result?

662
meganfriesen37
Captain II
claudematherne24
Varsity I
claudematherne24Varsity I
asked in Financials
Holding inventory at $0 Price and $0 cost

I am looking for a way to hold inventory at $0 and $0.  This general idea is that I have used inventory that we want to bring into and out of a location.  With this inventory being used, we do not want to value it at all in our GL.  These inventory items have the same inventory ID as new items that we want to value. I’ve seen the options in the Warehouse Location to cost separately, but I am still seeing the value sitting when I run an inventory valuation report.

1086
claudematherne24
Varsity I
jyounes
Jr Varsity II
jyounesJr Varsity II
asked in Financials
Add to Schedule - Greyed out

I cant get the add to schedule to un-grey.  I’ve made these before, im not sure what im missing.  

543
jyounes
Jr Varsity II
H
Captain II
HarshitaCaptain II
asked in Financials
payment recording in multi-currencies

Hello Community,I am stuck in an issue, where my company, in Acumatica, has the base currency of EUR and the payments recorded under this company’s cash account is in SGD. So here I have the Bills and Invoices in multiple currencies (AUD, MYR, INR etc). I have been migrating the data from Xero to Acumatica, so all the previous payments that have been recorded in Xero has the company been created with base currency of SGD, and also the cash accounts in SGD. Can you please suggest me how can I now make this in an easy work around in Acumatica for recording the payments? 

1263
Kandy Beatty
Captain II
K
kdurden
asked in Financials
Depreciation

I have multiple fixed assets that in their FA profiles have a status of fully depreciated, but also show 0.00 accumulated depreciation (balance tab) and no depreciation transactions (depreciation tab).  I’m trying to reconcile the FA Balance by GL report to GL and these assets are missing in my report for accumulated depreciation.Is there a situation where the above would be correct or did we do something wrong?  I believe these are only imported assets that are this way, if that helps.  (majority of imported are correctly showing fully depr though and i see no other differences)

1501
B
Freshman II
B
Freshman II
blaid27Freshman II
asked in Financials
Reverse depreciation once it is either fully depreciated or overly depreciated and posted

Good day , I am trying to figure out if there is a way to reverse and start the depreciation from beginning for assets that have either been fully depreciated or overly depreciated ? All the assets have been posted and i cannot figure out how to reverse and start again ? 

3152
A
Acumatica Employee
H
Freshman I
helpdesk37Freshman I
asked in Financials
Purchase order form having misleading information

Hi@ all, I have a scenario where the Excluded prices in a purchase order exceeds  included prices At first I thought that it was a report layout issue but for sure it’s not. Why might be the course this?

262
H
Freshman I
R
rupesha23
asked in Financials
FH_FileCreationDate Under batch payments screen

Getting Error “Field is not supported by the provider FH_FileCreationDate”Under batch payments screen.When trying to generate an ACH batch file, the following message appears:

220
R
E
Freshman I
enriqueyFreshman I
asked in Financials
AP Aging filter by subaccount

I need to show the outstanding payble for a certain subaccount. How can I filter the AP Aging by subaccount? Are there any other reports that allow me to do that?

692
ricoybanez
Jr Varsity III
dsimmerly
Pro I
dsimmerlyPro I
asked in Financials
Adding Multiple approval maps

has anyone had the project to add a large number of approval maps that are similar but different?  can they be copied?  can they be created with import ?  other suggestions?this is AP bills approval with a different set of approvals based on numerous sub accounts 

1031
ricoybanez
Jr Varsity III

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