IdealWare Online Users Manual

SP4-04 S/P MAINTENANCE
31606 Line Types Maintenance

 

PURPOSE

 

The line types maintenance program is used to add, modify and delete line type codes. Line type codes are used to relate detail line descriptions and G/L codes with specific sales order line types. The G/L codes are referenced when the sales or refunds are processed through the order register and update program.

 

Line type codes are specified in the following programs:

  • Cash Till Sales Entry. See 31543 - CASH TILL SALES ENTRY,  SALE/REFUND DETAIL LINE ENTRY - Procedure Other Line.
  • Sales Order Entry. See 31668 - SALES ORDER ENTRY, DETAIL ENTRY OTHER LINES.
  • Batch Order Entry. See 31538 - BATCH ORDER ENTRY and 31668 - SALES ORDER ENTRY, DETAIL ENTRY OTHER LINES.

The following line types must exist for the cash till sales and sales order entry programs to work correctly. These line types are included in the line types file. However, the G/L codes for these line types must be set to match your G/L configuration.

 

Code   Description

 

?   =  Entered at Input

CI  =  CARTAGE (INSIDE)

CO  =  CARTAGE (OUTSIDE)

CP  =  CUSTOMER PAYMENT TO

D   =  DESCRIPTION ENTRY

GT  =  GOODS AND SERVICES TAX

IC  =  INVOICED CHARGE SALE HOLDING

IS  =  INVOICE CASH SALE HOLDING

P   =  PRODUCT

PT  =  PROVINCIAL SALES TAX

 

Line Types Maintenance is accessed from:

  • Cash Sales Maintenance menu.

 

PROCEDURE

 

Select Line Types Maintenance from the Cash Sales Maintenance menu. The line types maintenance screen displays.


INVOICE LINE TYPE MAINTENANCE DISPLAY

┌────────────────────────────────────────────────────────────────────────────────┐
│07/19/08                    D E M O   C O M P A N Y                             â”‚
│                         INVOICE LINE TYPE MAINTENANCE                          â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│          LINE TYPE CODE              __                                        â”‚
│                                                                                â”‚
│       1. LONG DESCRIPTION                                                      â”‚
│       2. SHORT DESCRIPTION                                                     â”‚
│       3. G/L CODE                                                              â”‚
│       4. PST CODE                                                              â”‚
│       5. GST CODE                                                              â”‚
│       6. FST % CODE                                                            â”‚
│       7. AUTOMATIC/MANUAL                                                      â”‚
│       8. CASH SALE OR INVOICE                                                  â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
LINE TYPE CODE

 

Enter code of line type to add, modify or delete.

 

To add a new code see ADD A CODE. To modify or delete an existing code see MODIFY AN EXISTING CODE.

 

 

[F2] to display next line type code on file.

 

To scan remaining codes, press [Enter] at the code display. This clears the LINE TYPE CODE field. Then press [F2] to display the next line type code on file.

 

 

[F4] to exit to menu.

 

[F5] to display list of line types for selection.

 

Example Line Types Maintenance Screen display:

┌────────────────────────────────────────────────────────────────────────────────┐
│07/19/08                    D E M O   C O M P A N Y                             â”‚
│                         INVOICE LINE TYPE MAINTENANCE                          â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│          LINE TYPE CODE              CI                                        â”‚
│                                                                                â”‚
│       1. LONG DESCRIPTION            CARTAGE OUT                               â”‚
│       2. SHORT DESCRIPTION           DLVRY                                     â”‚
│       3. G/L CODE                    XX-5600                                   â”‚
│       4. PST CODE                    N           NON-TAXABLE                   â”‚
│       5. GST CODE                    Y           FULLY TAXABLE                 â”‚
│       6. FST % CODE                  N/A                                       â”‚
│       7. AUTOMATIC/MANUAL            M           MANUAL                        â”‚
│       8. CASH SALE OR INVOICE                    INVOICE OR CASH SALE ENTRY    â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│** FIELD NUMBER TO MODIFY; 'D' TO DELETE; CR TO CONTINUE: _                     â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘

ADD A CODE

 

If you enter a code which is not defined the following prompt displays.

 

** NOT ON FILE. DO YOU WANT TO ADD ? (CR=YES/F2=NO):

 

[Enter] to add a new code.

 

The program will step you through each field (see FIELDS below). Once all fields have been entered, the following prompt is displayed:

 

 

** OK TO UPDATE? (CR TO UPDATE; F2 TO MODIFY; F4 TO BYPASS):

 

[Enter] to accept and update.

 

[F2] to modify.

 

See MODIFY AN EXISTING CODE below.

 

 

[F4] to not add the code and return to CODE field.

 

[F2] to not add a new code.

 

You may enter a different NEW code, an existing code or press [F4] to exit.

 

 

 

 

MODIFY AN EXISTING CODE

 

If you enter an existing code you will be prompted whether or not you wish to modify or delete the code.

 

** 'M' TO MODIFY; 'D' TO DELETE; CR TO CONTINUE:

 

[Enter] to clear the display and return to the CODE field.

 

"M" to modify data fields.

 

** FIELD NUMBER (CR TO CONTINUE):

 

Enter the number of the field you wish to modify.

 

Once you have modified the field data (see FIELDS below) press [Enter] to return to this prompt where you may enter the number of additional fields to modify or press [Enter] again to end modifications.

 

 

[Enter] for modifications complete.

 

** OK TO UPDATE? (CR TO UPDATE; F2 TO MODIFY; F4 TO BYPASS):

 

[Enter] to accept changes and update the file.

 

The file is updated and you are returned to the CODE field.

 

 

[F2] to make additional modifications to the fields.

 

You are returned to the FIELD NUMBER prompt above.

 

 

[F4] to cancel all changes and return to CODE field.

 

"D" to delete the code.

 

** OK TO DELETE? (Y/N):

 

"Y" to delete the code.

 

"N" to not delete the code.

 

 

FIELDS

 

LINE TYPE CODE

 

Enter a 2 character line type code.

 

LONG DESCRIPTION

 

Enter a 30 character description.

 

SHORT DESCRIPTION

 

Enter a 7 character description. This description is displayed when the line type is specified during cash till sales entry and Sale Order Entry.

 

GL CODE

 

Enter the sales G/L account that will be affected by sale detail lines that reference this line type.

 

PST CODE

 

This field indicates how Provincial Sales Tax applies to this line type.

 

"N" for no PST to be calculated for line type.

 

"?" for PST to be determined at time of line input.

 

"Y" for fully PST taxable.

 

GST CODE

 

This field indicates how Goods & Services Tax applies to this line type.

 

"N" for no GST to be calculated for line type.

 

"Y" for fully GST taxable.

 

FST % CODE

 

Not used.

 

AUTOMATIC/MANUAL

 

This field indicates whether the line type can be specified by the operator during sale entry. This field can only be modified by an IdealWare consultant.

 

"A" to indicate automatic (internal) use by system only.

 

This line type cannot be specified during sale entry.

 

 

"M" to indicate this line type can be specified during sale entry.


CASH SALE OR INVOICE
ENTER 'I' IF INVOICE ONLY, 'C' IF CASH SALE ONLY OR PRESS CR FOR EITHER.

 

[Enter] to indicate line type applicable to both account and cash sales.

 

"I" to indicate line type applicable to account sales only.

 

"C" to indicate line type applicable to cash sales only.