ET721 Customer Payments
客戶帳款

Contents

00. Overview

做好商業發票, 執行 Shipment Control - Invoice Data Input, 系統會正式將發票資料匯入銷貨資料庫沖銷訂單記錄, 同時產生應收帳款. 本程式除了查詢應收帳款之外, 在客戶付款時, 可輸入付款記錄.

其次, 和客戶若有非出貨產生之金錢交易, 依性質可做 debit notes 或 credit notes. 這類金額也列入客戶帳款處理.

01. Toolbar

	應收帳款, 付款沖帳. 佣金付款作業
	Debit/Credit Notes, Data Entry. Posting to Accounts Receivable.
	Accounts Receivable Payment Details Receivable Statements Invoice Commissions - Invoice-based Listing Invoice Commissions - Itemized Details Debit/Credit Notes.

10. Accounts Payable, Data Maintenance

應收帳款資料由 invoice date input 及 debit/credit note 的 posting 產生, 通常不應改動. 不過假如一定得修正的話, 在這裡做. 即使如此, 在一般情況下, amount, balance, currency 還是不能更改. 若一定要更改這三欄, 須設使用者權限 ET61-ET721-VIEW-Authorize3.

11. Receipts of Customer Payments

客戶付款之記錄. 另有報表, 見第 12 節.

Balance	客戶一筆付款金額. 沖銷須同幣別, 合計金額不得超過付款金額.
Date	沖銷日期, 原則上同客戶付款日期.
Select All	選擇所有幣別和第一筆相同之記錄.
Clear	清除畫面.
Refresh	將已選擇之付款顯示.
List box	可以複選, 唯一次付款只能選擇一種幣別. 點選時付款金額會加總, 但不會顯示在 payment 欄. 按 Refresh 鍵才會顯示各別付款金額.
Partial payment	部份付款時用. 先勾選 partial payment, 再點選應付項目.
Total payment	付款總額.
Payment, return, ...	付款性質.

本節所談之帳款沖銷, 效果和第四節所述完全相同, 但流程用法不同. 未來或許會完全取代.

12. Payment Settlement

Invoice Payment Settlement (應收帳款付款沖帳)

(應付帳款沖銷另有第三節所說明之客戶付款記錄及帳款沖銷, 請先參考再決定取用何者. 我們估計未來本節說明的用法會被取代.)

Customer No.
Get Receivables...	取得前述客戶尚有餘額之應收資料, 最多 500 筆.
Date	客戶付款日期.
Select All	選擇所有幣別和第一筆相同之記錄.
Clear	清除畫面.
Refresh	將已選擇之付款顯示.
List box	可以複選, 唯一次付款只能選擇一種幣別. 點選時付款金額會加總, 但不會顯示在 payment 欄. 按 Refresh 鍵才會顯示各別付款金額.
Partial payment	部份付款時用. 先勾選 partial payment, 再點選應付項目.
Total payment	付款總額.
Payment, return, ...	付款性質.

Commission Payment Settlement (佣金付款沖帳)

Get Invoices...	取得 invoice 及佣金資料.  Invoice amount paid: 貨款已付清者. Has commission to pay: 有應付佣金之 invoices. Commission not paid: 佣金未付清之 invoices.
Quick Key for One Customer	取得單一客戶佣金記錄.
List box	一張 invoice 之佣金須一次付清. 可以複選. Date paid 顯示付款日期 (資料包含已付和未付資料時才有).
Payment date	此次付款日期.
Synchronize commission values	將付款金額記錄到 invcost.dat 檔.

30. Debit/Credit Note, Data Entry

Note No.	Debit note 或 credit note 的號碼. 自動選取的系統編碼為 DRCRNOTE-NO 及 DRCRNOTE-NOx.
Date	Note 日期.
Document	Debit note 或 credit note.
Customer No.
Attention
Staff No.	我方辦事人員.
Sales	我方業務人員.
Company	我方公司.
Item NO....Item name	Note 內之項目. 找到或新增 note 後, 按 Add 增加, 按 Modify 修改. Item Any string, not limited to item numbers. To find an item, use the button to the right. Item name May or may not show on documents. 120 bytes. Description 750 bytes. Image button If a legitimate image file is entered in the image file field, the image will be shown here. Click on this button, you can open the image in a default program window of your system. For non-image files (such as .xls, .doc, etc.), you can also open them by clicking the image button. Image file 128 bytes. File name only, no folder information needed. For non-image file names, no image will show, but you still can open them by clicking the image button. Quantity Not necessarily product quantity, can be something like 1 each etc. Price   Supplier share In case of claims or similar situations, the quantity that is to be shared by product supplier. Internal note Won't be shown on credit/debit notes. 480 bytes.
Total amount	Note 總金額, 可按右側 Calc. Total 紐計算.
Supplier share	廠商承擔的總金額, 由各 note items 之 supplier shares 加總.
Remarks	Debit/credit note 的注意事項.
Remarks II	主要為內部參考用的注意事項.
Key words	資料檢索用.

31. Posting, Debit/Credit Note

Posting 是將 debit/credit notes 金額轉為應收帳款. 在 credit notes 場合, 轉入的金額為負. 進入畫面時, 所有未 post 的 debit/credit notes 資料一齊顯示. 複選後按 OK 做 posting 動作.

40. Accounts Receivable, Viewing & Printing

Retrieve data using	可用 invoice no., invoice date, customer no. + due date,  due date, sales + invoice date 的順序擷取資料.
Data ordered by	可用 invoice no., invoice date, customer no. + invoice no., customer no. + invoice date, customer no. + due date,  due date, sales + invoice date 的順序排列資料.
Filters	應收資料來源有三: invoice, debit note, credit note. 可以選擇組合.
Show only items with balance	只顯示有餘額之應收記錄.
Show subtotals	以 invoice date, customer number 或 due date 排序時, 針對各類別小計.
Show customer prepayments	顯示客戶預付貨款, 同時顯示過期日數. 文件變為橫向列印.

41. Receivable Transactions (應收異動明細)

42. Receivable Statement (對帳單)

45. Invoice Commissions

Invoice-based Listing

Get Invoices...	Invoice amount paid: 只顯示已付款之發票. Has commission to pay: 只顯示有佣金要付之發票. Commission unpaid: 只顯示佣金未付之發票.
Data ordered by	資料列表之順序.
Show subtotals	依列表順序, 同類別記錄加總顯示.

Itemized Details

50. Debit Note & Credit Note

Query...

可以重複 query, 結果會加到一起.

55. Customer Payments

60. Receivable Statements on Excel

The template file used for exporting receivable data to Excel is called ARSTMx.XLT, where x is the company number of the company that issues these receivable statements. Cell A1 of this template should contain the full folder path for storing exported Excel files -- usually q:\torus\et61\excel\. Cell A2 should contain the full folder path that has signature files stored -- usually the data folder, q:\torus\et61\data\. Both folder positions can be modified directly on the template.

Multiple files are generated most of the time. The exported files are named according to sequential numbers controlled by system code ET721-ARSTM-FILE-NO.

For each company, a corresponding template file is needed. For example, for company No. 1, the template file is ARSTM1.XLT; for company No. 3, the template file is ARSTM3.XLT. The contents of templates can be changed to meet actual requirements, but it is imperative that row and column positions not changed. Only contents can be changed. All template files should be placed in the ET6.1 data folder.

98. Upgrades

99. System Codes

Last modified: June 2015