Financials

Our customer often pays multiple different charges to a vendor on a Quick Check. They are populating the Transaction Descriptions on the individual Document Details lines of the Quick Check screen.I have studied the AP Check with Remittance format and am unable to determine how to set up additional variables for each line on the AP check that correspond to the APTran.TranDesc values on the quick check. Normal checks are properly printing with Bill type and Reference numbers on the stubs, but I am not able to determine how to display the line descriptions when printing a Quick Check. This seems like something that would already exist, but I do not see a table included on the report format that would tie to the quick check details.Does anyone have a solution already for this? Thank you,Greg

Has anyone else experienced issues with rounding errors between Acumatica and Shopify?We have Shopify Plus with Avalara AvaTax integration, and Avalara AvaTax in Acumatica for all other orders We are regularly seeing rounding errors of a few cents between what gets calculated on the front end in checkout vs. what gets calculated in the sales order in Acumatica when our connector imports it There does not appear to be an option to force the tax amount from Shopify and bypass the tax calculation in Acumatica so that all totals lines upFYI we are not yet on Acumatica Commerce so using a custom connector.I know this is a typical issue and often just handled with a “slop” account for rounding errors, but just wish this wasn’t the case since Avalara should be making the calculation in the same way regardless of the platform. Guessing there are some character limits that may be causing this? Either way, curious if anyone else has experienced this and how you dealt with it? Thanks in advance!

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

I have a client that needs generic inquiries and dashboards to go off of their fiscal year and not the calendar year.  So in order for the inquiries / dashboards to be dynamic i need the @ functions or something like them to go off of their financial periods which are a fiscal year 

Where can I download the 2021 R1 compatible Bank Feeds Customization Package?

Where is the best place to learn about setting up the AP Approval process/Workflow?  I have looked in University catalog and nothing seems to really fit. Thanks!

Is there a canned or good way of generating turnover reports across branches? 

Hi All, @Naveen B,  I have set up an  Automation Schedule for “Refresh Currency Rates”.  I will only update the previous day rather than the date that it runs.  Also the schedule just stops running ever few days.  Is this a known issue?  Any response appreciated.My settings for the Schedule is as follows:- 

Hi All, @Irina, @Naveen B , When going into the “Write off Balances and Credits” screen and running this to write off Balances, the client would like an approval prior to the document posting.  Is this possible as I cant seem to get anything working? Cheers,Laura 

Hi I would like to generate P&L based on item class per below, but keep failing to find the right definition.Does anyone know the definition? Thanks in advance! 

Hi SirWe do a chart in dashboard, however we notice that the below in Black box -SSD is 4% margin. However , from the database , the margin should be negative 6% Is there anyone can advise what is the reason?Herewith the screenshot of dashboard and the chart configure for your reference/   

Is there a way to link an expense receipt for credit card to the vendor record?  Sometimes we pay for vendor bills on credit card, but they also need a 1099, but I can’t find where to link that to the vendor totals for end of year 1099 reporting.  

On a Purchase Order, is there a more efficient way to enter a different Ship-To Address and Ship-To Contact (of our company) than by checking 'Override' and typing in an alternate address/contact?  

Is there a way to change “All Customers” statement settings to (Print Statements)?

A conversion was completed from another software product.  For some reason after validating the entire process we know what the number is and it matches the difference between the balance sheet and income statement to balance it. It belongs in retained earnings and all other balances are matched against the GL ledger from the old program.  I need to make a one sided posting to that account or an adjustment account to sum to that grouping for the amount in question which balances the assets and liabilities and completes the transition.I have been unable to find a methodology

Hi,I’m importing trial balance . the debit and credit amounts exactly tally in the excel. but system keep showing below error. Appreciate your help. Thanks,Dulanjana 

I know there is a customization to publish for add apply retainage for AR Invoices and Memos but what do you need to do for AP Bills? The apply retainage button is not available right now in migration mode and I need this ASAP!

I have created the Order of  Type “IN” with manual numbering.When I am trying to Prepare the Invoice above error is getting. Can anyone help on this ? 

Hi,I have someone entering an expense claim using a specific Expense Item. Normally this item is taxable and has taxes calculated but in his instance, the supplier is not charging tax. How can the person entering their expense claim put the tax amount to zero as the taxes get calculated automatically based on the tax category and configuration. This could be the case on expense claims, or on PO’s or in AP Billls too. When I try to set it to zero I get the following error: 

Rookie question on ARM Reporting:I’ve modified a P&L column set to have three columns MTD/PTD/YTD actual values.I can’t figure out the right settings in the Data Source section of the Column Definition.Example of issue:  Printing report for January 2021 I ‘should’ get all three columns to be equal.But the result I am getting is shown below. The MTD Data source is set to The PTD Data Source is set to:The YTD Data Source is set to (I think this one is correct) I am looking for help on what the correct Data Source configuration should be for MTD, PTD, and YTD columns.Thank you,Mike Lupro 

This formula works for the YTD Column in my Column Set.=IIf(Left(@StartPeriod,2)='01',Left(Report.GetPeriodDescription(@StartPeriod),3)+' '+Right(@StartPeriod,4),Left(Report.GetPeriodDescription('01'+Right(@StartPeriod,4)),3)+' '+Right(@StartPeriod,4)+'-'+Left(Report.GetPeriodDescription(@StartPeriod),3)+' '+Right(@StartPeriod,4))But it does not work for my PTD column set.What would be the correct formula for my PTD column to display Oct 2021 - Nov 2021 when I run the report for the November period.And, while we are at it, what would the correct formula be for the MTD column to display Nov 2021? Mike Lupro 

Is there an easy way to revalue inventory for a specific item/site? Best I have found is inventory adjustments, but then you cannot add inventory to the same receipt because the costing is tied to the receipt.  We had a incorrectly costed move due to a incorrect AP entry for a sub component. 

Hello thereWhat is the code for creating a date and time stamp which shows on a report when running it?Thanks   

Hello, I want to set up a new branch but unsure where I can specify the data set for the branch.  We use first three character of sub account for department,  as 32A and the new branch is an aggregation of 32A, 32B, 32C.  Can anyone assist us to set this branch correctly?  

Hello,I am wanting to create a pdf form for AP Debit Adjustments. The business case is that when we have a Credit memo request from our Vendors, rather than waiting for the Vendor to create a Credit Memo on their end and send to us, I would like the ability to generate the a Debit Adjustment and print to PDF so I can send to the Vendor to initiate the request. I am told I have to create a form from scratch for this as out of the box there is not form for Debit Adjustments. How would I go about doing this and are there any best practices to help expedite the creating of this, ie copy AP Remit form etc… Thank you