Financials

Had a question come up recently and not sure how to answer.  Has anyone had this issue before? In using the AP Document Recognition, we have experienced Acumatica bypassing the needed invoice on page 1 and instead grabbing header data from page 2 of the pdf document which is usually a supporting sub-invoice to the actual invoice that should be addressed on page 1. This does not seem to improve with machine learning after several invoices from the same vendor. We are using version Acumatica 23.111.0019. Have your customers reported this and do you know if it has been improved in subsequent Acumatica versions.

Hi, is there anyone that has had success bringing in check numbers from a corporate checking account into Acumatica bank feeds (via MX or Plaid)? Our current bank feed with current bank only shows the word “check” with no actual check numbers. Also have a number of corporate credit cards who will no longer be supported via MX or Plaid through my bank Curious which banks anyone has successfully accomplished this functionality (JP Morgan, Bank of America, Truist, etc)

As a legacy of a prior configuration our instance has 1,000,000’s of customers which were used one time, and now sit there slowing down the system.If we set these to inactive should we expect a speed/performance benefit around the sales order/AR screens that reference customer? Currently it takes an eternity to load/search for customers

Hi All, Client is busy with Processing bank transactions but is getting this error object reference not set to an instance of an objectPlease advisethank you Dries

During a standard PO return. The item was selected from the Purchase Order Receipt (POR) - The vendor is clearly listed on the PO and should be in bedded within the PO. However, during the process, a new vendor name popped in and was not discovered until it was Released. The POR has the correct vendor, the PO has the correct vendor - but the Return has a different vendor. How is the even possible? Any suggestion on how that could happen, or what setting would cause it to happen. Could timing out and logging back in cause the error? Thank you for your assistance.

Looking for a way to send ACH payments without leaving Acumatica. Is this available?Basically some sort of integration with bank, or a way to automatically transmit the NACHA file. 

I need in formatting profit and Loss financials Statement so that you can see it monthly. As a trend Like January to April 

Hi All,Are there a report in Acumatica that I can show to the auditors.Auditors need to see if the users have posted anything to Acumatica in 2023, and if they have posted transactions, what they posted thxDries

Hi All,Are there a report in Acumatica that I can show to the auditors.Auditors need to see if the users have posted anything to Acumatica in 2023, and if they have posted transactions, what they posted thxDries

Is there a out of the box solution / setting to always exclude credit or debit memos from Statements?

Hi all, Does anybody have a import Template for Fixed assets balances to share with me. thxDries

Hi I was trying to an audit history of the person who has created a Journal Entry and the name of the person who approved the transaction. Unfortunately, I could not find any option in Acumatica. for your information, I followed the following steps,Audit History when you click on the “Audit Historyit gives only the person's name who had lastly modified the transaction BUT not the name of the person who had APPROVE the transaction.  As you can see in below-screenshot, someone has created this Journal. Another person checked the entry and did the bank reconciliation. The system indicates the same person's name as the ‘Creator’ and ‘Modifier’ which is not true.  Much appreciated if someone has any idea about this.

Good afternoon,We are using Banking -  Bank Deposits as a way to reconcile and for some reason we cannot locate the payments under certain Payment Methods...is there a dumb reason we are overlooking on settings that we need to alter?Our check payment method works fine, but we cannot seem to find ACH or CASH payments under this umbrella.Still fairly new to Acumatica, so I’m sorry if its an easy question!!!!  

Hi All, How do I copy this report from on tenant to another tenant thank youDries

Hi,I’m trying to translate GLs related to intercompany transaction and post the foreign currency difference in another unrealised forex GL eg. GL1234 while the rest of the GL’s forex differences goes to the default unrealised forex GL 6789. They are the same currency conversion eg. from USD to CAD.Or the intercompany foreign currency can be posted to the same GL6789 but different subaccount to differentiate them.Can anyone advise how to set this up?

Thank you.

Good morning,I am curious if there is a tab or possibly a report already created that could possibly show me all my customers that have NO open orders in Acumatica but also paid via certain methods of payment (cash or check)?In short, I am looking for a shorter way to approach finding customers that I need to cut refund checks for because they paid via cash or check.I am currently just going through and Aging AR report and looking basically one by one at all the customers.  But the AR report also shows all customers but also customers that have available balances due to open orders in the system.

Hi everyone,I'm looking for guidance on two tasks in Acumatica:How can I create a list of vendors that includes their email addresses? How can I generate a report that shows vendors and their associated subaccounts?Any detailed steps or resources would be greatly appreciated.Thank you!

Hi,Is it possible to change the post period for an vendor bill after it has been approved?Thank you.Regards,Raymond 

Hi,I have used bonus option in for the fixed assets which needs to be fully depreciated at purchase in Tax book. Once purchased it is fully depreciated and the net book value is zero .Now I want to change the depreciation method of the tax book to the same depreciation method as actual (Accounting) book. That means the asset needs to be depreciated same as accounting depreciations. I cant remove or edit the bonus field. I did a depreciation adjustment and re-ran the depreciation, but still it depreciates fully because bonus is applicable. Is there any way that I can remove the bonus method and let the asset depreciate over it’s useful life? Thank you,Dulanjana

Hi,i’ve had a few customers ask me if there was a calculation function within acumatica to add things within the amount field.  I wasn’t sure if anyone had seen this before? Thanks!

People are voiding payments that have already been deposited to the bank and it makes for A LOT of unnecessary work when reconciling.  In my eyes, there should be no reason to void any transaction that has already been released in a deposit.  If, for whatever reason, you need to void a transaction; you would need to first void the deposit, do what you have to do and recreate the deposit after.  Once a payment is deposited, it should be locked; period. Even Quickbooks had this capability; it’s very simple because the transaction is posted to the ledger when released in a deposit.  But if this is too much to ask, we should at the very least have the ability to restrict certain users from making changes to released payments, especially if they have been deposited.   Does anybody have any thoughts or workarounds to avoid this from happening?

Hi All, I am trying to copy an arm report from one tenant to another. For some reason I am doing something wrong because I cannot see it on the tenant I imported it to.

SWK (our solutions provider) has mentioned multiple times that Acumatica has the ability to accomplish split payments on Purchase Orders. Example we receive 10 items into inventory. The total for that PO is $14,010.00We have a vendor where we make payments on that particular PO in 3rds.If we received the inventory in July and our first payment due for that order is August 10th in the amount of $4670.00. Next payment will be September 10th $4,670.00 and August $4,670.00 completing the total payment for that invoice.  How do we accomplish this?

Good day, I have a client that asked me to do a Rejection Notification using email, i have created a Business event with the Trigger New Fiel Value Expense Claim status equal Rejected: Using this template (Note, I have removed the clients email from the FROM field):Make several attempts with differnet fields like Expense Total Greatar than zero (Using Operator AND), and diferent Expense Claims emails TO fields.Be advise that the my client has a Expense Claim Approval Mapping and a Notification setup for that on the Time and Expense Preferences. Any help is highly apprecaited.