INFORMATION PROVIDED IN THIS DOCUMENT AND ANY SOFTWARE THAT MAY ACCOMPANY THIS DOCUMENT IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A PARTICULAR PURPOSE.
The user assumes the entire risk as to the accuracy and the use of the information supplied. This information may be copied and distributed subject to the following conditions: 1)All text must be copied without modification and all pages must be included; 2)If software is included, all files on the disk(s) must be copied without modification; 3)All software included and documentation must be distributed together; and 4)This information may not be distributed for profit.
Copyright © 1996 Platinum Software Corporation. All Rights Reserved.
Platinum ia a registered trademark of Platinum Software Corporation.
All other trademarks contained herein are acknowledged.
GROSS PROFIT REPORT
GROSS PROFIT REPORT
The Gross Profit Report can be run by Document # or by line item. When the report is run by document #, the report will list one line per document. When run by line item, the report will list one line per item.
When run based on document, the report will optionally read the ARTRAN and ARTRANH files for the cost of the invoice or read the cost from the INCOST file in inventory. The below scenario explains the key fields when based on document:
1a) When "use entry cost for profit calculation" is set to "Y", the system reads the ARTRAN and ARTRANH files only. The cost is picked up from the memo cost field in either of these two files.
1b) When "use entry cost for profit calculation" is set to "N", the system looks to the ARLINH file for the SYS: Doc id. Once it locates a number, for example SYS: Doc id #3, the system then looks in the INTXDH file for a record with a SYS ID: 1 (meaning that it originated in AR) and the same DOC ID: 3. Once this is found, the system then looks at that record’s EVENT ID # in the INTXDH file, let’s say for example that this Doc id: 3 has an EVENT ID: 5. The system then looks to the INCOST file for all records with event #5, adds the cost of all of these records and displays this on the Gross Profit Report as one line. (The reason why it displays it as one line is becuase the report will only display one line for the entire invoice if run by Document #.) If any of the above key fields are not there or are missing, or if this linking system is broken at all, the Gross Profit Report will use the unit cost field in the ARLINH file, and give a message that there is no cost available for the item.
When based on line item, the report will either read the ARLINH file described in 2a) below or read the cost from the INCOST file described in 2b).
2a) When "use entry cost for profit calculation" is set to "Y", the system reads the ARLINH file only for the cost. The cost is picked up from the unit cost field of this file.
2b) When "use entry cost for profit calculation" is set to "N", the report works exactly as 1b) above, only that it will list one line per item rather than consolidating them into one line.
