http://www.abiscorp.com/faq/index.php?action=history&feed=atom&title=Sales_Order_Report Sales Order Report - Revision history 2026-04-28T11:14:06Z Revision history for this page on the wiki MediaWiki 1.31.0 http://www.abiscorp.com/faq/index.php?title=Sales_Order_Report&diff=5046&oldid=prev Amohammad: Created page with "__NOTOC__ ==Default Menu Location== Reports >> Order Entry >> Sales Order Report ==General Description== Sales Order Report screen generates information on an open sales..." 2024-04-30T18:16:40Z <p>Created page with &quot;__NOTOC__ ==Default Menu Location== Reports &gt;&gt; Order Entry &gt;&gt; Sales Order Report ==General Description== Sales Order Report screen generates information on an open sales...&quot;</p> <p><b>New page</b></p><div>__NOTOC__<br /> <br /> <br /> ==Default Menu Location==<br /> <br /> Reports &gt;&gt; Order Entry &gt;&gt; Sales Order Report<br /> <br /> ==General Description==<br /> <br /> Sales Order Report screen generates information on an open sales order.<br /> <br /> [[File:Sales_Order_Report.png]]<br /> <br /> ==Fields/Filters==<br /> <br /> &#039;&#039;&#039;Date Range:&#039;&#039;&#039; Time frame for the report<br /> <br /> &#039;&#039;&#039;Customer:&#039;&#039;&#039; Customer code<br /> <br /> &#039;&#039;&#039;Item:&#039;&#039;&#039; Item code<br /> <br /> &#039;&#039;&#039;SO Type:&#039;&#039;&#039; Sales Order Type<br /> <br /> &#039;&#039;&#039;Sales Person:&#039;&#039;&#039; Sales Person for the report<br /> <br /> &#039;&#039;&#039;Account Manager:&#039;&#039;&#039; Account manager for the report<br /> <br /> &#039;&#039;&#039;Warehouse:&#039;&#039;&#039; Warehouse location<br /> <br /> &#039;&#039;&#039;Sort By:&#039;&#039;&#039; Report preference<br /> <br /> &#039;&#039;&#039;Report Style:&#039;&#039;&#039; Report preference<br /> <br /> &#039;&#039;&#039;Status:&#039;&#039;&#039; Report status<br /> <br /> &#039;&#039;&#039;BOL status:&#039;&#039;&#039; Bill of Lading status<br /> <br /> ==Standard Report Fields(Page Header)==<br /> <br /> &#039;&#039;&#039;Company&#039;&#039;&#039;<br /> <br /> * lc_company<br /> <br /> &#039;&#039;&#039;Date Range&#039;&#039;&#039;<br /> <br /> * &#039; As of &#039; + dtoc(date())<br /> * &#039;( &#039; + lc_para + &#039; )&#039;<br /> <br /> ===Group Header===<br /> <br /> &#039;&#039;&#039;Customer&#039;&#039;&#039;<br /> <br /> * alltrim(company) + &#039; ( &#039; + alltrim(custno) + &#039; )&#039;<br /> <br /> <br /> ==Standard Report Fields(Line Items)==<br /> <br /> &#039;&#039;&#039;Order Date&#039;&#039;&#039;<br /> <br /> * iif(isnull(sodate),&quot;&quot;,sodate)<br /> <br /> &#039;&#039;&#039;Order Number&#039;&#039;&#039;<br /> <br /> * sono<br /> <br /> &#039;&#039;&#039;S/P&#039;&#039;&#039;<br /> <br /> * sp<br /> <br /> &#039;&#039;&#039;Load Date&#039;&#039;&#039;<br /> <br /> * iif(isnull(estdateh),&quot;&quot;,estdateh)<br /> <br /> &#039;&#039;&#039;Order Value&#039;&#039;&#039;<br /> <br /> * qtyord * price<br /> <br /> &#039;&#039;&#039;Ship Value&#039;&#039;&#039;<br /> <br /> * qtyshp * price<br /> <br /> &#039;&#039;&#039;Open Value&#039;&#039;&#039;<br /> <br /> * (qtyord-qtyshp) * price<br /> <br /> <br /> ===Group Footer===<br /> <br /> &#039;&#039;&#039;Total&#039;&#039;&#039;<br /> <br /> * qtyord * price<br /> * qtyshp * price<br /> * (qtyord-qtyshp) * price<br /> <br /> <br /> ==Summary==<br /> <br /> &#039;&#039;&#039;Report Total&#039;&#039;&#039;<br /> <br /> * qtyord * price<br /> * qtyshp * price<br /> * (qtyord-qtyshp) * price<br /> <br /> ==Additional Report Fields for Customization==<br /> <br /> <br /> [[Category:Order Entry]]</div> Amohammad