Product catalog
Shared local catalogue for Sales Orders, Transfers and Document Extraction matching. Each enabled module keeps its own SAP eligibility rule.
Synced stock may be stale. Transfer confirmation still rechecks live SAP.
This safe additional restriction is applied to every enabled module. Sales Orders use SalesItem, Transfers use InventoryItem, and Document Extraction uses PurchaseItem. Raw SQL and unrestricted OData are not accepted.
Supported filter fields, operators and examples
Built-in fields: Loading...
Selected Product Search UDFs: Loading...
Operators: eq, ne, gt, ge, lt, le, combined with and, or, and not (...).
Strings use single quotes. Escape an apostrophe by doubling it. Valid and Frozen accept only exact 'tYES' or 'tNO'. Item Group and Manufacturer require integer values. Module eligibility fields are controlled by B1Chat and cannot be entered here.
Examples
ItemsGroupCode eq 100 Manufacturer eq 5 and Valid eq 'tYES' (ItemsGroupCode eq 100 or ItemsGroupCode eq 200) and Frozen ne 'tYES' ItemName eq 'O''Brien' U_Web eq 'Y' (only if U_Web is selected in Chat & AI Settings -> Product Search UDFs)
Not supported: raw $filter=, SQL, contains/startswith/endswith, in, property paths, arithmetic, or administrator predicates for SalesItem/InventoryItem/PurchaseItem.
Product catalog sync
Full sync uses parallel SAP Service Layer sessions/ranges and removes stale products only after the effective-filter count guard passes. Changing the effective filter requires a guarded Full sync; Delta is automatically promoted to Full until it succeeds.