AMIS MISA icon

AMIS MISA

Tích hợp AMIS MISA cho n8n

Actions11

Inventory Report → Get Serial Balance Detail

AI-generated

Summary

Fetches AMIS MISA’s serial balance detail report for a date range, polls while the report is processed by a worker, and returns one n8n item per serial detail row with warehouse, item, voucher, and quantity fields.

Inputs

  • Date Range Preset — Choose This Year (default) or Custom. This Year uses January 1 through December 31 of the current year.
  • From Date — Required for Custom; provide the report start date in YYYY-MM-DD format.
  • To Date — Required for Custom; provide the report end date in MISA’s expected format, such as YYYY-MM-DDT16:59:59.999Z.
  • Session Key (required) — AMIS pSessionKey from DevTools for the same session as the configured cookie.
  • Use ID (required) — AMIS UseID from DevTools for the same session as the configured cookie.
  • Return All — Defaults to true. When disabled, Limit caps the number of report records fetched.
  • Limit — Maximum report records to fetch when Return All is disabled; defaults to 100.
  • Page Size — Records requested per page; defaults to 100.
  • Max Records — Safety cap on fetched report records; defaults to 10,000. With Return All enabled, reaching this cap raises an error.
  • Max Output Items — Safety cap on emitted serial rows; defaults to 50,000. Exceeding it raises an error.
  • Worker Max Attempts — Maximum worker polling attempts per report page; defaults to 10. The operation errors if the report is still processing after these attempts.
  • Worker Poll Interval (Ms) — Delay between worker polls; defaults to 3,000 milliseconds.
  • Request Timeout (Seconds) — Timeout for each AMIS request; defaults to 120 seconds.
  • Advanced Options — Optional AMIS raw filter and sort JSON fields are exposed, but this operation builds fixed report filters and sort values and does not read these options.

Output shape

A list of n8n items, one per serial detail row.

Each item contains MaKho, TenKho, MaHang, TenHang, MaQuyCach (serial number), NgayChungTu, SoChungTu, DienGiai, DVT, SoLuongNhap, SoLuongXuat, SoLuongTon, and DieuChuyenChuaNhapKho. Group nodes are flattened; rows without a serial number and summary rows labeled “Cộng” are omitted. The operation requires the AMIS MISA credential with cookie and origin, in addition to Session Key and Use ID.

Examples

Example 1: Use for serial-level inventory reporting or reconciliation over the current year or a custom date range; each output item represents a serial’s balance detail row.

Set Session Key and Use ID from the same AMIS session as the credential cookie, choose the date range, then connect the emitted row items to downstream processing.

Links

Discussion