We encountered this error in our staging Environment.We have multiple staging sites on the server. Lets say we have Stage.myCompany.com, which points to DB1 And Stage.MyCompany.Com/Stage2 points to DB2Stage.MyCompany.Com/Stage2 works, but Stage.MyCompany.Com gets the “Database could not be accessed” error.They all use the same App Pool, and all have no issues except for the main staging site.We know it is not a database issue because if we use switch Stage.MyCompany.Com/Stage2 to use DB1, it works. And if we switch Stage.MyCompany.Com to use DB2, it still shows the “Database could not be accessed” error.We are using version 2021R1 Version 21.103.0054Is there way where we can trace what is causing the error? TIA Mark
Hi, I modified a report but unable to save it to server. I can preview it but when I try to save to server, I get the following not helpful error. It does not tell me which field is too long. The report is AR641000. I was able to save the report but after some changes, it started showing the error. The error doesn’t tell me which field is causing the error.Anyone know how to narrow down the issue and resolve it?Report designer version is 2021.115Mark
Hi, We would like to notified the Owner of a Task whenever a field on a Task has been updated.However Screen CR306020 is not an option in Business Events Screen Name.Is there a way to get notified whenever a Task is saved? Thanks Mark
Hi,Is it possible to pass a Parameter to the GI when the GI is extended via a WebService EndPoint? Setup:I have created a generic inquiry called SubcontractsByProject, it takes in 1 Parameter called ProjectID, I have set the ProjectID with a default value of a project and it filters to that Project, so the GI is working as it should. I have extended a Webservice EndPoint to SubcontractsByProject using instructions from https://www.acumatica.com/blog/contract-based-apis-in-generic-inquiries/ The web service workshttp://localhost/entity/Subcontracts/18.200.001/SubcontractsByProject?$expand=ResultIt is returning data with the default ProjectID in the GI How can I pass a different value of ProjectID to the webservice?I tried adding a parameter in the Body like so in PostMan but it does not work ThanksMark
Does anyone know how to make the Project selector visible in the Purchase Order screen PO301000?In the PO301000 screen, I can see Project in the 2nd columnBut when I go to the screen, Project is not visible after Owner as shown below Thanks Mark
Hi, I followed this example https://help-2018r1.acumatica.com/(W(2))/Wiki/ShowWiki.aspx?pageid=d806636f-3cb8-4fd6-bc1e-fef9cdf9683dto delete an item. It works on Stock and Non-StockItem but it does not work on a Ledger. Instead of passing the line below to delete a StockItem string stockItem = rs.Delete("StockItem", inventoryID); I tried string msg = rs.Delete("Ledger", "0915ACT");but it does not work.I have tried endpoints 6.00.001, 17.200.001, 18.200.001 and 20.200.001 and all of them failed.Using EndPoint 20.200.001 fails to login using the same code.The ledger screen is localhost/Main?ScreenId=GL201500&LedgerCD=0915ACT Is it possible to delete a Ledger through the Web Service? The problem is we have many ledgers we setup and we want to programmatically delete them. We would also like to use the same code to do batch cleans of items we no longer want instead of manually deleting items. Thanks in Advance Mark
Hi,We are trying to customize a screen but would like to have different versions of same screen depending on user access. But there is no command to copy a Screen as we can only select a screen to modify.Is there a way to copy a screen and save it as a different screen name? Thanks Mark
Hi, I have extended Default/18.200.001 endpoint to include Construction SubContracts like this http://localhost/test/entity/Subcontracts/18.200.001/Subcontracts I can filter by a field from the summary like thishttps://localhost/entity/Subcontracts/18.200.001/Subcontracts?$filter=SubcontractNbr eq 'SC-000002' However, can I filter on a field in a details table?Example, Is it possible to filter by the Project field in Document Details tab in SubContracts end point?
Hi, I have extended Default/18.200.001 endpoint to include SubContracts like this http://localhost/test/entity/Subcontracts/18.200.001/Subcontracts/ I can retrieve all Subcontracts, but I would like to filter to get 1 SubContract back as it will hit the max size limit eventually. Is there a way to do this like its possible to do with Vendors http://localhost/[sitename]/entity/Default/17.200.001/Vendor/AAVENDOR?$expand=MainContact ? Additional notes:This is what I have currently and it works except it returns all subcontractshttp://localhost/test/entity/Subcontracts/18.200.001/Subcontracts/ I would like to have it working like vendors to filter to a subcontract like sohttp://localhost/test/entity/Subcontracts/18.200.001/Subcontracts/SC00001 to retrieve only subcontract SC00001and http://localhost/test/entity/Subcontracts/18.200.001/Subcontracts/SC00001?$expand=DocDetails to retrieve only subcontract SC00001 and expand DocDetails. Thanks in AdvanceMark
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.