Financials

Hi,I find the setup of an GL account in my company book is wrong in Acumatica. It was setup by my predecessor as asset, but it should be a liability item. As a result, the balance sheet is not balanced. I only find out now as I use the trial balance only in the past few months. I try to change the type in chart of account but an error message pop up. It said “You cannot change the selected GL Account type because transactions for the GL Account already exist”.Please advise how to resolve the issue. Thanks!Raymond

We just recently started using Acumatica’s Fixed Asset Module. Prior to this, we have kept everything on a spreadsheet and entered the depreciation via a journal entry.I have no issues entering/adding new Fixed Assets, but does anyone know the process of adding old fixed assets into the FA Module? By “old” I mean the assets that were purchased in prior years that have already been either fully or partially depreciated?When added into the FA Module, these assets should not have an impact on the General Ledger since the assets and the depreciation expense is already “on the books”.Thanks in advance for your help!

Has anyone worked with setting up ACH export scenario which will work with a Credit Union? In the first line, the first 691000134 is the Federal Reserve routing number, while the second 691000134 should be the credit union routing number which is on the Cash Account remit settings.  101 691000134 691000134  

We just upgrade our version from 2022R1 to 2023R1. We received complaint from our customer regarding on AP retainage process flow. Previously, user can define retainage during AP bill data entry without need to define at Vendor or Purchase Order. With 2023R1 version, user need to enabled retainage option at vendor master and retainage option must be define at Purchase order first then it will trigger at AP bill screen. Why the process flow changes? and i try to find the changes in 2022R2 and 2023R1 release note. No record on this changes. Or i miss out the information. Any one have solution as Purchase order already released without retainage and now user want to create AP Bil invoice with retainage. Thank you,NasFrom Malaysia with love.

I have an approval map set up for AP Checks and Payments. Currently, the approver is a workgroup with 3 members. As it is set up now, only 1 of the 3 members of the workgroup has to approve it. However, the people submitting the payments for approval are also in the workgroup. So, the scenario is that 1 person in the workgroup submits for approval, then 1 of the 2 other members have to approve it. Is it possible to do this utilizing the workgroup? Or do I have to set up steps with a condition of who is submitting it for approval?

I’d love to be able to access current bank account balances via the bank feeds functionality for use in a dashboard. Is this information pulled and available?

We’re in Canada and use the Plaid API to retrieve bank transactions and are wondering if it’s possible to retrieve bank balances as well.  If so, how do you configure Acumatica/Plaid and where would Acumatica store & display the balance.Ideally we’d like a dashboard showing bank balance less uncleared cash transactions to show an available cash position.TIA

How do I create the column set to have a column for each month and a total for the year?  I want to be able to select the year and then have the columns for each month.   

We have CM (Commissions) and RG (Regular Pay) for payroll. CM posts to Salesmen Commission account and RG posts to Salesmen Salary account.  I have 2 paychecks that posted to salesmen salary but should have posted to Salesmen Commission. The checks have already been released, posted, and cashed by the employee.How can correct the 2 paychecks that posted to the wrong account?Is it a G/L transaction i can do? (reverse the paycheck, then reverse the reverse and fix the accounts that are incorrect?)  Thanks in advance! 

Hi All,We created a business event based on a standard GI (AR0015DB). But the particular business event was not worked properly. As per the clitent’s requirement, the relevant emails (based on business event) need to be triggered when insert any record to the GI. But unfortunately, the emails were not triggered as we expect. It was triggered only through a schedule which created for the business event. Could please share with us any solution to address this requirement correctly ?Thank youNawanjana

Hello,How can we process a return on a cash purchase ?An item was purcahsed and returned several days later. If we void the transaction, how would we be able to perform the bank reconciliation? Thank you,

Hello!We have the ability to distribute expense among different subaccounts in one single bill, but is there is a way we can post the same proportions into different AP subaccounts?Currently, there is only one AP subaccount we can enter when creating a bill. Thank you 

Hello Community, We are getting the following subaccount related error in Acumatica Demo intance. Can anyone check and help   Regards,Jewel

Hi,i am creating a customer invoice and have a problem. It happens in the field “Project Task” under Details. After I pick one of the task from the list, the selected task disappear and the field remain blank. I can’t save the invoice when the project task field is blank. Not sure what goes wrong.Raymond   

Hi,Attached is the Bills and Payables screen for a new bill in my company version of Acumatica. I recall i can add the project field in the top part of the screen. But I forget how to do that. Could anyone kindly advise?Thank you.Regards,Raymond  

How would I correct a Subaccount on an existing Deferral scheduled item?  I am new to this role and would appreciate detail instructions if possible.  Thanks for any help I can get.    

.

Hi, I have a requirement to see the tax amount for each invoice line. In the invoices and memos form, under the details tab, there is a column for Tax Amount. It does not show any values while the taxes are applicable for the line. My tax calculation rule is exclusive line level.  Does anyone have any idea? Best Regards,Dulanjana

Hi,I recently make a change in AP preference by select “Require Single Project per Document’. Before the change, I can make payment on multiple invoices across different projects from the same vendor. After the change, it seems like I can only pay invoices of same project each time but can’t select to pay invoices across several projects. Could I ask if that is correct? Thank you.Raymond

I have tried creating a Dashboard widget for Quarterly Revenue without any success. Does anyone have one already built?

Hi,I’m new to Acumatica and I was wondering how I can import line items from an excel file into “Cash Purchases” in Payables, please? Thank you!

I would like to have a generic enquiry that lists out any AP invoices that are still open and have multiple payments applied.  Can someone advise how to get started.  I don’t know which tables I would need and how to join them.ThanksHere is an example of the data I am looking for: 

Would it be possible to create a project numbering sequence that included a character based on the project type?

Purchase accrual summary has an outstanding item for vendor. There is an order receipt quantity of 48 – this is the correct quantity, but the billed quantity is 24 units.  The billed quantity should be 48 units.  The cost is the same and correct on the receipt and billed lines so there is not a balance in the purchase accrual, but the line does remain on the report.How do we correct the billed quantity to get this off the report?

We just resolved a long standing dispute with a vendor that resulted in a refund.  I want to record this through the AP module so that my vendor history is complete.  It seems like the GL entries should be:dr AP/ cr expensedr cash/cr apI must be missing something because I see a lot of posts here saying to enter a “vendor credit” but I don’t have that option in my AP.  This leaves me with either entering a “debit adj” or a “credit adj”.  A credit adj records dr exp/ cr AP, so that’s wrong.  This seems to leave me using a debit adj.  But, once I record that it seems I can only apply it to an invoice or a credit adj.  I can’t seem to then cash settle it.I can enter it directly in the banking module and the GL will be correct (dr cash / cr expense) but my vendor history will be incomplete.Thanks in advance for any help.