Financials

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!

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?   

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.

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! 

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: 

Hi,Is there a way to specify in Acumatica that when a Payment Amount = 0 after the Processing of Payments that the balance of the vendor is 0 (selecting Bills and Debit Adj), the payment documents outcome (check or ACH) only creates Remittance Advice instead of creating checks with zero payment or ach file? 

Can you configure a workflow on a per user/group basis in Acumatica? Or is it strictly a system wide basis?

How do I set my payment terms at the vendor location level? I see it on the umbrella, but I pay an agent (umbrella), who controls many factories (locations), each with specific payment terms. How do I set these  termsat the location level?

Example:Vendor sends me a check that is an accumulation of both debits and bills (eg, vendor owes me 10k, but I owe the vendor 3k, so they cut me a check for 7k). What is the cleanest way to handle in Acumatica? Is it to apply debits to the bills first, to zero them out, and then do a vendor refund for the total remaining debits? Ideally I could go create a vendor refund and select both debits and bills, resulting in my total - but that doesn’t appear to be an option or I haven’t found the right checkbox to allow it. Thanks in advance for advice.

Hi @everyone,There are sales orders that we synched from BigCommerce to Acumatica that has an issue with the order quantity. In BC, it does show only 1 qty for item 10021. However, the order in Acumatica shows 1 Qty, and then another 2 Qty. This caused failure of synching the payment entity.BigCommerceAcumatica Stock  

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.

Does Inter-company transactions feature require both companies to use the same Ledger and Base Currency?I’m trying to create Transactions in one company with a base currency of GBP with another company using EUR currencies. Both companies use a different Ledger.

Good morning all. I’m attempting to assist a client using GL account/subaccount restriction and having issues with it. I’m going to provide a stripped down description of what I’ve tried and I appreciate if anyone could jump in with a suggestion on how to make this work.For sake of example, let’s say we have your basic chart of accounts using 10000-19999 for assets, 20000-39999 liabilities, 40000-49999 revenues, 50000-59999 COGS expenses, and 60000-99999 for various other categories of expenses. They also have subaccounts, so for keeping it simple lets say there’s a default 0000, and then AAAA, BBBB, and CCCC.  The client would like to restrict 0000 such that it cannot be used for accounts 40000-99999. After reading the help file, I created two groups.Group 1 Type A. This group had all users, every account 40000-99999, and subaccounts AAAA, BBBB, and CCCC.Group 2 Type A inverse. All users, every account 40000-99999, and only subaccount 0000. That seems to work fine when dealing with ac

I am looking for a report that will show me a group of stock items and last cost. Sorted by Vendor or Item Class.

Has anyone else had this error message when releasing a journal entry with a project code?“Another process has added the 'PMRegister' record. Your changes will be lost”

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

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

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

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

Hi,Please advise on creating a Checks and Payment transaction that includes Forex Gain/Loss.Scenario:The base currency is EUR, and we have a transaction in Bills and Adjustments in GBP.In the 'Bills and Adjustments' screen, a bill is created with a value of GBP 1200, which converts to EUR 1386.61 using a Forex exchange rate of 1.15551000.We received two payments in EUR, one for EUR 717.74 and another for EUR 736.93, with a Forex rate of 1.16916.Due to the excess amount, there is an error showing 'Document out of Balance'. I want to post the excess amount directly from the Cash Account to Forex without affecting the Accounts Payable account.Thank you.

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

In our Prepare Payments screen, there are multiple vendors with Credit Terms that do not allow a discount. On these bills, the system sets the Cash Discount Date = Document Date, even though no cash discount applies. Therefore, when you try to filter on the Prepare Payments screen for ‘Cash Discount Expires Within _ Days’, these bills get erroneously included. A second filter is currently required to be added to the Cash Discount Taken column where Amount > $0. 

I am trying to deleted a rejected Expense Claim but when I try to do that, I am receiving an error message that says the “expenseRefNbr cannot be empty”;  if it was rejected, why is that occurring?Is this a permissions or setup issue?  And if so, what should I look to change? 

We need to fix the user that shows search result to be like the rest that doesn’t show the result on the sales order screen. See images below for the correct display versus the wrong display.  For this user a results sub window opens as the user types in an Inventory code.   This image shows how it should look without the results displaying: 

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?