Financials

Hi, i want to set up a new Cash Management Preference but when i try to input COA for Cash in transit account there’s no COA to select. The COA already import and set type as CASH.Please help me to solve this, there is step that i miss?? Thank you   

Is it possible to record a bill payment in Company A that is automatically recorded as an Invoice Payment Received in Company B?We have multiple companies and Company A is constantly buying from Company B, Company C, Company D, etc. It would simplify matters significantly if when we pay the bill in Company A, the invoice in the relevant company is also marked as paid. Thoughts?

We are experiencing this bug:A stock item has previously been invoiced, and a credit memo has been made and released against that stock item. If a user creates another credit memo, referencing the same invoice number, the system will add the stock item(s) at a 0 qty to the credit memo. The ext. price of each stock item will be added to the total, even though the qty is 0.If the qty is changed after adding the item, the system then flags it as it should, and doesn’t allow the qty to increase, and more importantly it recalculates the refund to not have the ext price of that line in the total.Question:Has anyone else experienced this bug, and is there a way to flag this as the system used to and not allow this?  Info:Acumatica 2024 R2 Build 24.210.0019

I have clients that are trying to create GIs and work with their GLTran data.  The amount of data in this table has gotten very large over a few years of usage.  It significantly limits the GI filter capabilities as this dataset gets larger.  What options do customers have to create helpful GIs as their dataset gets larger. Here is an example:A client created a GI on just the GLTran table.  There are no table joins.The GI will pull back a record count if the last filter is removed (BETWEEN).  It sometimes pulls back a record count if the two filters with the date range are turned on.This is very frustrating that the filter capabilities become extremely more limited as the dataset gets larger.Does anyone have any suggestions or recommendations as we have experienced this in other places as well?

We recently migrated all our SKUs from average to standard costing due to average costs getting all mixed up. We did this by issuing out all of the inventory, updating costing to standard and entering a receipt back in. I am running the inventory valuation report but continuing to see the inventory valued at average cost rather than the new standard cost of the SKU for many items. One example is the following SKU:L175:Standard Cost - $42QTY on Hand - 425Expected Cost - $17,850 Cost per Valuation ReportAverage Cost - $235QTY on Hand - 425Cost on Inventory Valuation Report - $99,875 This appears to be an issue for all SKUs with an INCost ValMethod of “A”.Any reason why this INCost ValMethod would remain as average despite the SKU having

Hi Acumatica, I would like to show the report results for only a specific set of subaccounts. A comma separated list as input would be ideal. Is there a way to achieve this? It seems if I enter a start and end subaccount that only shows the numerical order but Id like to have the report shown for a grouping of non-sequential subaccounts.Thanks!!!!  

We are looking to utilize our company credit cards more to accumulate rewards.  My issue is - I do not want to lose the vendor history.  For example, we have used a vendor for many years and have always paid by check.  Now we want to pay with a credit card.  How can I do this?  The library says the “vendor” needs to be the credit card company.  But I want the vendor to stay as it has been.  Can I add “Credit Card” as a payment option?  And if so, then how does it work when I need to pay the credit card balance?  Thank you in advance for any insight!!

Hello all.  We are currently about to roll out the Request and Requisiton process for Purchase Orders.  I’ve been trying to figure out how to link the Requested By of the Request to the PO.  We want to see who submitted the request on the Purchase Order screen and the Purchase Order Report.  But I am having a hard time figuring out the connections.  Has anyone does this before?

Hello all,I have a scenario where I would like to record a payment against a PO via credit card as the vendor required upfront costs. We then have the AMEX defined as a liability for this so, then we pay the AMEX. So its like instead of debiting the record again I would like to debit the liability.How can I achieve this? Is it like under the I define the AMEX as a cash A/c under a liability GL account?Let me know your thoughts on this.Thanks.

Hi, I am a Newbie in AcumaticaI need to export in an excel format the full General Ledger, please can somebody tell me how?Regards 

Having an issue with adding the tax registration ID attached to a customer location.   

Hi Team, The hierarchy of posting.  Item-Level Accounts Take Precedence → If the GL Account is specified in the Stock Item, it will be used before checking the Posting Class. Transaction Overrides Are Always First→ If an account is manually set on a transaction (Receipt, Bill, Invoice, Adjustment), it overrides all other settings. Posting Class Acts as a Default → The Posting Class is the fallback if an Item does not have a specific account. Warehouse Accounting Can Affect Posting→ If enabled, Warehouse-Specific GL Accounts may override the Posting Class. Company Defaults Are Last Resort → If no account is found at the Item, Posting Class, or Warehouse level, Acumatica uses the default GL accounts from Inventory Preferences

I want to release fixed asset. But this error occured. How to fixing this? So I can release the asset 

Has anyone setup Bank Feeds loaded from a file? I’m struggling to find documentation on how the data provider is setup for the bank feed integration to work. We have the sftp credentials from the bank loaded but just need to know how we create the data provider on the Bank Feeds screen. Thanks https://elangham.acumatica.com/(W(456))/Help?CompanyID=Langham+-+Production&ScreenId=ShowWiki&pageid=155354ab-696c-403f-8797-dbded1188e16

We discovered that AP Migration Mode does NOT prevent deferral schedules from posting to GL. How should we handle legacy prepaid migration.

How to create budget in Acumatica? because I can’t input or import excel of budget 

Client recently added Bank Feeds (Acumatica 24R1) and set up a feed via Plaid to their operating account. The feed pulled part of 1 day’s transactions from the middle of the prior month (both in test mode and live), then received an error: The bank feed service (path: 0/plaid/transactions/get) returned the following server error: the requested product is not yet ready. please provide a webhook or try the request again later. Client then deleted the feed and connected with the same error after trying to pull from the following month. Attempts to retrieve additional transactions gets the same error.I have confirmed via the bank statement that there are many transactions over the last month and a half. Where are they?

Hi there,I’m wanting to create journals that hit Inventory ID.For background, we only have non-stock items, and don’t have any stock items as our business doesn’t deal with inventory.However, when I click into Inventory ID to select a stock item, the pop up only shows Stock items, which of course we don’t use/don’t have any. How do I get it to show our Non Stock so I can select that?In contrast, the journals seem to be able to do this, below is a journal with a source document originating from the Receivables module, where the non stock item has been chosen on the invoice document. 

I am struggling to get my automation to open GL Periods on a specific day of the month. This is the current schedule and conditions that I have,However I do not understand how to do relative values with the relative checkbox.I cannot use equations in these condition fields, so I am stuck.Can anyone help me with this? 

Wondering how everyone is handling the tariffs?  It’s easy enough when a vendor issues a price increase that I can just pass through.  My issue is when I am getting hit with tariff lines on invoices from vendors.  Not sure how to accurately absorb those lines on incoming PO’s and pass them along on a Sales Order without a ton of manual work.

Hello, i want to create Fixed Asset manually without PO or AP Bill. Because the company have the asset like form 2015. So, i thought we can create directly form Fixed Asset - Profile. Bu when i try to process to Depreciation, I can not get the amount of depreciation and when i try to check the Asset, in the detail tab of Reconciliation there is a warning “The fixed asset has unreleased purchasing transactions’ but when i try to release it, the error happen. Please somebody help me, i’ve been stuck to solve about thisssss, pleaseee helppp!!!😭😭, thankkk youu😃  

Has anyone seen an integration with Ramp (www.ramp.com) for Acumatica? I’ve seen an uptick in prospects looking for an integration with Ramp. This system looks to be what many start-ups are using for issuing Corporate Cards to employees. I’ve heard some people say that Ramp works with Plaid but I can’t find anything supporting that. 

How do I import the attachment with an import scenario?   The AP Document has an file attachment.  I am creating the AR Document based on the document lines in the AP Document. I can get the attachment file in an generic inquiry - On the APInvoice it is the NoteIdWith the import scenario I have the option to update the Note Text field but do not find the option to update the Files. 

We have customers with 60-day payment terms, but it typically takes them 5-7 days to process payments after they're initiated. This causes invoices to show as past due in our Aged AR reports even though the customer has already started the payment process.Is there an out-of-the-box way to add a "grace period" or "payment processing buffer" to the Aged AR aging calculations? Ideally, we'd like to add 5 days to the due date before an invoice shows as past due in our reports.I know we could adjust the payment terms from 60 to 65 days, but we want to keep the actual invoice due dates at 60 days and only adjust how aging is calculated for reporting purposes.Has anyone solved this issue?

Hello Acumatica Community members,Do you know if it is possible to see the time a transaction is posted without having to turn on audit activity? I’d like to see the time stamp on our generic inquiry in Accounts Payable and Accounts Receivable. Thank you,Kay Howe