Community
Discussion Forums
Financials

Financials

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

2,071 Topics
6,936 Replies

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

2071 Topics

Recently active

Most replies Most views Newest first

MarciaWVarsity I

asked in Financials

Currency Value Attribute

Hi allI would like to know if anyone can supply me with the regular expression for creating an attribute with a currency value. In other words, the value entered here must have two decimal points and be a number.I have voted for numeric type attributes, let’s hope we see it in a future version!Also, please let me know where I can find some resources on how to create my own regular expressions, it looks like Greek to me :-)

471

2 months ago

sangland2Freshman I

asked in Financials

Setting Business Date in automation schedules

Is it possible to set the business date in an automation schedule? Invoices are prepared using the process at month end because consolidation of sales orders is necessary. The volumes are high and when users run the process it may fail when it gets over 1 hour, resulting in no consolidation. So running the prepare in an automation should take care care of this. However invoicing does not start until day1 of the new period. Users set their business date back to ensure correct invoice date/period, hence the request.

504

2 months ago

rfrantzFreshman I

asked in Financials

Accurate AR Aging Report

Good morning,I am curious if there is already a report in Acumatica available that would show me an accurate AR aging for customers.I currently utilize the AR Aging Period - Sensitive report...but that will give me customers that still have open orders on their account, thus creating a “credit” on their accounts on the report. I would like to see a report that just shows invoiced customers basically...is there already a report available or have you found that you need to customize a report?

1496

2 months ago

dsimmerlySemi-Pro III

asked in Financials

Acumatica Payments

I am just learning Acumaitca Payments and trying to document the process for our customerAt the very beginning of the documentation it says “contact the Acumatica Payments sales team”Here the link where that is found…https://help.acumatica.com/(W(3))/Help?ScreenId=ShowWiki&pageid=7f8613be-52c8-444a-9048-dcaece4aaad3How do I “contact the Acumatica Payments sales team” or does the end customer do this ?

806

2 months ago

SallyAGFreshman II

asked in Financials

How can I get a subaccount description to print in the ARM Heading of the report

Hi All, I have an ARM P&L report that is using unit sets that allows selections by Company and branches. The report is structured to enable the selection of accounts by sub accounts. However, the headings are only printing the sub account code (which is meaningless to the recipient| and the site have 90 sub accounts used for reporting). Is there a way that I can get the actual sub account description to print in the heading as shown below (where administration is sub account 09) and North Shore, Warkworth etc is the branch name.Below is what is actually printing.Any advice would be much appreciated.thanking youSally

272

2 months ago

PaulMainard55Varsity I

asked in Financials

Stub Stub Check AP Check Report

Hi Acumaticans.Looking for a check format as noted above. Client refuses to buy new check stock and would be great to not have to reinvent the wheel. This report design is too painful to work with when it comes to making these kinds of layout changes.

471

2 months ago

LeslieAnnFreshman I

asked in Financials

Branch allocations for different subaccounts

We make use of a few branches, and our setup is done on several subaccount levels, I want to find out if it’s possible to set up rules that will accommodate an employee of a branch, to book transactions or time on the same branch but a different subaccount and then allowing the cost the be transferred to the subaccount used.

556

2 months ago

driesdeklerk50Jr Varsity III

asked in Financials

Print invoice showing blank

Good day all, We are trying to print an invoice from the invoices/memos screen but it comes out blank. but it is not always doing it. What can be the problem

512

2 months ago

stacy16Varsity I

asked in Financials

Deposit clearing cash account showing a balance after deposit has been made

Hello!Is there a reason there would be a balance left in my deposit clearing cash account after i have already done all the deposits and “cleared” the cash out?Any help would be appreciated! :)Thank you!

626

2 months ago

dsenevirathne54Jr Varsity III

asked in Financials

Reconciliation Statement Report - Reconciled Documents Dated After Reconciliation date

Hi,Do you know how transactions are picked into the “Reconciled Documents Dated After < Reconciliation Date> “ . And how can we fixes the difference? Appreciate your help. Thank You,Dulanjana

234

2 months ago

jmcclelland95Freshman II

asked in Financials

Why doesn't an Expense Claim push the Unit Rate to the Project Transaction?

I want to use the Unit Rate to allocate billable expenses to a COGS account but the Unit Rate does not get pushed to the Project Transaction. I can’t find a “Known Issue”. Is this standard Acumatica?

286

2 months ago

bsullivan08Freshman I

asked in Financials

Exported Excel reports with repeating Headers

When you export reports from Acumatica to excel, the headers of the report are repeated at every screen break. How do you stop these headers from repeating in excel? There are no page breaks in the column sets or row sets. This is something that annoys many clients, as they have to manually remove the headers from the excel file every time they export a report.

1796

2 months ago

aaghaeiCaptain II

asked in Financials

Can we conditionally tax items based on the company/branch does the purchasing.

Hello all,I am wondering how we can configure the system Purchase Order/Receiving/AP Bills to conditionally calculate tax or make exception based on the Company/Branch buying from a vendor? Vendors profiles are shared between all companies but some of our companies have tax exemptions, and some don’t. So, when we purchase stock/nonstock items using PO to AP or direct AP Bill, depending on what company/branch is the buyer, taxes should be added to the items or be exempted. How can we do this?

130

2 months ago

pcraske31Freshman I

asked in Financials

Process to update vendor default gl account and sub account

Could someone please advise how to update the default Vendor GL information in the location table?I have 650 records that need updating!Thank you.

Hi! I just took over AR and can’t seem to find an “easy” Excel report for my AR Aging.The ones I have pulled don’t have the Vendor Name on the same line as the invoice detail. Does anyone have an easy solution?Thank you so much!

351

2 months ago

yashodhalakshini85Freshman I

asked in Financials

GST Returns from Acumatica

Hi Team,Is there any report which can be used as GST return and schedules within Acumatica? One of our client’s need to get the GST returns and the relevant formats from Acumatica. Is is possible? Where to get? Thank You Yashodha

211

2 months ago

Kandy BeattyCaptain II

asked in Financials

ARM reporting description showing code

Hi All,This may be something I am just missing or having a moment, but when I am trying to show an Account on a Balance Sheet and I put just Description, it is still giving me the Code. Does anyone have a way to get the code off the reporting, I want to show only the description?

332

2 months ago

kyle90Semi-Pro I

asked in Financials

Sending SO Invoice with SO505000 (regardless of invoice status)

I think I’m not understanding the logic of the Process Invoices and Memos screen (SO505000) First - From the wiki, the only prerequisites mentioned for using this screen are:Email Invoice: Sends the selected invoices via email. The document selected for processing will be emailed only if the following conditions are met: This document has not been emailed before (the Emailed check box is cleared on the Invoices form). The customer account has the Send Invoices by Email check box selected. The Credit Hold check box is not selected for this document. However - we are seeing that only invoices in a Balanced Status can be emailed from this screen. Once the invoices has been released, your only option to email the invoice using a process screen is from AR508000 This appears to be intentional, although not documented well in the Wiki. I have a hard time understanding why we could only send unreleased SO Invoices or released AR invoices Our issue - we would like to email the SO invoices da

1134

2 months ago

HarrySemi-Pro II

asked in Financials

How to remove subaccount from different screens?

Hello all,I have been looking out for ways to find out the list of the transactions/master data where a specific subaccount has been used. How can I get the list?Any suggestions?Thanks.

243

2 months ago

mruizFreshman I

asked in Financials

How to create a report that compares budget ledger to actual ledger?

I think I need to create a new column set but don’t know how to set up the formula so that in one single report I can view an actual vs budget. Also, not sure if I am able to do this in the ARM reports?

4725

2 months ago

bmardanianFreshman I

asked in Financials

Inquiry on Setting Up Courtesy Reminders in Acumatica

Hello,We are trying to set up a process in Acumatica to send our customers a Courtesy Reminder 7 days before the due date. Initially, we considered creating a Dunning Level with a negative Due Date value, such as “-7,” but it defaults to 30 days, and it seems that the Dunning Level feature does not work with less than 1 day.We understand that another approach could be creating generic inquiries and using business events, but we want to confirm whether the Dunning Letter feature is intended only for overdue documents and not for those approaching the due date.I would appreciate any insights you can provide regarding this procedure.Thank you!

272

2 months ago

jmorganJr Varsity III

posted in Financials

Auto update sub account segment values

Our clients use segments for a variety of things, customers, projects, product etc,When they add a new value to the segment they have to go into the segment value screen and make the entry.This is dangerous as all segments are available and they could make accidental changes.Moreover there is a great efficiency to be had by declaring that at segment refers to say projects or a customer class or a product code for example, and then have the system insert the segment whenever a new project./ customer class / product is created.Thanks

How to import Disposed Fixed Assets by Import scenario

Hello,My client needs to upload a lot of disposed Fixed Asset in Acumatica.When I did the upload of arraund 5,000 FA I didn’t have problems with the fixed Assets with Active and Fully Depreciate Status, but when I try to import disposed FA the sisten generates active status for disposed FA. Please can you help me with the step by step of the upload of Dispose Fixed Asset by Import Scenarios?Thank youKarolina Ramírez.

170

2 months ago

bclarkJr Varsity II

asked in Financials

Shopify Line Discounts vs Acumatica Order Discounts

Hello, We’ve recently moved to Shopify for POS and ecommerce. We’ve created discounts in Shopify which gets discounted at the line level. However, we have the connection set to Order level discounts when syncing into Acumatica because the Line Level discounts do not link back to the Inventory ID’s when discounting at the GL level. The issue now is when we have an order come through with a discount AND an item that is taxable. Acumatica order discounts don’t reduce the taxable amount of the item fully, but in Shopify the taxable item was discounted correctly so the taxable amount was less. Any recommendations on how to resolve these discrepancies? Thanks!

331

2 months ago

dstjohn84Freshman I

asked in Financials

Calendar Year vs. Non-Standard Fiscal Year

How can a Calendar Fiscal Year be changed to a Non-Standard Fiscal Year?

2042

2 months ago

Page 7 / 83

Badge winners

arthia98has earned the badge Easy talker
eucciferri35has earned the badge Easy talker
jwang1has earned the badge Easy talker
DharmandarKumarhas earned the badge Easy talker
riglesiashas earned the badge Acumatica expert

Show all badges

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Social Login

Login to the community

Social Login

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.