ISV Solutions

Deleting Details from Expense Claims and Journal Transactions

Hi all,Via the Rest API, is there a standard way to delete just the line items on Journal Transactions or Expense Claims? If you pass in an item in the Details param, it will add to the Details which makes sense. I’d like to avoid completely deleting the old transaction / claim then making a new one. Thanks for your help!

754

ryanmiterFreshman I

Pushing Journal Transaction via API

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 wi

1734

nathantrauschtSemi-Pro II

EasyPost - Configuration - Does not Add Freight Cost to Shipment

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 worked

46115

Call out for acuConnect 2024 speakers

louisagooding69Acumatica Sr Business Development Manager

posted in ISV Solutions

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:

380

sruthic25Freshman I

How to fix Acuminator warning PX1076

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.

1763

amitr70Semi-Pro I

Fixing acuminator PX1072 warning inside static methods

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.

1222

IvanVarsity I

Receipt Line PR574695 - 1 not found.

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

1006

Is there any integration between Acumatica & HeavyJob and/or HeavyBid?

aaghaeiCaptain II

posted in ISV Solutions

Hello All, Is there any integration between Acumatica & HeavyJob and/or HeavyBid? Or has anyone done something about it?I had a look at HCSS website and apparently they integrate with all ERPs but Acumatica.

45410

IvanVarsity I

Acumatica Web Service Endpoint version for 2024R1

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

2042

IvanVarsity I

GET request for retrieving Purchase Receipts

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

1418

IvanVarsity I

How to Add 'Orders' table for Checks and Payments entity in Endpoint

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

662

IvanVarsity I

Receipt Line not found Error

962

IvanVarsity I

Official Acumatica Documentation, permission topic

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

2723

JSager76Jr Varsity III

What is the specific purpose of the tax agency for the Vertex integration

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.

1211

IvanVarsity I

The given key was not present in the dictionary Error

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

6385

hsarjapurVarsity I

AWS S3 integration

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

112814

jcox43Freshman II

ISV timeline to support latest Acumatica revision

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

1536

IvanVarsity I

Can't publish any version of customization project

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

1151

kgawryluk80Freshman II

Use Project Transactions to transfer Inventory Stock Directing to a Project

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.

12197

zbaird52Freshman I

Acumatica CPQ Integrations

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?

8238

IvanVarsity I

Acumatica Web Service Endpoint version for 2023R2

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 ?

3594

asmith50Jr Varsity III

Anyone else having issues with the Acumatica to Outlook integration?

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?

5312

IvanVarsity I

The file exceeds the maximum allowed size (25000 KB) Error during attachment upload

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 ?

6392

IvanVarsity I

How to pass 'Owner' field value into Bill

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

25516

Could not set value for field named "Owner" in Bill entity at 'Financial' tab

IvanVarsity I

posted in ISV Solutions

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" }, "Ve

1255