http://www.abiscorp.com/faq/index.php?action=history&feed=atom&title=Sales_Margin_Report
Sales Margin Report - Revision history
2026-04-28T08:07:31Z
Revision history for this page on the wiki
MediaWiki 1.31.0
http://www.abiscorp.com/faq/index.php?title=Sales_Margin_Report&diff=5665&oldid=prev
Kamar: Created page with "__NOTOC__ ==Default Menu Location== Reports >> Sales Force >> Sales Margin Report [imageauto||{UP(SALESMARGIN)}Sales Margin Report.png] ==General Description== Sales Margi..."
2024-11-04T16:02:21Z
<p>Created page with "__NOTOC__ ==Default Menu Location== Reports >> Sales Force >> Sales Margin Report [imageauto||{UP(SALESMARGIN)}Sales Margin Report.png] ==General Description== Sales Margi..."</p>
<p><b>New page</b></p><div>__NOTOC__<br />
==Default Menu Location==<br />
<br />
Reports >> Sales Force >> Sales Margin Report<br />
<br />
[imageauto||{UP(SALESMARGIN)}Sales Margin Report.png]<br />
<br />
==General Description==<br />
<br />
Sales Margin Report screen allows users to generate detail sales report either by period or by date range. When generating a report, users can either generate a report for a specific customer by entering a customer code or leaving a blank in the "Customer Number" field to generate a general report for all the customers. <br />
<br />
==Fields/Filters==<br />
<br />
'''By Period''' or '''By Date Range''': Options to choose a report type<br />
<br />
'''Month:''' Month for the report (Require only if the "By Period" is selected)<br />
<br />
'''Year:''' Year for the report (Require only if the "By Period" is selected)<br />
<br />
'''Beginning Date:''' Beginning date for the report (Require only if the "By Date Range" is selected)<br />
<br />
'''Ending Date:''' Ending date for the report (Require only if the "By Date Range" is selected)<br />
<br />
'''Customer Number:''' Customer code<br />
<br />
'''Item Number:''' Item code<br />
<br />
'''Sort By:''' Options for report generation<br />
<br />
'''Exclude Outbound Freight:''' Excludes items with the FREIGHTOUT item attribute.<br />
<br />
'''Exclude Inbound Freight:''' Excludes items with the FREIGHTIN item attribute.<br />
<br />
==Standard Report Fields(Headers)==<br />
<br />
'''Company'''<br />
<br />
* company<br />
<br />
'''Date Range'''<br />
<br />
* gd_passdate<br />
<br />
'''Customer'''<br />
<br />
* 'Customer : ' + alltrim(gc_cust)<br />
<br />
'''Item Number'''<br />
<br />
* 'Item: ' + alltrim(gc_item)<br />
<br />
'''Warehouse'''<br />
<br />
* 'Whse: ' + alltrim(gc_plant)<br />
<br />
==Standard Report Fields(Line Items Detail)==<br />
<br />
'''Order Number'''<br />
<br />
* sono<br />
<br />
'''Customer Name'''<br />
<br />
* CUSTOMER<br />
<br />
'''Customer No.'''<br />
<br />
* custno<br />
<br />
'''Invoice No.'''<br />
<br />
* invno<br />
<br />
'''Invoice Date'''<br />
<br />
* invdate<br />
<br />
'''Sales Price'''<br />
<br />
* extstot<br />
<br />
'''Standard Cost'''<br />
<br />
* gc_costlabel<br />
<br />
'''Profit'''<br />
<br />
* profit<br />
<br />
===Group Footer===<br />
<br />
'''Total for customer'''<br />
<br />
* 'Total For customer - '+alltrim(CUSTOMER)<br />
<br />
'''Sales Price'''<br />
<br />
* cextstot<br />
<br />
'''Standard Sales'''<br />
<br />
* cstcost<br />
<br />
'''Profit'''<br />
<br />
* profit<br />
<br />
==Summary==<br />
<br />
* textstot<br />
* tstdcost<br />
* tprofit<br />
<br />
==FAQ==<br />
<br />
'''Q:''' Why is an AR invoice not displaying on this report?<br />
<br />
'''A:''' This report only includes AR invoices where the underlying sales order is closed.</div>
Kamar