Financials

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? 

Good day allI am trying to write a GI to show AR payments and their applications. Can anyone tell me the field that links the two, apart from the CustomerID.I’m using tables ARPayment and ARTranPost.I tried ARPayment and ARAdjust but can’t get that to work. I appreciate any help.Many thanks in advance.

I have tried numerous times to split a journal entry into multiple lines without it posting successfully.  The only way I can get Acumatica to split an entry to multiple sub accounts is to do it one line at a time.  Why is this necessary?We are on 2020 R1

We are currently on 22r2 and will move to 24r1 soon.We have the need to stop users from seeing and being able to drill down into certain accounts on the P&L by branch report.  The users are all in the same branch, but not the same “department”.  They should not be able to see wages for the branch management (highest priority), and preferably not other departments in their branch (secondary concern).I have set up a restriction group and assigned only top management and finance to the group.  I have also assigned the specific sub accounts, and then the specific GL account, to the RG as well.The result is that the user can access the P&L by department, see the Wages listed on the P&L in total form.  Further, then can click on the amount and drill into the Wages amount, seeing the restricted account detail, as well as the associated subaccounts, some of which are restricted also.I have read the help text documentation and understand that for performance reasons, this is the res

Looking into the ability to have Attributes published into Customizations.  Use case:We have a testing environment that we test Customizations before publishing into our Production instance (as everyone should hehehe). I want to make a Attribute on the for Vendors, that I attach to each Vendor Class.  But I am trying to figure out how to do this in a Customization if possible, that way I don’t have to recreate those fields and connections in our Production instance.  I could just publish the Customization and it would create the required fields.  Is that possible?  I can’t find any documentation on that use case.

Hello team,I have been looking out if I can create a debit adj to reverse an AP bill of a non project code & then create a new AP bill under a project.Let me know if you have any other suggestions on this.Thanks in advance.

Hi Acumatica Team,Is there a report that we can see an Inventory Transaction related to the Project?Thank you!

Hello, we have a prepaid insurance expense that I wanted to setup a amortization schedule to expense monthly over the life of the policy. Is this possible with the out of the box solution?  thanks

Does anyone add the reference number provided by the bank for ACH batch transactions to the batch payment in Acumatica post Acumatica release of the batch paymentI have to release the payment in Acumatica to obtain the export file and would like to be able to go back and add the reference number from bank to that released batch payment in a field that can be searched in the GI.I appreciate any feedback.