Financials

Hi All, Close financial period in payable for 10-2024 Not able to close the period even all unreleased documents are cleared , But for other workspace all are closed only for AP  iam not able to closeattached screenshots for your reference

Hi,I am trying to setup a financial report template for a client and I am trying to have a different formula for the expenses. Currently, the budget variance is currently set to subtract the Budget amount from the YTD amount. However, they would like to have it set the opposite for only expenses. Is there a way to achieve this?   Thank you,Joey

Quick check was a wonderful quick easy way to correct the totals for a vendor on the 1099 report.I think it’s gone.Looking for a way to get this total changed.  Especially if the correction needs to a total of several invoices.For us, these corrections are usually needed when we make payments before we get a W9 and enter the 1099 info in the vendor set up. Sue Terrysterry@ex2technology.com

Hello Dear Community,My Controller came to me asking if there was a way to apply payments or create invoices while a customer is on credit hold? He said there are instances where they need to apply a payment to the customer but keep them “On Hold” status. So his team are having to remove the credit hold, apply the payment, then put the customer back on hold.Can you guys provide some input?  

Having an issue trying to close a completed production order. When I hit process in the Close Production Orders Module, I receive this error message: “IN Error: Unit conversion EA is missing.”Is this coming from the stock item or the completed production order. The base unit for this stock item is listed as EA. Thanks!!

Hi All,Trying to setup a label report. It consists of two labels on one report with the next function on the second label. The first label prints fine without spaces but the second label add a small space. This then gets added on each subsequent label.On the preview you can see it here:The two detail sections are exactly the same:Then on Acumatica it also only shows one label per page and not 2 with a white space at the bottom. Footer sections has been set to invisiblelooks like this when printing: 

Does anyone have an export scenario to accommodate Chase Bank’s Nacha File Format?  We are struggling, We are missing :Your Chase account is missing from the file.Find the company identification field and enter 0000000000 (10 zeroes).The company identification (shown in the batch control record) doesn't match the batch header record. We are close but need to be able to export on Monday. 

I’m setting up a construction project that will have its own specific cash account. How can I link them together so that when someone is entering AP bills across many different projects, they won’t have to edit anything in the financial tab for this specific one? I want it to automatically know which cash account to use. 

Hello!I followed the instruction in this post (How to create approval flow in Expenses Claim | Community (acumatica.com)) and was able to create a basic approval flow for expenses, but here are two things I can’t figure out. is there a way to create multiple level of approvals? Where first the expense gets approved by direct manager, and then it goes to next level authority to initiate payment? Is there a way to set email notifications on both level of approvals? this is the first level approval.. but once approved, how to move it to the next level authority to initiate payment?  I can’t seem to get the notification email to come through… This is what the email template that I’m using looks like, I have it sending to my email so I can test it. Not sure what I’m doing wrong. Is this something that needs business event to trigger as well?   Thanks so much!!  

 I would like the from email address in statements to be our finance email address opposed to our service email address.  I have changed but it’s picking up the service email address.It was changed under the email template for statements:And I also changed it under the accounts receivable preferences to set it as the default email account but it’s still picking up the other email address. 

We are currently going through an audit. How do I get documentation of a backup being tested for successful restoration?

Apparently you can Void an AP or Quick Check that has already been marked as cleared and/or reconciled in the system.  I put a ticket in with the Acumatica support and was advised to put in an idea for product change.  Has anyone else found this and addressed this issue?

The QTY on hand shows 0, Available QTY is 5 and available for shipping read 0 also, what is might be the course of this difference

Hi All,We would like to display an error to the user if the Project Budget exceeds while adding the details in Purchase Order and stop them from removing it from hold.Acumatica does some calculation on page load and displays a warning when the budget is exceeded as shown below: This is the budget in the project: For the Project, Project Task, Cost Code and Account Group combination, the budget in project is 1500 but in PO is 1501, so it is displaying the warning message.There are other logic as well which I do not know yet and it is complex if I have to replicate the logic.My job is to see if the budget is exceeded or not if it is exceeding, I need to give a message to user and stop from proceeding further.Things I have tried:Tried to implement the logic by myself but I am missing certain scenarios like the line item in PO can be marked as closed/cancelled, so they need to be treated differently. Catch the warning and show it as an error but the warning message is inconsistent. There a

Hi All.  We are looking for a way to close refunds that remain open with an irrelevant balance on them. There is an option to Write Off invoices or memos, but not for refunds. Is there a way to add that option to refunds?Thanks, 

We create service orders and sales orders (type of SO), which then get invoiced from there.  We also create RC Sales Orders for Credit Memos, which are created in the SO workspace.  The invoices, once released, go into Receivables, but they bypass the Receivables approval process.We need approvals on all invoices and credit memos, not just the ones that are created directly in the Receivables workspace, and approvals are not available for SO invoices and CM’s.  Is there a way to put this in place?

Hi, quick questionI noticed an Project Allocation was done twice in August….. I tired to reverse 1 Allocation and it reversed in Sept……. How do i reverse a reversal to get it in same month? Is it possible to change a date when reversing an allocation?  

We have created a payment processor for cybersource secure acceptance and we implemented the classes: V2.ICCHostedPaymentFormProcessor V2.ICCTransactionGetter V2.ICCProfileCreator V2.ICCHostedPaymentFormResponseParserView original The issue we have now, is that after payment is done on cybersource, it returns back the response to the PaymentConnector.html which in turn perfom the next line window.parent.px_callback.paymentCallback('action=transactResponse&response=' + urlParams.get("ref") );this close the payment popup, but the payment it self not converted to completed, not sure why and when opening the payment details and look under card processing tab, it display “Does not exist error” (see attached)I’m not sure what I’m missing at that stage, hope anyone can advise.

Hello,I’m creating payment pluign and integration between acumatica and cybersource payment acceptance, Cybersource secure acceptance requires creating of signature that is being posted with the transaction details, cybersource uses this signature to verify that the authenticity of the request.This signature can have special characters like = / _ - … etcWhen I implment GetDataForPaymentForm, I add the signature as form Parameter input with other transaction parameters, I set UseGetMethod = false so it uses POST method.Submitting to cyberosurce endpoint always fails because of invalid signature, upon troubleshotting, I found that Acumatica is stripping the = character from the signature when posting to the end point which at the end make signature not matching and cybersource declined the transaciton.And cybersource won’t accept URL encoded signature and it fails as wellI did PxTrace logging and made sure that correct signature is generated but when Acumatica post it it remove the = cha

I am working on a 12-month calendar forecast P&L.  It is not a rolling report and will always display January - December from left to right and a total. The results will display either actual or budget.  For the months up to and including the date the report is run the actual results display by month and budget will display for the months after the date selected.  For example, if I set the date to 08/2024 the report will display actual results in separate columns for January - August and budget in the columns for September - December.along with a total.  The column set has 36 columns, 12 columns to pull actual, 12 to pull the budget and 12 to add the combination of actual/budget based on the date selected.  I have it working to display either actual or budget by month using a visibility formula.  I now need the visibility formula to use in the 12 columns of totals so that only the total for the combination I have selected displays.  I have tried the formulas in other discussions, a

I am looking to implement Late Costs - costs that come in and need to be charged against a sales order often after the SO is completely closed out. Some examples of Late Costs would be Use Tax, an incoming freight charge, storage fees, credit card charges that are incurred in the field and not realized until after the SO is closed, and if we have a vendor bill that we want to reflect some or all its value to a Sales Order or specific sales order lines but the sales order line for it may already be closed (invoiced)Attached is a document that outlines the overview. Have you done this or know somewhere it has been implemented successfully?  

We have projects where we charge professional fees at an hourly rate and others that are billed on a flat rate basis.We are in the process of configuring an administration fee applicable to professional fees. For hourly rate projects we added an administration fee percentage directly in the billing rule calculation formula, and it works.On the other hand, we cannot do the same for fixed-price projects, the billing rule doesn’t allow access to the calculation formula. Is there another way to apply an administration fee to progress billing?

I have imported transactions from multiple tenants. Unfortunately there are about 8 batches that are out of balance. I do not understand why they are out of balance. I would appreciate assistance on this: Does nayone have any ideas on this?

Hi Team,We have a scenario regarding the consolidations of the financial statements. Appreciate if you could give your opinion regarding the scenario. There is a group of companies that contain 10 separate legal entities within the group. And the requirement from the client is to have separate financial statements for those legal entities and at the end of the month or any specific period of time, all the financial statements need to be consolidated. Also, the client needs to maintain 10 separate charts of account structures within the system. I already know we can have only one chart of account structure for all the companies within the system but i need to know whether if there is any workaround for that.  An example for the consolidation scenario is as follows. Company A has an account for record debtors as "Trade Receivable A" and then company B has an account for record debtors as "Trade Receivable B". At the end of the period, we need to consolidate these two A and B accounts int

Does anyone know how to query for Payments with a non-zero Available Balance — curyUnappliedBalUnfortunately this field isn’t available in the DB, and the code references other fields that also don’t exist in the DB. Someone on my Accounting team asked for a GI/SQL to isolate these Payments.