SAP B1 Service Layer 7 - Inventario

Overview

This node interacts with the SAP Business One Service Layer (version 7) specifically for inventory-related resources. It allows users to perform various operations such as retrieving, creating, updating, canceling, closing, reopening, and deleting inventory documents and entries within SAP B1.

For the Inventory Gen Entrie resource with the Get by Key operation, the node fetches a specific inventory general entry document from SAP B1 by its primary key (DocEntry). This is useful when you need to retrieve detailed information about a particular inventory entry, for example, to verify stock movements or audit inventory transactions.

Practical examples:

• Fetching an inventory general entry to check its status or details before processing further business logic.
• Integrating SAP B1 inventory data into other systems by retrieving specific entries on demand.
• Automating inventory reconciliation workflows by programmatically accessing individual inventory entries.

Properties

The property DocEntry / Key is a string representing the unique identifier of the inventory general entry you want to get.

Output

The output is an array of JSON objects where each object corresponds to one input item processed. For the "Get by Key" operation on Inventory Gen Entrie, the JSON output contains the full details of the requested inventory general entry as returned by the SAP B1 Service Layer API.

Example structure of the output JSON (simplified):

{
  "DocEntry": 123,
  "DocNum": 456,
  "DocDate": "2024-01-01",
  "Comments": "Inventory adjustment",
  "Lines": [
    {
      "ItemCode": "A100",
      "Quantity": 10,
      "WarehouseCode": "WH1"
    }
  ],
  "Status": "Open",
  ...
}

If an error occurs during the request, the output JSON will contain an error field with the error message.

No binary data output is produced by this node.

Dependencies

• Requires connection to a SAP Business One Service Layer API endpoint.
• Needs credentials including base URL, username, password, and company database name.
• The node authenticates by logging in to the SAP B1 Service Layer and manages session cookies internally.
• No additional external dependencies beyond the SAP B1 Service Layer API.

Troubleshooting

• Authentication errors: If login fails, verify that the provided credentials (username, password, company DB) are correct and that the SAP B1 Service Layer endpoint is reachable.
• Invalid DocEntry: If the specified DocEntry does not exist, the API will return an error which will be shown in the output's error field.
• Network issues: Connection timeouts or SSL certificate problems may occur if the SAP B1 server is unreachable or uses self-signed certificates. The node disables strict SSL verification (rejectUnauthorized: false) but network connectivity must still be ensured.
• Operation not supported: Using an unsupported operation or resource combination will result in no action or an error.
• Malformed JSON Body: For operations requiring a JSON body (not applicable for Get by Key), ensure the JSON is valid.

Links and References

• SAP Business One Service Layer Documentation
• SAP B1 Inventory Management Concepts
• n8n Documentation on Creating Custom Nodes

This summary focuses on the "Inventory Gen Entrie" resource and the "Get by Key" operation as requested.