http://www.abiscorp.com/faq/index.php?action=history&feed=atom&title=Customer_Sales_Analysis_Report
Customer Sales Analysis Report - Revision history
2026-04-28T02:50:52Z
Revision history for this page on the wiki
MediaWiki 1.31.0
http://www.abiscorp.com/faq/index.php?title=Customer_Sales_Analysis_Report&diff=5647&oldid=prev
Kamar at 19:05, 29 October 2024
2024-10-29T19:05:35Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revision as of 19:05, 29 October 2024</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l4" >Line 4:</td>
<td colspan="2" class="diff-lineno">Line 4:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Reports >> Sales Force >> Customer Sales Analysis Report</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Reports >> Sales Force >> Customer Sales Analysis Report</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[<del class="diffchange diffchange-inline">http</del>:<del class="diffchange diffchange-inline">//www.abiscorp.com/adjwiki/GetFile.aspx?File=Sales Force\Customer Sales Analysis Report</del>.<del class="diffchange diffchange-inline">jpg|Click here for screenshot</del>]</div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[<ins class="diffchange diffchange-inline">[File</ins>:<ins class="diffchange diffchange-inline">Screenshot_2024-10-29_140441</ins>.<ins class="diffchange diffchange-inline">png]</ins>]</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==General Description==</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==General Description==</div></td></tr>
</table>
Kamar
http://www.abiscorp.com/faq/index.php?title=Customer_Sales_Analysis_Report&diff=5645&oldid=prev
Kamar: Created page with "__NOTOC__ ==Default Menu Location== Reports >> Sales Force >> Customer Sales Analysis Report [http://www.abiscorp.com/adjwiki/GetFile.aspx?File=Sales Force\Customer Sales An..."
2024-10-29T18:50:46Z
<p>Created page with "__NOTOC__ ==Default Menu Location== Reports >> Sales Force >> Customer Sales Analysis Report [http://www.abiscorp.com/adjwiki/GetFile.aspx?File=Sales Force\Customer Sales An..."</p>
<p><b>New page</b></p><div>__NOTOC__<br />
==Default Menu Location==<br />
<br />
Reports >> Sales Force >> Customer Sales Analysis Report<br />
<br />
[http://www.abiscorp.com/adjwiki/GetFile.aspx?File=Sales Force\Customer Sales Analysis Report.jpg|Click here for screenshot]<br />
<br />
==General Description==<br />
<br />
Customer Sales Analysis Report screen generates an analyzed report for customers by different salesperson.<br />
<br />
==Fields/Filters==<br />
<br />
'''Customer ID:''' Customer code<br />
<br />
'''Start Date:''' Beginning date for the report<br />
<br />
'''End Date:''' Ending date for the report<br />
<br />
'''Sales Person:''' Sales person for the report<br />
<br />
'''Item:''' Item code<br />
<br />
==Standard Report Fields(Page Header)==<br />
<br />
'''Company'''<br />
<br />
* lc_company<br />
<br />
'''Report'''<br />
<br />
* lc_report<br />
<br />
'''Date Range'''<br />
<br />
* lc_date<br />
* lc_spf<br />
<br />
===Group Header 1: custno===<br />
<br />
'''Sales for Customer'''<br />
<br />
* alltrim(custno) + " / " + alltrim(company)<br />
<br />
==Standard Report Fields(Line Items)==<br />
<br />
'''Invoice Date'''<br />
<br />
* iif(isnull(invdate),'',invdate)<br />
<br />
'''Invoice #'''<br />
<br />
* invno<br />
<br />
'''Item Number'''<br />
<br />
* item<br />
<br />
'''Slsprs'''<br />
<br />
* alltrim(sp)<br />
<br />
'''U/M'''<br />
<br />
* unit_pur<br />
<br />
'''Qty Ship'''<br />
<br />
* qty2bill<br />
<br />
'''Ext Price'''<br />
<br />
* price*qty2bbill<br />
<br />
'''Margin'''<br />
<br />
* price-cost<br />
<br />
'''GM%'''<br />
<br />
* gm<br />
<br />
===Group Footer 1: custno===<br />
<br />
'''Ext Price'''<br />
<br />
* price*qty2bill<br />
<br />
'''Margin'''<br />
<br />
* (price-cost)*qt<br />
<br />
==Summary==<br />
<br />
* price*qty2bill<br />
<br />
* (price-cost)*qt<br />
<br />
==Additional Report Fields for Customization==</div>
Kamar