SAP B1 Service Layer 6 - Gestion Bancos icon

SAP B1 Service Layer 6 - Gestion Bancos

Interact with SAP B1 Service Layer 6 - Gestion Bancos

Actions19

Overview

This node interacts with the SAP Business One Service Layer specifically for managing incoming payments and related banking operations. The "Cancel by Current System Date" operation for the Incoming Payment resource allows users to cancel an existing incoming payment based on the current system date in SAP B1.

Typical use cases include:

  • Automatically cancelling incoming payments that are no longer valid or were created erroneously, using the system's current date as a reference.
  • Integrating SAP B1 payment cancellation workflows into automated processes within n8n.
  • Managing financial records by programmatically controlling payment statuses without manual intervention.

For example, a finance team could set up an automation that cancels incoming payments daily if certain conditions are met, ensuring data consistency and reducing manual workload.

Properties

Name Meaning
DocEntry Identifier of the document (incoming payment) to be cancelled by the current system date.

Output

The node outputs JSON data representing the response from the SAP B1 Service Layer after attempting the cancellation. This typically includes confirmation of the cancellation or error details if the operation failed.

The output structure is:

{
  "json": {
    // Response object from SAP B1 API, varies depending on success or failure
  },
  "pairedItem": {
    "item": <index_of_input_item>
  }
}

No binary data output is produced by this node.

Dependencies

  • Requires connection credentials to the SAP Business One Service Layer API, including:
    • Base URL of the SAP B1 Service Layer.
    • Username and password for authentication.
    • Company database name.
  • The node performs a login request to obtain session cookies used for subsequent API calls.
  • The environment must allow HTTPS requests to the SAP B1 Service Layer endpoint.
  • Proper permissions in SAP B1 are required to perform payment cancellations.

Troubleshooting

  • Authentication errors: If login fails, verify the SAP B1 credentials and company database name are correct.
  • Permission denied: Ensure the user has rights to cancel incoming payments.
  • Invalid DocEntry: If the provided document identifier does not exist or is incorrect, the API will return an error.
  • Network issues: Check connectivity to the SAP B1 Service Layer endpoint and SSL certificate validity.
  • Unexpected API responses: Review the JSON body sent (if applicable) and ensure it matches SAP B1 API expectations.

Common error messages may include:

  • Authentication failure messages indicating invalid username/password.
  • Not found errors if the DocEntry does not correspond to any existing payment.
  • Permission denied errors if the user lacks cancellation rights.

Resolving these usually involves verifying credentials, input parameters, and SAP B1 user permissions.

Links and References

Discussion