Community
Discussion Forums
Financials

Financials

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

2,014 Topics
6,710 Replies

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

2014 Topics

Newest first

Recently active Most replies Most views

bryanhinkle35

asked in Financials

Acumatica Row Level Security - GL Account Access Issue

Acumatica Row Level Security on the GL Account seems to work fine when you are trying to remove the account from selection when creating a new Journal Entry. However, any released Journal Entry, as well as a number of the GL Register and Edit Reports include these transaction lines for all users, as long as they have the right to open the Journal Entry or Register report. If the purpose of the Restriction Group is implied to:“your organization may have sensitive or confidential accounts and subaccounts which must be invisible for majority of users. You can control the visibility of these accounts and subaccounts for users (that is, -which users can view the accounts and subaccounts) by using restriction groups.”Wouldn’t you want the transaction rows to be suppressed in the report/entry screen as well. Does this match with what others have found when using the Account restrictions? Thank you. Bryan

2 months ago

bigilFreshman II

asked in Financials

Any option to hide a Transactions from some users..

Need to hide a AP Bill from some Acumatica users ( AP Clerk) . This bill is a Confidential bill . Only the Controller should be able to see it . How to do it ? Any Ideas?

2 months ago

neil40Jr Varsity III

asked in Financials

Why does "Enter PO Receipt" button stay visible even when all line quantities are fully covered by receipts

Build 23.212.0024A number of users are asking why the “Enter PO Receipt” button remains visible on a PO even when all stock item line quantities are covered by existing PO Receipts.Since it isn’t possible to easily see the existing PO Receipts for a PO, users can mistakenly create another PO Receipt. Quantities will be zero on the new (duplicate PO Receipt) but why allow it in the first place from the PO?Thinking there must be a good reason but can’t think of it. Any ideas?The SO workflow, as a comparison (which I would assume to be similar), doesn’t allow you to create shipments when all line quantities are already on shipments so why the difference? Another difference is that shipments created from the “Create Shipment” button on the SO are created and saved automatically whereas PO Receipts aren’t saved until you click the save button.

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 ?

22 days ago

jddonnell55Freshman II

asked in Financials

Purchase Order not recognizing budget on project

Purchase Order not recognizing budget on projectThe account code used is included in the TRAVEL account group and TRAVEL is included in the budget. When posting a JE, it works fine. When an attempt is made to enter a Purchase Order, it gives error (error comes before and after Cost Code entry)The PO error:The budget:Account Group

2 months ago

mdyerFreshman II

asked in Financials

Currency Conversion on Reports

Hello - We are a US based hotel company, with one of our properties having a Swedish owner. We need to report our financial statements in USD under GAAP, but our owner also would like to view the reports converted to Swedish Krona. Is there a way to convert a report that has a USD balance to another currency, or will we have to create a separate company and run all of the transactions with the currency converter?Thanks!

2 months ago

iacook28Freshman II

asked in Financials

Allocations

Every month expenses are accumulated in an account/subaccount combination that identify an expense account and cost center in which equipment repairs have been performed. At the end of each month these equipment repairs are to be reallocated, to a fixed set of 5 account/subaccount combinations. The allocation percentages will depend on the source cost center and will be on a different percentage basis, depending on the percentage of time spent working on the equipment for respective departments. The desire is to build a history of allocation rules, ideally by using a statistical ledger with the different allocation percentages.I can't figure out how to have a different set of percentages apply to the allocation from each source unique cost center when the destination accounts/subaccounts are constant without building a different allocation for each source/cost center; that could number in the dozens or more VERY quickly

1 month ago

srengdahlJr Varsity II

asked in Financials

Freight and tax on purchase order

When recording a bill for inventory purchase, we add sales tax and freight recording directly to expense account. When setting up the system, we talked about how we don’t necessarily have the tax and freight costs at time of receiving product so we set it up this way to add at time of entering the bill. This is creating a timing issue as we cross over a month end with a significant inventory purchase and the tax/freight skewing margins as they are expensed in month of bill and then customer invoice is following month. How can we set this up in the system better to avoid this?

2 months ago

HarrySemi-Pro I

asked in Financials

How to get this cleared checkbox activated in the reconciliation statements screen?

Thanks in advance.

8 days ago

SalomeSFreshman I

asked in Financials

Error Cancelling Invoice with Applied Credit Memo Version 23.211.0017

I'm encountering an error when trying to release the correction invoice in Acumatica. The system displays the following message: "The invoice cannot be canceled because it has the credit memo applied. Reverse the credit memo application before you cancel the invoice."The Credit memo is in Status close and only option on the credit memo is the following: I’m currently at a lost and because of this error we can’t release the new invoice because the above error keepings on popping up. This is also preventing us from closing the period as it still need us to release the new invoice. Want should we do I need urgent assistance on this. Thanks

2 months ago

jddonnell55Freshman II

asked in Financials

Journal Entry to a project with cost codes

Keep getting this message when attempting to post a JE to a project:The 10-530 cost code is not present in the project budget with the combination of the 1 project task and the UNBILLED account group.Db JE is going to account 11500UNBILLED account group account codes:

2 months ago

Kandy BeattyCaptain II

asked in Financials

Bank Feeds- Company ID

When trying to login with Acumatica for Bank feeds using PNC bank, the client needs to use a company ID, however on the Bank feeds, there is no option. Has anyone found a way around this or what is the way to login? Thank you in advance!

2 months ago

DrewNisleyVarsity I

asked in Financials

Auto-Fill Restrict Visibility

We have two companies, soon to be three, setup on Acumatica and they do not share customers at all. We have been using the “Restrict Visibility” field to make it so that employees can only access customers that are a part of their company. Unfortunately, people forget to fill in this field all the time, leading us to have to go through manually figuring out what company they belong to every now and then. I looked into trying to auto-fill this field using customer classes, but the customer classes are shared between companies, so that’s not an option. I decided to turn to coding and try to use PXDefault to pull the branch/company from what the user is signed into, but I can’t get it to work and it just keeps throwing the following error. If anyone could give me a hand, that would be great.The multi-part identifier "Customer.COrgBAccountID" could not be bound. Here is my codenamespace PX.Objects.AR{ [PXNonInstantiatedExtension] public class AR_Customer_ExistingColumn : PXCacheExten

1 month ago

jeans16Freshman II

asked in Financials

Change file name of ACH Plug-In created file

Is there a way to have the ACH file that is created with the ACH Plug in have a branch specific name? Our client has multiple companies with multiple bank accounts. When they create the ACH export using the plug in the file is created as ‘ACHmmddyy.txt. Client would like to know if there is a way to change that so it indicates the branch name also as when they process multiple payments on the same day and download them to their computer they have no way of knowing which bank account they are uploading the file for unless they open it up first.

2 months ago

nawanjanahansamali50Freshman II

asked in Financials

How add a dropdown list in 2023R2

Hi All,Could please share us the steps to add a dropdown list for a screen.Thank you

3 months ago

driesdeklerk50Jr Varsity III

asked in Financials

Exclude the Unreleased Balance from the Available Credit calculation

Hi All, Is there a setting that can exclude the Unreleased Balance from the Available Credit calculation?

3 months ago

williamq178Freshman II

asked in Financials

AP invoices (bills) - How to alert users the invoice number is already in use?

How can we setup the system to alert users if the invoice number they type in is already in use to avoid duplicates?

3 months ago

driesdeklerk50Jr Varsity III

asked in Financials

Customer Mailing & Printing

Hi All,I have a customer that want to have their statements send to a specific email address. When I send the customer statement it send it to the Account Email? What am I doing wrong? ThxDries

1 month ago

fmrubi11Freshman II

asked in Financials

Customer Credit Limit using Customer Currency

Is there a way to use the customer’s base currency as credit limit. Current setup requires that limit be put in base currency

3 months ago

coleenmcnally22Jr Varsity II

asked in Financials

AP Payment approval on reprint

Trying to configure a payment approval map that will trigger an approval if the payment enters the reprint process.Has anyone had done this or is it easier to handle through a security access? Coleen

3 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!

30 days ago

cwilliams23Freshman I

asked in Financials

Acumatica changed the vendor during a RETURN

During a standard PO return. The item was selected from the Purchase Order Receipt (POR) - The vendor is clearly listed on the PO and should be in bedded within the PO. However, during the process, a new vendor name popped in and was not discovered until it was Released. The POR has the correct vendor, the PO has the correct vendor - but the Return has a different vendor. How is the even possible? Any suggestion on how that could happen, or what setting would cause it to happen. Could timing out and logging back in cause the error? Thank you for your assistance.

1 month ago

thoward66Freshman II

asked in Financials

Depreciation error

Running monthly depreciation for several companies and I am getting Calculated+ as the Transaction Type instead of Depreciation+ on the fixed asset transactions. I have double checked that I chose Depreciation instead of Calculate Only. This only happened for two companies out of the 12 I ran this month. I also checked that depreciation completed successfully for both companies last month. I tried deleting the FA transactions and rerunning them to make certain everything was chosen correctly and received the same results.

3 months ago

rethavanalphen11Freshman I

asked in Financials

Recover Intercompany Costs on Projects

What is best practice on how Acumatica Recover Intercompany Costs on ProjectsWe have multiple companies with multiple currencies.company A company B company CWe create a project (project A) for a customer in company AResources from company B attend to work on project AResources from company C attend to work on project A Each Company/Branch will be extended as a customer and vendor.The Generate intercompany Sales process will be used. In company A – AR Invoice to company B for the employee time spend &In company A – AR Invoice to company C for the employee time spend Creating the AR Invoice will be a manual process / we can create an import scenario based on employee timecard entries that has not updated the Project.We do not want to create a loan account between the companies.

3 months ago

rkessler95

asked in Financials

Connecting a pro forma invoice to a sales order

We are a company that bills time and material invoices through the pro forma invoice setting. We are looking for a way to be able to tie this invoice into the sales order process somehow so that when we go to ship the order, it ties to the pro forma invoice. Right now we are manually creating the pro forma invoice, manually adjusting the sales order to match the pro forma invoice price, and shipping the sales order. This creates the issue of keeping the shipment in the ‘confirmed’ status, because if we ‘prepare invoice’ from the shipment, it would duplicate the invoice and book AR twice.Does anyone know of a better way of navigating this scenario?

3 months ago

Page 7 / 81

Badge winners

nhatnghetinhhas earned the badge Low Code | No Code Customizations or Integrations
johnh3has earned the badge Easy talker
andriitkachenkohas earned the badge Configuration and installation expert
andriitkachenkohas earned the badge Integrations and Web Services | APIs expert
andriitkachenkohas earned the badge Reports and Generic Inquires expert