Financials

I want to know if I do not have the Projects module licensed and I want a similar option that is the Account Groups under the Chart of Accounts function what can I use to further group my GL Accounts.

has any of you change the currency decimal places at a latter stage of the system?

Our construction company recently went through implementing Acumatica. I have Bills and Debit Adjustments that have been closed but still show on my AP Aging because there was retainage that was unreleased when the Debit Adjustment was applied to the bill. Is there any way to undo this?

Report:  Exported to Excel: I currently use P as format in column set.

Hi all,We create a prepayment from Bill & adjustment with project. (Document A) at this time It Does not generate any transactions to GL and not on the aging after release.When we pay prepayment, we do in Check & payment with Check type and Apply the prepayment number A. We also update Project in financial tab, At this point the PP is on the Aging, and update transaction to GL.But when we run the aging report, it does not show the project.Does any one have any ideas, please share with meThanks in advanced.​​​​​​

Hi,I’m working on a ARM report. The report shows the data expanded by sub accounts for some accounts. I need to add unit set to the report. the unit set should be triggered by a on segment of the sub account (the report should be filtered by the segment of sub account)Example - Sub Account 1 - ORG-DEP-000. in here, in the middle shows the expense category. there are multiple expense categories which is the second segment of the sub account. How can I create a Unit set to filter the report using that middle segment of the sub account.  Thanks,Dulanjana  

Is there a way to merge duplicate Vendor accounts that carry PO and PR transactions?

I have created a new company- TESTCOMP on the Companies (CS101500) form and activated it. But its not getting displayed in the company selection menu. Kindly let me know if I am missing out here anything. Thank you.

Hi Team, Do we have the concept of “Low value Assets” in Acumatica. Which means if an asset has minimal cost then it should be considered as low value assets and it should be depreciated within a year or less. Even though it has useful life more than a year. Any threshold limit is available for the assets are considered as a low value asset. Awaiting for your replies.

I am having several issues when applying customer payments as they come in.One issue is where a customer might issue us a check for $50.00 more than the invoice was created/open for. I cannot apply the $50.00 overpayment as I get the error stating the payment must be less than the balance.Customer mistakes like this are extremely common. How can I receive the check in and keep my customer’s balance correct (I should show them a $50.00 “credit” for the overpayment when all is said and done)

I understand that it’s suggested to not changing the decimal precision of a currency once transaction created and released. But, I just like to know what the problem exactly is. There are indeed transactions have been made on the currency (this is not base currency setup in the system) but most of them are having two decimal places on the amount, only one AR invoice has 3 dps. If this invoice is reversed and the decimal precision is changed from 4 to 2. What might be the impact? 

I have a prospect that receives payments for a scheduled training session i.e. month-1- payment is received however training can be scheduled to take place in month-3- but very often training classes are not yet full so they push training out again say to month-4-. How flexible is our deferral codes or deferral schedules in these instances? I.e., if a scheduled month or two months are missing and do not get ‘run’ or posted, what happens? Can they just skip months as necessary, then run the applicable month and update the schedule somehow? Thanks,

Hi Guys, can you give me an idea how to apply an Customer AR Invoice to another Customer Payment document? although both customer does not have parent child relationship.or how include Vendor/Customer ID in Journal entry document?

Hi Everyone,Is there a way to set a naming convention for a pdf file upon exporting? Thanks !

When generating financial reports,  users have long requested the option to export consolidated reports and unit sets to separate tabs in Microsoft Excel. Instead, Acumatica publishes financial report data to a single Excel tab requiring significant manual copy and paste work to create the desired report.  It is possible to make changes to the report and use the power of Excel macros to accomplish splitting the report into multiple sheets.  For details on how, see the following article:Solved! Exporting Acumatica Financial Reports Data to Multiple Excel Tabs - Dynamic Tech Services

Hi guys, in some countries (e.g. Germany) the accounting regulation requires corporates to carry forward the balances of the general ledger to the new fiscal year. It’s basically like a reversing entry, to take every account balance out from the last year’s ledger and record the exact balances into this year’s ledger. Is it possible to do this in Acumatica automatically? Thanks!

If I change the default cash account for AP on the Payment Method and Vendor Class level, is there a way to push that change to all existing vendors? 

I’m trying to generate a report to submit to the bank for positive pay.  The check register has everything I need except it only shows 10 characters of the Vendor Name.  Is it possible to show all of the characters? Thank you!

Prior to 22R1, we were able to display AP Bill Line data linked to a Project Invoice.The joins to get from ARTRan to APTran are:ARTran Left Join PMTran on  RefNbr = ARRefNbr AND  TranType = ARTranType  LineNbr = RefLineNbr PMTran Left Join GLTran on  BatchNbr = BatchNbr  OrigLineNbr = LineNbr  'AP' = Module GLTran Left Join APTran on  RefNbr = RefNbr  TranLineNbr = LineNbr  Module = 'AP'  TranType = TranType Acumatica used to populate both he orig doc number and the line when posting the GLTran row, but they stopped doing that in 22R1.The Tran Line number is NULL now.Our clients need to see  the AP Bill details related to the Invoice.Is there another path to join ARTran to APTran with project invoices?Thanks

Hello All,Trust you are fine.I was about running disposal of fixed asset and it complains of UNRECONCILED ASSET CAN NOT BE DISPOSED. However, The depreciation has been calculated up to the month of disposal Please, any help on how to reconcile under the reconciliation tab and what is meant by that. Thanks in anticipation of swift response from the community.

Good day I am seeking assistance on how to sort my expense items on the Profit and loss report high to low. This needs to sort automatically each time the report is generated. Is this at all possible? Help will be appriciated. Regards 

Hi allDoes anyone know how to apply an Customer AR Invoice to another Customer Payment document? or vendor bill to vendor prepayment document.Thanks so much! 

I’ve been trying to create a GI report listing all the Balance Sheet account code closing balances at each month end across multiple years. The aim is to export that via API to Power BI in a kind of clean CSV state i.e. no grouping, just rows and columns.So I want one row for each account code and each month end date. My first attempt generated 3,600 rows so it’s not that large a set of data.My attempt is 95% right but it’s missing key values and on reflection I think I’m using the wrong set of tables (or in the wrong way) but the documentation isn’t good enough to work that out.The reason it is wrong is when I compare the output to the Balance Sheet Financial Statement report I get some differences, but I can’t see why they are different. I have realised that the report doesn’t give me balances at a month end if there are no transactions in the month. I can fix this through a Power Query custom function but sadly I am still getting some errors. My model is as follows:tables: GL.Accoun

Trying to get a GI that shows the requested period trial balance with subaccounts.     Managed to devise one but it only shows the nominal account/subaccount if there has been movement in the selected period.   Has anyone managed to create one successfully that could share the details

Hi guys, I have a GI listed ending balance for current assets and current liabilities accounts by period. To create a dashboard KPI weights based on this GI, I need to create a filter for current month. Is there a way to define that “FinPeriodID = Current Period” ? Or is there a way to convert FinPeriodID to Month or Date? Because I know I can do a formula on filter for Month and Date, but not Period. :(