應(yīng)收賬款統(tǒng)計(jì)查詢表

,,,,,,,,,,,,,,,,,,,,

,應(yīng)收賬款統(tǒng)計(jì)查詢表,,,,,,,應(yīng)收金額：,,22320,已收金額：,13220,剩余金額：,9100,,,,,

,Accountsreceivablestatisticalinquiry,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,往來客戶,往來客戶1,,,,,

,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,訂單數(shù),1,,,,,

,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,應(yīng)收金額,960.00,,,,,

,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,已收金額,960.00,,,,,

,,,,,,,,,,,,,,,,,,,,

,序號(hào),訂單日期,,訂單號(hào),往來客戶,商品名稱,規(guī)格型號(hào),單位,數(shù)量,單價(jià),應(yīng)收金額,已收金額,剩余金額,備注,,,,,2023年

,1,1,2023/1/1,X100001,往來客戶1,商品1,xxx,個(gè),12,80.00,960.00,960.00,0.00,,,,,,

,2,1,2023/2/1,X100002,往來客戶2,商品2,xxx,個(gè),8,120.00,960.00,960.00,0.00,,,,月份,訂單數(shù),應(yīng)收金額

,3,0,2023/3/1,X100003,往來客戶3,商品3,xxx,個(gè),15,130.00,"1,950.00","1,000.00",950.00,,,,1月,1,960.00

,4,0,2023/4/1,X100004,往來客戶4,商品4,xxx,個(gè),23,100.00,"2,300.00","1,000.00","1,300.00",,,,2月,1,960.00

,5,0,2023/5/1,X100005,往來客戶5,商品5,xxx,個(gè),20,90.00,"1,800.00","1,000.00",800.00,,,,3月,2,"4,110.00"

,6,0,2023/6/1,X100006,往來客戶6,商品6,xxx,個(gè),16,150.00,"2,400.00","1,000.00","1,400.00",,,,4月,1,"2,300.00"

,7,0,2023/7/1,X100007,往來客戶7,商品7,xxx,個(gè),17,110.00,"1,870.00","1,000.00",870.00,,,,5月,1,"1,800.00"

,8,0,2023/8/1,X100008,往來客戶8,商品8,xxx,個(gè),22,70.00,"1,540.00","1,000.00",540.00,,,,6月,1,"2,400.00"

,9,0,2023/9/1,X100009,往來客戶9,商品9,xxx,個(gè),8,160.00,"1,280.00","1,000.00",280.00,,,,7月,1,"1,870.00"

,10,1,2023/10/1,X100010,往來客戶10,商品10,xxx,個(gè),6,50.00,300.00,300.00,0.00,,,,8月,1,"1,540.00"

,11,0,2023/11/1,X100011,往來客戶11,商品11,xxx,個(gè),16,100.00,"1,600.00","1,000.00",600.00,,,,9月,2,"2,680.00"

,12,0,2023/12/1,X100012,往來客戶12,商品12,xxx,個(gè),20,90.00,"1,800.00","1,000.00",800.00,,,,10月,1,300.00

,13,0,2023/9/1,X100013,往來客戶13,商品13,xxx,個(gè),10,140.00,"1,400.00","1,000.00",400.00,,,,11月,1,"1,600.00"

,14,0,2023/3/1,X100