Financials

I am playing  in our test (sandbox) environment and found out I don’t have access to run this report .

When running “Transaction for Period” report all data appears on the screen.  When downloading to excel it does not bring “Customer/Vendor” Field.  I have cleared out both sides of the column in Report Designer to make sure there is no overlap.  Moved the “Description” field off the page for now - though it does not download that information either.  Confirmed that the properties fields for “Customer/Vendor” is the same as the “Code” column - which does print.Displayed Report below:Results from Excel Download below:What am I missing? 

It doesn’t appear that the client ever closed any periods so transactions, in some cases, are getting posted retroactively into prior periods (or years!) For example, the client processed a void check in February that was originally issued in January, so it booked the void in January. I presume this happened because that period was still available for posting. The client is fine actually going in and closing periods in the various modules, including G/L but what they are really seeking is an understanding of what actually happens when they “click the button.” I am researching as well but hoping for some expertise. 

Is it possible to attach a fixed asset record to a customer record in Acumatica? 

Hello Community, I’ve prepared a Sales Report that you can use to review credit card sales transactions by branch by certain period. You can then drill down to review specific date by payment methods used and users who took the payment and even drill down further to review individual transactions. See the customization package attached (2024 R1 compatible). 

Hi- we were waiting for a significant repayment from HMRC for VAT, and wondered why it hadn’t been paid. From checking on our government portal our submission was zero. However, on the submission on acumatica has been unreleased but submitted - how is this possible?     

Hello all,Here I prepared an invoice for 12 months with cerdit terms of 12 months.After releasing the invoice system, create 12 separate invoices. In the 12 separate invoices created, the inventory is not showing.And the batch is taking the same accounts. 

All, How does everyone one handle a cost + project that uses expense/invoiced materials to build assemblies?  How do you capture the completed assemblies for the project? Would like to issue all those materials so they no longer show in the project whs along with the project to show the completed assy’s with the total cost of the materials used to make them. Is there another way to do this?  I am seeing some use the issue transaction on the acumatica, however  it does not go on to explain what the project whs looks like after this is completed?  Does that project whs show no materials in that whs?  How do we get the completed assy to show on the project if a item was built? Is there a certain way this project needs to be set up to accomplish this? Note: We created a Production Order, only to find out when the expense materials were released it put a 2nd expense on the project for the same materials show in that project whs. Any advice or guidance would be appreciated Thanks,.

I’m having an issue with a Import Settlement Batch that is in the pending review status. It seems that everything is correct on it, but I can’t create a deposit.

We are currently in version 2022 R2. Tax Category, Taxes Zone, and Taxes have all been set up.  We implemented in a Canadian branch, which is why we are adding a GST tax. However, the tax is not generating on POs and APs.  I have found a post, but our situation is the opposite. @Laura02  helped me out a lot to check and she was unable to get tax to appear on a PO in 2022 R2, which is the same version we are using at the moment. Purchase orders getting issued with tax - despite vendor being Tax Exempt Could this be a version issue? The PO and Bills and Adjustments are not generating a tax? Is there anyone else experiencing the same problem. 

Hi Everyone,I am trying to run a recurring transaction batch in AR but I am experiencing an error. I have it set to run on the 27th day of each month (today) but it will not run until the 29th. Notice “GL Error: The next generation date for this task is greater than the current business date.” I realize I could change the business date to the 29th but I would like all the invoices to date on the 27th. Is there something I am doing wrong here?  Thanks

Hello all,i have been trying to Auto-match the transactions in order to create the payments, but the instance triggers the following error message:I tried to check out the same process of auto-matching process in Sales Demo but it is working fine.What is it that the system is generating this error?The trace error:at PX.Data.PXFirstChanceExceptionLogger.ProfilerFirstChanceException(Object o, FirstChanceExceptionEventArgs args) at PX.Objects.CA.CABankMatchingProcess.CABankTranDetail_AccountID_FieldDefaulting(PXCache sender, PXFieldDefaultingEventArgs e) at PX.Data.PXCache.OnFieldDefaulting(String name, Object row, Object& newValue) at PX.Data.PXView.PrepareParametersInternal(Object[] currents, Object[] parameters, IBqlParameter[] selpars) at PX.Data.PXView.Select(Object[] currents, Object[] parameters, Object[] searches, String[] sortcolumns, Boolean[] descendings, PXFilterRow[] filters, Int32& startRow, Int32 maximumRows, Int32& totalRows) at PX.Data.PXView.SelectMultiBound(

Does anyone have experience of configuring Acumatica Taxes to enable Irish VAT Reporting/Returns ?

What is the best method to Convert Multiple Purchases over to Single Fixed Asset.A customer buys multiple laptops (Qty 8, similar Class, similar useful life) each at $1,000 on different dates or the same date.  What is the best method to convert to an Asset.Fixed Asset thresh hold to capitalize is $5,000.Do you setup an Asset with zero value and convert the 8 purchases as components to one Fixed Asset? Or would you setup an Asset with summary amount of $8,000 and then convert purchases as components to this Asset #?    Or do you setup a Parent Asset then add each converted purchase line amount to an Asset associated with the Parent Asset?  

Hello all,i have been trying to reconcile a sample cash account but the system displays the following error:I want to reconcile just the difference of​ 634.98. How can I do that?The Batch Payment has the status of Balanced but the payment lines under this batch has the voided status.​​​​​​

Hi,Can anyone guide me on resolving the issue?  

Hello all,I have not been able to release an AP Batch payment. It has the set of Voided Check records that have the status of Voided as shown below: 

Hello, We use the AP document recognition for AP Bills and it works great.Is it also possible to use this feature for cash purchases (i.e. expenses already paid)? Or this only available for unpaid bills? 

So here is the dilemma, currently if a Purchase  Order Receipt is returned in the system and the PO is closed, why would a Return Purchase Order Receipt still be available to apply to an invoice.   Is there currently a way in Acumatica to remove this POR so it does populate when you click on Add Purchase Order receipt so it is not attached to an invoice?  Or is their a better way we should be handling this process?  It does give an error message when applied but it still allows AP to release it.

Hi All, Can any one please guide me on this I want to send invoice on email directly to customer POS system PetroSoft. Is there anyway to do this? my client asked me to do this and this is super urgent task. Please help thanks.

I can only see how to set Wiki article as the homescreen, but I was wanting to create an I-Frame in a dashboard to our corporate website. Below I’ve attached screenshots of the Dashboard setup and the Portal Homepage selection  

we are currently doing an implementation. How do I load the budget? I have the template ready to go.

Hello all,I have been trying to print check but not have been able to. The system displays the following error message:And then it gets redirected to release payments screen.

As a number of posts have indicated, the system does not prevent timesheets from being released into closed periods. This is a big problem for many service business clients as they are frequently having to release timesheets that were entered late by the employee.  It results in changes to the balances and reports in periods that are closed and this is a nightmare for accountants who discover that their bottom line figures have changed in opening balances.  It breaks one of the fundamental controls of an accounting system. The “Custom Week” settings have an “Active” status but there appears to be no way to change the status to inactive. Thanks