能否通过Contract-based APIs从Acumatica提取供应商ACH信息？

Absolutely! You can definitely pull vendor ACH details—including their Account Number and Routing Number—using Acumatica's Contract-Based APIs. Here's a practical breakdown of how to make this work:

1. Target the Correct Entities & Endpoints #

Vendor ACH information is tied to their payment methods, so you’ll work primarily with the Vendor entity and expand its related PaymentMethods collection. In most Acumatica instances, ACH-specific fields live under the ACHDetails sub-entity of VendorPaymentMethod.

To confirm the exact structure for your instance, check the API metadata (e.g., run a GET request to /entity/Default/20.200.001/$metadata—replace the version number with your Acumatica version) to map out the full entity hierarchy.

2. Key Fields to Retrieve #

• Routing Number: Look for the RoutingNumber field within the ACHDetails section of a vendor's payment method.
• Account Number: The AccountNumber field in the same ACHDetails section will hold the vendor's ACH account number.

Note: If your instance has customizations, field names might include a Usr prefix (e.g., UsrCustomRoutingNumber)—double-check the metadata for these custom fields.

3. Sample API Request #

Here’s an example GET request to fetch ACH details for a specific vendor:

GET /entity/Default/20.200.001/Vendor
?$select=VendorID,PaymentMethods/PaymentMethodID,PaymentMethods/ACHDetails/RoutingNumber,PaymentMethods/ACHDetails/AccountNumber
&$expand=PaymentMethods($expand=ACHDetails)
&$filter=VendorID eq 'V00001'

This request filters for a specific vendor ID, expands their payment methods, and pulls the ACH routing and account numbers directly.

4. Permissions Check #

Don’t overlook this: The API user account needs proper permissions to access vendor payment information. Assign roles that include access to the Vendor Maintenance screen and payment method details—otherwise you’ll run into permission errors or receive incomplete data.

5. Handle Customizations #

If your Acumatica instance has custom fields for ACH data (like additional verification numbers), include those in your $select parameter using their full custom field names (e.g., PaymentMethods/ACHDetails/UsrACHVerificationCode).

内容的提问来源于stack exchange，提问作者Manny Siddiqui