��—�ܹ�

��ҳ��Ҫ��Ϊϣ��ϵͳ��ű��Ĺ��ܵ��з��߶�׼��ġ�

��۶��

��۶��ķ��µĽű��

SelectOrderItems.php

�˽ű��Ϊ��ѡ��˿ͼ��Ʒ�Ĺ��ܡ�

�˶��Ĵ��߼��Χ��һ��Items�Ĺ��ﳵ��Ϊһ��Ự��һ��LineItem��ɵ��飬ÿ��е��Ʒ��˶��е��Ϣ-��ϣ��ǿ�Ԥ��ģ�Items�Ự��Ҳ��̧ͷ��磺�˿ͣ��ң��͵ȵȡ��Ŷ��ݴ浽�˻Ự��С��ڴ��е��۶��ֻ��û��ȷ��ύ�˸��ĲŻ��ݿ⡣��ɽű�DeliveryDetails.php��ɵġ�

�ű�SelectOrderItems.php��ڴ��ڵĶ��޸ģ�ֻҪ��ݿ��ȡ��ݣ��Items�Ự��ƷLineItems��鼴�ɡ��Ҫ��ȷ��ı��Ǻ��ġ�

�ű�ʹ��ַ��Ʒ�ӵ��У�

1.ѡ��ࣨ��飩��ߴ��һ��֡��û��ѯ��ť��ʼһ��ϵͳ��ʾ��Ʒ�Թ�ѡ��

2.ͨ��ֱ��벿Ʒ��û��Ϥ�˿��Ʒ��룬��Ѹ��۶��û��밴ť�Խ��ҳ��롣

��

�˽ű��ݹ˿͵Ļ��Һ��Ͳ�ѯ��ۡ��ͼ��Ӧ�ļ۸��û��ö�Ӧ�˿͵��ͺͻ��ң��Ǿ�û��Ʒ��Լӵ��

��װ��Ʒ-��Щ�ڿ��Ʒ��õĽ׶ξͶ��-��Ǳ��ֳɶ�Ӧ�Ĳ�Ʒ��ֱ�ӿ��ڶ��޸ġ��һ��ݼ��ѡ��ÿ��Ĳ�Ʒ��ֻ��һ��Ʒ��˸��ʱ��磬һ̨��xyz��壬��䣬��̣��꣬256M�ڴ�ȵȡ��װ��Ʒ��Щ��붩��ɾ��256M�ڴ棬��ʹ��512M�ڴ�ȡ��Ҫ��ĸ��ġ�

��װ��ƷҲ��룬��²�Ĳ�Ʒ��װ��Ƽۡ��붩��ʱ��װ��Ʒ��װ��ֽ��Ĳ�Ʒ��ڶ��۷��¼�У��ǲ��ά��ݣ��ܻ��¼�仯��Լ��Ʒ�ı仯��

��

ѡ��˹˿ͺͶ��ÿ�е��Ʒ��Ҫ��븶�˵�ϸ�ڡ��logicworks.ini��룬�˷��Ǳ��ġ��һ��ѡ���ܼ�ֵ��ָ��ֵʱ��˷ѡ��˷Ѽ��ǻ��ڲ�ͬ�ĳ��̣�ָ��Ŀ��ص��Ҫ�˵ֵĳ��ж��ġ��ڸ��˵�ַ�ĵڶ��л��ߵ��Ҳ��У��ű��ᱨ��ϵͳ��м��̣��ô��ѡ��ݶ��˷ѵĹ�Ӧ�̡��˷Ѽ��һ��ļ�FreightCalc.php�е�һ��Ҫ��صĲ��˵�ַ��ص㣬��һ��飬��ѳ��BestShipper��˷�FreightCost.�ļ�FreightCalc��ű�DeliveryDetails.php�ű��ʹ��Ļ��Ҫ��ά��׼��kgs��Լ��˷ѹ�ģ��

��ʹ��Ҫ�ɼ��ݲ�ʤ��ɣ��logicworks.ini�йر��˷�ѡ���Ŀǰ��ϵͳ�У��˷�ѡ�

һ��ϸ�ڶ��뵽DeliveryDetails.php�ű��ô��Ϳ��ύ��ݿ��ˡ��ʱ��ȫ��Items�Ự��ֻ�ж��˻��߱��ύʱ��session��ű��ݿⱻ��¡�

��۶��

ʹ�ýű�SelectSalesOrders.php��Բ��Ҷ��

�˽ű��ʹ��ü��ַ��һ��δ��ɶ��

1.��ݹ˿�-��SelectCustomer.php�ű��ѡ��һ��˿ͣ��ʾ�˹˿͵�δ��ɶ��

2.��Ʒ-ѡ��Ʒ��ɵ��ű��ȥ��SelectProduct��ֵܷ�һ��Ľű��Ҿ��ַ��ڹ˿Ͷ��Ը��ֱ�ۡ�

3.��ֱ��붩��š�

SelectSalesOrders.php ѡ��۶��ű�

�ڷ��صĶ��Զ��޸Ļ��߿��Ʊ��

�˽ű�Ҳ�ṩ�Զ��е��޸�......SelectOrderItems.php,��в��Ʒ�Ѿ��Ʊ��ܽ��е��õ��ѿ��Ʊ��Ҳ�޷�ɾ��Ѿ��Ʊ�Ķ��С�

��Ʊ

��Ʊ��ѡ��Ҫ��Ʊ��д�붩��Ȼ�󶩵��Կ��Ʊ��

��Ʊ��SelectOutstandingOrders.php�ű��ʾ�˻�û�п��Ʊ��ж��С��л��û�ȥ�ı�Ҫ��Ʊ��޷��ı�۸��ۿۡ��Ҳ�ṩ��ֶ��˷Ѻ�˰�յ�ѡ��

�ű�ConfirmDispatch_Invoice.phpʵ��ڴ��Ʊ�Ĺ��У��ݿ��ﴴ��DebtorTrans��¼��SalesAnalysis��¼�Ϳ��ƶ��¼��˲ֿ�Ŀ��¼��۶��ϸ�ڡ�

Ҫ�鿴һ��ɶ��ϸ�ڣ�ʹ��ű��SelectCompletedOrder.php ��ṩ��δ��۶��ƵĹ��ߡ��ҳ��Ҳ��ʾ��Ѿ��ҿ��Ʊ��

SelectCompletedOrder.php ѡ��ɵĶ��ű�
�ṩ��δ��۶��Ƶ�ѡ�񹤾ߡ��ҳ��Ҳ��ʾ��Ѿ��Ʊ
�͸��˵��

Ӧ��˻�/�ͻ��˻�

�˿��˻��¼��ֹ�˾��¼��¼��ã��н��Ҫһ��ֹ�˾��¼��Ʊ�ͺ��ַ�Ʊ��ǲ��տ�Ҫ��ֹ�˾��¼��˻����ǰ��¼��棬��˴ӽ��ۻ��δ��Ľ���Ʊ(SysTyeps_TypeID=10)�ȷ��ü�¼��DebtorTrans��м�¼Ϊ��ַ�Ʊ(SysTypes_TypeID=11)�Լ��տ�(SysTypes_TypeID=12)��¼Ϊ��

Ӧ��˿��տ�

��кܶ�ԭ��ֽ��ͨ��Ϊ��Ʊ���տ��Ŀ��յ��˿͸���ܽ��Ҫ��к˶ԡ��տ�ĺ��һ��տ��ȫ��֮ǰ��տ�ű��һ��տ��Ϣ��Ӧ�յ��ӱ��ã��ݿ��±��ļ�¼��¼�տ��ʱ仯��

Ӧ��ʺ��䣩

ϵͳ��ƣ��˺��ֻ��ѡ��տ��ߺ��ַ�Ʊ�Լ��еĴ��ķ�Ʊ��Ա��뵽��Ӧ�ķ�Ʊֱ��տ��ߺ��ַ�Ʊ��䡣��ѡ��Ľ��¼��㣬��뵽��ط�Ʊ�Ĳ��֡�

ע�⣬��û��ʹ��java��߿ͻ��˵Ľű��޷��̬��ж��Ҫȥ��䡣
��ű��ͨ��з�ʽ��ã�

1)��û�в��£��᷵��䵽��Ʊ��տ�ͺ��ַ�Ʊ��

2)�˿ʹ��--��д˹˿͵��δ��ȫ��ĺ��ַ�Ʊ��տ��ʾ��

3)��(11��12)�Լ��״��룬�⽫��ʾ��׼��ǰ��Ĳ��ּ��Ʊ�Լ��δ��ķ�Ʊ��Ѿ��ڵ��ģ��ҿ��Խ��µ��㡣

Sales Analysis ��۷��

��еķ�Ʊ�ͺ��ַ�Ʊ��߸��۷��¼��۷��¼��档ͨ��ά��һ��ֿ��۷��һЩ�ظ��ݡ��˳��߼��ڣ�

��Ҫ��۷��ʱ��Ҫ��ѯ�ļ򻯳̶ȣ��ṩ��ٶ�
��۷��ͨ�ֶν��Խ�һ��ṩ��۷��ѯ�ı��
��ݱ�֮��仯��ɾ��⽫��۷��⡣

��۷��Ա��Ϊ��Ĳ�ķ��ࡣ��򵥣��ṩ�˼��ԡ��ƿ��Ա��Ժ�ʹ�á��б��pdf�ļ��ֱ�Ӵ�ӡ��߱��ڱ��Թ��ʻ��ߴ浵��һ��ѡ��ǿ��б��.csv�ļ��ӱ��ߵ��ݿ��Borand's Paradox��Microsoft Access.

��Ķ��ʾ�ڼ䷶Χ�Լ��ʾ��Ϣ��GP��ë��, �ɱ��ֵ��ڼ��¶ȣ��ϵͳά��û��ɼ��ڼ��ʱ��۷��ҳ��ô˱��Ĳ�ѯҳ��Ժ��׵�ָ��Ҫ��ڡ�

Purchase Orders �ɹ��

�ɹ��к��۶��Ƶ�ѡ�񹤾ߣ��ʹ�õĽű�� POSelectOrders.php
�˽ű��ʾ��е�δ��ɶ��Ѹ��˵�δ�յ��ģ����ѡ��ָ��Ĺ�Ӧ�̻��߲�Ʒ��Խ��ʾ��ѡ��Ĳɹ��

�˽ű�Ҳ��ʾ��ӵ��

1. ��ĳ��޶��ڣ��粻�ܽ��е��ٵ��Ѿ��ջ��Ķ��
2. ��ӡ�ɹ��˲ɹ��Ѿ��ӡ��Ϊ��á��Ա��´�ӡ��EMP��ʾһ��ʾ�˶��Ѿ��ӡ��˲��ظ��ӡ��ظ��Ӧ�̵��⡣
3. ��ջ��

Inventory ��

ÿ�β�Ʒ��Ʊ��ߺ��ַ�Ʊ��EMP��ݿ��Ʒ��ഴ��仯��Ʒ��ϣ��ַ�Ʊ��ע��𻵣��ô�ᴴ��ֿ��仯��
1. ��Ʒ�˻ؿ�棬Ȼ��¼�Թ˿͵�Ƿ�
2. ��ѡ��˻��ע��Ʒ��ϣ�

��յ�һ��ɹ��Ʒʱ��Ҳ�ᴴ��仯��
ÿ�ο��仯��ʱ��Ĳֿ�Ŀ��¡�
��ȫ��ۺͲɹ��ϡ��漰ֱ��Ŀ�潻��ǣ�
1. �ֿ��Ŀ��ת��
2. ��

��͵Ľ��޷��⣬��װ��װ�ϣ��Ϊ�⼸�ֲ�Ʒû�п��仯��߿��ڡ�

Stock Inquiries ��ѯ

ѡ��һ��Ʒ��ʾ��п��ԶԴ˲�Ʒ��ѡ�
l �ֿ��Ŀ��
l ��״̬��ʾ��ϵ��ٶ��
l ��ڷ�Χ�Ŀ��仯
l δ��ɵ��۶��

��еĲ�ѯ��ѭһ��Ƶĸ�ʽ��Ǿ��Ϥ��û�ֱ��롣��һ��ѡ��ǣ��ѯ�ű��Դ�SelectProduct.php�ű��ã��еĹ��߿��ѡ��Ҫ�Ĳ�Ʒ��

Accounts Payable Ӧ��˿�

ʹ�ýű�SuppInvoice.php��빩Ӧ�̷�Ʊ.
�˽ű��SelectSupplier.phpҳ��ʹ��SupplierID��á�һ��һ��Ӧ�̱��ݸ��ҳ�棬EMP�ᴴ��һ��µ�SuppTrans��棨��棩��ڴ˷�Ʊ��Ϣ��SuppTrans��飬һ��˷��һ��ã��紬�˷ѣ�װж��Լ��˰��յ��Ļ����Ʊ��GRN,��ЩҲ��Ʒ��

��ڹ�˾��GL��ӣ��ϣ��Ӧ��Ϊ��á��˽ű��GLCodes��ĳ�Ա��ҳ��ϤGLCode��û�ֱ��GLCode��ߴ�ѡ��ѡ��һ��롣��д��ռ乩��дժҪ��

�ӽű�SupplierInvoice.php��ű�SuppInvGRNItems.php��ѡ��Ѵӹ�Ӧ��յ��δ��Ʊ�Ļ��Ʊ��ÿ��Ʒ��ʾ��յ��Ѿ��Ʊ��Ʊ��Ĭ��Ϊ�Ѿ��յ��ȥ�κ��Ѿ��Ʊ��Ա��Ըı�۸�һ��logicworks.ini��Ӱ��˽ű��Ϊ��˼�鳬��Ĳ��ô��˶��Ʊ�ı��ؿ��Ʊ��շѼ۸�

��Ʊ��յ��б��ۼӡ��GL��Ӧ�̵��Ϊ��ã��ô��к��б��ۼ��ô�Ʊ��ܵĻ��ҽ���û��ã��˻��ҽ��뱻�ֶ��룬��ǽ��Ʊ��յ��Ļ��ࡣ

Ӧ�ô˹�Ӧ�̶��󣬹�Ӧ�̷�Ʊ�ĵ��Ĭ��Ϊ��Ʊ��ڡ��һ��ѡ��ֱ�ӴӴ��Ʊ����ĸ��¼��ǵ��Ʊ��ܺ͡�

Supplier Payments ��Ӧ�̸��

ʹ��ֶ��ʹ��ִ�и��ַ��֮һ��Դ��е��ڵĽ��ļ�¼��

ִ�и��Ϊ�ѵ�ָ��ڣ��ָ��ң�ָ��Լ�ָ��˻��Ҫ�ķ�Ʊ��¼Ҳ�ɴ˹��̲��ִ�и��ÿ��Ѿ��Ʊ�Ļ��ʲ��첢�Ҹ��´˷�Ʊ�ķ����Ӧ��Ϊ��Ļ��˽��ס��ж��;��и��¼Ҳ��

��ͨ��ѡ��Ӧ��Ȼ��ֶ��ֶ��빩Ӧ�̸����Ӧ�̵Ļ��Ϊ�Զ�ʹ��Ĭ�ϻ��ҡ�Ȼ��ʱ��뱻��룬һ��Ļ��н��κ�ժҪ��

�ֶ��ڲ��SupplierID��ʱҲ��˷��ĸ��