Customer reporting workflow
Planning example. Stacksync support for the required connection and record operations needs a technical review.
Starting event: A change to the selected Proposed customer table in Snowflake (choose its name) or Customers record needs a defined result in the other system.
- Start with Snowflake Proposed customer table in Snowflake (choose its name) and Visibility ERP Customers. Use the record-matching and field-ownership rules from your mapping worksheet.
- Resolve person or company type, legal entity, business role, and any billing account before transactions.
- Test a normal update and one failed or repeated update in the supported direction. Keep both record IDs with the test results.
Expected result: Test an individual buyer, a company buyer, and one company with multiple billing relationships. Do not merge these into a single generic contact.
If it fails: Hold ambiguous customer matches for review and resolve customer type before retrying dependent records.
Supplier bill reporting workflow
Planning example. Stacksync support for the required connection and record operations needs a technical review.
Starting event: A change to the selected Proposed supplier bill table in Snowflake (choose its name) or Bills of Material record needs a defined result in the other system.
- Start with Snowflake Proposed supplier bill table in Snowflake (choose its name) and Visibility ERP Bills of Material. Use the record-matching and field-ownership rules from your mapping worksheet.
- Resolve supplier, expense/account codes, entity, currency, and accounting period before bill lines.
- Test a normal update and one failed or repeated update in the supported direction. Keep both record IDs with the test results.
Expected result: Test a duplicate supplier document number in another entity, a partially paid bill, and a closed period.
If it fails: Verify whether the bill was approved or posted before retrying; use the approved adjustment process for posted bills.
Sales order reporting workflow
Planning example. Stacksync support for the required connection and record operations needs a technical review.
Starting event: A change to the selected Proposed sales order table in Snowflake (choose its name) or Sales Orders record needs a defined result in the other system.
- Start with Snowflake Proposed sales order table in Snowflake (choose its name) and Visibility ERP Sales Orders. Use the record-matching and field-ownership rules from your mapping worksheet.
- Create or locate the customer and products first; resolve taxes, currency, and fulfillment references.
- Test a normal update and one failed or repeated update in the supported direction. Keep both record IDs with the test results.
Expected result: Test a multi-line order, a partial cancellation, and two partial shipments. Compare line totals as well as the header.
If it fails: Check for an existing destination order before retrying a timed-out create; reconcile line IDs to avoid duplicate fulfillment.
Reconcile Visibility ERP business records with Snowflake
This is an evaluation scenario; connector and operation support require confirmation.
Starting event: A finance-owned record in Visibility ERP needs operational visibility through a selected destination dataset.
- Select Customers or Vendors with the correct legal entity, period, and currency.
- Define a reporting relationship in Snowflake; do not equate customer records, ledger accounts, and posted transactions.
- Decide whether the process only reports a financial state or requests an approved accounting action, and maintain a separate transaction ID for each action.
Expected result: Totals reconcile within the same entity/currency/window; a repeated handoff creates no duplicate financial transaction.
If it fails: Verify posting and settlement state before retrying. Use the approved adjustment path for already-posted transactions.