Financials

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? 

I have a set of sales that I wish to isolate and reclass to a different account. Has anyone done this before? I’m not sure how to handle the shuffling out of one account into another, the finance segments in ACK have always been a weak-spot for me. Any help is greatly appreciated.Longer explanation: We started up a new division, but we didn’t know it would be it’s own full division until it grew. So now I need to take the sales for those items and put them to a new class to show a new profit center on our P&L. I can find the old/new accounts and sub accounts easily enough, but actually deducting from the old account and attaching everything to the new account without wrecking my system has me a bit nervous. Thanks in advance for your help!

Hello Everyone, In the Stock Item screen [cst.in.20.25.00], under actions, there is an ‘update cost’ button but when i click it, nothing happens...is this button really working? Kind regards,Melq 

Hi Anyone know what is the problem below?We have make fund transfer in SGD currency (CF000057,SGD200,000 exchange currency is USD146659.42, However the journal transaction’s (S20110554) amount is not tally with Fund Transfer figure. I done 5 same transaction and only one transaction is capture incorrectly. Could anyone can advise what is the problem? How to make the adjustment in order to capture the correct figure? Hope to hear frmo you all soon 

Is there a way to tell the system to look at the header description in an entry form and pull it to the line detail transaction description? It’d be nice to have this in other screens, but I’m particularly interested in the Bills & Adjustments screen (below is an example invoice to demonstrate). Right now we have manually type in the transaction description each time. 

I’ve recently gone through Acumatica’s discount code and Credit terms setups. Our client specifically requested that a rebate (discount) is provided to their customers once they have exceeded volume ordered - but not only at a document level, but rather at a monthly accumulative level. I don’t believe that Acumatica provides this feature, and its rather a standard Credit term practice in Africa. 

Hi Sir Due to vendor profile- tax zone was not set correctly so the AP reflected the tax 26 as below.Not sure what is the correct way to offset or write off this tax amount 26 from the AP bill?Hope to hear from you soon.Thank you 

Hi Sir/MdmNot sure if anyone know what the root cause to cause this issue happend.We understand that Vendor AP bill will auto generate once we receipt in the goods and tick the create bill.We notice that one of  AP Bill generated is come with Tax whereHowever , the vendor set up Tax Zone is Tax exempt  .Not sure why the AP bill will come with tax? Anyone can advise?Please find the screenshot as below Hope to hear from you soonThank you

Hello everyone ; How exactely does the reverse vat work? I created a reverse vat and a general one to cancel it while billing but it doesn’t work. I’ll have the tax amount on the bills of a EU clients. Help !!! Thanks  

 Option is available in GL Preferences Screen. This gives you one batch for all the released documents however we have a customer who is wondering if it was possible to only have one line for the entire batch.  See attachment for further details - You'll see that I released 2 bills together to get batch 4414 and 2 checks together to get batch 4415 but they are wanting to only see one line with the total (for example for batch 4415 they would want to only see one entry to AP for $68.25.  Is this something that is possible?  It's actually more in the cash account where they would like to only see the one entry.  They're finding it a lot to reconcile the bank when each payment goes in individually.

Hi May i know who know how to do the reverser after we found that we issue wrong inventory out?Do we can do the reverse in journal entry?DR inventory  CR Purchase?Hope to hear from everyone soon. Thank you

My company recently switched from Sage 300 to Acumatica. Acumatica is superior to Sage in most ways. But something I enjoyed using in Sage that I miss is provisional posting. It’s nice to have the ability to test a journal entry prior to posting. The ease of reclassifying entries in Acumatica makes this less of a necessity than it was in Sage, but it would still be useful.

Hello everyone  The trial balance upload is balanced. I take it off hold and release it and i have this error msg   “The trial balance cannot be released until there are unposted General Ledger batches.”Please help !!  Thank you 

Hello,     We are dealing with “breaking cases” scenarios in business. Such as we have 1 item in “Case UOM” and can be converted to “bag UOM” item with the conversion rate 1 case = 12 bags.      We know Acumatica has multiple UOM functions, however, for historical reason, our company ispreferring to use “ItemA” stand for case item, and “ItemA-I” stands for the bag item (breaking down item). In short, the case item and bag item are with different inventory IDs.      We normally purchased item in case, and sold them in either case or bag. So, we sometimes use “inventory adjustment”  to convert case item to bag item.      Unfortunately,  during the year end review, we found some users forgot to input “unit cost” for bag item on several documents, not too much but also not too little. Since the bag item “VGYCS-I” were sold and issued invoiced.We are afraid of it would make the financial statement incorrect, because it looks like we sold item at 0 cost? Actually, I have 2 questions here:1，

Hi Anyone know how to set the email notification in “ Time and Expenses”?We would like the system can auto send out the notfication email to the sender when their claim is approved so that sender can go in and release the claim accordingly.Otherwise , sender dont know when the claim is approved. Hope to hear from you soon. Thank you

Hi I encountered a problem of expense claim as below , not sure how to solve it ? Anyone can advise?Thank you