SAP B1 Service Layer 6 - Gestion Bancos

Overview

This node integrates with the SAP B1 Service Layer 6 specifically for managing bank-related operations, including external reconciliation processes. It allows users to perform various actions such as creating, updating, retrieving, and deleting bank pages, incoming payments, vendor payments, and handling external reconciliations.

For the External Reconciliation Reconcile resource with the Reconcile operation, the node sends a request to reconcile an external reconciliation record in SAP B1. This is useful in financial workflows where external payment or bank reconciliation data needs to be matched and confirmed within SAP B1.

Practical example:
A finance team receives reconciliation data from an external banking system and wants to update SAP B1 to mark those transactions as reconciled. Using this node, they can send the reconciliation details directly to SAP B1, automating the process and reducing manual errors.

Properties

Note: The JSON Body property is shown only for certain operations including err_reconcile (the Reconcile operation for External Reconciliation).

Output

The node outputs an array of JSON objects corresponding to each input item processed. Each output item contains:

• json: The response from the SAP B1 Service Layer API call.
  • For successful reconciliation, this will typically include confirmation details or the updated reconciliation status.
  • In case of errors, it returns an object with an error field describing the issue.

No binary data output is produced by this node.

Dependencies

• Requires connection to an SAP B1 Service Layer instance.
• Needs credentials including:
  • Base URL of the SAP B1 Service Layer API.
  • Username and password for authentication.
  • Company database identifier.
• The node authenticates by sending a login POST request to /Login endpoint and uses returned session cookies for subsequent requests.
• No additional environment variables are required beyond the credential setup.

Troubleshooting

• Authentication failures: If login fails, check that the base URL, username, password, and company DB are correct and that the SAP B1 Service Layer is accessible.
• Invalid JSON Body: Ensure the JSON body provided matches the expected schema for the reconciliation operation; malformed or incomplete data may cause errors.
• Network issues: The node disables SSL certificate verification (rejectUnauthorized: false), but network connectivity problems or firewall restrictions could still block requests.
• Error responses: The node captures error messages from the API and returns them in the output under the error key. Review these messages to identify issues like missing permissions or invalid document keys.

Links and References

• SAP Business One Service Layer Documentation
• SAP B1 External Reconciliation Concepts (general reference)

Note: These links provide general guidance on SAP B1 Service Layer and reconciliation features; specific API details may require consulting your SAP B1 version documentation.