Financials

We need to migrate from the 2018r2 acumatic version to 2023r1, with certain custom options included in the original versions, which is the best strategy to migrate a large version difference.

Business case:  Get multiple invoices from same vendor with same dollar amounts. Approver has to click into each invoice to see invoice number. If you click into the invoice, it then reverts the invoices you marked as approved back to blank. Very tedious and time consuming. The vendor invoice number field is NOT available to select in the Column Configuration screen. 

Hello there I voided on the 20th October instead of voiding it on 30 April. How do I correct this 

Hello All,I have been trying to setup and synchronise the consolidation process in Acumatica.I have been using the U100 and Sales Demo data for this and I want to setup the same for U100 instance. I would like to consolidate the data for the Actual ledger of Headoffice with the consolidation ledger of Sales Demo instance.For this I created a consolidation ledger in the Sales Demo instance. Imported the COA of Headoffice to the Sales Demo instance.Here in the above screenshot, I have entered the Username, pwd and the URL for the Sales Demo instance.And upon synchronising the following error is getting triggered:  Kindly let me know what is it I am missing during the process.Thank you in advance.

Need to invisible the field “Bill” in ‘Document Type dropdown’ when selecting ‘AR’ as Module. and also It shouldn’t affect the visibility when selecting ‘AP’ as the module. (logic applicable only for ‘AR’)How can I achieve this. Any Code snippets/ ideas?Make field “Bill” invisible when selecting AR Make field “Bill” visible when selecting AP (as prevailing) 

When wanting to manipulate the deferral schedule I select the override checkbox and then save.  I go into the deferral schedules and see my draft schedule saved as desired  After I post the invoice, it reverts back and posts the original schedule.  What am I doing wrong?  

Hi all!My accounting team is curious where the Check Description on Batch Payments comes from.Some checks will have a generic ‘Payment for ‘VendorID’’.Others will have an actual description (seems to happen if there’s only one bill with that description on the check).Still others will be completely blank.Ideally, they would like every description to be ‘Payment for ‘VendorName’’, but until I can find how that description is being set up in the first place, I’m not sure what to do.Does anyone have an idea where how the check description on Batch Payments is being populated? 

Hi All,We would like to have a report similar to “Transactions for Period”, but for each transaction under each account, is there any way to show the “opposite account”?For example, here’s an entry that has been recorded.Debit:       4600 Administration Expenses                          600 USD          Credit:       1005 Citi USD Bank Account                                600 USD For this transaction under “1005 Citi USD Bank Account”, we’d like another column showing that the opposite account is “4600 Administration Expenses”. Same for the transaction under “4600 Administration Expenses”.Is there any way to achieve that? Thanks!

A supplier have some outstanding invoices. They can be show in the “AP Aging” report. However, nothing show up in “Documents to Pay” when I try to arrange payment under “Prepare Payments”.

Hi, we are currently implementing Acumatica and are trying to figure out the best way to manage sales taxes. We have a very small 4 person accounting team. The maintenance that is required in Acumatica for sales taxes seems like it could be a full time job. Can anyone shed some light on how much time it takes to manage the sales taxes through Acumatica without a product like Avalara? Has anyone used a partner besides Avalara or Vertex to manage sales taxes? 

How To added new Parameter Start date and end date in default data source settings Added

Hi Everybody, Just a simple question as I’m new to Acumatica System. We have some AP and AR & Bank transactions in a foreign currency (USD) while our base currency is AUD.  In our old system we used to run an unrealized gain/loss report and it would tell us to make an adjustment to the AP/AR/Bank account, with the differences taken into a FX Unrealized Reserve GL  in the equity section. How do we do that same in Acumatica. Is there a report we run so make the same transaction?  Additionally, how does it calculate the realised gains and losses? Thanks in advance.  Regards, HAK

We received two payment for 1 invoice.  We entered  the 1 payment and applied it on the invoice (Batch unreleased). When entering the second payment the invoice is not availably to apply the payment on(until the first batch is released.  Please let me know if there is a way to apply two payments on 1 invoice. Thank you 

Is there a list somewhere of all the standard reports that comes with Acumatica?

We are currently implementing Acumatica and just discovered from our consultant that there is no easy way to create an approval map to handle situations where an invoice doesn’t match the PO (i.e. price variance, freight charges added, etc...). In a perfect world, we would be able to replicate our current purchasing software which sends an automatic approval to the person who made the purchase order to approve the variance as AP has no idea if it is legit or not. Does anyone have any suggestions for possible workarounds to handle AP Invoice/Purchase order variances without us reverting to the old fashioned way of sending each invoice manually back to the buyer to ask for their approval?

Hi everyone,Below is my processStep 1: I have a bill to buy sth with qty 3, then I convert a purchase to a fixed asset and also calculate depre Step 2: I allocate this asset to small divisions by subaccountStep 3: I process that allocation, but in the GL transaction, the column quantity shows zeroI wonder why it does not show the quantity here. Please advise me if I need to correct the process.Thanks in advanced 

Hi,I tried to hide this button in a particular role, may I ask which field it needs to be revoked for this field?Thank you!

Hi:There are no GL accounts in Account Summary for a company under a tenant. The tenant was created with the Sales Demo dataset. I specified the Actual Ledger for the new company. All the financial periods for 2023 are active for the new company. What did I miss? The master financial calendarCOA for James BicyclesAccount SryPlease help me asap since I have to get ready for a demo.ThanksToon SixAntoonS@ICGTechnology.comc: 973 727 9665

We have an approver map set up, but we’re finding several one-off exceptions to the rules we have built. Is there really no way in Acumatica to just direct a bill to a specific user for approval? Perhaps a customization, has anyone done this before? 

Hi Team,Is there a way to hide a particular Tenant in a log in screen in Acumatica?Thank you!

Hello, When we release a project Invoice for a Stock item shipment, the journal entry usually generates four transactions. Trade Receivable (Debit) Revenue - Piles (Credit) Shipped - Unbilled Accounts Receivables (Credit) Inventory Materials (Debit)However, there is a project in which the invoice journal transaction is not generating the two last transactions. We want to understand why is it not affecting “Shipped - Unbilled accounts receivables” and “Inventory materials” accounts, despite all projects follow the same workflow.  Thanks

Hello - We have a temp AP clerk, and would love to have them enter transactions and bills, but NOT be able to release them. Is there a way to revoke access to the “Release” function on this screens, while granting access to the rest? I am searching through the securities and am not finding it. Thanks for any guidance!  

Hi, Is it possible to change customer in AR documents after saving the document(Ex: AR invoice,credit/debit memo)?Regards 

I need to correctly know how to reverse a credit memo, the should not have been entered into the system

Hello Everyone,I am reaching out to understand what is allowed as naming convention typically in any field within Acumatica? I see some allows hypen/dash and some doesnt. Does Acumatica alphanumeric characters allow special characters? For Tax ID we are looking for a three segmented approach to be able to identify what they are when someone looks at the code. Example : ON-HSThttps://help.acumatica.com/(W(16))/Wiki/ShowWiki.aspx?pageid=692e30c9-e0af-4aa3-b0f6-f3ba190d257a Thanks,Hari