Financials

Anyone else using Chrome having issues with Aatrix? I just allowed Chrome to disable Flash since it will be retired in Chrome this month. I’m assuming this has caused my issue as Aatrix will no longer open. The Government Reporting processes and shows a green check-mark that the operation completed after running a report but Aatrix never opens.I opened Microsoft Edge and was able to complete. So I’m not sure what the issue is other than Flash.

Some of our deposits were posted to the bank deposit as a date in the subsequent month in error. I see the option to reclassify the journal transaction related to it, however the date I need to change to is in the previous month (different period). It gives me a yellow exclamation mark with the error, but there are no options to change the period? I also just tried to process and proceed, but it does not move forward.  

Is there a formula or function to count the days from the beginning of a period to the end of a period specified to the ARM report form?  I tried the following but it’s not giving the correct result:=DateDiff('d', @PeriodEnd, @PeriodStart)

Hello all,I’ve been following the help guides but am getting errors when I try to schedule an ARM report by email.Looks like when I go to check the status, the execution result is “The report with name Key Financial Numbers is not found” as you can see here: I’m not sure where to more clearly define the report name as the Screen ID is defined in a condition of the Automation Schedule:I initially created this by:navigating to the report itself; defining the parameters & the Print & Email settings; saving those as a report template; and then choosing “schedule template.”As far as I can tell, that is by the book.What am I missing in my configuration? This doesn’t seem to be common so I assume I’ve missed a data element.Thank you all for the ideas!Arline

HiI received the error msg for the below , Not sure how to add it into the control account.Is there is any problem if we dont add in the inventory into control account? Actually system allow us to save and close it without problem. When next time we open again , there is no this kind of messgae pop up. 

Hi Not sure if anyone know what is the problem below?  We will do the prepayment and make the payment , however system pop up below message , I did check the cash account for the 10740 , Is it inside the cash acocount , aslo , for the vendor payment account also enter under same account 10740.Could anyone to advise? Thank youThank you

Hello, We are in the process of converting a customer from Sage 100 to Acumatica. In Sage 100 the customer has tokenized credit card information. The customer will be using the same credit card processor (Paya) for Acumatica as they used in Sage. The tokenized data should be the same. However we are finding that once converted Paya does not recognize the data. Has anyone done this type of conversion before?

Several customers have requested Financial Reports (P&L, etc.) by week.  In some cases they would like to look historically to compare a week in the current period to a historical period for trend analysis. In other cases they budget by week and revise their budget for next week based on last week.  A good example is a hotel chain where they look at room nights to determine staffing and supply requirements.  We are looking at Velixo and Power BI but would prefer to have an easy solution that is more out of the box and built with standard Acumatica tools.  Has anyone tackled this and can share their experience?  Anyone else need this functionality?

Hello everyone, I need advice on a particular situation...I have several communication bills that needs entering but for accounting purposes, it needs to hit different account e.g. accrued expense, cash in bank etc...is there a way that I can call them up in the bills and adjustment screen? instead of calling the item from the inventory? Thanks in advance,mrivera67

We are looking for an enhancement that allows us to create customer pricing by item/Customer Location or by Item class/Customer location. Any thoughts or advice would be appreciated Thanks, Bob  

Hi Anyone know how to add in new posting class ? this is current what we using but i need to create new account for a new product line so we need to create a new posting class Not sure who can share with me ? thank you

Hello,    In last Christmas and new year, we’ve sent some gift to our customers. So they don’t have to pay them. These invoices are with amount/balance on them.    I know, I can write off the invoices, or I can create a credit memo to offset it.     But from Accounting Angle,  what’s the best way to do it?    The people from my company said they wish these numbers can also be counted into Cost of Good Sold.

Client has the following accounts setup –Account A is an Expense Account with a Credit BalanceAccount B is an Expense Account with a Debit Balance They would like Account A to show as a positive on the P&L even though it is a Credit BalanceThey would like Account B to show as a negative on the P&L even though it is a Debit Balance The client is on the latest version of Acumatica How can I make this work?   ThanksMike

Hi AllCurrently , we have a new product line and we wouldl like to differentiate the sales , purchase and inventory with existing product line so that can reflected in financial report for different product line.Not sure which method is good for differentiate?Differentiate by sub accountorDifferentiate by new account code , which mean we create a new account code for sales, purchase and inventory. 40000 vs 4000157300 vs  5730114720 vs 14721Which method that you suggested? what the reason that you suggest the method? 

Hi SirWe would like to create a invetory code for new product line , the account code will be 14721 .We understand that the account code posting for inventory is controlled by posting class.Need to create a new posting class for this new product line.  When we create a new stock item and assign this new posting class, then system will post to these new account code. My question is what is posting class referring to?Is anyone can guide me how to do the above create the new posting class in system?Hope to hear from you soon.Thank you 

We are trying to use the ARM Project Reports for a rolling 12 months.  We would like to add the Task’s Revenue Budget in the report.  Has anyone tried that or have a better idea?

HI SirWould like to check with you all about the cost statistics unde stock  item.My question :  is system auto generate the cost or we need to manual key in cost for the cost under Cost statistics ? 

Hi Anyone know what is the below for?  

Hi Sir2020 R2 New Feature VideosWe understand that account code 40000 is for sales and 57300 is for Purchase.Currently , we would like to differenciate the SALES and Purcharse under different product. Not sure how to do it in order that balance sheet it will reflected into different SALES by product.  Hope to hear from you soon.Thank you 

Hi Siri would like to modify existing P&L Report in accumatica system .However i encoutered below issue.According to existing P&L report  there are Q1 . Q2 Q3 and Q4 , Currently, i would like to modify to Q1 and Q2 and delete and column for Q3 and Q4. I encountered the below error message . I would like to cancel column E , F , G . Not sure who can guide me how to delete the column? 

Hi SirWould like to check with you something related with sub accountCurrently , our subaccount is xxx-xxxx ( Dept-Analysis),  2 segment key We would like to add in one segment key for project become xxx-xxxx-xxxx (Dept-Analyis-Project), 3 segment keyIf we add in new segment key, is is there any impact for those transaction is only 2 segment key?Any issue when we run any report , like trial balance, BS and P&Loss?Hope to hear from you soon.Thank you

Customer is on version 2019 R2 and is wondering if this version includes the 1099 NEC changes.TanyaClient Success Manager

Out of 6 clients who went live, we encountered 2 clients having issues to export reports to PDF.1 client with 2 companies, had issue in 1 company having 5 branches, i.e all 5 branches in the 1 company are affected.This happens in 2019R2 build 19.205.0023. Anyone encountered this before?Trace on why cannot export to PDFAppreciate any valuable input.

Is there any way to see the Adjusted Cash balance in Acumatica?  it would essentially be the the value of bank account, plus unreconciled checks, minus unreconciled receipts, plus other adjustments such as reversals?  This is especially valuable when doing cash management exercises for bill payments.   Maybe this functionality already exists, but we just don’t know about it?

Hi SirWe do the same for 2 transaction for vendor Chubbsg and Platinum28 . Issue a Debit note to offset the Credit Adjustment.However,  CHUBBSG ‘s status is CLOSED  but PLATINUM28 ‘s status is OPEN .Plesae refer to belowIs there any one know what is the reason behind?