Skip to main content

Financials

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

  • 2,540 Topics
  • 8,321 Replies
2540 Topics
H
Freshman I
helpdesk37Freshman I
asked in Financials
SO error

When I try to release a sales order the following error populate;- And on the document line on the detail tab the system claims that the minimum gross profit required for the unit price is not satisfied What might be the course of this?

2291
Manikanta Dhulipudi
Captain II
K
Jr Varsity II
kevinheng21Jr Varsity II
asked in Financials
AR Customer Balance

Can we watch beginning AR Balance Customer before release new invoice

1315
K
Jr Varsity II
K
Freshman I
KGantzFreshman I
asked in Financials
a credit credit card transaction

I am entering our credit card transaction and it won’t allow me to post a credit transaction.  

22613
meganfriesen37
Captain II
F
Freshman I
FrankieDCFreshman I
asked in Financials
Is it possible to consolidate the tax into a single tax line item?

Note* We are using avatax

412
F
Freshman I
R
Freshman I
rgreenoughFreshman I
asked in Financials
Inter-branch issue - Payment and Applications will not release

We have several customers who are paying through a Credit Card portal that is integrated into our Acumatica. Our main location is Atlanta, but we have customers paying from Orlando and Nashville using the portal.Acumatica will process the payments and the funds will be received. However, the funds will only go into our Atlanta Bank account and not the company for which the transaction took place. This then leaves the transaction as pending processing or balanced (unable to release or close). This is creating many Inter-branch Acumatica Issues. See screen shot below: My questions,1. will activating the Inter-branch Transaction feature in Acumatica release these transactions and show as paid? 2. If activating the Inter-branch feature, will this cause any other issues within Acumatica? Is this a viable solution?Thank you for your time.

451
D
Freshman I
K
Freshman I
kstockmanFreshman I
asked in Financials
Approval Maps for AP Bills

I’m trying to set up Approval Maps for AP Bills.  Certain Vendor Bills need to be approved by certain managers.  There is also a list of vendors that don’t need an approval.  My first attempt didn’t seem to work.  IBelow are the screenshots for the Step & Rules.  Any help would be appreciated!     

3075
K
Freshman I
dsimmerly
Pro I
dsimmerlyPro I
asked in Financials
Reverse Multiple AP Bills

Is there a process to reverse and apply debit for multiple AP bills as once ?

894
iqraharrison
Captain II
E
Freshman I
enriqueyFreshman I
asked in Financials
AR Write-off

 I still can’t write off an AR balance after I have enabled write-offs for a customer,. What suggestions do you have?   

2454
iqraharrison
Captain II
cervantes09
Freshman I
cervantes09Freshman I
asked in Financials
Indirect purchase order capabilities

Hello All,   Does Acumatica have the capabilities to process indirect purchase orders?Completely separate form BOM tied items which would fall under direct BOM tied purchase orders? R&D/NPI  vs. Sustaining/Released into Production  Current issues with my R&D, non-stock, NPI department and materials issuing or receiving and stocking their items since they are not in final stages of the sustaining process.Same question with Work orders  and materials.  

1686
Laura02
Captain II
N
Freshman I
nadia02Freshman I
asked in Financials
Is it possible to print out two different currencies invoices for a customer in Acumatica?

Hi All, I have a question regarding an invoice to a customer.The customers would like to receive invoices with USD and CAD amounts attached to the invoice (they do not mind receiving two different invoices in two different currencies). I entered the currency ID in Financial Tab on Customers (AR303000) as CAD, as a result, when I printed the invoice in CAD currency. The question is when I clicked VIEW BASE (because the company currency base is USD) and I would like to print out the invoice with USD currency. The invoice keeps displaying CAD currency in the invoice. Is it possible to print out two different currencies invoices for a customer in Acumatica?Looking forward to hearing your response. Thanks.

1863
S
Freshman I
S
Freshman II
stephaniet98Freshman II
asked in Financials
Journal Batch Size

We have a customer that we are implementing that can have journal batches with a large number of transactions.  Is there any information on how many journal transaction lines a batch can have before there are performance slow downs when viewing and releasing the batch in the journal transaction screen?

482
S
Freshman II
C
Jr Varsity II
coleenmcnally22Jr Varsity II
asked in Financials
BAI2 Bank File Import Scenario

I have a customer that needs to import a BAI2 file - actually it will be quite a few files.  Does anyone have any experience in creating an import scenario for the BAI2 file?  It will include multiple bank accounts in one file.  I know that Acumatica does not support BAI2 files using the Import Bank Transaction Process, but at this point it is all that the bank will provide.Any help would be appreciated. Coleen.

1180
C
Jr Varsity II
H
Freshman I
helpdesk37Freshman I
asked in Financials
Customers statement

Am trying to generate customers statement but it’s giving the below error What might be the course?

1607
Laura02
Captain II
R
Captain II
ray20Captain II
asked in Financials
Combine Finacial Report from different tenants?

Hello,       Our company are planning to do 2 kinds of business, storage service and distribution.For storage serivce, the inventory are NOT supposed to post to ledger, it is customer’s inventory. For distriution , the inventory will post to ledger and will be counted as COGS when issuing and invoicing.      So , to serve this need, we are planning to maintain the 2 kinds of business in 2 separated tenants.     Here comes the quesiton, How can we combine the P&L report and Balance sheet easily,or even automatically?

1037
aaghaei
Captain II
C
Freshman II
CCOMEAUFreshman II
asked in Financials
GL Error: Cannot insert the record. The record Customer (1981072ALB) has been marked as deleted. Your changes will be lost

Does anyone know what causes the error.  I am using the Change ID function in receivables and I get this GL Error when I go to save the chage.

3048
Kandy Beatty
Captain II
B
Freshman II
byates
asked in Financials
Inventory Valuation Issues

Hello, I am having an issue with inventory valuation on a specific item and a specific site and I cannot figure out how the system settled on the valuation. Attached is detailed inventory valuation listing from Dec 2022 - March 2023. All of the past period valuation and the transactions seem to be between 5.24-5.94. Yet somehow at the end of Period 12 (March 2023) the ending valuation is $1.19. I cannot figure out in the attached file where the issue is so I am wondering if this could be some kind of DB issue?I have already ran the Validate Inventory with no change. We are also using the FIFO valuation method.  Let me know if you see anything in the attached which may  be causing this issue. 

2594
B
Freshman II
J
Freshman I
jroseberryFreshman I
asked in Financials
Releasing migrated fixed asset transactions

I have migrated approximately 460 fixed assets that now need to have their Purchasing+ transactions released while still in initialization mode. Using the ‘Release Fixed Asset Transactions’ screen requires that the ‘Update GL’ box be selected, however, since these are migrated transactions we do NOT want the GL to be updated.I am able to release the transactions one-by-one while in initialization mode. Is there a way to mass release these transactions while remaining in initialization mode? 

903
Chris Hackett
Community Manager
bjeter78
Freshman II
bjeter78Freshman II
asked in Financials
How to reverse landed cost with wrong PO receipt attached?

Client has attached the wrong PO receipt to the Landed Cost? How do they correct?

3883
Kandy Beatty
Captain II
S
Jr Varsity III
shuang57Jr Varsity III
asked in Financials
Automation Schedule of "Refresh Currency Rates" doesn't work

Hi All.I want the system to refresh the currency rate from EUR to CHF daily automatically. So I created an automation schedule of “Refresh Currency Rates”. It is being executed at the scheduled time, but there’s no processed reocrd (see below). Could someone please tell me what’s wrong? Thanks!And the settings are the following: 

3426
E
Varsity I
J
Freshman I
jenniferyaholnitskyFreshman I
asked in Financials
Change Account Group Type

Is it possible to change the account group type? I set up an account group that was linked to all asset accounts, but the type was listed as expense, and now I am unable to change it to asset. Is there a way to adjust this?   

2378
iqraharrison
Captain II
Prasadug
Jr Varsity II
PrasadugJr Varsity II
asked in Financials
sales orders unit price recalculation history

Is there any sales price history tracking report for sales orders item-wise and AR invoice item-wise?

792
iqraharrison
Captain II
J
Freshman I
jonmonahanFreshman I
asked in Financials
Filter Purchase Order Receipt and Billing report

How does one filter the Purchase Order Receipt and Billing report to only show Unvouchered Receipts?

1282
J
Freshman I
R
Rurbina
asked in Financials
How to reverse a payment application VIA REST API

Does anyone know of a way via REST API to trigger the reverse application action on payment/application History Tab  

570
R
A
Varsity I
ashleybVarsity I
asked in Financials
Batch Payments - Branch Restriction

Hello,We are running into an issue currently where users are able to see all AP Batch Payments under the “Batch Payments” screen even if they do not have access to that Company/Branch. When they click into the batch, they are unable to see the payment details, however if they have access to the Release function, then they are able to release that batch. Is there any way to prevent a user from releasing a batch that is not within their branch access list? And/or can we restrict their view from the Batch Payments screen?Thank you!Ashley

982
Chris Hackett
Community Manager
dmzasdf
Varsity I
dmzasdfVarsity I
asked in Financials
Pay expense claims via payroll or AP?

We are currently paying expense claims via payroll, but considering to move paying expense claims via AP. What does your company do?

2954
Doug Johnson
Acumatica Moderator

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