Financials

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

  • 1,470 Topics
  • 4,877 Replies

1470 Topics

S
Freshman I
saheed ridwan domain plusltd cFreshman I
asked in Financials

Fixed Asset

Hello All,Trust you are fine.I was about running disposal of fixed asset and it complains of UNRECONCILED ASSET CAN NOT BE DISPOSED. However, The depreciation has been calculated up to the month of disposal Please, any help on how to reconcile under the reconciliation tab and what is meant by that. Thanks in anticipation of swift response from the community.

7
Y
Acumatica Employee
11 months ago
D
Freshman II
dsenevirathne54Freshman II
asked in Financials

Reverse/Roll Back Depreciation

Hi,What is the option available to roll-back/reverse depreciation for a specific fixed assets or a class of assets.  Thanks,Dulanjana 

11
H
Freshman I
1 year ago
M
Acumatica Employee
MPushpakumara48Acumatica Employee
asked in Financials

Restriction Groups

What is the difference between restriction groups of type A and type B?

2
M
Acumatica Employee
1 year ago
N
Semi-Pro I
NoahSemi-Pro I
asked in Financials

Cost calculation for non-stock kits, where is the cost?

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

2
Dana Moffat
Acumatica Moderator
2 days ago
E
Jr Varsity II
erinJr Varsity II
asked in Financials

Time and Expenses : How to set email notification to sender once the claim is approved

Hi Anyone know how to set the email notification in “ Time and Expenses”?We would like the system can auto send out the notfication email to the sender when their claim is approved so that sender can go in and release the claim accordingly.Otherwise , sender dont know when the claim is approved. Hope to hear from you soon. Thank you

1
Irina
Community Manager
3 years ago
L
Freshman I
lori00Freshman I
asked in Financials

customer refund

Is there a way to print a check for a customer refund that is not tied to the credit memo process?  The GITHUB package is not an option.

4
T
Freshman I
2 months ago
saiful murad
Jr Varsity II
saiful murad
asked in Financials

2020R2 AP Automation - Incoming Documents screen

Hi,Eagerly downloaded the SalesDemo snapshot for 2020R2 and searched high and low for the Incoming Documents screen, which was demo-ed by Doug in the launch. Found it in Site Map (AP.30.11.00) but its not appearing in the default Payables Workspace.Are there any additional settings or configurations for it to appear and immediately use?

5
D
Varsity I
9 months ago
B
Jr Varsity III
brucewarrell96Jr Varsity III
asked in Financials

Bank Feeds Customization Package for v2021 R2

Does Bank Feeds support v2021 R2 yet?

2
Doug Johnson
Community Manager
1 year ago
B
Freshman II
byates
asked in Financials

Correcting AR Invoice Date to Different Period

Hello, I have a released AR invoice that had the incorrect date entered. I have tried to correct the invoice date, which moved from July into June period, and when trying to release the corrected invoice I get an error;“Inserting 'Applications' record raised at least one error. Please review the errors. Unable to apply the document because the application period precedes the financial period of the document.”So it appears it is due to crossing to a prior period. How can I correct this AR invoice and get it in the correct financial period? 

4
L
Freshman I
1 month ago
K
Freshman II
khairiFreshman II
asked in Financials

sub Report Parameters

Helloi just add a parameter in my report to select the account range it works fine but i want my filter to suggest the list of the account i writing like this one but its not working this is what the filter looks like  i tried to add the branch id like the standard filter but its not working 

1
lauraj46
Captain II
2 years ago
E
Jr Varsity II
erinJr Varsity II
asked in Financials

How to split the Profit & Loss financial Report based on branch?

Hi Anyone know how to split the profit & loss financial report based on branch?Currently, our Profit and loss financial report is combine 2 branch into one.Based on existing combine Profit and loss financial report, Not sure if anyone one know how to create/split a Profit and Loss financial report to individual branch 

2
N
Freshman I
8 months ago
S
Jr Varsity II
suemackeown13Jr Varsity II
asked in Financials

Formatting a date in Report Designer

Does anyone know of a way to format a date in report designer as follows:10th October 2022I can get the date, month and year correct, but not the ‘th’.Is this possible? 

4
S
Jr Varsity II
1 year ago
L
Freshman I
lbrewsterFreshman I
posted in Financials

Has anyone ever configured Acumatica to produce an export for WIRES - (not ACH)?

We have a client that wants to upload a file to their bank for international wire transfers.  Has anyone ever tried doing this before?

4
Gabriel Michaud
Captain II
1 year ago
E
Freshman I
ekermaniFreshman I
asked in Financials

How do I build a custom connector for Power Automate?

Hi,I’ve been trying to build a custom connector from Powerautomate and it is not authenticating me. I have tried both Post authentification using Json as well as OAuth2.9 from Postman and they were both successful. Issue #1:I’ve tried the api key authentication but don’t know where to find the API key for acumatica? Can someone let me know where to find it please?Issue #2: In lieu of the API Key authentication, I tried OAuth2.0 but keep getting the error: “The client application is not known or is not authorized”Can you please confirm that my URLS are correct, I need the following fields:Host: Host.acumatica.comClient id: generated in acumatica under connected applicationClient Secret: generated in acumatica under connected applicationAuthorization URL: https://Host.acumatica.com/identity/connect/authorizeToken URL: https://Host.acumatica.com/identity/connect/tokenRefresh URL: https://Host.acumatica.com/identity/connect/tokenScope: api

6
jmckinnon
Freshman II
10 months ago
nithyashankar71
Jr Varsity II
nithyashankar71Jr Varsity II
asked in Financials

GL Error: Missing Account Mapping for Branch 'CAPITAL ' and 'PRODWHOLE '

Hi Team,While releasing the “ Inventory Receipt”, I am getting the error ” GL Error: Missing Account Mapping for Branch 'CAPITAL ' and 'PRODWHOLE '” . Kindly suggest the missing one here.

6
F
Freshman I
3 months ago
A
Jr Varsity I
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?  

9
A
Jr Varsity I
1 year ago
E
Jr Varsity II
erinJr Varsity II
asked in Financials

How to create approval flow in Expenses Claim

Hi SirNot sure if anyone know how to create the approval flow in the Expenses Claim?It would be good if you can give me a guide/step to create the approval flow.Reefe to below, there is not able to “ add” in the approval details. 

5
V
Freshman I
5 months ago
patrickcolgan94
Freshman I
patrickcolgan94Freshman I
asked in Financials

Best Practice to Convert Multiple Purchases over to Single Fixed Asset.

What is the best method to Convert Multiple Purchases over to Single Fixed Asset.A customer buys multiple laptops (Qty 8, similar Class, similar useful life) each at $1,000 on different dates or the same date.  What is the best method to convert to an Asset.Fixed Asset thresh hold to capitalize is $5,000.Do you setup an Asset with zero value and convert the 8 purchases as components to one Fixed Asset? Or would you setup an Asset with summary amount of $8,000 and then convert purchases as components to this Asset #?    Or do you setup a Parent Asset then add each converted purchase line amount to an Asset associated with the Parent Asset?  

6
L
Freshman II
1 year ago
D
Freshman I
danielosheaFreshman I
asked in Financials

TimeCard correction problem - The Employee Labour Cost Rate has not been found

We have a problem when correcting time cards after they have been approved and released. It appears where we have work items associated with a task we get the error "The Employee Labour Cost Rate has not been found". So we cannot release the card. We don't have this problem if the work item is not associated with a task.Have you come across this before? Any ideas on a solution, please?  

5
S
Freshman II
1 year ago
K
Freshman I
KC2022Freshman I
asked in Financials

Cash Account Configuration

Hi! I made some error upon creating cash account. I have made the Accounts Receivable as cash account. Is there any workaround for this? System says that I can no longer delete the cash account and change it, as there is already GL transactions made prior to creation of Cash account. Highlighted in yellow is the wrong account entered. 

14
Laura02
Captain II
1 year ago
V
Freshman II
ViweMFreshman II
asked in Financials

Change the account type of a GL Account from the database

Is there anyway of changing the account type of a GL Account from the database. I understand its not possible from Acumatica’s Chart of Account screen so I think a script is the most possible options but I am not sure which tables store the account type.

7
T
Jr Varsity II
7 months ago
B
Jr Varsity III
bduprey51Jr Varsity III
asked in Financials

Modify how Voided Checks are displayed & calculated on the bank reconciliation

Often a client will issue a check in one financial period and then void it in another.  If the check is voided before the bank reconciliation is done, the check has a balance of 0 on the bank rec.The proper way to handle this is to include the amount as outstanding in the month is was issued and voided/cleared in the month it was voided.For instance, if a check is issued 8/15/2022 for $5,000 and voided on 9/10/2022.  The August, 2022 reconciliation needs to show the $5,000 as an outstanding item.  

7
coleenmcnally22
Jr Varsity II
10 months ago
A
Freshman I
ASamson21Freshman I
asked in Financials

Restrict Visibility of GL Account and Subaccount by Company/Branch

Hi All, How can I restrict a GL Account and Subaccount to specific company/branch?Any help will be highly appreciated. Thanks, Anne Samson

8
A
Freshman I
1 year ago
E
Jr Varsity II
erinJr Varsity II
posted in Financials

Transaction " Status

Hi SirWe do the same for 2 transaction for vendor Chubbsg and Platinum28 . Issue a Debit note to offset the Credit Adjustment.However,  CHUBBSG ‘s status is CLOSED  but PLATINUM28 ‘s status is OPEN .Plesae refer to belowIs there any one know what is the reason behind? 

4
E
Jr Varsity II
2 years ago
K
Jr Varsity III
ketillerJr Varsity III
asked in Financials

AR Register report - Error "Object reference not set to an instance of an object"

Hello,I am receiving the following error when trying to change the financial period to August “08-2022” the financial period is still open. Has anyone seen this error?Thank you,  

7
Chris Hackett
Community Manager
1 year ago

Badge winners

Show all badges
Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2023  Acumatica, Inc. All rights reserved