Skip to main content

Financials

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

  • 2,396 Topics
  • 7,924 Replies
2396 Topics
M
Freshman II
michellec11Freshman II
asked in Financials
Best way to add handle fees

How are people applying handle fees? We have been manually adding a non-stock item to each order. Does anyone do this from an invoice level vs sales order level? How is this working for you?

1276
Chris Hackett
Community Manager
C
Freshman I
chacalawaganFreshman I
asked in Financials
How to correctly override tax amount in Bills and Adjustment

Hi! I would like to ask if it is really possible to override tax amount in Payables Module - Bills and Adjustment. I tried doing it in one of our vendors (Vatinc) but it resulted to wrong value of entries. Can someone enlighten me on how to properly override tax amount.Gross Amount: P31,200.00Taxable Amt.: P27,678.51Tax Amt.: P3,321.49Withholding Tax: P276.82I attached the screenshots of the transaction.Thank you very much. 

2662
Chris Hackett
Community Manager
B
Jr Varsity III
brucewarrell96Jr Varsity III
asked in Financials
Permissions for Adding Contact Records to Customer or Business Accounts

Where are the permissions to allow the adding of contacts on the Customer and/or Business Accounts screens?  I can add contacts on the Contacts screen in the Marketing workspace.

2446
Chris Hackett
Community Manager
S
Jr Varsity III
shuang57Jr Varsity III
asked in Financials
How to add accounts to the list of GL revaluations accounts

Hi guys,If I record a transaction not in the base currency to a GL account (not a cash account) manually (not through AP or AR), and I want to do GL revaluation at the end of the period. How to add this particular account to the list of GL revaluations accounts? Because right now I could only see the cash accounts when I try to revalue GL accounts. Thanks!

1151
Laura02
Captain II
K
Semi-Pro I
krausef77Semi-Pro I
asked in Financials
Default Location Subaccount not pulling into new Customer locations

Happy Friday, We are currently experiencing an interesting issue that the Freight and Freight Subaccount is not pulling in from the Default Customer Location (which pulled it from the customer class/customer).Here the Default Location:Here the New Location with the Checkbox same as Default marked: Not quite sure where I would find a setting or how would troubleshoot this. Cannot find anything in Receivables, Sales Order or CRM Preferences.Any ideas on how to resolve this issue?

1194
V
Acumatica Employee
abdallaahmed61
Varsity III
abdallaahmed61Varsity III
asked in Financials
AP656100 report error

after upgrading my acumatica website to version 2022 R1 im getting this error with the unposted documents reportwhen i click unposted documents in manage financial periods screen 

544
abdallaahmed61
Varsity III
xkylewrightx
Semi-Pro I
xkylewrightxSemi-Pro I
asked in Financials
Change Salesperson on Sales Order

Is there any way to change the salesperson on a sales order after saving the record?Thank you!!

5923
rpiester
Freshman II
martingaxiola
Varsity I
martingaxiolaVarsity I
asked in Financials
How to explain Unposted Journal Transactions

Team, I am struggling to explain Unposted Journal Transactions. I know there are some issues and some scenarios explained, but for normal people, why there is unposted transactions on the system? They are random, and can have a good explanation for my client, every now and then, when closing the month, there will be uposted journal transactions, and there will be no good answer for those. I have put a schedule to post every night unposted transactions to see if the problem goes away, but still want to have a good answer for them. Thank you. 

9279
martingaxiola
Varsity I
D
Freshman II
dipalim18Freshman II
asked in Financials
After an upgrade to Acumatica ERP 2020 R2,In ARinvoice DAC CampaignID field not present.

Hi,On Invoice screen using CampaignID field selector but After an upgrade to Acumatica ERP 2020 R2 it gets vanished.I saw the release note and it has removed the Campaign ID field,But it is the client's requirement, the client needs the Campaign ID field on Invoice Screen (SO303000).so what i need to do for this, can you Help me. 

180
D
Freshman II
F
Freshman I
Fie
asked in Financials
Release Payment adding new column

Hi Team,Asking on your end if it is possible to add a new column from this screen. Regards,

453
Naveen Boga
Captain II
M
Freshman I
MComan62Freshman I
asked in Financials
Applied Prepayments to and invoice will not auto post.

The setup of the system allows AP to auto post when released.  Everything does that except 1 thing.  When we go to close out an invoice that we have completely paid with prepayments the system stops at the Posting stage.  We have to do close the AP this way because its the easiest way to get the money from Vendor deposits to COGS.  Is there a setting that would allow this to happen that we are missing?  This is the only type of transaction that doesnt work.P.S. The invoices are being created from PO’s for a project

2003
Chris Hackett
Community Manager
D
Freshman I
dwoblongFreshman I
asked in Financials
DR Error: Reallocation Pool data cannot be calculated

We are seeing an error that I can no find any information on. “DR Error: Reallocation Pool data cannot be calculated, because the fair value price cannot be found for the combination of: the {INV ID} item, the EACH UOM, the USD currency, and the 3/14/2023 date.”This happens when we try to release an invoice. Any idea what could cause this?Thanks 

1362
D
Freshman I
E
Freshman I
enriqueyFreshman I
asked in Financials
Re-print Check

How do I re-print a check after it as been released?

3633
iqraharrison
Captain II
J
jdille
asked in Financials
Taxes on PO Invoice not posting to inventory

Hi All,I am trying to figure out how to configure ACU so that taxes from PO invoices will post to the inventory account instead of to the AP accrual account. Does anyone know how to do this? Thanks!Jude

37915
K
Semi-Pro II
nithyashankar
Jr Varsity II
nithyashankarJr Varsity II
asked in Financials
Charge Back Process

Hi Team,Do we have the concept of “Charge Back” concept in Acumatica? Thanks,

1616
meganfriesen37
Captain II
K
Freshman I
kaeFreshman I
asked in Financials
How to make petty cash account as a cash account

Dear Acumatica users and experts,Is there any way to make petty cash account as a cash account. The reason I asked because I would like to ask the possibility to access petty cash as a cash account in Receivables Module. The person-in-charge responsible for petty cash but we would like to restrict him/her to use only receivable module Thanks

1373
Kandy Beatty
Captain II
S
Jr Varsity II
satwikh1Jr Varsity II
asked in Financials
Expression Editor under Data Class FixedAsset

Dear experts,Need to know on how to get Fix Asset’s Qty and show it FA Balance Report (FA630000) / Acu2021 R2 because in expression editor under Data Class “FixedAsset” the data field is not available.appreciated for any solution / work around on this.thanks in advance.

140
S
Jr Varsity II
J
Freshman I
Joeldk96Freshman I
asked in Financials
Accounts and Subaccounts on ARM reports

Wondering if I could get some help generating ARM reports with the account and subaccount info expanded.  I have my ARM reports built utilizing account classes as the data sources so I don’t have to manually add every account number onto the reports when we create new accounts.  This has worked well until now when I need to get subaccount details under each account. When I expand data as SUB it does not break it down by account but just give me a total for each subaccount within that account class.  I think I could make this happen by manually adding a line on my row set for every account and a line for  subaccounts under that but I’m hoping there is an easier way that also wouldn’t require as much maintenance in future if we add accounts etc.

8257
Laura02
Captain II
S
Freshman I
shelsantillan96Freshman I
asked in Financials
Does Fixed Asset: Disposal Parameter fields Before Disposal with options "Depreciate" and "Suspend" generates the same outcome?

I have tried to simulate both options but I end up with the same outcome. I expected that upon choosing “suspend”, depreciation would not be computed. 

1122
S
Freshman I
B
Jr Varsity II
brandontfrankJr Varsity II
asked in Financials
Allocations Rules - accumulate costs to a specific cost code?

Right now we have a few allocation rules that are setup to capture cost, every hour, for certain cost codes that get time applied to them from Time Entry. For example… if cost code 00-0010 (cost type Labor) gets entered on time entry for 4 hours - accumulate $400 of cost. The issue is 00-0010 (cost code) E (cost type) is the cost code that automatically gets created for $400. Is there a way we can dictate what cost code those allocation rules accumulate cost towards? Ex: 00-0010 - Cost Code Labor (L) - Cost Type gets selected during time entry, that $400 goes towards 00-2000 Equipment.Seems silly they wouldn’t allow us to dictate where those costs get tracked?

1544
Heidi Dempsey
Community Manager
K
Freshman I
khowe86Freshman I
asked in Financials
One inquiry with all checks (regular checks and quick checks)

Hello!  Have any of you combined the the Quick checks and Regular checks in one inquiry?  We are new to Acumatica but don’t understand why the “check list” isn’t the check list?   Thanks, Kay740-418-5250 (cell)khowe@stockmeister.com

2016
D
Jr Varsity II
F
Freshman I
frankd97Freshman I
asked in Financials
Prepayment Request do not validate terms and calculate cash discounts

In scenario where Vendor requires prepayment in full amount of PO, the associated Prepayment Request functionality does not populate terms nor calculate the Cash Discounts. If terms are 1/10/30 the system only calculates and processes cash discounts when processing an Actual Bill. In case where prepayment % is less than 100% it takes the Full Cash Discount on Final Payment when Bill is entered. Entering the Bill in advance and paying the Bill less cash discount to solve the transaction issue does not resolve the Accounting for what is really a prepayment transaction. Any ideas on how to process a prepayment less a cash discount at the time of prepayment?

320
F
Freshman I
F
Firazfaisal164
asked in Financials
COGS Breakdown Report

Hi, Do we have a standard or customized report do generate from Acumatica, where we can see the breakdown of the Cost of Goods sold (COGS)? This report needs to have the direct costs (PO cost) and the indirect costs (Freight, Customer duty, SST, Demurrage, etc) separately?Example :  Or else, is there a way to record the indirect costs (From landed costs) to a separate GL account without including it in the Inventory account? Thanks in advance 

2691
U
Jr Varsity III
F
Jr Varsity III
fdomingo
asked in Financials
When I want to Print voided CV why Acumatica print AP Voucher any one who have a Ideas about this? The Image reference below

 

705
F
Jr Varsity III
Z
Jr Varsity II
zhaotJr Varsity II
asked in Financials
Automation Schedule to Release Invoices Only Runs Once

Hi all, I wanted to create an Automation Schedule to release specific types of invoices. I would schedule it to the next minute when I test. I kept conditions simple as it is my initial test. I created a bunch of invoices with varying dollar amounts.This condition successfully released invoices with $0. However, after I deleted the “amount” condition trying to release the rest of the invoices, it would not release the rest of the invoices. Additionally, it shows “0 times executed” and shows no history when I click “view history,” even though I am 100% sure that the $0 invoices were successfully released.I could only release the rest of the invoices if I create a brand new automation schedule. After that, it will no longer work again. Please let me know if you have ran into similar issues, or I am just doing something wrong here. Any input is appreciated.

1622
craig2
Pro I

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 — 2024  Acumatica, Inc. All rights reserved