Financials

Good day allI am trying to write a GI to show AR payments and their applications. Can anyone tell me the field that links the two, apart from the CustomerID.I’m using tables ARPayment and ARTranPost.I tried ARPayment and ARAdjust but can’t get that to work. I appreciate any help.Many thanks in advance.

I have tried numerous times to split a journal entry into multiple lines without it posting successfully.  The only way I can get Acumatica to split an entry to multiple sub accounts is to do it one line at a time.  Why is this necessary?We are on 2020 R1

We are currently on 22r2 and will move to 24r1 soon.We have the need to stop users from seeing and being able to drill down into certain accounts on the P&L by branch report.  The users are all in the same branch, but not the same “department”.  They should not be able to see wages for the branch management (highest priority), and preferably not other departments in their branch (secondary concern).I have set up a restriction group and assigned only top management and finance to the group.  I have also assigned the specific sub accounts, and then the specific GL account, to the RG as well.The result is that the user can access the P&L by department, see the Wages listed on the P&L in total form.  Further, then can click on the amount and drill into the Wages amount, seeing the restricted account detail, as well as the associated subaccounts, some of which are restricted also.I have read the help text documentation and understand that for performance reasons, this is the res

Looking into the ability to have Attributes published into Customizations.  Use case:We have a testing environment that we test Customizations before publishing into our Production instance (as everyone should hehehe). I want to make a Attribute on the for Vendors, that I attach to each Vendor Class.  But I am trying to figure out how to do this in a Customization if possible, that way I don’t have to recreate those fields and connections in our Production instance.  I could just publish the Customization and it would create the required fields.  Is that possible?  I can’t find any documentation on that use case.

Hello team,I have been looking out if I can create a debit adj to reverse an AP bill of a non project code & then create a new AP bill under a project.Let me know if you have any other suggestions on this.Thanks in advance.

Hi Acumatica Team,Is there a report that we can see an Inventory Transaction related to the Project?Thank you!

Hello, we have a prepaid insurance expense that I wanted to setup a amortization schedule to expense monthly over the life of the policy. Is this possible with the out of the box solution?  thanks

Does anyone add the reference number provided by the bank for ACH batch transactions to the batch payment in Acumatica post Acumatica release of the batch paymentI have to release the payment in Acumatica to obtain the export file and would like to be able to go back and add the reference number from bank to that released batch payment in a field that can be searched in the GI.I appreciate any feedback.

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.    

.