> For the complete documentation index, see [llms.txt](https://docs.a1erp.digiwin.com/a1usermanual/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.a1erp.digiwin.com/a1usermanual/70-guan-li-bao-biao/0000-jin-xiao-cun-bao-biao/0345-shang-pin-pi-hao-zhui-zong-biao.md).

# 9.1.14 商品批號追蹤表

依商品及批號追蹤進出貨異動資料

從進銷存報表進入【商品批號追蹤表】

![](https://857350244-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHvK0-xSa7vRWJ_%2F-LJq5alDksAOu5GCurAp%2F-LJq84RpWpZwZrXBm1Ae%2FA08-001.png?alt=media\&token=9aa36a16-281b-4080-a0ed-1c4c7c9701e1)

## 一、查詢內容

一定要輸入【品號】及【批號】二個資料，才可查詢資料

![](https://857350244-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHvK0-xSa7vRWJ_%2F-LJq5alDksAOu5GCurAp%2F-LJqCXmPYHs2gRXakDLl%2FA08-002.png?alt=media\&token=8bbb45df-19c0-4bb1-9331-9da05491692c)

\
可查詢該商品在那項批號的進貨及銷貨等異動情況

![](https://857350244-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHvK0-xSa7vRWJ_%2F-LJq5alDksAOu5GCurAp%2F-LJqCrujgqSep9TZV2rF%2FA08-003.png?alt=media\&token=60804459-15bf-4027-8c77-f1cbeecc5d56)

## 二、報表樣式

### 1、列印樣式

![](https://857350244-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHvK0-xSa7vRWJ_%2F-LJq5alDksAOu5GCurAp%2F-LJqDJRjKDi7lhn7boQs%2FA08-004.png?alt=media\&token=ef409c22-c817-4546-a2ec-dbae44c87c39)

### 2、轉出樣式

#### 一種是【轉出查詢資料】，另一種是【轉出報表格式】

> 【轉出報表格式】：將【列印】功能看到的內容，轉為excel報表格式

![](https://857350244-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHvK0-xSa7vRWJ_%2F-LJq5alDksAOu5GCurAp%2F-LJqECP3YBJrEhslk5td%2FA08-006.png?alt=media\&token=34477d20-ebc4-4d90-aa56-16adeeb0d467)

> 【轉出報表格式】：將【查詢】功能看到的內容，轉為excel報表格式

![](https://857350244-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LIKjbHvK0-xSa7vRWJ_%2F-LJq5alDksAOu5GCurAp%2F-LJqDwK_ypAF9B2yCka3%2FA08-005.png?alt=media\&token=1847402b-fa31-4acd-835f-a5c697e10bea)