Learn
Learn
Support
Support
Product
Community
Partners
MAP
- Marketing Automation Platform

Community
Discussion Forums
Financials

Financials

General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Deferred Revenue, Taxes, Currency Management

2,165 Topics
7,234 Replies

When you subscribe we will email you when there is a new topic in this category

2165 Topics

enriqueyFreshman I

Outstanding checks report

Where is the outstanding checks report? I can’t find in Acumatica.

5042

1 year ago

hjosephdcmFreshman I

asked in Financials

Automating Sales Order to Sales Invoice Process

I need assistance determining how to automate the process of taking a completed (i.e. shipped and invoiced) sales order that imports in from a 3rd party application to a sales invoice. Inventory is not being tracked and under Sales Order PreferencesHowever, the sales invoices are not posting on the shipment date, but the date the order is being processed in Acumatica. I want to use the Quick Process function but was told by the consultants that this feature cannot be used if the sales invoice needs to be posted on the shipment date. How do I automate this with the release date the shipment date?

3362

1 year ago

kristianharianjaSemi-Pro I

asked in Financials

Overpay invoice

The customer of our client pay bulk amount for multiple invoices. The customer also include list of invoices (in excel) that are paid and how much of each invoice paid. Some are overpaid, some match, some are underpaid. The client needs to be able to apply the overpayment to an invoice so that they can track which invoice that has been paid more than it should be. Is there a way to do that without creating one payment application per invoice?

2804

1 year ago

GhazalshokrollahiJr Varsity III

asked in Financials

Fully depreciated Assets with NBV 0 , How to stop depreciation

Hi All,I have imported some assets which are 0 NBV and are fully depreciated. depreciation method is DV and the asset is depreciated sooner than when it should be. when I calculate the Depreciation it still calculate depreciation amount eventhough it should be zero. how can I stop this? I cannot seem to see any status of fully depreciated on the front end. Thanks for your helpGhazal

3464

1 year ago

jamesbarnettFreshman I

asked in Financials

R&D materials / R&D tax credits

Our UK based organisation has an R&D department with a team of about 30 people. We intend to set up a separate R&D warehouse within Acumatica, configured in such a way that the value of the stock within it is posted to an expense account on the PL - i.e. has zero value. Each time an item is purchased by R&D, it will be entered as a stock inventory item (with a stock inventory item class) and the default warehouse will be set to R&D. We will also set a custom checkbox on the item to flag it as R&D. When the items are received into the R&D warehouse, we would then be treating them as an expense, while at the same time having the ability to transfer items out of the R&D warehouse and into the main warehouse when they move from a prototype R&D phase and into production - so that their value then appears as stock on hand (by unchecking the R&D flag and doing a transfer).Please forgive my lack of knowledge:Does that setup sound like it would work? I was ho

280

1 year ago

juneterris87Freshman II

asked in Financials

Purchase Invoice Approval - Approved By user who createdPO

I have a scenario where when a purchase invoice is received and matched against the purchase order I want the purchase invoice to be approved by the owner of the purchase order.I have tried different options using the employee from list option on the approvers tab but cannot get this approval working.The only way I can get this working is if I specify a rule per user listing the user on the condition tab and again as an employee on the approver tab. With more than 100 users entering purchase orders this well not be easy to maintain.Anyone came across using the employee from list for this purpose and could advise

801

1 year ago

Laura02Captain II

asked in Financials

Mixed Years in Balance Sheet Drill-down to GL Details report

We are running version 2021 R2 in a multi-company, multi-branch environment. The quarterly Balance Sheet shown below has been printed for periods 01-2022 through 12-2022 for one company, “Company C”. There is no unit set, just Row and Column sets.When I click on Total Intercompany receivables as shown, the resulting GL Details report has multiple years included. The total is correct, but the presentation is confusing to the users. Why does the drill-down show records from the previous year? Thank you.

400

1 year ago

ashleybVarsity I

asked in Financials

AR Aged Period Sensitive by AR Account

Hello - Does anyone have an AR Aged Period Sensitive report that subtotals by AR Account?? We are looking for this to easily tie back to our TB.

1641

1 year ago

DonGreenFreshman II

posted in Financials

Multi EIN Company - Divisionalized under one Instance ? - or Multi Instance Multi Company ?

We JUST started implementing Acumatica and have 3 similar companies operating under separate EIN requiring separate P&L, Tax returns, etc.Interested to know if ANY options exist other than separate Tennants/Companies and if there is a viable solution to have a single Tennant/Company with separate divisions.Any suggestions are greatly appreciated.

Webinar: Essential Sales, Marketing, and Support Solution for Increasing Revenue and Customer Satisfaction ( October 5, 2022 at 11AM PT)

Essential Sales, Marketing, and Support Solution for Increasing Revenue and Customer Satisfaction When: October 5, 2022 at 11AM PT Attend this webinar to:Gain an understanding of the unique power of CRM software. See how a CRM workflow maximizes leads, opportunities, and case management. Get an inside look at how Acumatica’s CRM solution performs.Register now to imagine what your business’s life could be like with integrated workflows that automate processes, keep key tasks moving, and share KPIs in real time. https://event.on24.com/wcc/r/3942368/B6BF10D69C6C8489EEB954200E8C1B8F

241

1 year ago

nithyashankarJr Varsity II

asked in Financials

AP Document Recognition

Hi Team,Currently, I am testing AP Document Recognition. I need some clarifications regarding the PO invoice. Once the PO and Receipt are posted in the system. By using the Incoming Documents, I am pushing the invoice to the system. Here, my query is related to the inventory price update during the process. Awaiting for your replies.

6334

1 year ago

myoungFreshman I

asked in Financials

Deleting a released expense claim

I realize expense claims cannot be deleted once released so how do I get rid of the claim that was put in incorrectly but not caught before claim was released. Tried making a negative receipt but that doesn’t work.

1862

1 year ago

JerryMonahanFreshman I

asked in Financials

Can you add % of Sales column to a P&L financial statement?

I’m trying to add a column to my customer’s P&L that will show the % of Sales for each row on the report (e.g., Sales = 100.0%, COGS = 36.2%, etc.). I can add calculations between columns (e.g., (F-E)/E), but not within the same column. Is this possible with the standard financial reports?

1934

1 year ago

jessicaASAVarsity I

asked in Financials

How do we add Entry Types to the Receivable Payment screen?

Is there a trick to getting entry types to show up on the Receivable Payments screen, Charges tab? We are considering using that to record wire fees.On the Entry Types screen, I checked the Deduct from Payment box, but the entry type does not show as an option on the Payments screen. Is there another step I should take? We are on 2022 R1. Thank you.

1452

1 year ago