Financials

Hi,I create a “credit adj” for a vendor in Payable incorrectly. I reverse it and a “debit adj” was created for the original transaction. I try to clear the “Credit adj” with the “Debit adj” but fail. Does anyone know how to do?Thank you.Regards,Raymond

I am trying to set up a consolidation unit in the GL in the F300 training.  The consolidation unit is on a separate tenant from the consolidation company but on the same instance.My Acumatica version is 2023 R1.The company name is AZ_Subsidiary.  From what I’ve read, this should also be the Tenant ID.However, the system throws an error (actually multiple errors) when trying to synchronize the subsidiary ledger to the parent ledger. Looking at the trace log, the first error thrown is “Unable to connect to the remote server.  So I’m assuming the main problem is an incorrect URL.From what I’ve found on the web, the core tenant URL should be:https://MyDomain.net/MyInstance/AZ_Subsidiarywhere “MyDomain.net/MyInstance” is the public URL for the instance and “AZ_Subsidiary” is the Tenant ID.But it’s not working.  So I’ve also tried:https://MyDomain.net https://MyDomain.net/MyInstance (i.e. the public URL for the instance without the tenant ID) All of the above with http: ~/AZ_Subsidiary ~I’ve

Has anyone had success with Bank Feeds and Truist oneview business account/or enterprise spend account connection ? I cannot get past the login screen with either MX or Plaid. Trying to get credit card Account to import.

All, I am looking to modify the standard AP check into a Stub-Check-Stub format in portrait.  Has anyone accomplished this?

Are there any Acumatica customers that need to keep detailed tracking of their long term investment assets holdings?  Any need for automated unrealized gain/loss valuation adjustments with corresponding journal entries?  Any need for interest accruals or amortization of investment holdings?

Ideally we are looking for a solution which allows a customer to enter their Credit Card or ACH information in a PCI compliant portal, then automatically collect payments monthly based on a customer’s subscription. We have used Chargebee in the past, but it will be too expensive for our current prospect.

One of our companies is now becoming a branch of another one of our companies. Is there an easy way to do this? Thanks in advance!

Under Sales Order Preferences>Sales Profitability Settings there is the option “Cost Calculation Basis for Non-Stock Kits” which we have set to ‘Non-Stock Kit Standard Cost Plus Stock Component Cost’   The documentation seems really clear about it’s functionality:Cost Calculation Basis for Non-Stock Kits The cost the system should use for non-stock kits in sales profitability reports. Select one of the following options: Stock Component Cost: The system uses the sum of the costs of the kit’s stock components. Non-Stock Kit Standard Cost: The system uses the standard current cost of the non-stock kit. Non-Stock Kit Standard Cost Plus Stock Component Cost: The system calculates the sum of the standard current cost of a non-stock kit and the costs of the stock components of this kit.   The costs of stock components of a non-stock kit are updated on release of the inventory issue generated for the Sales Orders invoice with this non-stock kit. For more information, see I

Has anyone integrated Acumatica with PaySimple?  working with version 2023 R1

Hi, I have schedule to email customer statement. My automation schedule has been run, but the emails have not been triggered.  What will be the reason ?? Please help me to resolve thisThanks

Okay FRIENDS,So I have a client who has pinpointed a discrepancy between their GL and their bank rec.   In a prior period somehow a check ran through payables and paid off a bill but does not have a GL batch associated with the entry.   Not sure if this is data corruption or perhaps was accidently triggered using migration mode.  Anyways, long story short, my bank recs are good by my GL bank balance is overstated.   I need to post a GL entry to bring the GL balance back in line with the bank reconciliations.  How do I accomplish this without impacting the banking module.  Can we do this or do we need ACU support to assist? RoperMan ! 

Hello - We have an AP payment that was erroneously applied with a date of 06/29/2028 in the post period 06/2023. I know there is an option under the Payment Methods screen to allow “default void date to document date” for AR, but what would the solution be for AP?  

Hi All, I have created a column set that has a period from 01-2020 up to 12-2023 where I want to be able to run an Income Statement report based on the parameter that I set in the report parameters. So, I put a range 02-2020 to 08-2023 in the report parameter but the on the report output it shows all the columns available in the column set.In my column set, I use the visible formula below. (note: the period changes per column)=IIf((Left(@StartPeriod,2)<=1 And (Right(@StartPeriod,4)<='2020')) or (Left(@EndPeriod,2)>=1 And (Right(@EndPeriod,4)>='2020')),true, false)Any help would be highly appreciated. Thank you very much. Regards, Anne Samson 

Hey all, I’m seeing random issues with the bank feed form but I have yet to see this one on here. Figured it’s worth discussing. I’m also opening a case with Acumatica. Just wanted to see if anyone has come across this before. The customer has confirmed that all the credentials are correct despite the error message. “The bank feed service (path: 0/plaid/transactions/get) returned the following server error: one or more of the account IDs is invalid.”Please let me know if you have any information regarding this. Thank you! 

I am trying to  find out how can i solve this error on the Journal Transactions screen. Can anyone please help me here. This is the error I am getting.Project is Required but was not specified. Account '214875 ' used in the GL Transaction is mapped to Project Account Group.

Hi All, We are having the following error when generating invoice for a contract.Issue: User is logged into Branch A Trying to generate invoice under Contracts screen. Branch for this Contract is B. If the logged in user changes the current branch to B and then generates invoice it works fine. This used to work in our previous version of 2019R1, recently we have upgraded to 2022R1 and hence started seeing this issue, so just thinking if the upgrade has put in some sort of restrictions for Cash accounts based on the branches.

 This article provides information about the Acumatica implementation of 1099-MISC and 1099-NEC tax documents and e-filing options for 2023. Detailed information about these forms is available from the IRS website (1099-MISC, 1099-NEC).Information for Customers who use Pre-Printed FormsForm 1099-MISC, Form 1099-NEC and filing instructions have been converted from an annual revision to continuous use. Therefore, there are no changes in 1099-MISC, 1099-NEC form layout that require changes in the Acumatica ERP.  To resolve possible issue with the printing alignment, we encourage you to update to the following Acumatica ERP builds where the paper size of the 1099-NEC (AP653100) report have been changed to Letter:2022 R2 Update 3 (22.203.0043) or later 2022 R1 Update 14 (22.114.0029) or laterFor more info, workaround for earlier builds and additional steps to fix possible alignment issues, refer to the Known issue: The report printed on the 1099-NEC (AP653100) form did not fit the Letter pa

Has anyone encountered this error before?: GL Error: Cannot update the record. The record Account (4000-103) has been marked as deleted. Your changes will be lost.  We are working on an implementation for a client and had deleted the “4000-103” numbered account. Acumatica now wont let me recreate the same account #? Is there a specific root cause for this? Anyway to get around this? 

I am trying to report a gross margin percentage on a report while using the column set Rounding to Thousands.  To illustrate, I have the following rows.No Rounding:100  Sales   10,000120  Gross Margin  5,400125  Gross Margin %  (@120/@100) = 54%  format #,##0%  When rounding to Thousands is not used the calculation is fine.With Rounding to Thousands:125 Gross Margin %  (@120/@100) = 0%  it appears to divide the .54 result by 1000Changing formula to multiply by 1000:125 Gross Margin %  (@120*1000)/@100 = 50%  it appears to round the 540 result to the nearest  thousandth .5.  Note that if I multiply by 10,000, the result is 540%.If anyone has experienced this problem and can provide a solution, I would appreciate it.   

Have formatted the excel import file date field to not display the time.  When imported into Acumatica, it brings a time stamp.  Just need the date, not the time.  Have attempted setting the field on import scenario to “=TEXT([column name], “dd-mm,yyyy)”This does not work.Any suggestions? 

How can we assist our clients in getting the vendor 1099s updated to include amounts from their previous system prior to their migration to Acumatica?Keep in mind most of our clients will not have access to their old systems, nor will they be able to run the 1099s for 2023 year-end.  

Hi, I created a GL account "999991" in the Parent tenant and attempted to map it to the Consolidation tenant. However, I was unable to locate the corresponding GL account in the Consolidation tenant for mapping purposes.Upon further investigation, I discovered that the Account ID (highlighted in yellow) value differs between the two tenants. Could this discrepancy be the cause of the mapping issue? If so, how can we synchronize the Account ID values to enable mapping between the tenants?  

Hello all, We work on Import Bank Transaction in 2022 R2, and we try to set up Relevance Calculation in the best manner. As I understand there’s two ways to set up Relevance 1. Cash management preferences 2. Match settings. Help section mention that the Cash Management preferences is the one who get priority if there’s no set up for a particular cash account. As you can see below, we’ve tried to put much off the weight on the amount, but the system doesn’t seem to take it into consideration and we can’t adjust directly in the match settings. How can we have 0 as a relevance if it takes amount in consideration?Is there any way to force him to take it into account? Thanks!

Hi I created our third subaccount segment, it’s a product subaccount ideally linked to inventory item.When I create a sales order and sales invoice, I see all 3 subaccounts generated Channel-Customer-product. However, even though the item is invoiced, no issue was created. Usually this is an automatic process but I had to manually look up that issue and when I click release, it has an error, saying Product of subaccount does not exist.I’m not sure where Acumatica pull the subaccount from.Here is the screenshot of the customer and inventory ID subaccount:  

I have experianced that we loose quite a bit of information after updates. Items like value added tax numbers on POD’s and Pro-Forma invoices. I would like to understand if this is due to the updates or the way that the customisation was implemented?