Financials

Hi all. Are Balance sheets and Income statements possible in Acumatica with Power BI?

We need to order Bank Checks.  Does Acumatica have a standard “form” of check?  If so, where can we order the checks that match the standard Acumatica “form” of check”? 

I brought back a copy of the Finance Basics course from the Acumatica Conference for our Controller. She has been working through it, but is confused because the instructions don’t quite match up to the guide. For example, financial periods are not open for the 2022 time period (this can be fixed by opening financial periods for 2022). In addition, for example, when reversing a transaction on page 10, it says to find the transaction on 2/25/2022...but this doesn’t exist. It does exist for 2/25/2021.I would like to fix this problem, so that the user doesn’t keep having to second guess the training materials or work around them. Is the fix here to just change 2022 to 2021 for all instructions? Can someone advise? We are using u100 from 2022 R1 currently. I have attached the Learner training guide from the conference.

Hi, There was an error while we are uploading the Employee.  Regards

I am struggling to even get started writing a Balance Sheet report on ARM. I have managed to cobble together a P&L which works but have no idea about how to start with the Balance Sheet coding. There were no basic templates on our system so I wonder if someone could give me a suggestion for column settings, using the basic balance sheet rules. I am fine with the rows.  

How does Acumatica control the dunning letter levels for 30/60/90/120 day levels where the ‘severity’ of the dunning letter increases with each monthly iteration.  Like 30 day “Please send in your payment’ to 120 day - “Your account will be closed if we don’t have payment in 10 days”.  We only see one notification template but believe there are ‘severity levels’ in the dunning letters but we don’t know a) how they work and b) how to modify the language to match the clients preference.Thank you,Mike

HiMy customer Balance Sheet is out of Balance, I found one batch with transactionsin multiples periods, thsi is affecting the balance sheet because the debits are in one period and credits in other. I do not have idea why this happens.Any idea how i can revert this batch with the same periods?I was thinking using a sql script to update the batch by a CustomizationAny idea how i can resolve this?ThanksVivian

Hey Guys,Am looking for a company providing quality medical accounts receivable services.Any leads would be highly appreciated.Cheers,David

The Reclassification feature is great.However the load and the search and replace functions do not allow the use of wildcards.The most common use of reclassification is to change one of the segment values in a sub account.Very often there are more than 2 segments in a sub account.  In our example there are 5 and a sample entry looks like this 000-000-NTW-ATO-1413.  Many other values will exist in that sub account structure.  Eg.  COM-000-CLO-VMI-0205Assuming that I want to change all of the second segment 000 to COS there is no easy way to select those subaccounts that contain that 000.  I have to address every possible permutation that contains the second 000 to get this to work.Wildcards would assist greatly because then I could use a statement like:  ???-000-???-???-???? Thanks James  

Hello,I have 3 statement cycles defined in the “Statement Cycles” screen.All 3 are available for choosing from the drop down in the “Print Statements” screen.However, only 2 are available for choosing in the “Prepare Statements” screen.The one that is missing is my EOM statement cycle.Any idea as to why I don’t have that statement cycle available to choose in “Prepare Statements”?Thanks!

Hi All, I have uploaded Assets and they have been depreciated using Tax Type “Book”.  however now the client would like to calculate “Tax” (i.e. no posting) as well.  I don’t seem to be able to add another Book in the Balance section against the Asset.   How do I add this please? Regards,Laura

Hello Everyone,  Is there a way that I can mask or hide the details of an invoice [e.g. item sold] so that when payment is applied to an invoice, the AR Clerk can only see the invoice number and amount of invoice? Thanks in advance!  Kind regards,Mrivera67

We imported Amazon orders which invoiced and completed, but then noticed the dates were incorrect and not aligned to the proper sales date.  We need to delete all of them and then re-import with the proper dates.  We have reversed the invoice and created a credit memo as stated in the community, but are still unable to delete the orders so our sales are all skewed.  There is an notification that because of the order not actually having a shipment we can’t delete it.   This is quite urgent so any assistance is really appreciated.  Is there a way to move the ship date out so that it is not completed and then remove the record?  Or go into the data and remove it directly?   This is the error:  @Irina do you know of a solution or someone at Acumatica that can assist?

Hi all. If the financial period of an AR Inoive is wrong, and the invoice has been paid by customer, is there any way to change the wrong period, except reversing all the related documents and then generating new ones? Thanks!

Newbie question here.  We are currently in the process of having our Acumatica partner build our database.  I’m looking at the P&L report and the format seems weird to me.  Below is an example.  I’m definitely not used to, and do not like, that their is a line amount for the the GL account and then additional lines amounts for each subaccount, which results in duplicate line item amounts.  What I should be able to see is what is in the second screenshot (from our current accounting system).  Our partner tells us there is no way to format the report in Acumatica in the same was it’s formatted in our current accounting system.  Can someone tell me if that is true?  Because the way it looks now seems very illogical.   

I had a question about the purchasing reports.  Is there a way to run a report that details all the purchase orders with the PO #, amount, date, etc, as well as who approved the purchase order? I was able to run a PO report that shows the #, amount, date, etc but I cannot find a way to run a report or modify the report to include the individual who approved the PO.  Is this possible to see in one of the reports?

Hello,Unfortunately one of our users has deleted the 2022 budget. Is there any way to restore this other than a snapshot restore? Our latest one is from before the bulk of the work was done. Appreciate any help anyone can offer! 

Is there a way to process the invoice before shipment? The business is  to render services to the customer by registering their cars to the DMV and it require documents to be shipped back to the client.

How are vendor bank details stored in Acumatica? In NetSuite they have the electronic bank payment bundle, is there something similar in Acumatica? Or is it just the default payment method settings area in the vendor forum? 

Can anyone direct me to where the sales region is added? 

Hi All,  @Naveen B ,does anyone know how/where I can fix this Bank Feed Error please?  I cant access the help for errors:-Cheers,Laura

Hi,The Tenant is configured with two companies and a one company(Ceramic) have two branches. When creating transactions the system allows to create transactions in between branches and this affects a difference in the branch level TB. Please refer below example.The Midaya Ceramic Pvt Ltd is configured with two branches - Ceramic and CandlesWe have created two warehouses for Ceramic and Candles. I have created a transfer from Ceramic warehouse to Candle warehouse. In this case system creates a journal transaction for both branches affecting a difference in branch level TB.In this case I need a help on avoiding occurring transactions like that since the customer haven’t purchased intercompany transactions. Thank you,Dulanjana 

Hello COmmunity,I am simulation a process.Assuming a client go live. On the bank module, transactions like inter bank transfers, payment, bank charges etc have been posted against a bank.HOw can I bring in the opening balance of the bank before go live so that the bank balance can be use to relate with the reduce the negative value to it actual value….. Thanks in anticipation

Does anyone know if there is an integration with Dunn & Bradstreet or any other credit checking facility for Acumatica? ThanksSharon

Is there a way to permanently exclude credit and debit memos from the Print/Email process?  IE we would like memos to permanently not show up on Print Invoices and Memos screen (filter not really acceptable) and not trigger the Invoice notification template defined in AR preferences Thank you!!