Discussions, Best Practices, and Product Feedback

Recently active
Forums
Help others

Develop Integrations with Web Services | APIs

REST API: retrieving a CustomerPaymentMethod

Does anyone know how to retrieve data in a CustomerPaymentMethod using a CustomerID, PaymentMethod name, Card Account Number, and Value using the REST API in Postman? Here’s what I have so far in my GET method:https://sandbox.com/entity/Default/22.200.001/CustomerPaymentMethod/Customer/C10010473712 I’m not sure what all the parameters are supposed to be so I just get an error using that:{ "message": "An error has occurred.", "exceptionMessage": "No entity satisfies the condition.", "exceptionType": "PX.Api.ContractBased.NoEntitySatisfiesTheConditionException",

1 hour ago

bbdragonflyFreshman I

Financials

Report that has GL activity at transaction Level

Hello,I’m wondering if it’s possible to get a report that has GL activity for the month of April at the transaction level for the purpose of splitting the activity into two sections 4/1-4/25 and 4/26-4/30?It would most likely be trying to open up the Account Details Inquiry to allow for more than one GL account. Open to any other ideas might have to get that data.Thanks.

1 hour ago

pjamesFreshman I

Develop Integrations with Web Services | APIs

authApi.Login() hangs up

Hello everyone,First time poster here. I have used the GitHub “endpoint model generator” solution to generate the DLL’s I need to allow my C# application to connect to our Acumatica instance with our extended endpoint and the RESTAPI dll’s (Acumatica.RESTClient.dll and Acumatica.RESTClient.ContractBasedApi.dll that get compiled along with my endpoint dll.I am using Visual Studio 2022 and C#.I have been unable as of yet to figure out why the authApi.Login() function just locks up the app.This is the content of the request (that was put together by the Acumatica code) as it looks immediately before being passed to the Client.SendAsync(request) call that hangs up. {Method: POST, RequestUri: 'https://<ouracumaticadomain>/AcumaticaERP1//entity/auth/login', Version: 1.1, Content: System.Net.Http.StringContent, Headers:{ Content-Type: application/json; charset=utf-8}} Content: {System.Net.Http.StringContent} HasHeaders: false Headers: {} Method: {POST} Options: {System

2 hours ago

azhangFreshman I

Configuration and Installation

Invoice Notification is sent out twice back to back to customer even activities on customer record says only one time

Hi All,I wonder if anybody is having the same issue. two copies of email sent out:we use the standard out of box notification templates InvoiceNotification (screen name: invoice, screen id: so303000) to send email to customers through “Print Invoices and Memos”(AR508000) manually. Customers receive two copies of the same email back to back. I check the activities on the customer record and all emails, Both places show only one copy sent out. Anybody seen something like this? any ideas where to go to fix it? we are on 2022R1 build 22.118.0022appreciate any help/ideas. Thanks.

2 hours ago

Chris HackettAcumatica Community Manager

Acumatica News & Updates

What you may have missed in the Acumatica Community! April, 2024

Dear Community Member,With so much going on in the Acumatica Community I have consolidated recent activities in case you missed anything.Connect, Learn and Share How to Answer Questions on Acumatica CommunityAcumatica Community relies on a large group of people working together to create a comprehensive Question/Answer/Resource depository. Upcoming May and June 2024 Acumatica User Group MeetupsJoin the S. Texas Acumatica User Group and then RSVP HEREJoin the Pacific Northwest Acumatica User Group and then RSVP HEREJoin the NE Acumatica User Group and then RSVP HEREJoin the Canada East User Group and then RSVP HERE (Montréal) Sam Kabiri - Acumatica Community Featured Member for May 2024Meet Sam Kabiri our Acumatica Community Featured Member for May 2024. It’s great to have you as part of the Acumatica Community @hkabiri! Product update announcementsAcumatica 2023 R2 Update 11 Build 23.211.0017Acumatica 2024 R1 Update 2 Build 24.102.0053Acumatica 2023 R1 Update 17 Build 23.117.0021Acuma

2 hours ago

nicolestantonJr Varsity I

Configuration and Installation

How to Configure Acumatica Payments to Automatically Generate a Payment Link

Hi - we recently switched from Paya to Acumatica Payments/Fortis for our payment processor. With Paya, we could generate payment links automatically when the invoice is released. The team from Acumatica Payments said we could likely set up a business event to do this as well, but I’m not sure what all that would involve. Does anyone have experience setting this up themselves?

3 hours ago

Doug JohnsonAcumatica VP, Product Management

Financials

AP Document Recognition

Benefits of AP Document RecognitionAP Document Recognition streamlines processing of vendor bills that you receive in PDF format. AP Clerks spend less time re-typing data so they can focus on higher value tasks. Worker productivity: spend less time entering documents Accuracy: reduce data entry errors which may result in incorrect vendor payments Approvals: integrate with existing approval and workflow processes AI/ML: extracted data accuracy (vendor ID field) improves after manual correctionWho can use AP Document Recognition?Prior to April 1, 2023 Acumatica offered a promotion for up to 1,000 pages/month for free. After the first year, customers could purchase the feature.Starting April 1, 2023 all new and existing Acumatica subscription customers (does not include perpetual licenses - PCP) get 50 free pages so they can try the feature. Customers who already paid for the service get an additional 50 free pages. A vendor bill with a front and a back counts towards 2 of your 50 monthly

12018

3 hours ago

josbornFreshman I

Distribution

Vendor Lead Time GI

Hello,I am trying to create a GI that shows Vendor ID, Vendor Name, and Lead Time so I can revise it and upload back to Acumatica using a Data Provider/Import Scenario. I cannot find the field for vendor lead time in the GI builder. Anybody know which table to add?

3 hours ago

mrhoades

Reports and Generic Inquires

GI to pull Project info and Inventory Location info after 2023R1 table changes

We had a Project Inventory Location GI we had created in 2022R2 we use heavily. Now that we are upgrading to 2023R2, the GI has to be re-written because of the PMLocationStatus and PMLotSerialStatus tables having been removed in 2023R1. I’ve been trying to get the GI modified using the table references in the Release Notes for 2023R1. I am apparently missing something. I would appreciate help reviewing our original GI (titled Project_Inventory_Location.xml attached here) against the version I am working to modify in our SANDBOX for our upgrade to 2023R2 titled MR_050724_Project Inventory Location.xml attached here. The modified GI is creating duplicate rows. I’ve reviewed the GI and am not seeing the reason for the duplicate rows being returned. Thanks for looking and any help you might offer in advance.

3 hours ago

jvarughese23Freshman II

Import and Export Scenarios

Do Anyone has an Import Scenario to Update Bank Account details to Employee Master File for ACH

Am totally new to Import Scenario , Can anyone help on this

4 hours ago

Discussion Forums

Get inspired and gain all the knowledge you need

Financials

1776 topics
5844 Replies

Distribution

1719 topics
6599 Replies

Manufacturing

603 topics
2273 Replies

Construction

583 topics
1950 Replies

CRM

161 topics
482 Replies

Field Service

284 topics
930 Replies

Retail

454 topics
2007 Replies

Payroll

213 topics
719 Replies

Low Code | No Code Customizations or Integrations

225 topics
814 Replies

Develop Customizations

2398 topics
9686 Replies

Develop Integrations with Web Services | APIs

586 topics
2403 Replies

ISV Solutions

120 topics
494 Replies

Configuration and Installation

762 topics
2786 Replies

Reports and Generic Inquires

1764 topics
6829 Replies

Import and Export Scenarios

683 topics
2795 Replies

System Health and Performance

133 topics
482 Replies

Community site discussions

230 topics
433 Replies

Community Introductions

95 topics
281 Replies

Everything Else

725 topics
2391 Replies

News & Announcements

Acumatica News & Updates

111 topics
164 Replies

Events & Meet-ups

139 topics
85 Replies

Developer Newsletter

19 topics
0 Replies

43 topics
0 Replies

bpgravesFreshman II

Develop Integrations with Web Services | APIs

REST API: retrieving a CustomerPaymentMethod

1 hour ago

pjamesFreshman I

Develop Integrations with Web Services | APIs

authApi.Login() hangs up

2 hours ago

mrhoades

Reports and Generic Inquires

GI to pull Project info and Inventory Location info after 2023R1 table changes

3 hours ago

amitr70Freshman I

A data corruption state has been detected - SoLine.

While creating sales order and adding line items in so line i am encountering this error. Below is the screenshot of the error. I am not able to find out the actual cause of the error. Please help.Details : Name: Aggregate Validation: PX.Objects.SO.SOOrder+orderQty. Below is screenshot.We already upgraded within R2, both 206 and 209 but still issue remains there. Please help how to debug this issue as in my code there’s no exception throwing. Let me know if there’s any specific settings or locations to look out for.

4 hours ago

epanJr Varsity II

Everything Else

Wire Batch payment not able to release

Hi There, I tried t void a wire which went through before the batch payments released. Now I can’t release the wire batch payment due to error “This Batch Payments contains voided documents. You must remove them to be able to release the Batch”Now, the system void payment got posted in Bank Rec but the wire payment still shows balanced. I can’t release the wire payment. Could you please advise how to fix this issue? Thank you.

4 hours ago

wmatthews1877Jr Varsity III

Reports and Generic Inquires

Alpha characters entered into an INT field

Is there a way to “filter” out alphanumeric characters from an INT field? Somehow, our Parent.BAccountID field has aat least four customer numbers, such as AAMISC, C000001, INTMISC, and KCTEST which, when I do a GI linking Parent accounts with Child accounts it continually throws an error message:I’ve tried filtering out the “bad” customer numbers in various ways without any success. For example and I am only using two of the four for now:Any help, if it is possible, would be appreciated. I suspect that these were imported into the system because I didn’t think it was possible to do this as a manual entry.

4 hours ago

jaymarzianJr Varsity III

Import and Export Scenarios

Service Order Import Scenario Generated By a Business Event Issue

Hey Folks,Hoping someone has tried to do this before. I have everything working except that I can’t get the import scenario to work because of “Branch Location”. When you run an Import by Scenario manually, Branch Location gets populated based on the one selected in your profile, but because the import scenario gets run by the triggered business event, it does not pick up any Branch Location. I can’t even tell what Branch the system chooses to post the service order from. So, this is what I need:1, Some way to select a Branch Location from the Import Scenario. Something that can maybe search the field, and return the first value.Here is my import scenario, I tried manually selecting my default BL, but to no avail:

4 hours ago

HarryVarsity III

Construction

New to the community?

Get Started HERE and be sure toIntroduce Yourself

Acumatica User Groups

Educational Resources

Community Library

Blogs

What you may have missed in the Acumatica Community! April, 2024

User leaderboard

Show full leaderboard

Acumatica employee leaderboard

Show full leaderboard

Badge winners

bbdragonflyhas earned the badge Easy talker
kkeating24has earned the badge Easy talker

Show all badges

Acumatica Community

New to the community?

User leaderboard

Acumatica employee leaderboard

Badge winners

Events Calendar

Latest Articles

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded