应收账款统计查询表

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

,应收账款统计查询表,,,,,,,应收金额：,,22320,已收金额：,13220,剩余金额：,9100,,,,,

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

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

,,,,,,,,,,,,,往来客户,往来客户1,,,,,

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

,,,,,,,,,,,,,订单数,1,,,,,

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

,,,,,,,,,,,,,应收金额,960.00,,,,,

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

,,,,,,,,,,,,,已收金额,960.00,,,,,

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

,序号,订单日期,,订单号,往来客户,商品名称,规格型号,单位,数量,单价,应收金额,已收金额,剩余金额,备注,,,,,2023年

,1,1,2023/1/1,X100001,往来客户1,商品1,xxx,个,12,80.00,960.00,960.00,0.00,,,,,,

,2,1,2023/2/1,X100002,往来客户2,商品2,xxx,个,8,120.00,960.00,960.00,0.00,,,,月份,订单数,应收金额

,3,0,2023/3/1,X100003,往来客户3,商品3,xxx,个,15,130.00,"1,950.00","1,000.00",950.00,,,,1月,1,960.00

,4,0,2023/4/1,X100004,往来客户4,商品4,xxx,个,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,个,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,个,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,个,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,个,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,个,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,个,6,50.00,300.00,300.00,0.00,,,,8月,1,"1,540.00"

,11,0,2023/11/1,X100011,往来客户11,商品11,xxx,个,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,个,20,90.00,"1,800.00","1,000.00",800.00,,,,10月,1,300.00

,13,0,2023/9/1,X100013,往来客户13,商品13,xxx,个,10,140.00,"1,400.00","1,000.00",400.00,,,,11月,1,"1,600.00"

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