Financials

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.

Hi SirWe have encountered a problem about the inventory , we make mistake do receipt in a part # where that should be use existing 5 parts to do kit assembly into one part # . Currently , our system have extra 5k in inventory history valuation but in financial inventory account is correct . We cannot do adjustment transaction as it concern about double entry where it will affected financial account figure.May i know if there is any way to do offset the extra 5k in inventory but not affected the financial inventory figure?  Hope to hear from you soon.Thank you

Hi allFirst time here so please bear with meWhen choosing a Customer in Payments and Applications on a specific date ( July 8th ono.) it goes blank. But when in Profile and choosing Actions- Payments and Applications the process is allowed.

Hi Everyone ~After years of using Quickbooks Online I have recently taken a new job using Acumatica. It’s been a learning curve, so many moving parts in Acumatica. Here’s my question:  The company I work for receives inventory items that are paid by credit card and there is no PO. How do I enter the inventory and the bill that goes with the items.  Thanks for your help. 

Hello Acumatica! I have a question (a dumb one :p) ; can we import a transaction with Batch Module = AP ?  Thnx :) 

I need to create a Parent - Child relationship between APTran and ARTran tables. The artran.OrigInvoiceLineNbr field has no value (value is NULL) on the existing data. Can I populate this field with the APtran.LineNbr value for reference in the ArTran table?

We are trying to change the description field in the timecard.  We have found that the “Summary Day for:”  is very confusing.  We would like to make the Description field be filled with a single ‘ or a , .  This makes the Summary day for: go away.  Has any one defaulted the description or know how to. My next project is to make overhead tasks not choose Billable when the employee uses them

On the Revalue AP Accounts form, I specify the settings to perform the revaluation of open AP documents. The Revalued Balance > 0.  When I release the transaction and review the Journal Transaction for the revalue AP.  I notice that the generated batch has a 0 Debit and Credit AmountNotice that on the Revalue AP Accounts screen the Revaluation Total value is not 0How do I resolve this? 

On the Budget Form the Stat Ledger is defaulting in the LEDGER field.  When I run the Budget Import Scenario the first branch gets imported to the budget ledger but the following branches go to the statistical ledger.  I have hard coded the ledger on the import scenario and I have tried mapping the field.I think the issue with the default ledger being incorrect is causing the incorrect import results.Has anyone else experience this?ThanksColeen