General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Deferred Revenue, Taxes, Currency Management
- 1,480 Topics
- 4,910 Replies
Hello,I am trying to figure out how to handle a rejection in the Approval map process where it would send an email back to the AP processor notifying them of this rejection. Also, the AP processor could be one of two people (email addresses). Is it possible to control whom the rejection email gets sent to as well? Mike
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
We have discovered that we have duplicate IN journals being created. So far we have found them to be on Moves, Materials, Purchase orders and Adjustments. It isn’t every time but is a couple of times a day. Values of the journals vary significantly. It is across our users, so not limited to one user.The journals are identical, one auto releases and the other sits in ‘unposted’ status.Has anyone had similar happen?
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 !
Issue is that a handful of AP Bill transactions are appearing incorrectly in the September BAS when they should be appearing in the October BAS. Example: Transaction itself was created in the system in September 2023, dated 04/08/23 but post dated 04-2024. GL Register Detail for this transaction confirms the From-To period as 04-2024. However, when running the report “Tax Details by GL Account by Period” this transaction is appearing and the Tax Period shows as 03-2024.My question is why is this transaction appearing on this report as post period 03-2024? Where is it picking up the post period date from? I have checked the Financials Tab and batch details but all showing as 04-2024 for October.
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?
Benefits of AP Document RecognitionAP Document Recognition streamlines processing of vendor bills that you receive in PDF format. AP Clerks spend less time re-typing data so they can focus on higher value tasks. Worker productivity: spend less time entering documents Accuracy: reduce data entry errors which may result in incorrect vendor payments Approvals: integrate with existing approval and workflow processes AI/ML: extracted data accuracy (vendor ID field) improves after manual correctionWho can use AP Document Recognition?Prior to April 1, 2023 Acumatica offered a promotion for up to 1,000 pages/month for free. After the first year, customers could purchase the feature.Starting April 1, 2023 all new and existing Acumatica subscription customers (does not include perpetual licenses - PCP) get 50 free pages so they can try the feature. Customers who already paid for the service get an additional 50 free pages. A vendor bill with a front and a back counts towards 2 of your 50 monthly
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
Hello - We have found a check at one of our properties “On Hold” from 12-2022 (screenshot 1). When I go to open this check, I get this error message, “Object reference not set to an instance of an object”. I have found this check applied to a Bill, with the status of “Open”, and I cannot delete the bill or clear the application. When I select “Pay”, I get the same error message “Object reference not set to an instance of an object”Additionally, I have found a debit adjustment referenced to this Bill in 09-2023, seemingly attempting to reverse the error. But I am unable to apply the Bill to the Debit Adj, or release it. (screenshot 3 and 4))Does anyone know a workaround so I can find this check and delete it? (A second check had already been cut and paid for the same time period)Thanks! Bill with the Check Applied and the Debit Adj
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
GL Error: Cannot update the record. The record Account (********) has been marked as deleted. Your changes will be lost.
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.
Do any UK users have experience of setting up Acumatia to support collection of Direct Debits ?This involves sending an XML file every month to a bank with details of the Direct Debit payments being requested from customers i.e. customers bank details, an amount to be collected, a collection date etc.
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:
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.