Financials

Hello,When we have migrated the fixed assets and when we run depreciation for the next first period, system will look at the asset from the acquisition date and calculate any over/under depreciation. Is there any way that we can depreciate asset from the migration date without doing over/under adjustment by the system for the fist period after migration? Simply system needs to run depreciation without considering over/under depreciation adjustments.Thank you,Dulanjana

We are finding inconsistent behaviour with the recognition of expenses receipts (24R2).Sometimes European dates are recognised other times not.But this question is about currency.  We are finding that all receipts are assigned the currency code of the company and that the currency symbol on the receipt is ignored.I would like to know if users in the US find that the expense recognition recognises the currency.  I assume that US employees will frequently have CAD or GBP expenses to claim.  ThanksJames 

Hi Team,For xxxx Customer. The total payment was $10,021.98 but T5018 reports shows only $6883.56 As shown in the screenshot below, the highlighted Ref. Nbr. appears correctly in the T5018 Report Details; however, the remaining payments are not being displayed. Could you please advise on the root cause of this issue?   

Good day,I added a new Company/Branch to the Unit Set.  All the individual company/branch reports work.  However, the Consolidated (ALL) report is now not working.  I have new Canada reporting ledger that is the new addition. Nothing else has changed other than adding the new company/branch reporting ledger for Canada. Any advice to getting the ALL (Consolidate Balance Sheet) for a consolidated Branch.  Below is the Unit set.Thank you.  

Good day communityI need to do a bulk reversal of batches created by FA which can’t be deleted. I have posted all the batches and created an import scenario to reverse. Error message is “Batch Status invalid for processing.” Can anyone help? Thank you 

We have been creating statements for several months and today when we went to run statements we got an error ‘ Nullable object must have a value’ . I have checked the statement cycles and the preferences and have not found a problem.  Any suggestions on what to check next?

We just upgraded to 24r2 and are thinking of switching to Acumatica Payments.  With our current third- party payment vendor, Credit Card Processing fees are calculated, and these fees are being added to the Acumatica Payment screen so that the customer is paying for using a credit card.Is there a way to continue to calculate credit card processing fees and charge them directly to a customer if we move to Acumatica Payments?

We have a client who wants to use project accounting in a somewhat unconventional manner.  The client is using projects account to track manufacturing WIP and progress billing.  The client did not buy either Distribution or Manufacturing as they are using a 3rd-party solution for these features.  They want to have the ability to use progress billing, but because they recognize revenue by the “completed project” method, they need to post their billings deferred revenue.  Using a WIP schedule for this is not ideal for this client.The plan was to allow them to generate progress billing on demand, posting the credit side of the invioce to Deferred Revenue, then use the allocation feature at the end of the job to reclassify the Deferred Revenue, along with their WIP, to revenue and COGS, respectively.  I tried using a different methodology, where they generated progress billings, then offset the final bill with the sum of their progress billing to request the final amount due while recogniz

Hi Acumatica team,We have a client who is interested in Acumatica Artificial Intelligence features (AI Acumatica), I have been searching for manuals without success.Cloud you share with me a manual about how to use the Artificial Intelligence in Acumatica (AI)? Thanks

I’m hoping to find other Acumatica community members who utilize the multi-base currency tenant feature in Acumatica.  The company I am the Director of Finance for started using Acumatica in 2022 and went live on 2021 R2. We have four companies worldwide, each with their own base currencies, USD, GBP, EUR and HKD.  When we were sold Acumatica, there wasn’t much talk or offerings surrounding the multi-base currency feature and even Acumatica had a warning label on it that it was still relatively new.  We started out by creating 4 tenants with 4 different base currencies, but our companies are so integrated in day-to-day sales and operations that this became such a hurdle for us.  When we upgraded to 2022 R2, we created a development environment to start testing out the multi-base currency feature and quickly found out that many of the great things about having multiple companies within one tenant were taken away with the activation of this feature.  Transfer orders, intercompany transac

We have investors in our company who receive periodic distributions based on their shares invested. We intended to use the “Cash Purchase” option to create the checks since they are not for AP and should not have a bill/bill payment associated with the distribution. However, when going to print the checks, we realized that nothing prints in the memo field or on the remittance sections that would tell the payee what the check was for.Is there a way to have a memo print on the checks when using the “Cash Purchase” option?

When trying to release an AP batch I get an error: Updating 'GL Batch' record raised at least one error. Please review the errors. Batch is out of balance, please reviewI cannot see any problems with the batch and it’s not out of balance  

I’m working on a customization for the project screen to expose two amounts from the Balances screen (1) Income Totals - Actual + Open Committed Amount and (2) Expense Totals - Actual + Open Committed amount. I can’t seem to figure out how to reference this part of the schema as the data field for my custom field.I’ve tried various iterations the last of which looked like….                          Balances.Income.CuryActualPlusOpenCommittedAmount    and                          Balances.expense.CuryActualPlusOpenCommittedAmountThose did not work. Any thoughts would be appreciated.  

I have a service order with an inventory item on an appointment, but the item did not flow through to the invoice.  I am not sure how this could happen.  Any thoughts?

Hi Acumatica, Is there a way in Acumatica to set the format of my password?Numeric Alphabet Alphanumeric Alphanumeric with special characterThank you!

Good day CommunityMy client is looking to change the life if a Class if assets from 36 months to 60 months from the end of a financial year.The challenge is they want to depreciate to remainder of the (extended) life of the asset over the remaining time (60 months - age to year-end) but depreciation now calculated as (NBV at year-end / remining life) and NOT (Orig.Cost / remaining life), e.g.Orig. Cost 07-2023        100 000.00       NBV 12-2023                   86 111.11          remaining months         55.00   New Month depr             1 565.66  (86111.11/55) Does anyone have any idea how I would set the deprecation for such a calculation please?Many thanks in advance.                     

Good day communityCan anyone assist me by telling me which tables are relevant to write GI in order to balance IN subledger and GL?Suddenly the subledger & GL have gone out of balance and the difference appears to be growing. There are hundreds of transactions so I am struggling to do this using a normal recon process. I really need to generate a GI to help but can’t figure out which tables to use.If anyone has an existing GI or can at least advise which tables to use I would be very grateful.Many thanks in advance.

Good day We run the company by using calendar years (For management accounts purposes), however the reporting on the budgeting side only allows for financial years, my question is, is there a way to use Calendar years when creating and reporting on the budget function? 

Acumatica Row Level Security on the GL Account seems to work fine when you are trying to remove the account from selection when creating a new Journal Entry.  However, any released Journal Entry, as well as a number of the GL Register and Edit Reports include these transaction lines for all users, as long as they have the right to open the Journal Entry or Register report.  If the purpose of the Restriction Group is implied to:“your organization may have sensitive or confidential accounts and subaccounts which must be invisible for majority of users. You can control the visibility of these accounts and subaccounts for users (that is, -which users can view the accounts and subaccounts) by using restriction groups.”Wouldn’t you want the transaction rows to be suppressed in the report/entry screen as well. Does this match with what others have found when using the Account restrictions? Thank you. Bryan  

Hi, we’re having an issue where the provided signature image is not printing on checks over $1,000. There are no threshold settings on the Signature tab of the Cash Account. I also verified there are no Visible Expr settings on the form for the PictureBox. What am I missing?24R2

Currently, there is no way to restrict documents created by users to view only their documents.  For example, Purchase Orders created by User A using PO Clerk Role.  There is no way in the system currently to restrict User A to only view the Purchase Orders created by User A.I can create a GI with a condition created by = @me and use this as a default.  Then, update the Access rights for PO screen and revoked the buttons “first”, “next”, “Prev” and “Last”.  Update the OrderNbr to “View only”.  This works but in the Global/Universal Search, the user can enter a PO number and this will show up in the search and click on it.  I have yet to find anyway to restrict this search.This should be an easy thing, i.e. restricting a document to the created users only.Any ideas how to restrict the Global/Universal search?  I.e. turn off search for PO numbers in the Search. CheersFrank 

One of our customers had 2 invoices for the same customer that had the same cash discount date. A payment was created to completely pay both of these invoices.The payment was within the due date but outside of the Cash Discount Date. The payment still applied the cash discount.I have tried to recreate this issue with the same vendor but cannot. It calculates the total correctly even when I change the payment date. I went through their old payments and the majority are correct but I did find one other that had the same issue.Any idea what circumstances could be causing this?

Hello,I have an AP Bill which pay by line is ticked. The Bill has been reversed and the debit adjustment is created.Then I’m trying to apply it against the bill by the payments and applications from. Since it needs to be applied with the type payment, The payment type is selected and the Debit Adjustment is loaded in the line. But The bill does not show any available balances to apply. But the bill is still open, the lines show the balance to zero. There are no any other applications as well.I tried to recreate this but I could not recreate this as well. is there any specific reason for this behavior. Thank you

Please kindly advise, how can set up Purchase on Tax Type because we want to separate VAT INPUT and VAT OUTPUT. Many thanks for your advice and support

Does anyone know how I can assign more tax years to the tax agency in the Tax Period?My issue with the system is that I can see multiple years as a filter for some tax agencies. However, for some tax agencies, I can see only one or just a few years .For example, for the Florida state tax Period, the system shows the years between 2018 and 2026but for Massachusetts, it is different. Just for your information, at first, I thought it might show the years that have transactions. However, Massachusetts has transactions in 2021 and 2022, but those years are not displayed.On the other hand, I checked the Company Calendar, and there was no issue with that either.