Financials

Hi Team, When I trying to perform cash transactions in the “Entry Type” field I didn’t find anything even though I have already created some of the “Entry types”. What is the issue here I really don’t understand.Thanks,Nithya

Hi Community,How do I apply a misc cash application? We are a non profit that receives large cash donations. We do not create an invoice as these are random.I tried Banking>Bank Deposits> CA Deposit> Select the Charges tab entering the rev accounts. but the following error. My “charge” does not return levels. Thanks,

Hi Community,I’m trying to add a misc cash deposit. How do I add selections in Entry Type?   

A reference was made in the solution below to “report designer  Page Setting >>Margins>>Top.”Can someone please post a screen shot of this path?  I do not see it in my Report Designer and am wondering if it is not loading properly.Thanks 

Hi Sir How do i duplicate a dasboard to another?

I’m trying to find a formula to build a view for what is left to bill in the project.  ‘Revised Contract’ minus ‘Revenue to Date’. See attached. Has anyone had success? 

Tried to Release an AP Retainage, the process shows successful but no Invoice generated under Bills and Adjustments.

I can get the GET call working with $expand=TaxSettings but the PUT call fails Please help with updating PREmployeeAttributes. This is a detail entity for top level entity EmployeePayrollSettings. Been at it for 3 days now. Any Help would be appreciated, Novice here

I created a Proforma and released it which created an invoice. This invoice was also released and it was in the “Pay” state. Later, I realized that the “Amount to Invoice” was incorrect. So, I created a credit adjustment for that invoice. Now if I run a Billing for the project the “Previously invoiced amount” is incorrect. I tried to go back to the Proforma to “correct” it but it gave me the below error message.   I am not too sure where to go from here. Any ideas? Please and Thank you! 

Our company, for both AP Bills and Purchase Orders, need to have a specific sequence of approvals depending on the dollar amount, and we do not want emails sent to subsequent approvers until the approver before has approved either of the transactions.  I notice on screen EP205000 that is hidden allows for the sequential approvals as wanted, but that the Preference screen look at EP205500 for the approval map which does not include the sequential approvals and also sends all the emails for the needed approvers at one time and allow for an approver to approve the transaction whether lower level approvals have been received or not.  Could it be possible to select which approval screen to use versus being forced to use the EP205500?Also, it would be advantageous to have the Steps on the EP205000 screen similar to EP205500 for the ability to separate the different approvals depending on branches, tenants, etc. 

Hi Acumatica,We have some queries regarding the standard capabilities of Acumatica.In Account Code in the Chart of Account Screen is there a way or a setup to exceed for than 10 characters? In Sorting of Account Code. Is there a way not to sort the coding?                               Thank you!                           

Hello Everyone, There are times when our accounting department would need to print out a journal transaction record, is there a built-in option for this? Similar to SO and PO? Thank you in advance! Kind regards,mrivera67

Often a client will issue a check in one financial period and then void it in another.  If the check is voided before the bank reconciliation is done, the check has a balance of 0 on the bank rec.The proper way to handle this is to include the amount as outstanding in the month is was issued and voided/cleared in the month it was voided.For instance, if a check is issued 8/15/2022 for $5,000 and voided on 9/10/2022.  The August, 2022 reconciliation needs to show the $5,000 as an outstanding item.  

We have a client with a financial year that begins in November.  The 1099 reports in Acumatica pull data based on that Financial Year.  The 1099 DACs only track the financial year, not transaction dates that I could potentially add in Report Writer.  Has anyone run into this issue and how it might be solved?

I have an employee that was paid 3rd party disability and I am inquiring on how to process and pay his employer required portions of this and record it

We have a client that processed statements for 12/31/2023 but needs to process 12/31/22. They tried on demand but says it did not work. Any suggestions?

Hi!When loading open AP with balances and/or retention, which screen fields are referred to in the error message as “Migrated Balance” and “Document Amount”? We were able to load cleanly with migration mode off as an initial test, but not with migration mode on as is needed. Thank you,Dave Z

How do process an AP Debit Adj with Status of Reserved. 

Client A2022R2.Created Corporate Credit Card assigned to an Employee.Created Payment Type set to Credit Card.Client is paying a AP bill using the Payment type = Credit card that is the same as the Corporate Card.Setup Bank Feed to create Employee Expenses assigning the Employee.  This creates a Employee Expense receipt and works nicely.  Is there a way to match the AP bill payment to the Bank Feed import so that it does not create an employee expense? 

Hello everyoneI have seen this issue in 3 different versions and builds, the current version I’ve been trying it and use is:2022 R1Build 22.110.0018 Wondering if there is a fix for that and if it happens to anybody else.When I copy a Released Cash Entry (CA304000) that has the Cleared check mark and Date information and paste on a brand new transaction, those fields copy and they should not. 80% of the time I manually uncheck it, but sometimes we forget and they show up in the Bank Reconciliation as cleared and reconciled with the wrong date. Visual-:  Thank you Wileyska  

Is there a report that includes all manual journal entries within a date range?

Happy Friday all!We have a separate GL for our eCom Sales that is configured at the customer level. If I create a AR Invoice the GL populates as expected based off the Customer. However, on the SO side, the Account GL always defaults to our B&M GL regardless of the customer. Is there a hidden config in preferences or something that I am not seeing? Wanting it to default to what is in the Custom GL Accounts info. Thanks 

Hi Community, Is there any way to create an advance invoice ( AR Side) and offset it with the final invoice in acumatica?? I have checked in the Payment and Application Prepayment functionality. But when the amount is large for receiving any payment from customer they usually ask for advance invoice.   Regards,Jewel ParvezLead ERP Consultant Allaint Rigserv LLC

Hi,I’ve been trying to build a custom connector from Powerautomate and it is not authenticating me. I have tried both Post authentification using Json as well as OAuth2.9 from Postman and they were both successful. Issue #1:I’ve tried the api key authentication but don’t know where to find the API key for acumatica? Can someone let me know where to find it please?Issue #2: In lieu of the API Key authentication, I tried OAuth2.0 but keep getting the error: “The client application is not known or is not authorized”Can you please confirm that my URLS are correct, I need the following fields:Host: Host.acumatica.comClient id: generated in acumatica under connected applicationClient Secret: generated in acumatica under connected applicationAuthorization URL: https://Host.acumatica.com/identity/connect/authorizeToken URL: https://Host.acumatica.com/identity/connect/tokenRefresh URL: https://Host.acumatica.com/identity/connect/tokenScope: api

Why is the Balance Sheet printing incorrectly?It prints like this:It should print like this:The set up is the same in test company (which prints correctly) as the production company.Production setup:Test Setup