General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Deferred Revenue, Taxes, Currency Management
- 1,320 Topics
- 4,381 Replies
When running reports, for example, the Customer Summary Report I cannot get it to sort by name. It always sorts by the customer ID. I change the sort in the Additional Sort and Filters and I’ve tried to change the sort in the report designer but it still won’t sort it the way I want. Any help will be appreciated. Thanks,
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?
Hi Now i currently the chart color all are blue .May i know how to change to other color that we preffered like green , orange , purple and etc .Understand we need to go in the chart setting to type in the common. Not sure who can share with me the step of how to change the color or any video link can send to you? Thank you very much
After upgrading from 2019R2 to 2020R1, meet "Sequence contains no matching element" errors on creating customer refund on "AR302000"
Hello, Our company normally just give customer credit memo and will not refund money. So we used “customer refund” function only 1 time in 2019R2, and it is ok. It went well, no error happened. However, after we had upgraded to 2020R2 and we had to create a new customer refund. it says “Sequence contains no matching element”. Just right after we have chosen the type as “customer refund” or “void refund”. Can someone helped us out?
In our test environment, we’ve created a Non-Stock ‘Freight Estimate’ item to add to Sales Orders so we can authorize a credit card payment before the shipment. The ‘Require Shipment’ box is unchecked and the settings for our Sales Order Preferences, Order Type, Shipping Rule, and Non-Stock Item are identical, but in our Live environment it is left off the Shipment (visually), but is pulled onto the Invoice and shows the Shipment # on the line. This does NOT happen in testing which is the desired behavior. We have ‘Add zero lines for Items not in Stock’ checked and we give the ‘Freight Estimate’ a quantity of 0. Does anyone have any info on why a non-stock item that doesn’t ‘Require Shipment’ is being attached on the back end to the shipment..and messing up our invoices? This issues has been driving me and our Partner nuts. Nobody seems to be able to figure it out, so I’m really hoping someone here can help us out. I can post a ton of more info if needed. Thanks a ton for any he
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
Hi, I am trying to Release an invoice but I get an error that says GL Error Actual Ledger “ must be defined in base currency USD only. This is happening in our live environment but not in the sandbox (which was refreshed yesterday). This leads me to believe that a setting was changed somewhere inadvertently by a user. Any help would be appreciated.TIA
How can I use Customer Invoice to pay for a Vendor Bill?I saw the option to "Extend as Vendor" on customer screen and "Extend as Customer" on vendor screen but I didn't find how do I apply a vendor bill to a customer invoice...I would appreciate any suggestion.Thanks
How do I import the attachment with an import scenario? The AP Document has an file attachment. I am creating the AR Document based on the document lines in the AP Document. I can get the attachment file in an generic inquiry - On the APInvoice it is the NoteIdWith the import scenario I have the option to update the Note Text field but do not find the option to update the Files.
Hi all...perhaps someone can share some ideas on following TAX (VAT) issues.To be able to create a meaningful tax report i have created 3 different tax zones and tax categoriesTax zone 01 / category 01 = local purchase and sales on 15% VAT. All stock items are set to this category, all good in this scenario.Tax zone 02 / category 02 = all foreign customers (exports) set to tax zone 02 / category 02, this category is set to 0% VATTax zone 03 / category 03 = all foreign vendors (imports) set to tax zone 03 / category 03, this category is set to 0% VATThe VAT for imports is paid by the customs clearing agency and invoiced as 'Custom VAT" together with other charges to us. In our tax report we need to show the total value of imports and total value of exports for the tax period.In my opinion the tax setting of the foreign customer and vendor should have priority over the tax setting of the stock item.Currently you have to go to each line item and manually change the category to 02 or 03 t
Hi Anyonei would like know more about the landed cost in accumatica. As i know once we entered the landed cost . it will become part of value of inventory instead of freight cost expenses. Not sure if my understanding is correct?As we would like to know the freight cost of each import shipment or outbound shipment, Not sure if acumatica got this function to let us take in the freight cost?Hope to hear from you soon.Thank you
Has anyone done an integration with Bill.com or checkissuing.com?Issue: We have several customers that issue a large number of AP check each month through Bill.com. This results in a lot of manual entry, labor printing, stuffing and mailing checks. The customer is open to moving to other solutions or continuing with Bill.com along with an integration that allows the AP bills to be input once and the bill and remittance recorded in Acumatica.https://www.checkissuing.com/https://www.bill.com/
Currently when viewing the Trial Balance (detailed) you can only view one financial period at a time.It would be beter as accountant that I should be able to select start period and end period. So I could e.g. Say show the the Trial Balance and movement from 1 March 2020 to say 31 May 2020. The trail balance should therefore show the Opening balance as at 1 March 2020, the accumulated Debits and Credits for the period (3 months), and then the final closing balance as at 31 May 2020.Currently we are limited to only obtaining a trial balance for one financial period at a time. It make analysis of financial results cumbersome to work with, and each financial period needs to be exported and then summed and grouped in excel… very time consuming unnecessarily so.
I have an AR Credit Memo stuck in a reserved status. It was initially created to process a refund but another AR credit memo was created in its place. The refund was processed and attached to the replacement CM and those two documents are closed.The AR Credit Memo is not applied to anything and all options on the actions, inquiries, and reports menus are grayed out. It is a part of a batch that was posted to the GL which makes me believe that the document was released before it was reserved. Any ideas on how to get this document out of reserved status? Our end goal is to delete it or close it out with a debit memo.
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!
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.
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 AP Aging report is created to run based on the Document Date (Bill/Invoice Date) which at the end of the month leaves our AP out of balance with the General Ledger. We have some bills that are dated for the end of one month, but not entered into Acumatica until the beginning of the next month. I understand that the invoice date is important as this indicates when the bill is due so I don’t want to change that. But is there any way to run the aging report on a transaction date (date that the bill was entered) as opposed to the invoice date so that our AP Aging report and General Ledger will balance?
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.