ISV Solutions

Hello all. We have built an integration to push Journal Transactions into Acumatica with the Rest API. Our transactions can have hundreds of line items, which would come over as Transaction Details. We first tried to do this within a single request. But we get this error when trying to push transactions with more than 10 details: ```[Acumatica] 414 Request-URI Too Long: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN""http://www.w3.org/TR/html4/strict.dtd"><HTML><HEAD><TITLE>Request URL Too Long</TITLE><META HTTP-EQUIV="Content-Type" Content="text/html; charset=us-ascii"></HEAD><BODY><h2>Request URL Too Long</h2><hr><p>HTTP Error 414. The request URL is too long.</p></BODY></HTML>``` We have since broken up the request into batches of 10. This also doesn’t work because the Journal Transaction will get rejected if the lines don’t balance, and the way we separate lines we can’t guarantee batches of

2022 R2 We have paid for Shipping Carrier Integration license. I have integrated EasyPost for UPS using our carrier rates as per the provided guides. Tested the setup and it is connecting properly.Tested Confirming Shipment to Verify Connection - It workedWhen shopping for rates at the sales order document and select a rates, it adds the cost to the document and marks up the cost to add a freight price correctly per the freight terms I have setup. Great.Add cost and price based on rate selected and shipping terms (120% of freight cost)But, we don’t have standard packages for all our products. We do manual packaging. So, our workflow requires us to add packages, dimensions, weights at the shipment document level. No problem, add this at the shipment level instead of sales order level. The issue we are having is that after adding the package details, shopping for rate and selecting a rate it does not update the Freight Cost field. Furthermore, if we manually add the freight cost (not ide

Are you a thought leader in the Acumatica space? If so, submit a session idea for the upcoming September acuCONNECT virtual conference happening September 13-14!  We’re looking for educational content to help your fellow users and partners make the most of their Acumatica system (no sales pitches, please).Submit your idea here:https://acu-connect.com/acuconnect-2024-session-submission/   Please submit by 5/31 for consideration for this year’s big event.

I am encountering a warning message with the following content. Could you please assist us in resolving this issue? PX1076"Warning"This code calls Acumatica internal API marked with PXInternalUseOnlyAttribute which is not intended for public use.  CustomerSchemaDetails details = SalesPersons.Search<CustomerSchemaDetails.sourceField>(SchemaConstants.LocationID);   if (details?.IsActive == false)     {          details.IsActive = true; // am getting warning in this line number          SalesPersons.Cache.Update(details);     }     Thank you in advance.  

 I need to fix acuminator warnings of type PX1072. Here I have a custom graph written in which there’s a static method. Inside this static method, I need to use graph in BQL statements. Since its custom graph with static method, so I cannot use this and Base as well. Initial code is using new PxGraph() as a wrokaround. Below is the screenshot. Also wanted to understand if calling a delegate having update/insert statements at various places inside row selected is good or bad? I am using 2024R1 Preview as my instance.

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, 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.