PeachPro sets you free
|
|
|
|
PeachPro sets you free
|
| SED Enhanced Invoicing Reports |
SED Enhanced Invoicing Reports
Create the S/I reports you always wanted! Would you like to have a document register sorted and subtotaled by salesperson for just paid invoices?
How about a document register for just a certain range of job order numbers? A register sorted by ship to or bill to information? A register detailing outstanding quotes for a range of customers? With this powerful menu driven product, SED - Enhanced Invoicing Reports you can print the report you need in minutes. Print reports by salesperson, job/order number, tax code, ship date and more. Menu options allow you to specify what information prints on the report and where it prints, it also allows you to preview the format of the report before printing it. Choose from more than 40 fields to print.
After activating SED - Enhanced Invoicing Reports you will be presented with the following menu when selecting the Document Register from Sales Invoicing:
+--- Select Document Register ---+ | E - Enhanced Document Register | | S - Standard Document Register | +--------------------------------+
When you choose E - Enhanced Document Register, the following screen will appear:
+------------------------------------------------------------------------------+ |SIRPTS9 E233 Enhanced Document Register COMPANY ID: SP | |05/19/95 Software Professionals, Inc. GENERATION #: 53 | +------------------------------------------------------------------------------+ +-- Document Register Options --+ Current Report:Peachtree Default Report | | S - Selection Criteria | File Name.....:SETING | | T - Sort Criteria | Sort Criteria: Totaling | | R - Report Layout/Content | First Sort By.:Document Number N | | O - Totaling Options | Then By.:Document Date N | | V - Save/Load Settings | Then By.:None N | | P - Print Document Register | Grand Totals.....: Y | +-------------------------------+ Totals Only......: N | | | | | +----------------------------- Selection Criteria -----------------------------+ | Post Status......: Posted, Current Active, Current Held | | Document Type....: Quotes, Orders, Invoices, BO Orders, BO Invs, Crd Memos | | Quote Number.....: All Order Number.....: All | | Document Date....: 01/01/95 To 10/10/95 Invoice Number...: 100001 To 100011 | | Salesperson......: All Terms Code.......: All | | Job/Order Number.: All | | Payment Status...: Paid, Un-Paid, Partially Paid | | Sales Tax Code...: 123 To 909 | +------------------------------------------------------------------------------+ | F1-Help F6-Sel Crit F7-Preview F10-Menu ShF10-Home | +------------------------------------------------------------------------------+
Listed below is a description of what each option will do:
S - Selection Criteria: Determines which documents should be included on the report
T - Sort Criteria: Determines how the report will be organized and how detail will be listed
R - Report Layout\Content: Determines what detail prints on the report
O - Totaling Options: Determines what totals will appear on the report
V - Save/Load Settings: Save settings for future use and load previous settings you have saved
P - Print Document Register: Prints the report
F1-Help: Can be used at any time for detailed information regarding the current options on the screen
F10-Done and ShF10-Home: Will exit you to the Peachtree program menus
F6 - Sel Crit: Will allow you to scroll through the current selection criteria window
F7 - Print Preview: Will print a Document Mask showing you how your current report layout will print
To select the first option choose S - Selection Criteria. This option will allow you to specify which documents should be included on your report.
You can narrow your selection using the following fields:
+-- Selection Criteria ---+ | D - Document Info | | B - Bill Info | | S - Ship Info | | C - Cust UsrDef Info | | P - Purchase Info | | A - Amounts | +-------------------------+
After selecting D - Document Info from the main Selection Criteria menu the following menu will appear.
+----- Document Info -----+ | P - Post Status | | T - Doc Type/Number | | D - Doc Date | | S - Salesperson | | O - Job/Order No. | | Y - Payment Status | | X - Tax Code | | C - Terms Code | +-- Selection Criteria ---+
P - Post Status: Use the Space Bar to choose Current Active, Current Held, and/or Posted Documents.
+---- Document Status ----+ | P - Posted _ | | A - Current Active _ | | H - Current Held _ | +-- Space bar to Toggle --+
T - Doc Type/Number: Press enter to set a range of document numbers for Quotes, Orders, Invoices, Backorders and Credit Memos. Use the space bar to toggle them on/off.
+--------- Doc Type ---------+ +-------- Quote Number --------+ | Q - Quotes _ | | A - All Quote Numbers | | O - Orders _ | | R - Range Of Quote Numbers | | I - Invoices _ | +------------------------------+ | X - Backorder Orders | | B - Backorder Invoices | | C - Credit Memos | +- Enter Set / Space Toggle -+
If you select R - Range Of Quote Numbers you will be asked to define the range you would like included on your report. Please note that F2-Lookups are available for Doc Type/Number.
+----- Range of Numbers -----+ | Starting Num: | | Ending Num..: | +----------------------------+
D - Doc Date: Select A - All Doc Dates or R - Range of Doc Dates to limit your selection.
+--- All/Range Dates ----+ | A - All Doc Dates | | R - Range of Doc Dates | +------------------------+
If you select R - Range of Doc Dates you will be asked to define the range you would like included on your report.
+------ Range of Dates ------+ | Start Date: 01/01/94 | | End Date..: 01/01/94 | +----------------------------+
S - Salesperson: Select A - All Salesperson or R - Range Of Salespersons to limit your selection.
+-------- Salesperson --------+ | A - All Salespersons | | R - Range Of Salespersons | +-----------------------------+
If you select R - Range Of Salespersons you will be asked to define the range you would like included on your report. Please note that F2-Lookups are not available for this field.
+----- Range of Salespersons-----+ | Starting Salesperson: | | Ending Salesperson..: | +--------------------------------+
O - Job/Order No: Select A - All Order Numbers or R - Range of Order Numbers to limit your selection.
+-------- Order Number --------+ | A - All Order Numbers | | R - Range Of Order Numbers | +------------------------------+
If you select R - Range Of Order Numbers you will be asked to define the range you would like included on your report. Please note that F2-Lookups are not available for this field.
+---- Range of Order Numbers ----+ | Starting Order Number: | | Ending Order Number..: | +--------------------------------+
Y - Payment Status: Select P - Paid, U - Un-Paid or R - Partially Paid.
+---- Payment Status -----+ | P - Paid | | U - Un-Paid | | R - Partially Paid | +-- Space bar to Toggle --+
After selecting which Payment Status you wish to limit your selection to, hit [ESC], you will be asked to define what transaction type constitutes a "Payment". Select each type of transaction you would like SED to consider a "Payment" when calculating whether a document is Paid, Unpaid or Partially Paid. Hit [ESC] again after making your selection.
+--- Define Payment Status ---+ | AD - Adjustment | | BD - Bad Debt | | CR - Credit | | EP - EP Discount | | MC - Misc Credit | | OC - OCR Credit | | PA - Payment | | RE - Return (Stocked) | | RS - Return (Service) | | RN - Return (Non-Stocked) | +--- Space bar to Toggle ----+
Please Note: If you do not include all transactions in Payment Status it is possible for a document to show "Part Paid" even though the total debits in A/R match the total credits. This could be caused, for example, by Defining Payment Status to only include PA transactions and having a $100.00 invoice with a $50.00 EP transaction and a $50.00 PA transaction applied to it. Since the invoice is $100.00 and you defined Payment Status to only include PA transactions ($50.00) the invoice would reflect a "Part Paid" status.
X - Tax Code: Select A - All Tax Codes or R - Range Of Tax codes.
+-------- Tax Code --------+ | A - All Tax Codes | | R - Range Of Tax Codes | +--------------------------+
If you select R - Range of Tax Codes you will be asked to define the range you would like included on your report. Please note F2-Lookups are available for Tax Code.
+-- Range of Tax Codes --+ | Starting Tax Code: | | Ending Tax Code..: | +------------------------+
C - TermsCode: Select A - All TermsCodes or R - Range Of TermsCodes.
+-------- TermsCode --------+ | A - All TermsCodes | | R - Range Of TermsCodes | +---------------------------+
If you select R - Range Of TermsCodes you will be asked to define the range you would like included on your report. Please note F2-Lookups are available for TermsCode.
+- Range of Terms Codes -+ | Starting Terms Code: | | Ending Terms Code..: | +------------------------+
After selecting B - Bill Info from the main Selection Criteria menu the following menu will appear:
+------- Bill Info -------+ | I - Bill-To ID | | N - Bill-To Name | | 1 - Bill-To Address 1 | | 2 - Bill-To Address 2 | | 3 - Bill-To Address 3 | | Z - Bill-To Zip Code | +-- Selection Criteria ---+
By selecting any of the Bill Info Fields you will be prompted whether you want to include All or a Range. For example selecting I - Bill-To ID you will get the following options:
+-------- Bill-To ID --------+ | A - All Bill-To IDs | | R - Range Of Bill-To IDs | +----------------------------+
Selecting Bill-To Name, Address 1-3, and Zip code will also give you All or Range options. Please note that F2-Lookups are not available for Bill-To Address 1-3 or Bill-To Zip Code. F2-Lookups is available for Bill-To-Id.
After selecting S - Ship Info from the main Selection Criteria menu the following menu will appear:
+------- Ship Info -------+ | N - Ship-To Name | | 1 - Ship-To Address 1 | | 2 - Ship-To Address 2 | | 3 - Ship-To Address 3 | | Z - Ship-To Zip Code | | D - Ship Date | | V - Ship Via | +-- Selection Criteria ---+
By selecting any of the Ship Info Fields you will be prompted whether you want to include All or a Range. For example selecting N - Ship To Name you will get the following options:
+-------- Ship-To ID --------+ | A - All Ship-To Names | | R - Range Of Ship-To Names| +----------------------------+
Selecting Ship-To Address 1-3, Zip code, Ship Date, or Ship Via will also give you All or Range options. Please note that F2-Lookups are not available for any of the Ship-To fields.
Selecting C - Cust UsrDef Info from the main Selection Criteria menu allows you to limit your selection based on the AR Customer User Defined Fields. Please note that F2-Lookups are not available for User Defined Fields.
+--- Cust UsrDef Info ----+ +-------- Cust UsrDef 1 ----------+
| 1 - Cust UsrDef 1 | | A - All Cust UsrDef |
| 2 - Cust UsrDef 2 | | R - Range Of Cust UsrDef |
| 3 - Cust UsrDef 3 | +---------------------------------+
| 4 - Cust UsrDef 4 |
| 5 - Cust UsrDef 5 |
+-- Selection Criteria ---+
+----------------- Range of Cust UD 1 ------------------+
| Minimum Cust UD 1: |
| Maximum Cust UD 1: |
+-------------------------------------------------------+
Selecting P - Purchase Info from the main Selection Criteria menu allows you to set a Range for PO Number and PO Date. Please note that F2-Lookups are not available for Purchase Info Fields.
+----- Purchase Info -----+ | N - PO Number | | D - PO Date | +-- Selection Criteria ---+
Selecting A - Amounts from the main Selection Criteria menu allows you to limit your selection based on the Dollar amount of certain document totals.
+------------------- Amounts --------------------+ | T - Taxable Sales S - Sales Tax Amount | | N - Non-Taxable Sales D - Document Total | | P - Payment Amount 1 - User Def 1 Amt | | B - Total Before Tax 2 - User Def 2 Amt | | E - EP Discount Amt 3 - User Def 3 Amt | +-------------- Selection Criteria --------------+
If you select T - Taxable Sales, S - Sales Tax Amount, N - Non-Taxable Sales, D - Document Total, P - Payment Amount, B - Total Before Tax, or E - EP Discount Amt, you will be prompted with an All or Range selection box.
+-------- Payment Amount --------+ | A - All Payment Amounts | | R - Range Of Payment Amounts | +--------------------------------+
Please note: On Posted Invoices, P - Payment Amount reads information from Accounts Receivable. It consists of All PA, EP, BD, and OC transactions. Therefore it is possible for a document to have a "Fully Paid" document status even though the payment amount does not equal the document total. This is because other types of Accounts Receivable transactions may have been entered into Accounts Receivable that act as a credit toward the invoice. Example: RE, MC, or CR transactions would not be included in the payment amount, but they may be used to define what constitutes "Payment Status".
On current invoices, P - Payment Amount is a total of all PA transactions on your sales invoice (EP, BD, and OC transactions are not available in Sales Invoicing).
If you select any one of the three user defined amounts you will get the following options:
+------------------------------------------------------------------------------+ |SIRPTS9 Enhanced Document Register COMPANY ID: SP | |05/17/95 Software Professionals, Inc. GENERATION #: 53 | +------------------------------------------------------------------------------+ |--------- Define User-Defined 1 - SI Amount Contents ----------+ | | SA - Sale (Stocked) _ SC - Service Charge _ | | | SS - Sale (Service) _ MD - Misc. Debit _ | Totaling | | SN - Sale (Non-stocked) _ MC - Misc. Credit | N | | PA - Payment BD - Bad Debt | N | | RE - Return (Stocked) EP - EP Discount Amount | N | | RS - Return (Service) OC - OCR Credit |als.....: Y | | RN - Return (Non-stocked) ST - State Sales Tax _ |ly......: N | | FR - Freight _ CO - County Sales Tax _ | | | CR - Credit CI - City Sales Tax _ | | | AD - Adjustment _ |--------------+ |------- Space bar to Toggle/Esc when settings correct --------+ | | Non-Taxable Sales: All | | Payment Amount...: All | | Total Before Tax.: All | | EP Discount Amt..: All User-Def 2 Amt...: All | | Sales Tax Amount.: All | | Document Total...: All User-Def 3 Amt...: All | | User-Def 1 Amt...: All | +------------------------------------------------------------------------------+ |F1-Help F5-Use AR | +------------------------------------------------------------------------------+
You can use the [F5] Function Key to choose if you want this User Defined Amount to read the information from Sales Invoicing or Accounts Receivable. (Each User Defined Amount can be set to read Sales Invoicing or Accounts Receivable information independently of the other User Defined Amounts)
If you choose to read the information from Sales Invoicing, Payment information or other transactions made in Accounts Receivable will not be reflected in your totals.
If you choose to read the information from Accounts Receivable, a certain amount of detail will be lost as Peachtree consolidates Sales Invoicing transactions as it posts the information to Accounts Receivable. For Example: If you entered an invoice with an SA transaction for $50.00 and a RE transaction for $10.00 with $3.00 in Sales Tax, Peachtree would consolidate that invoice into a single SA transaction for $43.00. Likewise your User Defined field would pick up $0.00 for RE transactions and $0.00 for Sales Tax transactions when you are looking at the Accounts Receivable detail. If you are unsure of what has been posted to Accounts Receivable for a particular invoice, simply query that customer and look at the transactions for that invoice. Since Current\Held Documents have not yet been posted to Accounts Receivable, any transactions that exist in Accounts Receivable for that document number were for previously posted documents. Since these Accounts Receivable transactions do not really apply to Current Documents all User Defined - Accounts Receivable Amounts will show 0.00 for Current Documents. This is to stop PA or other transactions made on an original previously posted invoice from appearing on a current backorder, etc.
Hit the space bar on each transaction type that you would like to include in that User Defined Amount. After finishing your selections hit [ESC]. You will then be prompted to include All or a range of User Defined Amounts.
+--------User-Def 1 Amt--------+ +---Range of User-Defined 1 Amts----+ | A - All User-Def 1 Amts | | Min User Def 1 Amts : 0.00 | | R - Range Of User-Def 1 Amts| | Max User Def 1 Amts : 0.00 | +------------------------------+ +-----------------------------------+
Note: If your User Defined Amounts consisted only of Credit\Payment type transactions you can enter a Positive amount here. Example: if
your User Defined Field consisted solely of PA Transactions entering Min $50 to Max $500 would only include documents that had payments totaling between $50.00 and $500.00. However, if your User Defined Amounts consisted of both Sale\Charge type transactions AND Credit\Payment type transactions entering Min $50 to Max $500 would only include documents where the "Total Sale Transactions less Total Payments\Credits" results in a balance of $50.00 to $500.00.
To select the second option choose T - Sort Criteria. This option determines how the report will be organized and how detail will be listed. You can define up to three sort keys, or levels of sorting. For example you may want to print a report sorted first by Salesperson, then by Payment Status, then by Payment Amount. You would do this by making your first sort key equal to Salesperson, the second equal to Payment Status, the third equal to Payment Amount.
+---- Select Key -----+ | F - First Sort Key | | S - Second Sort Key | | T - Third Sort Key | +---------------------+
Selecting any of the sort key options will present you with the following menu, simply select any one group and you will receive an additional menu to select the field you wish to sort by.
+-- Select Sort Criteria Area --+ D - Document Info:
| D - Document Info | +-- Sort Criteria by Doc Info --+
| B - Bill Info | | P - Post Status |
| S - Ship Info | | T - Doc Type |
| C - Cust UsrDef Info | | N - Doc Number |
| P - Purchase Info | | D - Doc Date |
| A - Amounts | | S - Salesperson |
+----- First Sort Criteria -----+ | O - Job/Order No. |
| Y - Payment Status |
| X - Tax Code |
| C - Terms Code ¦
| A - Act/Hold Status |
+----- First Sort Criteria -----+
+ Sort Criteria by Bill-To Info +
| I - Bill-To ID |
| N - Bill-To Name |
| 1 - Bill-To Address 1 | S - Ship Info:
| 2 - Bill-To Address 2 | + Sort Criteria by Ship-To Info +
| 3 - Bill-To Address 3 | | N - Ship-To Name |
| Z - Bill-To Zip Code | | 1 - Ship-To Address 1 |
+----- First Sort Criteria -----+ | 2 - Ship-To Address 2 |
| 3 - Ship-To Address 3 |
| Z - Ship-To Zip Code |
C - Cust UsrDef Info: | D - Ship Date |
+-- Sort by Cust Usr Def Info --+ | V - Ship Via |
| 1 - Cust Usr Def 1 | +----- First Sort Criteria -----+
| 2 - Cust Usr Def 2 |
| 3 - Cust Usr Def 3 |
| 4 - Cust Usr Def 4 | P Purchase Info:
| 5 - Cust Usr Def 5 | +---- Sort By Purchase Info ----+
+----- First Sort Criteria -----+ | N - PO Number |
| D - PO Date |
+----- First Sort Criteria -----+
+------ Sort by Amounts ------+ | T - Taxable Sales | | N - Non-Taxable Sales | | P - Payment Amount | | B - Total Before Tax | | E - EP Discount Amount | | S - Sales Tax Amount | | D - Document Total | | 1 - User Def 1 Amt | | 2 - User Def 2 Amt | | 3 - User Def 3 Amt | +---- First Sort Criteria ----+
Please Note: The total number of characters used in sorting (# of characters in Sort code 1 + # of characters in Sort Code 2 + # of characters in Sort Code 3) is limited to 59. If your sort selection exceeds 59 characters you will receive the following message. If you choose accept, it will only use the # of characters listed for your sort. Please note that it will be left justified, meaning in the below example the first 21 characters of Cust User Def 1 will be used in the sort followed by the first 19 characters of Cust User Def 3, etc.
+---------------------- Sort Character Limit Exceeded -----------------+ | The total number of characters used in sorting cannot exceed 59. | | To keep within this limit we have adjusted the number of sort | | characters used for your selected sort as follows: | | | | Cust User Def 1.......: From 40 characters to 21 | | Cust User Def 3.......: From 40 characters to 19 | | Cust User Def 5.......: From 40 characters to 19 | | | | This will NOT affect the number of characters printed out in your | | report. It will only affect the number of characters used in | | sorting the affected fields. If information significant to the | | sort is contained beyond this limit you may wish to select shorter | | sort criteria. | | | | Accept adjusted lengths? Y | +----------------------------------------------------------------------+
To choose the third option select R - Report Layout/Content. This option determines what detail prints on the report.
When selecting Report Layout/Content, you will be presented with the following screen:
+------------------------------------------------------------------------------+ |SIRPTS9 Enhanced Document Register COMPANY ID: SP | |05/17/95 Software Professionals, Inc. GENERATION: 53 | +------------------------------------------------------------------------------+ |+------ Report Content ------+ Current Report:Peachtree Default Report | || T - Title/Header/Footer ¦ File Name.....:SETING | || D - Document Info ¦ Sort Criteria: Totaling | || B - Bill Info ¦ First Sort By.:Document Number N | || S - Ship Info ¦ Then By.:Document Date N | || C - Cust UsrDef Info ¦ Then By.:None N | || P - Purchase Info ¦ Grand Totals.....: Y | || A - Amounts ¦ Totals Only......: N | +----------------------------+ Layout Design Area -----------------------------+ | 1 2 3 4 5 | 6 7 | | 1234567890123456789012345678901234567890123456789012345678901234567890123456 | | DOC DOC CUST. MERCHANDISE | |1NUMBER S .DATE... ..ID.. ..CUSTOMER NAME.......... SALESPERSONSERVICES 1| |2 2| |3 3| |4 4| |5 5| |6 6| | SAMPLE FOOTER MESSAGE AT THE BOTTOM O | +------------------------------------------------------------------------------| | F1-Help F5-View Right F7-Preview | +------------------------------------------------------------------------------+
As you add each field you will see them displayed on the "Layout Design Area". If the length of the field is longer that the title each leading or trailing space will use "." as a place marker so you can see how many columns each field will use. You can use [F5] to toggle between the right half and left half of the report. You can use [F7] to print a preview, or display a preview on your screen. The preview will consist of pre-set data, but will be in the format you have specified.
Report Layout/Content allows you to specify which fields should be included on the report, and how they should be included. You can select from the following fields to place on the report. Based on the type of field, you will be presented with different field options.
Field: Type of field: Group Field is located: Post Status Text Document Info Document Type Text Document Info Quote Number Text Document Info Document Date Date Document Info Salesperson Text Document Info Job/Order Number Text Document Info Payment Status Text Document Info Sales Tax Code Text Document Info Order Number Text Document Info Invoice Number Text Document Info Terms Code Text Document Info Bill-To ID Text Bill Info Bill-To Name Text Bill Info Bill-To Address 1 Text Bill Info Bill-To Address 2 Text Bill Info Bill-To Address 3 Text Bill Info Bill-To Zip Text Bill Info Ship-To Name Text Ship Info Ship-To Address 1 Text Ship Info Ship-To Address 2 Text Ship Info Ship-To Address 3 Text Ship Info Ship-To Zip Text Ship Info Ship Date Date Ship Info Ship Via Text Ship Info Cust Usr Def 1 Text Cust Usr Def Info Cust Usr Def 2 Text Cust Usr Def Info Cust Usr Def 3 Text Cust Usr Def Info Cust Usr Def 4 Text Cust Usr Def Info Cust Usr Def 5 Text Cust Usr Def Info PO Number Text Purchase Info PO Date Date Purchase Info Taxable Sales Numeric Amounts Non-Taxable Sales Numeric Amounts Payment Amount Numeric Amounts Total Before Tax Numeric Amounts EP Discount Amt Numeric Amounts Sales Tax Amount Numeric Amounts Document Total Numeric Amounts User-Def 1 Amt Numeric Amounts User-Def 2 Amt Numeric Amounts User-Def 3 Amt Numeric Amounts
Each of the Field types has the following related set of attributes:
+-------------------- Document Number --------------------+ | Field Row : 2 | | Start Column : 1 | | Length : 6 Standard Length: 6 | | Field Title : Doc Nr | +---------------------------------------------------------+
+--------------------- Document Date ---------------------+ | Field Row : 2 | | Start Column : 10 | | Length : 8 Standard Length: 8 | | Field Title : Doc Date | +---------------------------------------------------------+
+----------------------- Taxable Sales -----------------------+ | Field Row : 2 | | Start Column : 20 | | Length : 13 Standard Length: 13 | | Field Title : Taxable Sales | | Num Dec Places : 2 | +-------------------------------------------------------------+
Field Row: The row on which this field should appear
Start Column: The column at which this field should start printing
Length: The number of characters of this field that should print
Field Title: The title to be displayed in the header for this field
Num Dec Places: The number of decimal places to display for this field
When selecting R - Report Layout/Content, the following menu will appear:
+------ Report Content ------+ | T - Title/Header/Footer | | D - Document Info | | B - Bill Info | | S - Ship Info | | C - Cust UsrDef Info | | P - Purchase Info | | A - Amounts | +----------------------------+
T - Title/Header/Footer:
Selecting T - Title/Header/Footer from the Report Content menu the following screen will appear:
+------------------- Title/Header/Footer Options ------------------+ | Report Title..........: Enter Title information here........ | | Edit Header...........: N | | Edit Footer...........: N | +------------------------------------------------------------------+
Use Report Title to change the Title on your report.
Use Edit Header to change the Header on your report.
Use Edit Footer to Change the Footer on your report.
Please Note: To edit the header/footer enter Y (Yes) and the cursor will automatically move to the lower layout section where you may edit the header/footer. This is done to assist in lining up columns. The F5-Left/Right key can be used to move from the left part of the screen to the right part of the screen while editing.
Selecting D - Document Info from the Report Content menu the following screen will appear: Use the space bar to toggle a field on/off.
Use enter to change current settings.
+---------------- Document Info -----------------+ | P - Post Status _ O - Job/Order No. _ | | T - Doc Type _ Y - Payment Status _ | | N - Doc Number _ X - Tax Code _ | | D - Doc Date _ C - Terms Code _ | | S - Salesperson _ A - Act/Hld Status _ | +----------- Enter Set / Space Toggle -----------+
Selecting B - Bill-To Info from the Report Content menu the following screen will appear: Use the space bar to toggle a field on/off. Use enter to change current settings.
+-------- Bill Info --------+ | I - Bill-To ID _ | | N - Bill-To Name _ | | 1 - Bill-To Address 1 _ | | 2 - Bill-To Address 2 _ | | 3 - Bill-To Address 3 _ | | Z - Bill-To Zip Code _ | + Enter Set / Space Toggle -+
Selecting S - Ship-To Info from the Report Content menu the following screen will appear: Use the space bar to toggle a field on/off. Use enter to change current settings.
+-------- Ship Info --------+ | N - Ship-To Name _ | | 1 - Ship-To Address 1 _ | | 2 - Ship-To Address 2 _ | | 3 - Ship-To Address 3 _ | | Z - Ship-To Zip Code _ | | D - Ship Date _ | | V - Ship Via _ | + Enter Set / Space Toggle -+
Selecting C - Cust UsrDef Info from the Report Content menu the following screen will appear: Use the space bar to toggle a field on/off.
Use enter to change current settings.
+---- Cust Usr Def Info ----+ | 1 - Cust Usr Def 1 _ | | 2 - Cust Usr Def 2 _ | | 3 - Cust Usr Def 3 _ | | 4 - Cust Usr Def 4 _ | | 5 - Cust Usr Def 5 _ | + Enter Set / Space Toggle -+
Selecting P - Purchase Info from the Report Content menu the following screen will appear: Use the space bar to toggle a field on/off. Use enter to change current settings.
+------ Purchase Info ------+ | N - PO Number _ | | D - PO Date _ | + Enter Set / Space Toggle -+
Selecting A - Amounts from the Report Content menu the following screen will appear: Use the spacebar to toggle a field on/off. Use enter to change current settings.
+---------------------- Amounts ----------------------+ | T - Taxable Sales _ S - Sales Tax Amount _ | | N - Non-Taxable Sales _ D - Document Total _ | | P - Payment Amount _ 1 - User-Def 1 Amt _ | | B - Total Before Tax _ 2 - User-Def 2 Amt _ | | E - EP Discount Amt _ 3 - User-Def 3 Amt _ | +------------- Enter Set / Space Toggle --------------+
A confirmation will be displayed showing the current settings for each User Defined amount. Transaction Type definitions may be changed, but the Selection Criteria (All/Range) may not be changed within Report/Layout. You may also change whether you want the data from Sales Invoicing or
To choose the fourth option select O - Totaling Options. This option allows you to choose what totals will appear on your report.
+------- Totaling Settings --------+ | 1 - Document Number Totals _ | | 2 - Document Date Totals _ | | 3 - Non-Sorted Totals _ | | G - Grand Totaling | | O - Totals Only | +---- Enter Set / Space Toggle ----+
Please Note: The title for each sort key reflects the particular sort choices selected.
Totaling Options allows you to specify which totals you would like to display on your report. 1 - the first totals will cause a total to print on the report any time the primary sort key changes. 2 - the second totals will cause a subtotal to print any time the secondary sort key changes, and similarly 3 - the third totals will cause a subtotal to print any time the third sort key changes. For example: suppose you are sorting by salesperson and document date. If you have first, and second key totals turned on, then any time a new date or salesperson is encountered, a subtotal will print.
G - Grand totals print at the end of the report on their own page.
O - Totals Only will cause the report to omit all detail lines and print only the totals for each sort key and/or grand totals.
Two options are available: Enter Set and Space Toggle. Use this option to specify which amount totals are to print at this sort level. A screen will display reflecting all amounts in your report. A check mark indicates the amount will print.
If the totaling level is a date-type level then an additional screen will allow the user to determine how often totaling will be done at this level. Allowable frequencies are: daily, weekly, monthly, quarterly, or annually. All or any combination of these choices are acceptable.
To choose the fifth option select V - Save/Load Settings. This option will save settings for future use and load previous settings you have saved.
+-- Save/Load/Delete Settings --+ | S - Save Settings | | D - Save As Defaults | | L - Load Settings | | V - Load Saved Defaults | | F - Load Factory Defaults | | O - Delete Old Setting | | C - Print Current Settings | +-------------------------------+
S - Save Settings: Allows you to save current setting for future use.
D - Save As Defaults: Allows you to save current settings as defaults. These settings will automatically be active each time you enter SED - Enhanced Invoicing Reports.
L - Load Settings: Allows you to load previously saved settings.
V - Load Saved Defaults: Reloads Saved Defaults.
F - Load Factory Defaults: Loads the Setting that were Shipped with SED - Enhanced Invoicing Reports.
O - Delete Old Setting: Allows you to delete files with old settings.
C - Print Current Settings: Prints a comprehensive report detailing all current settings.
The settings will be saved into the invoicing/receivable data file directory under the name SDXXXXXX.Tcc where XXXXXX is the name specified by the user and cc is the current company ID.
To choose the sixth option select P - Print Document Register. This option will prompt you for the printer destination, your report will then be created and printed.
Your SED - Enhanced Invoicing Report will be followed by a "Report Summary Totals" Section that lists a summary of Sales Invoicing Detail information only. Transactions from Accounts Receivable are not reflected on this report.
+--------------------------------------------------------------------+ | REPORT SUMMARY TOTALS | | TAXABLE NON-TAXABLE GROSS | | ------------ ------------ ------------ | | Sales...........: 1402403.62 310908.79 1713312.41 | | Misc. Debits....: 6332.70 0.00 6332.70 | | Returns.........: 195865.91- 223292.47- 419158.38- | | Misc. Credits...: 5.65- 0.00 5.65- | | Freight.........: 0.00 113.00 113.00 | | ------------ ------------ ------------ | | Sub-Totals......: 1212864.76 87729.32 1300594.08 | | | | Credits.........: 0.00 1120.00- 1120.00- | | Payments........: 0.00 2777.50- 2777.50- | | Adjustments.....: 0.00 11000.00 11000.00 | | Service Charges.: 0.00 0.00 0.00 | | ------------ ------------ ------------ | | Sub-Totals......: 0.00 7102.50 7102.50 | | | | SALES TAXES TAX REFUNDS GROSS | | ------------ ------------ ------------ | | State...........: 49734.25 1219.59- 48514.66 | | County..........: 12433.85 304.87- 12128.98 | | City............: 12433.85 304.87- 12128.98 | | ------------ ------------ ------------ | | Tax Sub-Total...: 74601.95 1829.33- 72772.62 | | | | ============ | | Report Total....: 1380469.20 | +--------------------------------------------------------------------+
Your SED - Enhanced Invoicing Report will then be followed by an Active Settings Report which will give a list of any selection criteria that was not set to All.
+--------------------------------------------------------------------------+ |Report Name......: SETING | |Rpt Description..: Peachtree Default Report | |Post Status......: Posted | |Document Type....: Quotes, Orders, Invoices, BO Orders, BO Invs, Crd Memos| |Payment Status...: Paid, Un-Paid, Partially Paid | +--------------------------------------------------------------------------+
|
