Financials

I have migrated approximately 460 fixed assets that now need to have their Purchasing+ transactions released while still in initialization mode. Using the ‘Release Fixed Asset Transactions’ screen requires that the ‘Update GL’ box be selected, however, since these are migrated transactions we do NOT want the GL to be updated.I am able to release the transactions one-by-one while in initialization mode. Is there a way to mass release these transactions while remaining in initialization mode? 

Client has attached the wrong PO receipt to the Landed Cost? How do they correct?

Hi All.I want the system to refresh the currency rate from EUR to CHF daily automatically. So I created an automation schedule of “Refresh Currency Rates”. It is being executed at the scheduled time, but there’s no processed reocrd (see below). Could someone please tell me what’s wrong? Thanks!And the settings are the following: 

Is it possible to change the account group type? I set up an account group that was linked to all asset accounts, but the type was listed as expense, and now I am unable to change it to asset. Is there a way to adjust this?   

Is there any sales price history tracking report for sales orders item-wise and AR invoice item-wise?

How does one filter the Purchase Order Receipt and Billing report to only show Unvouchered Receipts?

Does anyone know of a way via REST API to trigger the reverse application action on payment/application History Tab  

Hello,We are running into an issue currently where users are able to see all AP Batch Payments under the “Batch Payments” screen even if they do not have access to that Company/Branch. When they click into the batch, they are unable to see the payment details, however if they have access to the Release function, then they are able to release that batch. Is there any way to prevent a user from releasing a batch that is not within their branch access list? And/or can we restrict their view from the Batch Payments screen?Thank you!Ashley

We are currently paying expense claims via payroll, but considering to move paying expense claims via AP. What does your company do?

Does anyone know how to capture production losses for financial purposes in the manufacturing module?now we found that kit assembly production loss cannot record, In finance side, production loss cannot count into production costhow to record the production loss in the manufacturing module. (raw materials loss during the production)Is there any setup/configuration we need to do configure to capture the production loss cost?

I’m investigating the new module Global Financials.  We are trying to determine if the module is ready for prime time, or should we hold off for now.  We’ve been struggling to find detailed information regarding the module and thought that this would be a good topic to help others understand the state of the module release.If you have knowledge, please share thoughts on:General product viability. The value proposition to clients. Any experiences with product support?  Is the support team knowledgeable and able to support partners and clients? Customer success and satisfaction with the module. Demo Resources, either demo databases, or demo scripts. Other information to help assess the module. We will be investigating further and will share information as it becomes available. Any thoughts will be greatly appreciated. Thanks, Mark​​​​​​​

Hi All,I have seen that the report Cash Flow Forecast CA401000 give the information of cash in & out by customers.We got the issue customers usually pay partial invoice for project invoice (because of their own financial issue), so it caused the wrong cashflow report CA401000 which is calculated based on the due date of whole invoice.Is anyone have any solutions for this case?Thanks in advance!Yên Chi  

When using the run allocations screen, GL batches for allocations are generated on-hold or balanced.Is there any way of changing the status to auto-release? There are multiple daily allocations, and manually releasing them every day doesn’t feel like a good use of time.I have considered an automation schedule for Release Transactions, but the problem is we can’t filter directly by Type: Allocation, so other GL batches which we don’t want to release also end up in the same schedule.

Has anyone seen this error before for inter-branch mapping. We’ve tried saving multiple times for the past few days but no luck: 

Hi Acumatica,I just want to ask how the prorate set up calculated in contract management?I just have an initial contract amount of 6,000 (Qty 2 , Cost of 3,000) and then when I upgrade to have  (Qty 3, Cost of 3,000) upon Upgrade of Contract it generate an amount of 2,771.74. My main question is how the system calculate the pro rated amount.Please see attached screenshot for your reference. New Contract Items upon Upgrade : Contract Template Upon Upgrade :Customer Contracts upon Upgrade:Seeking for your assistance for this concern. Thank you!

Hi AllNot sure if anyone know how to define the column C below in RED BOX detailsCurrently , i would like to create a Balance sheet Report comparative month to monthExample: Balance Sheet Report Comparative  Sept 2021 and Aug 2021I manage to set for Sept 2021 in column B  , however i am not sure how to set for Aug 2021 in column C , Refer to below in RED BOX highlightedI tried the formula in  = Format( '{0: MMMM d, yyyy}',Report.GetPeriodEndDate(@StartPeriod,-1)) is not workable.May i know who can help in this formula?  

Hi All,I am trying to retrieve Account class value on a col set based on row set account class value.My row set is set to expand based on (code-description) but one of my customers wants this to account class next to the account code.I have tried using @startAccountgroup and @endaccountgroup. This has not worked.If any suggestions please let me know.  

Is there a way to configure the scenario we use for “Export AP Payment to ACH” to not use=Left(Provider.Coalesce([APPaymentList.ExtRefNbr],[APPaymentList.RefNbr]),10)But to instead use the [APInvoice.InvoiceNbr] field? There is another question about this in the community:but it has never been answered. Is there a way to join to the APInvoice table in order to bring this field into the ACH export file?

Hey everyone, I’m coming up short despite setting up tax categories, IDs, and zones. We have a customer that’s loading historical data with line items on invoices and they want to bring in tax line items but this error keeps coming up. Am I missing something? “The CA tax cannot be applied to the document because there are no document lines whose tax category contains the CA tax.”  

How does Acumatica handle items that contain a bottle deposit charge for states that have bottle deposit laws

Hi Support,  Please help how to check error with these error.  

Can we adjust ending cash account balance in module banking of acumatica 

Hi guys.Please can you give me some suggestions. There are certain batches related to a specific subaccount that are not appearing on the on the Trial Balance and GL. What could be the cause and what can I look at?

When I open trial balance, it show me ”account cannot be mapped”. How to solve it 

 Hi, We created 02 companies in 01 tenant. The base currency we defined for company A is LKR. The base currency of Company B is SGD. Then there was an error occurred while releasing the invoice.  It is as follows. So cant we have two base currencies in our scenario ?