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,162 Topics
7,224 Replies

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

2162 Topics

Most replies

Most views

Newest first

saheed ridwan domain plusltd cFreshman I

asked in Financials

How to bring in Bank opening Balance after already posting transactions

Hello COmmunity,I am simulation a process.Assuming a client go live. On the bank module, transactions like inter bank transfers, payment, bank charges etc have been posted against a bank.HOw can I bring in the opening balance of the bank before go live so that the bank balance can be use to relate with the reduce the negative value to it actual value….. Thanks in anticipation

11632

2 years ago

bradyr82Freshman I

asked in Financials

Can't delete sub account

Can’t delete a sub account. Can’t figure out where to find the rest of them so i can delete them. 2/3/2022 6:54:58 PM Warning at ParentDeletingHandler.cs:159:RaiseConstaintViolationException():Subaccount (00 - -) cannot be deleted because it is referenced in multiple tables. 1: Currency (USD) - Foreign key Currency(aRProvSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute 2: Currency (USD) - Foreign key Currency(aPProvSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute 3: Location (118, MAIN) - Foreign key Location(cSalesSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute 4: Location (118, MAIN) - Foreign key Location(cDiscountSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute 5: Location (118, MAIN) - Foreign key Location(cRetainageSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute

2221

2 years ago

sharonconkey87Freshman I

asked in Financials

Dunn & Bradstreet integration

Does anyone know if there is an integration with Dunn & Bradstreet or any other credit checking facility for Acumatica? ThanksSharon

461

2 years ago

xkylewrightxSemi-Pro I

asked in Financials

Email invoices but not credit memos

Is there a way to permanently exclude credit and debit memos from the Print/Email process? IE we would like memos to permanently not show up on Print Invoices and Memos screen (filter not really acceptable) and not trigger the Invoice notification template defined in AR preferences Thank you!!

1125

2 years ago

gbrazelton14Jr Varsity III

asked in Financials

AP Quick Check - variables to show the individual Line descriptions

Our customer often pays multiple different charges to a vendor on a Quick Check. They are populating the Transaction Descriptions on the individual Document Details lines of the Quick Check screen.I have studied the AP Check with Remittance format and am unable to determine how to set up additional variables for each line on the AP check that correspond to the APTran.TranDesc values on the quick check. Normal checks are properly printing with Bill type and Reference numbers on the stubs, but I am not able to determine how to display the line descriptions when printing a Quick Check. This seems like something that would already exist, but I do not see a table included on the report format that would tie to the quick check details.Does anyone have a solution already for this? Thank you,Greg

Shopify - Acumatica Sales Tax Rounding Issue - Avalara AvaTax

Has anyone else experienced issues with rounding errors between Acumatica and Shopify?We have Shopify Plus with Avalara AvaTax integration, and Avalara AvaTax in Acumatica for all other orders We are regularly seeing rounding errors of a few cents between what gets calculated on the front end in checkout vs. what gets calculated in the sales order in Acumatica when our connector imports it There does not appear to be an option to force the tax amount from Shopify and bypass the tax calculation in Acumatica so that all totals lines upFYI we are not yet on Acumatica Commerce so using a custom connector.I know this is a typical issue and often just handled with a “slop” account for rounding errors, but just wish this wasn’t the case since Avalara should be making the calculation in the same way regardless of the platform. Guessing there are some character limits that may be causing this? Either way, curious if anyone else has experienced this and how you dealt with it? Thanks in advance!

8945

2 years ago

Doug JohnsonAcumatica VP, Product Management

posted in Financials

1099-MISC and 1099-NEC updates for Tax Year 2021

For tax year 2021, the IRS made minor changes to the 1099-MISC and 1099-NEC forms. Details of the changes can be found on the IRS website. Acumatica will implement these changes in upcoming versions of the software to assist with customer 1099 filings. There are 3 changes that impact Acumatica.Form 1099-NEC sizing. Acumatica will reduce the height of the form to match IRS changes. Form 1099-MISC, box 11. New use for box 11 includes any reporting under section 6050R, regarding cash payments for the purchase of fish for resale purposes, from a individual or corporation who is engaged in catching fish. Form 1099-NEC, box 2. Payers may use either box 2 on Form 1099-NEC or box 7 on Form 1099-MISC to report any sales totaling $5,000 or more of consumer products for resale, on buy-sell, deposit-commission, or any other basis.1099 Paper Forms:Changes to the 1099 Paper forms are currently available in the following builds of Acumatica:2021 R2 Update 3 Hotfix 1 (21.203.0030) and later 2021 R1 Up

330033

2 years ago

alicia23Jr Varsity III

asked in Financials

@Quarter functions on fiscal year vs calendar year

I have a client that needs generic inquiries and dashboards to go off of their fiscal year and not the calendar year. So in order for the inquiries / dashboards to be dynamic i need the @ functions or something like them to go off of their financial periods which are a fiscal year

gmercedeVarsity I

Where can I download the 2021 R1 compatible Bank Feeds Customization Package?

6727

2 years ago

kmckenzieJr Varsity III

asked in Financials

AP Approval

Where is the best place to learn about setting up the AP Approval process/Workflow? I have looked in University catalog and nothing seems to really fit. Thanks!

5293

2 years ago

cmorelandSemi-Pro III

asked in Financials

Turnover REports

Is there a canned or good way of generating turnover reports across branches?

1173

2 years ago

lauracastagnaVarsity I

asked in Financials

Refresh Currency Rates Automation schedule stops working and only updates previous day

Hi All, @Naveen B, I have set up an Automation Schedule for “Refresh Currency Rates”. I will only update the previous day rather than the date that it runs. Also the schedule just stops running ever few days. Is this a known issue? Any response appreciated.My settings for the Schedule is as follows:-

24119

2 years ago

lauracastagnaVarsity I

asked in Financials

Is Approval map for AR Write Off's possible?

Hi All, @Irina, @Naveen B , When going into the “Write off Balances and Credits” screen and running this to write off Balances, the client would like an approval prior to the document posting. Is this possible as I cant seem to get anything working? Cheers,Laura

1001

2 years ago

cherleneFreshman I

asked in Financials

Report Profit and loss based on item class?

Hi I would like to generate P&L based on item class per below, but keep failing to find the right definition.Does anyone know the definition? Thanks in advance!

3037

2 years ago

erinJr Varsity II

asked in Financials

Dashboard chart data not tally with data base record

Hi SirWe do a chart in dashboard, however we notice that the below in Black box -SSD is 4% margin. However , from the database , the margin should be negative 6% Is there anyone can advise what is the reason?Herewith the screenshot of dashboard and the chart configure for your reference/

624

2 years ago

rsudkamp69Jr Varsity II

asked in Financials

Tying Vendor Record to Credit Card Receipt

Is there a way to link an expense receipt for credit card to the vendor record? Sometimes we pay for vendor bills on credit card, but they also need a 1099, but I can’t find where to link that to the vendor totals for end of year 1099 reporting.

1805

2 years ago

abeckerman65Jr Varsity I

asked in Financials

shipping address

On a Purchase Order, is there a more efficient way to enter a different Ship-To Address and Ship-To Contact (of our company) than by checking 'Override' and typing in an alternate address/contact?

Default Customer Print Statement Settings

Is there a way to change “All Customers” statement settings to (Print Statements)?

882

2 years ago