Financials

Our UK based organisation has an R&D department with a team of about 30 people. We intend to set up a separate R&D warehouse within Acumatica, configured in such a way that the value of the stock within it is posted to an expense account on the PL - i.e. has zero value. Each time an item is purchased by R&D, it will be entered as a stock inventory item (with a stock inventory item class) and the default warehouse will be set to R&D. We will also set a custom checkbox on the item to flag it as R&D. When the items are received into the R&D warehouse, we would then be treating them as an expense, while at the same time having the ability to transfer items out of the R&D warehouse and into the main warehouse when they move from a prototype R&D phase and into production - so that their value then appears as stock on hand (by unchecking the R&D flag and doing a transfer).Please forgive my lack of knowledge:Does that setup sound like it would work? I was ho

I have a scenario where when a purchase invoice is received and matched against the purchase order I want the purchase invoice to be approved by the owner of the purchase order.I have tried different options using the employee from list option on the approvers tab but cannot get this approval working.The only way I can get this working is if I specify a rule per user listing the user on the condition tab and again as an employee on the approver tab.   With more than 100 users entering purchase orders this well not be easy to maintain.Anyone came across using the employee from list for this purpose and could advise   

We are running version 2021 R2 in a multi-company, multi-branch environment. The quarterly Balance Sheet shown below has been printed for periods 01-2022 through 12-2022 for one company, “Company C”. There is no unit set, just Row and Column sets.When I click on Total Intercompany receivables as shown, the resulting GL Details report has multiple years included. The total is correct, but the presentation is confusing to the users. Why does the drill-down show records from the previous year?  Thank you. 

Hello - Does anyone have an AR Aged Period Sensitive report that subtotals by AR Account?? We are looking for this to easily tie back to our TB.

We JUST started implementing Acumatica and have 3 similar companies operating under separate EIN requiring separate P&L, Tax returns, etc.Interested to know if ANY options exist other than separate Tennants/Companies and if there is a viable solution to have a single Tennant/Company with separate divisions.Any suggestions are greatly appreciated.

 Essential Sales, Marketing, and Support Solution for Increasing Revenue and Customer Satisfaction When: October 5, 2022 at 11AM PT Attend this webinar to:Gain an understanding of the unique power of CRM software. See how a CRM workflow maximizes leads, opportunities, and case management. Get an inside look at how Acumatica’s CRM solution performs.Register now to imagine what your business’s life could be like with integrated workflows that automate processes, keep key tasks moving, and share KPIs in real time. https://event.on24.com/wcc/r/3942368/B6BF10D69C6C8489EEB954200E8C1B8F

Hi Team,Currently, I am testing AP Document Recognition. I need some clarifications regarding the PO invoice. Once the PO and Receipt are posted in the system. By using the Incoming Documents, I am pushing the invoice to the system. Here, my query is related to the inventory price update during the process. Awaiting for your replies.

I realize expense claims cannot be deleted once released so how do I get rid of the claim that was put in incorrectly but not caught before claim was released. Tried making a negative receipt but that doesn’t work.

I’m trying to add a column to my customer’s P&L that will show the % of Sales for each row on the report (e.g., Sales = 100.0%, COGS = 36.2%, etc.). I can add calculations between columns (e.g., (F-E)/E), but not within the same column. Is this possible with the standard financial reports?

Curious how anyone is using the Charges tab on the AR Payments & Applications? I am wondering if these can be used in claim management when processing AR payments in lieu of creating Credit memos for all the deduction claims on a AR remittance. So I wanted to get thoughts. I can’t seem to test as charges on my end are just blank with nothing to select under entry type so I am not even sure where to configure. 

Please join Solver on March 1st at 1:00 PM EST to learn about https://www.acumatica.com/acumatica-marketplace/solver-corporate-performance-management/ and how your customers can benefit from this Fulfilled by Acumatica solution.  Here is the link to the event:https://events.teams.microsoft.com/event/8e360595-5afe-44f6-9ebc-8d47c9e50ce2@0cc9806c-44f8-445b-87c9-709c71ad38b0

I’m needing a detailed general ledger for all accounts and all transactions for an entire year to present to our auditors.  The transactions for period report keeps timing out.  The best I can do is run the report by quarter.  Any suggestions?

Good day Could someone please indicate if this type of product is available in South Africa. We queried this from our seller and he they indicated the following: “We are waiting minor changes for the AI engine to work as we have experienced a challenge with the process in S.A. due to the date format S.A. use compared to US. US work on month day year and SA work on day month year. This is causing error for SA currently. We are monitoring the update to the AI engine frequently as we have other clients also interested in this functionality. This module is currently only available in US and Canada.” I am no developer, but this does not seem to me as a problem because I am able to edit the date format on Acumatica. So why can't the AI also take this into account. We could really use a product like this to cut our AP Billing time as we do a lot of transactions and is wasting time if it can be done quicker and more efficient. Are there any South African companies that may be using something s

Hi Acumatica,May we ask your assistance if there is a settings on how the First name and Lastname will reflect in Acumatica. The client wanted to set as Lastname, Firstname Middle Initial. Is this possible? Thank you!

Acumatica Version Build Number: 21.220.0010 We have a requirement to display a payment hosted form to enter credit card details on custom action.We have tried to extend graph and replace piece of code of CreateCCPaymentMethodHF action from PaymentProfileGraph.cs.Action is getting displayed on screen but not able to get hosted form on screen as facing issue while calling HTTP request. As per Error, We have added HTTP NuGet package but it does not worked.We would need your assistance in displaying Hosted form on custom action to enter Card details.

Hi,Eagerly downloaded the SalesDemo snapshot for 2020R2 and searched high and low for the Incoming Documents screen, which was demo-ed by Doug in the launch. Found it in Site Map (AP.30.11.00) but its not appearing in the default Payables Workspace.Are there any additional settings or configurations for it to appear and immediately use?

Hello! Does anyone know if there is a way to change the default Start Financial Period on the P&L Financial Statement to always default to 1 month prior to current month? I have looked at the Default Data Source Settings and could not find a way: 

Hello - Does anyone know how I can get the Transactions for Period report to run by a Company Group? I can run the TB reports by Group but for some reason not the Transactions reports.. I have a feeling it has something to do with the Org fields but I am not sure how to correct.Transactions for Period:Trial Balance Detailed: 

I pay vendors by Job, I go to ‘Prepare Payments’, select the job and pay vendors from there, then I ‘Process’ once to compile them in the ‘Process Payments/Print Cheques screen.  So I do this for multiple jobs.  I do this so I only have to print cheques once, instead of going to the printer 5+ times.  But what this causes is, if I pay the same vendor in multiple jobs, it puts those cheques separately and does not combine them.  So if I Pay that vendor over 2+ jobs, that vendor gets 2+ cheques. Is there a way to combine those into one cheque from that screen, or is there another way I can achieve the same outcome but where the cheques are combined?

We have two companies in Acumatica, but both use the same bank account. We have created two cash accounts (one representing each company) in Acumatica, both using the same GL account but different branches/companies. Are we still able to use the bank reconciliation feature?I would expect both bank recs to have a large difference but should net each other out (in a perfect world) once fully reconciled - However seems like the reconciling task will get confusing/complicated as you are not sure whether a transaction is truly missing (& requiring a payment/invoice) or whether it was posted to other company. Does anyone run bank recs in a similar situation? Does it work for you?Or should we go down the path of opening a separate bank account for each company account?

Hi all,I am trying to figure best way to handle the following:I work for a non-profit organization where they have fundraisers and miscellaneous events a year. I want to keep track of all activities (Revenue and Expense) for each event. My company did not purchase the project management package and do not have it in our budget.How can I keep track and analyze all the activities for each event? I would like to run statements for each event.Many Thanks,

Thanks to @matthewbeebe for the nudge in the right direction of object was being used. I eventually found it myself but they saved me a lot of time.These were the two key parts of the Export Scenario for payments with Addenda including the Vendor Reference Number. All of the information about the entities used in ACH Payments is in PX.Objects.dll file and using dotPeek I was able to see how they were being built and from there go to PX.Objects.AP to figure out the field to use. To get the Vendor Reference Number, I used Matthew’s suggestion of APPaymentApplications.InvoiceNbr and that eventually led to finding how to get the Payment applied to the Invoice which is APPaymentApplications.CuryOrigDocAmt whereas the default Export Scenario has APPaymentList.CuryOrigDocAmt which makes the same total amount repeat for each invoice which is not what we want.I’ve spent months working with multiple Acumatica Partners and people at our bank trying to get this to work. I do want to note that ther

Hi Team,When I sent a payment via API to Acumatica, I receive the error message: "exceptionMessage": "Error in action invocation:\nAR Error: Application Date cannot be less than Document Date."This error does not always occur. Could you clarify how to fix it? I attached the example of the request.

Afternoon, I am trying to close a financial period and I am getting the error that there is an unposted production document. However, when I click the Unposted Documents to check for any unposted it returns that there are none. So at a bit of a lose on how to find this mystery document to release.  Thoughts?   

We have been live for eighteen months.  We have never run the “Recalculate Customer Balances”. What is the procedure to run the recalculate customer balances? Does this need to be done for each month? Should we start with the oldest month run to current month?