Financials

Here is how you set up Acumatica Payments in 2023r2 version of Acumatica ERP.PrerequisitesMake sure you have the details needed to connect to your Processing Center.For Acumatica Payments you need the following values APIKEY, HASHKEY, LOCATIONID, USERID. It usually looks like the following:LOCATIONID: 11eda672c8d689b4ae137d65USERID: 11ecb74a72b0eb6ba237fcd7APIKEY: 41db9b32681e5a2ea1122e40HASHKEY: e6f8fe93f9479c330148c9e1 To get these values, you need to log in to your merchant account, using https://[yourcompany].sandbox.zeamster.com/ for the sandbox account or https://[yourcompany].zeamster.com/ for the live account.Then navigate to your profile settings → Advanced to generate Hash Key and API KeyThen go to Locations → Your Location and copy Location Id.Then go to the settings of the location→ usersSelect your user and copy the UserID In Acumatica make sure you have the following settings.The Acumatica Payments feature is active on the Enable/Disable features form (CS100000)  On the A

Can someone let me know what the logic of the conversion of units of measure is. I have read the help area about 10 times and I must have a mental block as it seems to be the reverse of what I would expect for converting from one unit to another. i.e. I would think converting a box of 10 bottles to a base of 1 bottle would require the instructions to divide by 10 but the operand is multiply. I am feeling quite stupid about this so please be gentle.. 

For tax year 2021, the IRS made minor changes to the 1099-MISC and 1099-NEC forms. Details of the changes can be found on the IRS website. Acumatica will implement these changes in upcoming versions of the software to assist with customer 1099 filings. There are 3 changes that impact Acumatica.Form 1099-NEC sizing. Acumatica will reduce the height of the form to match IRS changes. Form 1099-MISC, box 11. New use for box 11 includes any reporting under section 6050R, regarding cash payments for the purchase of fish for resale purposes, from a individual or corporation who is engaged in catching fish. Form 1099-NEC, box 2. Payers may use either box 2 on Form 1099-NEC or box 7 on Form 1099-MISC to report any sales totaling $5,000 or more of consumer products for resale, on buy-sell, deposit-commission, or any other basis.1099 Paper Forms:Changes to the 1099 Paper forms are currently available in the following builds of Acumatica:2021 R2 Update 3 Hotfix 1 (21.203.0030) and later 2021 R1 Up

Benefits of AP Document RecognitionAP Document Recognition streamlines processing of vendor bills that you receive in PDF format. AP Clerks spend less time re-typing data so they can focus on higher value tasks. Worker productivity: spend less time entering documents Accuracy: reduce data entry errors which may result in incorrect vendor payments Approvals: integrate with existing approval and workflow processes AI/ML: extracted data accuracy (vendor ID field) improves after manual correctionWho can use AP Document Recognition?Prior to April 1, 2023 Acumatica offered a promotion for up to 1,000 pages/month for free. After the first year, customers could purchase the feature.Starting April 1, 2023 all new and existing Acumatica subscription customers (does not include perpetual licenses - PCP) get 50 free pages so they can try the feature. Customers who already paid for the service get an additional 50 free pages. A vendor bill with a front and a back counts towards 2 of your 50 monthly

Has anyone had success with Bank Feeds and Truist oneview business account/or enterprise spend account connection ? I cannot get past the login screen with either MX or Plaid. Trying to get credit card Account to import.

Hello all, I was wondering if any in the community is using the Shipped not invoiced functionality in Acumatica and if so what their feedback is on the functionality. I am currently exploring switching to this functionality as I do not like the way the system handles SO Order shipments from an inventory perspective.  My issue is that we do not invoice an SO until it is delivered to the customer. Which at that point we are invoicing and posting the IN so that the revenue and the expense are posted at the same time. However, with the OTB configuration  this process leaves the inventory in the system at the site until it is invoiced when, in my opinion, it should move the inventory from the site to an In-transit account until and invoice is created and the COGS are expensed. So I have been looking into the shipped not invoiced which placed the inventory cost into a Accrual account until the invoice is posted. However, OTB it appears that this Shipped Not Invoiced account does not show up

We have a running live environment for a couple of years now. Due to business ownership change and/or restructuring, the financial year for the company has changed. Current: Jan to Dec - 13 periods (with period 13 as adjustment period) The change:The current Financial Year 2020 has increased to 18 months until June 2021 (i.e. Jan 2020 until Jun 2021).After that, the Financial Year will be 13 periods again from July 2021 to Jun 2022…. and so on. I need help on how can this be smoothly implemented. Thanks  

Hello, Seems like a simple question, but I’m at a loss on this one. So AP debit adjustments can easily be applied to AP bills….However I can not find a way to have a simple vendor credit adjustment applied to an invoice. There appears to be no similar process there credit adjustments can be applied to AP Bills. Can anyone assist? Thanks, Bob

Hi EveryoneCurrently , we have create a generic inquiry to combine table invoice and memo  and table payment and check  in order to get the column for “ due date “ and “ payment date”   If we would like to get system to calculate the day of over due , which mean “due date” minus “ payment date” in order to get the day of over due.  May i know how to do this in generic inquiry?  Hope to hear from you soon. 

Just getting used to the what seems incredibly formal statement process (for a small company anyway). I ran the statements for a period and forgot to enter one receipt of money from the customer, how do I re-run the statement to include for this extra money received on the last day of the month. It all feels very locked in and unwieldly to me as I am used to just re-running a statement as many times as I like. Best Regards Malinda

The QTY on hand shows 0, Available QTY is 5 and available for shipping read 0 also, what is might be the course of this difference

HiNot sure if anyone know how to reserve the inventory once the invoice released?We encountered a senario as belowCustomer last mins cancel the shipmnet which mean the invoice that we generated is need to cancel. How to cancel invoice and reverse the inventory ?Could anyone give me a guide/Step? 

How do I find out the source of the system foreign exchange rates in Acumatica.  I have searched but are unable to locate.  I need to provide to our auditors. Any help much appreciated.

When a customer has an overpayment on account can that overpayment be turned into a credit memo?  I need an action to  show the customer the credit on account and remove the payment sitting open.

Can a Remittance Advice be printed/emailed after the Payment is Released?

Does any one know how to reverse a Landed Cost? We had an entry with a clerical error and the amount was incorrect. Now inventory is overvalued and we have the amount sitting in the accrual account. The AP bill should address the accrual balance but will create a credit on the P&L variance account. Not sure how you address the inventory valuation. So looking for ways to edit, delete or otherwise correct the LC transaction. 

I am looking to expand my profit and loss statement to include details for each of the expense accounts. I currently have my expenses grouped together and I am not sure how to show them all separately. For example, the salaries I have 10 g/l accounts for and everything is grouped together as salaries…. Does anyone have experience in customizing the P/L? Thank you! I appreciate any feedback!

Hello,I am aware that Acumatica has a dedicated account for keeping track of the YTD Net Income balance and with every income or expense transaction, this account is updated. Furthermore, as documented in Acumatica’s Help material (see below), Acumatica automatically updates the Retained Earnings account for the next financial years that are defined. The system updates this account for every transaction posted to an income or expense account. When the system updates the balance of the YTD Net Income account, it also updates the beginning balance of the Retained Earnings account in the next financial years for which the financial periods are defined. For a new financial year, the system resets the balance of YTD Net Income to zero for a new financial year. However, for auditing purposes, when a user looks at the Account Summary and Trial Balances for the retained earnings account, the Ending Balance of the last period of one year would not match with the Beginning Balance of the first p

Does Acumatica have integration with Stripe Payment Systems? Thanks

I’d like to delete a released bill, how can I manage it?Right now I could only see the “reverse” button, and when I clicked it the system just created a debit adjustment. I want to delete both of them. Please teach me how. Thanks in advance!

HiI have created a dashboard in finance , however i dont know how to put it as main page , which mean when i log in , it will show the dashboard that i created as currently is show the “controller” that created by aucumatica as below 

2022 Tax Year 1099-NEC Form 1099-NEC and filing instructions have been converted from an annual revision to continuous use. Therefore, there are no changes in 1099-NEC form layout or in E-File format that require changes in the Acumatica ERP. For the list of Acumatica ERP builds with up-to-date 1099-NEC forms, refer to the 1099-MISC and 1099-NEC updates for Tax Year 2021 post.To resolve possible issue with the printing alingment, we encourage you to update to the following Acumatica ERP builds where the paper size of the 1099-NEC (AP653100) report have been changed to Letter:2022 R2 Update 3 (22.203.0043) or later 2022 R1 Update 14 (22.114.0029) or later 2021 R2 Update 19 (21.219.0019) or later  2021 R1 Update 28 (21.128.0009) or laterFor more info, workaround for earlier builds and additional steps to fix possible alignment issues, refer to the Known issue: The report printed on the 1099-NEC (AP653100) form did not fit the Letter paper size knowledge base article. 2022 Tax Year 1099-M

We have prepared and and released GST tax reports for the company using wrong period ( Monthly ) for the periods January to August. Now we want to update the tax period to the correct one ( Quarterly ) but the period type drop down menu is inactive , I think because we have released tax reports in the system.Is it possible to void these tax reports without financial impact?

It looks like they are set to print with the Acumatica Ref # order.