MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Distribution > Order Processing > Screens > Postbilling and Debit/Credit Memo > OP130S04 - Line Detail

OP130S04 - Line Detail

 

 

WILLIAMS     CO  001          ORDER PROCESSING                 BEF     6/03/94

 DSP01        WHS BEL      POSTBILLING AND MEMO ENTRY               LINE DETAIL

 Bill-to  A-1          A-1 SERVICE                                             

 Ship-to  A-1          A-1 SERVICE                     Doc No 00002698 Type IN 

                                                                               

 Line      001             Status  O  OPN             Part Type  MFG           

 Part      BOLT-100        PURCHASING PART            PURCHASING PART2         

 Order Qty      75.000     Base Prc              .630    Price List            

 Ship Qty       75.000     Unit Prc              .630    Price UM       PK     

 Order UM   PK             Ext Prc             47.25     Cust Line Dsc  .00000 

                           Unit Cost        6.0000000    G/M Percent    99.999-

 Slspsn1   SL1  SALESPERSON 1              Slspsn2                             

 Cust Part                                 Price Cd  6   Stk Loc   NOPRLOC     

 Part Msg  001 PART MESSAGE PRINT CODE 1   Apply Dsc Y   Bal Type  D           

 Whs       BEL PICKING & SHIPPING INC                    Job No                

 Ship Via  S1   SHIP VIA CODE 1 FRT        Plan/Unpl P   Lot No    BOLT-100-LOT

 Route     R1  ROUTE ONE DESCRIPTION       VAT Cd        .00000                

 Rsn Code  00  DEFAULT SHIPMENT          Ship Date 06/03/94   Tran Type   SALE 

 Terms     T1  SHIPPING TERMS 01         Prc Date  06/03/94   Tran SType  P  

 Comments  N                             Cash Disc N          Tran Code   N     

                                                                               

 F4=Prompt           F5=Multi-Line       F7=Header           F11=Recap         

 F12=Comments        F13=Cancel Billing  F15=Rekey Data      F24=More Keys     

 

 

The line detail screen is used to update invoice, debit/credit memo, or cash sale document line detail information.  The displayed data fully describes the line including price information and document level defaults that can be overridden.  This screen may be used in addition to the multi-line screen when additional line information is required.

COMPANY/WAREHOUSE

Display only.  The selling company and warehouse for the document.

CURRENCY

Display only.  The currency associated with the customer.  Price information on the screen is expressed in this currency.

BILL-TO CUSTOMER NUMBER/CUSTOMER NAME

Display only.  The invoice, debit/credit memo, or cash sale will appear on the account for this customer.

SHIP-TO CUSTOMER NUMBER/CUSTOMER NAME

Display only.  The customer to which the goods were shipped.

DOCUMENT NUMBER

Display only.  The unique number assigned to this document by the system.  This number is used throughout the system to identify the document.

DOCUMENT TYPE

Display only.  Indicates whether the document is an invoice, debit memo, credit memo, or cash sale.

LINE NUMBER

Display only.  The document line for which detailed information is displayed.  To select another line, press F5 to return to the multi-line screen.

LINE STATUS

Required.  Used to define the line status of the order line that is being maintained.  The line status code can only be changed to C (closed) on the line detail screen.

PART TYPE

Display only.  The part type for the item being billed.  It is retrieved from the item's Part Master File record.  All part types are valid except planning and non-stock.

PART NUMBER/PART DESCRIPTION

Required.  These fields are used only to change part descriptions for nonstandard parts.

ORDER QUANTITY

Display only.  The quantity of the item that was requested.

BASE PRICE

Display only.  Indicates the base price used for the part associated with the shipment line.  The base price can come from a contract, a price list, the Warehouse Balance file, or be manually entered.  This is the price of an item before any of the discounts are applied.  If discounts are used they are applied to the base price.

PRICE LIST CODE

Display only.  Indicates the price list or price list template, if one was used, for the shipment line.  The line was only priced using the Price List if the Price Code is set to A - Price List Pricing.  The price list defaults from the customer.  It is defaulted from the Ship-to Customer; or if it is blanks then from the Bill-to Customer.  If no default is found in either customer, it will default from templates using Reference File category G86.  The Price List cannot be changed if the Firm Price Flag is set to Y - Yes.

SHIPPED QUANTITY

Required.  The quantity shipped or returned for the line.  The ship quantity must be entered unless the item is a reference item.  It cannot be negative.  The sign of this quantity is determined by the adjustment code and document type.

UNIT PRICE

Optional.  The price for each unit of the item.  If you leave this field blank, the unit price will be calculated using the price code and the base price on the item's Warehouse Balance File record.  The price cannot be negative.

If the Value Added Tax (VAT) or Goods and Services Tax (GST) Included flag on the header is set to Y, the price entered in this field must include the VAT or GST.  Note:  This applies only in VAT and GST environments.

If this line represents a gift (pricing code = 8) and the header specifies that VAT will be charged to the customer on gifts (there is no 'GST on gifts'.) The system uses the gift in this field to calculate the tax.  The system does not include this price in the invoice total.

PRICE UNIT OF MEASURE

Optional.  The unit of measure associated with the unit price.  It must be the same as the stockkeeping, selling, or purchasing unit of measure on the item's Part Master File record, or it must be the same as the pricing unit of measure on the warehouse balance record.

ORDER UNIT OF MEASURE

Display only.  The unit of measure associated with the order quantity.

EXTENDED PRICE

Optional.  The ship quantity multiplied by the unit cost.  It cannot be negative.

If the Value Added Tax (VAT) or Goods and Services Tax (GST) Included flag on the header is set to 'Y', any price entered in this field must include the VAT or GST.  Note:  This applies only in VAT and GST environments.

If this line represents a gift (pricing code = 8) and the header specifies that VAT will be charged to the customer on gifts, this field contains the total value of the gift (there is no 'GST on gifts'.)  The system uses the field to calculate the tax.  The system does not include the value of this field in the invoice total.

CUSTOMER LINE DISCOUNT

Optional.  The customer discount to be applied to this line.  One of the discounts is used when calculating the unit price of the line item.  This percentage cannot be greater than the maximum discount limit on Reference File category 029.

UNIT COST

Optional.  Used to define the unit cost of a reference or nonstandard item, items on a direct ship sales order, or items on a credit memo.  The unit cost cannot be negative.

GROSS MARGIN PERCENT

Display only.  Value calculated from the relationship of the extended selling price to extended inventory cost.

SALESPERSON CODE 1 AND 2

Required for salesperson 1.  Optional for salesperson 2.  Associates one or more salespeople with the document.  The description for the code will be printed on order paperwork.  Codes must be defined on Reference File category 315.  In the Sales Analysis module, this sale will be included into the statistics for Salesperson 1.  These fields default from the salespersons entered on header screen (which default from the bill-to customer's Customer Master File record).

CUSTOMER ITEM NUMBER

Optional.  The number the customer uses to identify the item.

PRICE CODE

Optional.  The price code is used in calculating the unit price if the unit price is not entered.  The price code must exist on Reference File category 415.  Once a pricing method is established, prices will be recalculated only if the price code is '9' (for contract pricing) or if it is changed to either '9', 'A', '6', or blanks.  It cannot be changed if the Firm Price flag is set to Y - Yes.  Must be '6' (manual) or '8' (gift) in Value Added Tax (VAT) or Goods and Services Tax (GST) environments where VAT or GST is included in the price.  Optional in all other circumstances.  If the order uses price list pricing, this field will be set to 'A' (price list). 

STOCK LOCATION

Optional.  The location from which the line was picked for shipment or to which it will be returned.  If you leave this field blank, the stock location entered on the header screen will be used.  If no stock location was entered on the header screen, the location from the part's warehouse balance record is used.  The stock location cannot be blanks unless the part is a reference part or the shipment type is direct.

PART MESSAGE CODE

Optional.  Used to attach a message to the document line.  This field defaults to the part message entered on the Part Master File.

APPLY DISCOUNT FLAG

Required.  Indicates whether discounts are allowed to be applied to the base price of this order line.  This field defaults to Y-Yes, except for bundle parts.  This field may be changed as long as the Firm Price flag is not equal to Y - Yes on lines with a price code of 8-Gift.  The valid values for this field are Y - Yes and N - No.

BALANCE TYPE

Optional.  The balance type from which the item was picked or to which it will be returned.  The balance type cannot be blanks unless the item is a reference part or the shipment type is direct.

WAREHOUSE

Optional.  The sourcing warehouse for the line.  It is entered if the sourcing warehouse for this line is different from the selling warehouse entered on the Function Select screen. If the shipment type is direct, this warehouse must be the same as the selling warehouse.

TAXABLE ITEM FLAG/APPLY PST

Required.  This field is used to indicate if the line is taxable or not in a US tax or Provincial Sales Tax (PST) environment.  The system does not calculate taxes for items with a taxable item flag set to 'N'.  Valid values are 'Y' and 'N'.

JOB NUMBER

Display only.  Displayed only if the Job Control module is installed.  If a job number was entered on the multi-line screen, that number is displayed here.

SHIP VIA CODE

Required.  The carrier to be used for shipping the order.  Ship Via codes and descriptions are defined on Reference File category 319.  The description for this code will be printed on order paperwork.

PLANNING FLAG

Required.  Indicates whether this shipment is to be netted against any existing forecast for the related period.  The netting is performed as part of the master scheduling generation process.

U - (Unplanned), The order will be added to the total demand within the Master Schedule generation.

P - (planned), The order will be netted with any forecast in the Master Schedule generation.

LOT NUMBER

Optional.  The lot from which the item was picked for shipment, or to which it will be returned.  The lot number is required for lot-controlled parts.  If the lot is on hold, an error message is displayed and the lot number is reverse imaged.  No inventory may be issued from or received into a lot that is on hold.

SHIPMENT ROUTE

Required.  The route to be used for the shipment.  Shipment route codes and descriptions are defined on Reference File category 320.  The description for the code will be printed on order paperwork.

VALUE ADDED TAX CODE/GOODS AND SERVICES TAX CODE

(Field is VAT CD or GST CD depending on the environment.) Required in VAT and GST environments.  This field designates the VAT or GST tax code for the shipment line.  The system applies the VAT or GST tax code to shipment lines whose home/export flag is 'H' (home).   The system uses the VAT or GST rate associated with the VAT or GST code on the line.  If you enter a code in this field with an exonerated or suspended VAT or GST status, you must enter an authorization number on the Header screen.

VAT ON GIFT

Required.  Indicates whether VAT will be calculated for the gift or no charge line type (price code = 8).  This field will be defaulted from Reference File category M10 if a part sales order message code has been entered and a record exists on the category.  Otherwise, the value will default from the sales order header.  Valid values are:

Y - Yes, VAT will be calculated for the line type.

N - No, VAT will not be calculated for the line type.

ADJUSTMENT REASON CODE

Optional.  The reason this document line was created.  If you leave this field blank, the reason code from the header screen is used.  Reason codes are defined on Reference File category 432.

SHIP DATE

Required.  The date the item was shipped.  It must be less than or equal to today's date.

TRANSACTION TYPE

Required.  Assists in calculating the tax rate for an item.  This field is only displayed if Vertex and US Taxes are used.  Valid values are listed on Reference File category I81. 

TERMS

Optional.  Indicates the delivery terms for the shipment.  Valid values are found on Reference File category 321.  This field defaults from sales order.

PRICING DATE

Display only.  Indicates the date the order line was priced.  The line pricing date defaults from the shipment header.  It cannot be changed if the Firm Price flag is set to Y - Yes.  Note:  the order line pricing date can vary from the header pricing date.

TRANSACTION SUBTYPE

Required.  Assists in calculating taxes when Vertex and US Taxes are used and works in conjunction with the Transaction Type.  This field is only displayed if Vertex and US Taxes are used.  Valid values are found on Reference File category I82.

COMMENTS

Display only.  Indicates whether comments exist for this line.  Possible values are Y (yes) and N (no).  To view or enter line comments, press F12.

CASH DISCOUNT

Display only.  Indicates whether a cash discount was applied to the order associated with this shipment line.  Valid values are Y-Yes a cash discount was applied or N-No cash discount was not used.  The cash discount percent is calculated using the value added tax amount and the net sales amount.

TRANSACTION CODE

Required.  Indicates the type of processing that occurs for this transaction when Vertex and US taxes are installed.  This field is only displayed if Vertex and US Taxes are used.  Valid values are displayed on Category Reference category I83. 

COMMAND KEYS

Enter - Validate screen.

F4    - Used to display valid values for field prompted.

F5    - Display the multi-line screen (OP130S03).

F7    - Display the header screen (OP130S02).

F11   - Display the recap screen (OP130S05).

F12   - Display the comments screen (OP130S06).

F13   - Used to cancel the order that is currently being displayed.

F15   - Clear all fields that you have just entered in order to enter new data.

F16   - Display the Serial Number Assignment Window (OP112S01) in change mode.

F18   - Display pricing/discount information in the Postbilling Line Window (PBLINE).

F24   - Display additional command keys that are valid for the current screen.