Financials

Currently we use an old fashioned spreadsheet to track customers balances that have been sent to collections. Does Acumatica have a better tool within its system to track these? 

Hello, I am hoping someone can help me to grey out the email field on invoices to customers who do not have an email set up in their profile.Customer was sending them to herself first to review them, and then would forward to the customer from her contact list??

Hi All,i’am nubi here, and like to ask a question, there is something strange, why when transactions using tax account 111001 in the journal appear account 710205 Rounding lost account in the last line

Can Financial Years be defined by Company within the same Tenant?Example:Company A Financial Years = Calendar (Ends December 31) Company B Financial Year ends June 30th. Company C Financial Year ends April 30th.

Does Bank Feeds support v2021 R2 yet?

Is it possible to post a vendor payment to the Undeposited Funds GL? We use PayPal for both incoming customer payments and a few vendor subscriptions. PayPal includes both of these transaction types in our daily deposits, but we are not able to match our deposit records with PayPal’s activity because the vendor payments are not available in Undeposited Funds as we create our deposits. They would post to the Undeposited Funds GL similar to a customer refund. Thank you in advance.

Hi Team, I have a query on “Chart of Accounts”. If we have a Two companies in a single tenant but we should have two different sets of Chart of accounts for each company. Can we able to do that or can we create Chart of Accounts specific to each company.Awaiting for your valuable comments. Thanks,Nithya

Anybody has a script that develops opening closing balance for balance sheet accounts. I have developed a script based on SQL MAX function but this only gives a latest closing balance. I need a script that allows a range for a Power Bi report.I have seen in Report Designer that for the Trial Balance it pulls from a field called “AHLast” but have no idea where this comes from

We have recently been getting this error, "Type mismatch in the expression: '-'.", when a calculation in a column attempts to subtract one column from another, i.e.: =B-C. Both columns B and C are GL column types. The formula =B+C works but the formula =B-C does not.Has anyone encountered this error before?

We have a client that sent out a 1099 to the wrong vendor and tax id. They need to reprint a zero dollar 1099 for the vendor. I have fixed the balances in AP but the 1099 form won’t print a zero dollars. Any idea how to do this? 

Hello!The AP aging report is calculated based on the due date not from the document date. Is there any possibility to change the Aged Based On type to Document date?Thank you,Regards,Amanda Pallawala

Hello there How does Acumatica allow me to for instance pay a USD invoice on the system with a bank entry in a different currency say GBP and have both the bank entry correct and the allocation against the Purchase invoice correct as well So for example : you have a USD purchase invoice of USD1000 and you pay this amount but through your GBP baml account and the exchange rate on the payment was 2/1 and so the GBP bank entry should be GBP500. I would expect to be able to make the payment entry as USD1000 and fix the exchange rate at 2/1 and for the bank entry therefore to fall out as GBP500 to match the bank entry. We will have this happen quite a lot as we have an employee who pays invoices in many currencies on our behalf and the PO and the Vendor invoice is entered in the originating currency but the bank entry paying this employee back will be in another currency so it could be A: Vendor Invoice RMBB:Vendor Invoice EuroC: Vendor Invoice GBP We need to clear these entries and allocat

Does anyone know if there is a way to specify a Vendor lien waiver form based on the Project or Customer?

Is it possible to send Invoices and documents in one email without dragging and dropping attachments?

The item ID for non-stock and stock items only allows 10 digits. I would like to increase it to 25. How I can do that? I am on 2021 R2 version.  

Hi,Im trying to create a purchase receipt for a stock item that is in the ‘no purchase’ status but system is giving me an error that you cant create receipt for item with no purchase status.Any way i can do it? we still need a receipt for it since at the time of creating the PO it was still a purchase item.

Can any one tell me how to Reprint Checks in Acumatica? I prepared my payments and processed, but an error came up...not sure what the error said, it was only up for a sec. So I hit the process button again. So now the invoices are showing closed and I have not checks. 😔 

Can Lien Waivers be generated automatically from AP when creating a bill related to a Project?Now only the waivers are generated automatically if a Po is created in the project and an Ap bill is generated from this PO.Vivian 

How can I set up a payment terms for the 10th day of the month following the invoice date? Example: Invoice Date = 03/09/2022                Due Date = 04/10/2022

The current Calculate Commissions process ONLY computes commissions for salespersons.  No financial transactions are generated from the Calculate Commissions process. I’m suggesting an enhanced process that would debit Sales Commission Expense into an expense account associated with the salesperson and a balancing credit to a Sales Commission Payable Liability account.  There are other Ideas in the Acumatica Community that request posting commissions into an Accounts Payable vendor and I support those ideas as well.  Credit A/P - Debit Commission Expense. Currently the reporting for Sales Commissions is inadequate.  The report of commissions by salesperson does not list the customer, invoices, or amounts that comprise those totals.  The Commission Details inquiry does not list the Salesperson responsible for the sale.  It is a challenge to get a GI that provides all the information a controller would need to make financial entries into the general ledger and get the salespersons paid.

Hello thereWe are an importer of goods and often use sea shipments from the Far East, which means we are invoiced in full by the supplier when the goods are handed over to the agent at the port (say month 1) and then the goods can take up to 9 weeks to arrive and then they are booked in (say month 3).With previous software I have had two date fields, one the posting date which is when the entry arrives in the accounts and two the document date which is the date of the suppiers invoice. This way the invoice would be entered as the same date as the receipt of goods but the aging could be arranged by document date. All very helpful. Acumatica has only one date field avaiable for a purchase invoice and I am not sure what to do for the best. I know we could probably use Goods in Transit booking which is technically the correct way but we prefer not to as we are such a small company and would prefer one entry instead of two. (booking goods in and then transferring them once they arrive)….Doe

Hello,I am aware that Acumatica has a dedicated account for keeping track of the YTD Net Income balance and with every income or expense transaction, this account is updated. Furthermore, as documented in Acumatica’s Help material (see below), Acumatica automatically updates the Retained Earnings account for the next financial years that are defined. The system updates this account for every transaction posted to an income or expense account. When the system updates the balance of the YTD Net Income account, it also updates the beginning balance of the Retained Earnings account in the next financial years for which the financial periods are defined. For a new financial year, the system resets the balance of YTD Net Income to zero for a new financial year. However, for auditing purposes, when a user looks at the Account Summary and Trial Balances for the retained earnings account, the Ending Balance of the last period of one year would not match with the Beginning Balance of the first p

Hi,In the invoices form (SO3030PL) always system picks the sales account which is mentioned in the stock Item if a stock item is available in the invoice. Even though we change to pick the ledger account from posting class or warehouse by posting class, it always pick the account from the stock item.Is it possible to change this to pick the sales account from warehouse or posting class ? Thanks

Hello Everyone, As I am a newbie to the Fixed Asset module...i did a big BUBU...I uploaded a list of fixed assets but later was told that that is not the final list, so how can I erase the first uploaded list? or should I just override the existing list, is this possible? Thank you! Kind regards,mrivera67

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.