Financials

Hi all,  We are excited to have an educational and partner focused webinar to help introduce LeaseQuery, ASC 842, and our partnership with Acumatica. Register below! https://leasequery.com/webinar-registration-acumatica-applying-the-new-lease-guidance-asc842/?utm_master=AcumaticaCommunity

The financial report shows the detailed account code description values for actuals, allocations and budget figures by department. Since the upgrade to 2021R1, the first column will show the data correctly, but those after that only show the totals that are from the formulas set out in the rows (no GL account values are displayed).The summary report for this information, where the accounts are not expanded, show all figures correctly.Has anyone else had this issue with this new version?

Is it possible to post a journal entry to an account-subaccount combination where the subaccount has not yet been established in the list of subaccounts?

I incorrectly input the amount of a credit memo and hit release. Is there a way to correct or delete? It has not been applied to an invoice and in open status.  Thanks.

Hi SirThere is a problem that i encountered below. Not sure if there is any way to solve in acumatica system?We have purchased item A USD1000 , however the item A will be temporary keep at supplier site for do some testing , we are holding the ownership of the item A , consider that is our inventory should reflected in financial report.In system , may i know how to locate these USD1000 inventory but not allow the system to allocat the order once order is placed for this item .Currently.we are try to put under different warehouse location but the qty is stil reflected under inventory qty and system will allocate the item once the order is placed where the item is not physical in our warehouse . Hopefully can get some solution for the above matter.Thank you  

Is it possible to change the match settings in process bank transactions. The ref. nbr. weight need to be Tran Desc - this field contain the reference details for the transaction. The Ref.Nbr field is bank generated and will not match to transactions. It will help if bank rules can be created for AP and AR transactions.Above will result in a greater auto-match result

Hi Not sure anyone know the reason that why only show the few of the bank instead of all the bank info?We should have 7 bank accounts but not sure why the current period balances is only showing 4 bank account? who can advise? 

I’m a user of 2020 R2.  I noticed that in the “Generate Intercompany Documents” screen (AP503500) - it shows all historic eligible transaction here, but i don’t see a button to dismiss the transactions that i will never ever need.  What this does is creates a giant backlog of transactions which Acumatica thinks are ready to generate intercompany tranactions that won’t ever be used.  This makes the navigation in that screen hard. is there a way to dismiss the unneeded transaction candidates if not, does anyone think introducing the “hide” functionality might be a good idea?

Version: 21.106.0024We use “No Rounding” for rounding and “#,##0” as formatting to display whole dollar amount on the report and but need 2 decimal when export to Excel for analysis. This works fine in 20R1 version, but 21R1, only whole number got exported to Excel, seems formatting actually truncated the decimals.

I would like to setup an audit on the Vendor name.  Does anyone know where I locate the field on the Audit Setup?I am working in 2020R2

Our company has an ongoing problem of customers paying twice for invoices that they pre-payed on because the invoice doesn’t show payments applied to that invoice. I have added a subreport to show an invoice’s payments. Now, I need a way to use the payment total on the main report, which I know can’t be passed from the subreport to the main report. I ask about this on StackOverflow before I knew this community existed and someone there suggested a DAC extension, which I’ve never done before. I’ve read through the 2019 R1 Customization guide and have a weak grasp on how DAC Extensions work. The problem is that all of the examples are shown for user entry fields and all of the examples I’ve found on StackOverflow are for user entry fields, too. I need a extension field that is calculated for the report and I haven’t found an example for that, yet. I’m waiting to get approval from the finance department to contact our third-party Acumatica support company, but in hope of getting it done a

I am experiencing challenges with Access right to company documentation.We have a 3 step processStep 1 - Receive supplier invoice for expense in Company A, Create AP InvoiceStep 2 - Create ARInvoice for the on charge to my sister company, create in Company A. ARInvoice is based on AP Invoice line detailsStep 3 - Generate the APInvoice, use Generate Intercompany Documents [AP503500] Process, from the ARInvoice - APInvoice in Company BMy challenge and I hope you can assist, I need to view the PDF/file attachment for the expense received from the APInvoice that is Step 1  on Inter company Process.The challenge is that the user in company B does not have access to the Company Access Role (company A) & hence cannot view the Supplier Invoice.We are on Acumatica 20.208.0031. Row level security for Vendor Access is activeWe do not want to give the user access to the Company Access Role.  How can the access rights be adapted to be able to view the Supplier invoice that was created in a diff

Hi SirI would like to do bank recon in system. However , i am not able to import the bank transaction that i extract from bank under excel file (refer to below)  Not sure what is the problem? Could anyone give me a guide/step to import/upload the bank statement transaction to system for me to do the bank recon?  

Is there way to create a TB starting balance update? We have already uploaded a starting TB and need to change a few accounts. From what I see, even when I only populate the Trial Balance screen with my desired GLs once I release and the Journal Transaction is created it includes every GL and assumes the GLs I did not populate I want set to zero and the corresponding journal tran is populated with that assumption. I am unable to delete any of the lines for GL I do not want to touch.  Other than just posing a manual journal can this be done through Trial Balance?

My client needs to create tax transaction from the General Ledger.  I cannot seem to get it to post.I thought it had a rounding problem but I set GL rounding to 0.05.  Still it will not release.  Version : Build 2020.5.7.3877

The form CA302000 does not contain a saved Reconciliation record. The message is received when the user attempts to select a Reconciliation link displayed on the Reconciliation Statements page

Do we have ? or can we have a option to see the GL posting effect (Dr/Cr) before releasing a transaction. Now we have to post the transaction to see the GL posting and if any mistake we either need to reverse or do adjustment entries.

Hello,  Our company is a 2020R2 users. In the course of our financial workflow, we would like to create AP Checks and Payments (AP.30.20.00) first and then link them to open AP Bills and Adjustments (AP.30.10.00) later.  This would be done because i would like to match AP Checks to bank transactions as soon as possible, and then book the proper AP bill. I played with it in our system, but it seems that Acumatica’s workflow is only to create AP bill first, then create a full or partial AP Check and Payment. The “Receivables” module allows for AR Checks and Payments to be created separately from AR Invoices, but not the “Payables” mode.   Is there a reason why i cannot create AP Check separately as unlinked from AP Bills? Thanks,Kirill

Hi AllDo you know if there is any AI  technology for Finance module in acumatica? If not ready yet, may i know if there is any intention to add in AI in acumatica? Hope to hear from you soon.Thank you

I am creating a from in report designer in which the font is not a standard (i.e. not found in the list of fonts in report designer). I have installed the font on my computer and created the report template with this font.When the report is run on Acumatica, though, the font is incorrect and the spacing is out. Is there a way to get around this? Or alternatively, how do I find what fonts are available on the server?Many thanks.Sue

HI,  When user enter the payable bill, need to distribute the invoice lines according to pre-defined ratios. Ex. Following AP Invoice header total is 10000.But in line level user need to segregate automatically according to pre define ratio.User expectation is when select the supplier and total amount in header level, line level should be created base on header amount.Avoid the data entry mistakes user need this. ​  RegardsNethupul

When entering a AP bill for a on inventory stock item (enter an invoice for Public Water Co. that is $1,000.00) we have to enter;Quantity 1, UOM each, UNIT Cost $1000.00, to get the Ext Cost Is there a setting we need to change to be able to just enter the bill total??

Dear all,We want to ask about how we can link between Budget in Finance module with Project Budget in Acumatica?Thank you for your kind attentionBest Regards,Agung Edhy Triyono

Our company is “new” to Acumatica. We have been on system for over one year. We post AP bills by Purchase Orders > Actions > Enter AP bill - Need to know how others are set up to have project managers approval for AP bills entered “thru” purchase orders.

Hi, Does Acumatica support Italian Accounting practices and Language ?Also is there a list of resellers/partners in Italy ?Many thanks.