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
Hello, I have added a small customization to the Vendor Status field such that it includes a new available option for selection. This was done through the Customization Project via the ‘Fields’ section of the ‘Vendors’ [AP303000] screen, where a new Combo-box value of ‘Z’ and description of ‘Pending Approval’ (see below screenshot) were added. The respective value of ‘Pending Approval’ is available on the ‘Vendors’ [AP303000] screen, however when running the Generic Inquiry which shows the list of Vendors, there is a slight issue, whereby the Status is being shown as blank. I have some workarounds to this such as by using a Switch function to manually show the status description, although this is not “clean” as it could break in case of upgrades and it would be considered as sort of “hard-coding”, thus is not good practice. Does anyone know whether there is perhaps some missing configuration that I need to do to make the value description show for the new Combo-box values? Thanks in
Hello, We are encountering an issue after a recent Acumatica upgrade, with the DeviceHub.Basically, the printer has been configured and was working prior to the upgrade (on version 2021R1), however after installing the latest DeviceHub version 2022R1, the log shows the following message. When I am trying to use the ‘UPDATE PRINTER LIST’ on the ‘Printers’ screen in Acumatica, the DeviceHub log is not registering the request being made from the Acumatica web app. Note: The printer is correctly installed and the machine which is being used to run DeviceHub does have access to it as well. Has anyone ever encountered this please? Thanks and Regards,Nigel Pace
I have a UDF defined on the ‘Bills and Adjustments’ screen which is of type ‘Checkbox’ (Boolean) which works just fine. This UDF was defined using Acumatica’s User-Defined Fields functionality, thus its not a standard field added through the Customization Project. I have tried to add the UDF checkbox to show up on the ‘Checks and Payments’ screen under the ‘DOCUMENTS TO APPLY’ screen which does work and it does show its value, however I am encountering a strange behaviour whereby the value of the field disappears (is set to Null / False) when the record is saved. Below is an example:When adding the bill under the ‘DOCUMENTS TO APPLY’ tab, the UDF’s value is retrieved and shown correctlyWhen pressing the save button (saving the payment record), the ‘Disputed’ UDF checkbox for Bill 003126 is changed to False/Null as shown below Note that this field is read-only in the grid which is correct, as the actual ‘Disputed’ UDF field is set on the ‘Bills and Applications’ screen, hence the role
Hello, I have a situation where a user needs to be notified whenever the credit limit utilisation of a customer exceeds a certain threshold. I have tried using an existing GI which Acumatica offers out-of-the-box with title ‘AR-CreditLimitCustomers’ and added a field to calculate the utilisation percentage. The calculation is as below.=((([ARBalancesSharedCredit.CurrentBal]+[ARBalancesSharedCredit.UnreleasedBal]+[ARBalancesSharedCredit.TotalOpenOrders]+[ARBalancesSharedCredit.TotalShipped]-[ARBalancesSharedCredit.TotalPrepayments])) / [CustomerSharedCredit.CreditLimit]) * 100 However, as expected, the business event does not trigger due to a known limitation that business events do not work on calculated fields. For this reason, I created a SQL View which basically runs the same query as in the GI above and included the custom formula as well as a separate field. I created a DAC linked to this SQL view and added it to a new GI and a business event to it linked to this field.Despite hav
Hi, I am having an issue with the ‘W(n)’ value in the URL generated by Acumatica.For reference, this is a sample URL https://domain/AcumaticaInstanceName/(W(n))/Main?ScreenId= AR3010PL Basically, when clicking a shared filter KPI widget on a Dashboard, the system opens the Generic Inquiry in a new tab, however the W(n) value is always the same and the shared filter that is opened is the same as when the user clicks the first filter. I am aware that this value is used for caching purposes, however I cant understand why its not incrementing such that the correct shared filter is opened. Has anyone had experience with such issues please? If so, can you please advise what can be done to sort such issues? Thanks,Nigel Pace
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.