ISV Solutions

Hi, What’s endpoint version for Acumatica 2024R1, is it 23.200.001 ?

Hi,Recently I faced with such problem :Earlier such request worked : https://abcd.acumatica.com/entity/ARTSDocEndpoint/20.200.001/PurchaseReceipt?$filter=ReceiptNbr eq 'PR001383' and VendoriD eq 'PP1'&$expand=DetailsBut now it loading all set of data from Acumatica and I get timeoutI set timeout at 10 minutes and after that Acumatica returned all Receipts that are present at Acumatica.I doublechecked data that I am trying to get via filters and tried to get another data from Acumatica - noting worked. I tried to perform similar request with PurchaseOrder and Vendor entities - everything worked. Also, I checked endpoint and all fields are present for Purchase ReceiptPlease help, maybe some addtional configuration should be checked 

Hi, In my Acumatica 21.211.0033 I need to configure endpoint in such way that I will have an ability to generate Checks and Payments item with type Prepayment that will have ‘Documents to Apply’ table and ‘Orders’ tableI have already found and added ‘Documents to Apply’ tableBut I can’t find ‘Order’ table for checkes and payments. What’s it’s name ? Can it be added for using in creating new ‘Checks and Payment’ item with type ‘Prepayemnt’ ?I need something like this 

Hi,My application generates request, which creates bill. It worked till Monday, but after Acumatica was updated I started receive such error :"Receipt Line PR574695 - 1 not found.",. I checked Acumatica Endpoint and everything what was added is not missed.Here is example of request {  "VendorRef": {    "value": "103tyjt5462"  },  "DueDate": {    "value": "04/28/2024"  },  "Vendor": {    "value": "00018"  },  "Date": {    "value": "02/28/2024"  },  "Description": {    "value": "dhID \"4\""  },  "ReleaseBill": {    "value": "True"  },  "PostPeriod": {    "value": "02-2024"  },  "Details": [    {      "InventoryID": {        "value": "BRUNO"      },      "Description": {        "value": "StuH"      },      "Qty": {        "value": 1.0      },      "UOM": {        "value": "EACH"      },      "UnitCost": {        "value": "3,2"      },      "Project": {        "value": "X"      },      "Branch": {        "value": "520"      },      "ExtendedCost": {        "value": "3,2"      },      "POLi

Hi,I need to proved my client with information concerning minimal set of rights for creating and getting some entities (Bill, purchase Order, Purchase Receipt via our API)I found this topic  But I need an official guide reference concerning this issue 

Our organization is working toward use of the Vertex tax integration with Acumatica.  In review of the documentation, it states the need to create a tax agency vendor specific to/for Vertex.  We are trying to understand the specific use of that vendor account.  Is it just for the integration, or will all taxes be paid to that Vertex vendor?Currently, we have multiple accounts with state and local entities as we file and pay taxes.  We just need to understand if this single agency vendor will then replace those individual accounts, or if the Vertex vendor is just used for the interface.

Hi,I am receiving error “The given key was not present in the dictionary", when I am trying to make request to Purchase Receipt entityHere is URL of my request:  https://aiimy.acumatica.com/entity/ARTSDocAlphaEndpoint/20.200.001/PurchaseReceipt?$expand=Details&$select=VendorID,ReceiptNbr,Details/POOrderNbr,Details/InventoryID,Details/LineNbr,Details/ReceiptQty&$filter=OrderNbr eq 'PO001283' and VendorID eq 'AAVENDOR'This request worked previously, maybe something has chnaged in AcumaticaI checked endpoint for fields availbality and they are all presentHeader section Footer section I attach full stack trace, maybe it helpsIts Acumatica 21.211.0033

Just checking if anybody in the Community know bit more about AWS S3 - External file storage integration. Any guidance or insight how to select the best S3 storage for Medium/M Resource level of Acumatica, what specs we may be looking for? And what pitfalls to avoid. I did check with Acumatica support and there was not much help either, so asking the community if anybody has any insight on this topic.Thanks 

Is there a timeline that an ISV is required to supported the latest revision of Acumatica? I’m wanting to upgrade to Acumatica 2023 R2 but I have a key ISV that has only released support for 2023 R1. Two months seems like more than ample time to release R2 support. Thanks,Justin

Hi,I have customization project which I use for different Acumatica versions (2022R1 ,2022R2, 2023R1, 2023R2)At all versions it works perfectly, except 2023R1Package is successfully published without errors, but when I go to endpoint and press any entity I receive the following errorI tried follow the refence and select some company, but everything is emptyWant to put emphasize on that such behavior appears only at version  2023R1, at 2022R1 ,2022R2,  2023R2 everything is fine. What can cause such error, should be Acumatica reinstalled ? Endpoint version is 22.200.001P.S.I can’t attach the customization projectThanks in advanced 

We have inhouse inventory that is transferred to projects on a monthly basis.  Currently through Project Transactions you can enter the Inventory ID, qty, price, etc and the costs will go onto the job however it does not make any adjustment to the inventory stock item itself.  We then have to go into Inventory Preferences, shut off the “Update GL” so that the adjustment does not double up in the GL,  make an adjustment to the physical quantity and cost to reflect the new quantity on hand, then turn the GL back on.  With internal transfers of inventory to projects, we should be able to make one entry that will update the project, the GL and the inventory item all at once.  According to support, we do not have that function at this time so anytime someone has an adjustment to move inventory to a project it is a 3 step process.  We would like to get this streamlined into one and done entry.

Good morning, We are evaluating some CPQ platforms to handle made to order products, is anyone aware if Acumatica has ever or has plans to integrate with more advanced CPQ tools like ConfigureOne, KBmax or ThreeKit?

Hi,In this topic It was told that new version of endpoint is planned for 2023R2Is it already released ?If yes, is it 23.200.001 ?

I recently upgraded my Microsoft Outlook to 1.2023.807.100 (Production) and client version 20230804005.15. Now I have lost all functionality of the Acumatica integration with Outlook. Is everyone else having the same problem?

Hi,My application generates new Bills in Acumatica via REST request.if document’s size is less than 25mb everything works fine, new bill is created and document is attached to it, otherwise if documents size is > 25mb, I receive this error.Is there any configuration parameter in Acumatica to increase allowable size of the document ?

Hi,I am trying to create Bill with ‘Owner’  field via such request{      "WorkgroupID": {    "value": "AP Processors"  },  "PaymentMethod": {    "value": "FEDW-IRE"  },  "Vendor": {    "value": "ASIV1yuotu0137"  },  "Company": {    "value": " Energy"  },  "OwnerContact": {    "value": "Diane Lehr"  },  "PostPeriod": {    "value": "08-2023"  },  "Branch": {    "value": "6400"  },   "BranchID": {    "value": "6400"  },  "Type": {    "value": "Bill"  },  "Owner": {    "value": 18897  },  "VendorRef": {    "value": "1135244"  },  "AccrualAmount": {    "value": "18,561.64"  },  "Date": {    "value": "05/29/2022"  }}I want to pass to Owner definite value but it’s type is intHow to get this value for specific Contact name and pass it correctly for new Bill entity?

Hi,I am using application that generates json request for creating new Bill itemNew bill is successfully created, but filed Owner does not contain my value, which I sent, it contains some default valueI checked endpoint configuration and checked Owner value availability in system and I can’t figure out why Acumatica does not set my value to this field.I there some specific configuration should be done to achieve this ?Here is my request :URL : https://ccgijkhlm.acumatica.com/entity/DocEndpoint/20.200.001/BillBODY : {   "Date": {    "value": "01/20/2022"  },  "VendorRef": {    "value": "byIvan"  },  "Vendor": {    "value": "V00032346"  },  "Branch": {    "value": "CCG234MAIN"  },  "Description": {    "value": "PO0002342345246"  },  "DueDate": {    "value": "9/14/2023"  },  "Terms": {    "value": "NET30"  },  "Owner": {    "value": "Lehr"  },  "WorkgruopID": {    "value": "AP Processor"  }    }

Hi,For Acumatica authorization such request is used URL : https://ath.acumatica.com/entity/auth/loginBody ;                                              {"name" : "admin",                                             "password" : "somePassword",                                             "company" : "",                                             "branch" : "",                                             "locale" : "en-US"}Sometimes company, branch, locale are obligatory, sometimes are optional.When we use Oauth 2.0 authorization to Acumatica I do not see the usage of these parameters anywhere My question is : Does Oauth 2.0 require company, branch, locale for authorization ?How Acumatica process these parameters for oauth2.0 ?

Previous to the Acumatica 22R2 version, Bank Feeds were installed as a customization and licensing only monitored the Production Tenant. I was able to support the client when production issues arose by using the Copy Tenant to refresh a “Sandbox/Support” Tenant. In 22R2 and later the bank feed was transitioned to a Feature and not a Customization Project but the new licensing structure is monitoring all Tenants in the Database for License Violations. If the Copy Tenant is utilized for ongoing support the license monitor sees a violation because the bank feed licenses count all tenants. As a result, the Production Tenant Bank Feed is halted until Acumatica Support Intervenes. Is there a new procedure on providing ongoing support using the Copy Tenant feature and not interrupt the Production Bank Feed because the license is monitored at Database Level across all tenants. This makes it difficult to support clients without interrupting production because of this license model.

We are running 23R1 and have sendgrid intergrated. We have business events that are trigger-based during various phase of the customer lifecycle ie: Opportunity is created, Project is assigned, Waiting on material, XYZ. We would like to use multiple ‘from” domains and multiple “reply to” domains so we can triage replies to cases (think zendesk lite).  In sendgrid I can create multiple single Sender Verifications ie (Support@domain, Sales@Domain, estimating@domain), however acumatica only has one sendgrid email account (email service plug in) that has the API where I can import templates. Below are 4 examples of what we’d like to accomplish: 

Does anyone know of a good tool to integrate a Golf Course / Country Club / Restaurant with Acumatica?   Currently on 2022R2

This is kind of an SOSI would normally spend a few days on a project before asking for help, but I’ve been given a fire to put out which has a significant impact on the customer.On the customer portal, users are able to enter support cases.  I need to limit the support cases that show up in the grid to just cases created by the contact that is logged in.  Right now, all cases are being displayed for any user.  The users are simply contacts for a BAccount “PORTALUSER”.  So, when that contact logs in, they see everything for that baccount.My thought is to somehow change the view on the grid so that it adds a where condition CRCase.contactID =  AccessInfo.contactID.FromCurrent()It looks like I need to modify the FilteredItems view.   Can I override this?  Or, is there some way I can override one of the screen events to restrict the Case view?I’m also trying to find out how I can get the contactID of the current user.I can get the userID with this code:            Guid? currentUser = Commo

Hi, I faced with such error while trying to insert such set of data to AcumaticaURL :https://Agroup.acumatica.com/entity/ARTSEndpoint/22.200.001/BillBODY :{  "VendorRef": {    "value": "00067001"  },  "DueDate": {    "value": "05/22/2023"  },  "Vendor": {    "value": "PU0262"  },  "PaymentMethod": {    "value": "BACBOS"  },  "Date": {    "value": "05/22/2023"  },  "Description": {    "value": "docAlpha BatchID \"25270\""  },  "CashAccount": {    "value": "10305"  }}The error is the following I tried various values for this field but result remains sameI mapped this field in EndpointWhat Can cause such issue ? 

Hi,In My ISV Product,I need to update Allocation check box in Sales Order from Material receipt release.(Inventory QtyAvail < 0)I wrote code to update IsAllocated=true for Existing SOLineSplit. After Material Receipt release getting Base SO code Exception that “Qty will go Negative”..So that I am unable to update Allocation in Sales Order.Error is populating at g.Save.Press() from the Below Image Is there alternate code to update Allocation.   

We are setting up with a retailer and have to use their account.  I am unable to know what some of the information for the following:  Where do i find this or is there a way to use their account without that information?ACCESSNUM The access code according to your agreement. ENDPOINT The URL of the UPS service. SHIP ENDPOINT The URL of the UPS ship service according to your service agreement. TNT ENDPOINT The URL of the UPS Time-in-Transit service according to your service agreement. VOID ENDPOINT The URL of the UPS void service according to your service agreement.