Stock Sales Retrurns {FPMO4-11}

This option allows for the maintenance of Stock Sales Returns where stock are sold to Student or Debtors on credit or for cash. An Issue, document types SD, SE or SH, is a pre-requisite for  to process a Return. 

The following must be set up before the user can process a stock sales return in this option.

• Access Restrictions on Document Type  {FCSM-4}.

• To process a return the user must have PM processing access by  linking the user to PM Access Restrictions.  

• The Rules are:

• If linked to FP the user cannot be linked to FPS or FPS% and visa versa.
• If linked to FPS the user cannot be linked to FP or FPS% and visa versa.
• If linked to one of the following Access Restriction: FPSA, FPSC, FPSD, FPSF, FPSH, FPSK, FPSL or FPSP  the user can also be linked any other of these restriction but not FP or FPS

• Set System Operational Definitions {FCSM-1}, TAB - System Operation Definitions
  

• Transaction Types for Stock Return {FCSO-7} 
• Returning stock sold on credit or cash the following transaction are generated.
• Stock Return -SH, SF, SN
• Sales Reversal - events TM, TL,TN
• Cost Sales Reversal - event TK
• Output VAT is generated using the link transaction on event the sales transaction type.
• Input VAT is generated using the link transaction on event the cost of sales transaction type.
• The users have no control over the Transaction type in this option, it is maintained by the program.
• Transaction Types must be defined in option {FCSO-7} for the following events.

• It is mandatory to complete this block before the users can access Block 2.
• The user will select the type of return document to process.
  
• On tab from the document type field the document number will be allocated to the return document.
  
• The user will select the store to return the item to and tab to the orginating document fields.
• Originating document - A pre-requisite to process a return is an issue, referred to herein as the originating document. The originating document information is used to fill the same fields on the return.     
  Originating Document Type - The originating document type is associated with the document type of the return document and defaults as follows
      

  Type of  Stock Sale	Return Document Type	Originating Issue Document Type
  Accounts Receivable Credit Sales	TD	SD
  Student Debtor Credit Sales	TE	SE
  Cash Sales	TH	SH

  
  Originating Document Number - The issue document number on which the items being returned were issued.    
  Originating Line Number - The user can either return all items on an issue or a specific item. Selecting a line number only copies the lines issue information into the return, selecting line zero (0) copies all lines into the return.
• On navigation to block 2 the return documents lines are filled from the orginating document infornation. 
  

Field	Type & Length	Description
Document Type	A2	The issue document type to use for the stock item issue. Valid document types for stock sales are TD -Return Credit Sales Accounts Receiveable , TE- Return Credit Sales Student Debtors and TH- Retrun Cash Sales. Return document types are maintained by ITS and may be queried in option {FCSO-23} and are controlled by a sequence (Range 61 to 89).  Pop up Menu - available on field document number. LOV Type of Documents - Lists issue document types and descriptions.
Document Number	A10	Document number may be entered by the user or can be generated by the program. To automatically generate a document number the system operational definition code AR must be set to (A)automatic or (B)oth. Auto generated numbers (consisting a prefix and number) are maintained in the option Auto Generated Numbers {FCSM-3}. A document  number is obtained by the program from the Auto Generated Numbers where the code equals  "K1 - STORE RETURN/EQUIVALENT NUMBER".  To manually allocate a document number to a issue the system operational definition code AR must be set to (M)anual or (B)oth. If set to (M)anual the user is required to enter a document number.   If set to (B)oth the user may manually enter a document number else on enter or navigation from the field the program will allocate the number from the auto generated numbers. "K1- STORE ISSUE/EQUIVALENT NUMBER"
Store Code	A2	The store code to which to return the items. Items cannot be returned to another store as form which the item was issued. Store codes are defined under option {FPMM-22}.  If the user is restricted to a store through having a store code linked to the user in the option "Finance User Access Control" {FCSM-5}, the store will default and cannot be changed by the user. Pop up Menu - available on field store code LOV Stores - Lists store codes and names.
Return  From Type	A2	The document type of the original stock sale issue form which the item will be return. A stock issue is a pre-requisite for a stock return. The return from document type is determined by the type of return. An AR Stock Sales Return (TD) will set the return from type to (SD) AR Stock Sales Issue. Type of  Stock Sale Return Document Type Originating Issue Document Type Accounts Receivable Credit Sales TD SD Student Debtor Credit Sales TE SE Cash Sales TH SH
Debtor Code	N9	A student or other (AR) debtor number. If the stock sale return relates to a stock sales issue, the debtor number of the student or other debtor. The list of values will change between student debtord and other debtors (AR) depending on the return and return from documnt type.  The list of values available on the field will list the code and name of debtors where a store issue from the store exists for the debtor.
Return from Document	A10	The list of values contains issue document and line numbers on which items were issued from the store on the document type to the debtor. For each document apart from the lines listed, the list of values also contains a line (0) zero.  If the user wants to return the complete document the user should select line (0) zero and go to the next block else if the user returns a specific line the user must select the specific line number field.
Line Number	N3	Selecting a line number only copies the lines issue information into the return, selecting line zero (0) copies all lines into the return.
Account Type	A4	Account Type is copied form the originating issue document for a stock sales return and cannot be updated by the user.
Payment Agreement	A4	Payment Agreement is copied form the originating issue document for a stock sales return and cannot be updated by the user.

Example:

 

Block 2:  Stock Issues Item Detail

Field	Type & Length	Description
Item Code	N8	The item codes of the items selected to be returned from the original document. The user is not allowed to make any changes or add items to the return.
Description	A30	The item description of the item is displayed.  The field is not accessible to the user.
Available Quantity	A8	The total quantity available on the item on the issue (original document) to be returned. The field is not accessible to the user.
Return	N6.3	The number of units to be returned. The return quantity defaults from the available quantity on the original document. The user can reduce the default available quantity but may not increase the available quantity.
Issue Price	N15.2	The unit price of one issue unit at which the item were sold. The  Issue Price copied form the originating issue on a stock sales return cannot be changed by the user.
Mark Up %	N5.2	The mark-up % of the item as per original issue document. The  Mark-Up % copied form the originating issue on a stock sales return cannot be changed by the user.
Cost Price	N15.2	The calculated cost of the item. Cost  cannot be change by the user.
Total	N15.2	Displays the item detail total value in local currency VAT inclusive for the line.
Expense GLA Cost Centre and Account	A4 + A8	The value defaults from the original document and cannot be changed by the user. Pop Up Menu - available on fields Cost Centre and Account. Cost Centre / Account Description - Displays the cost centre and account description for the various fields. Show Date And Time - Displays the date and time the transaction was processed.
GL Note		The GL Note of the item as per original issue document. The GL Note copied form the originating issue on a stock sales return cannot be changed by the user.
VAT Rate		The VAT Rate of the item as per original issue document. The  VAT Rate copied form the originating issue on a stock sales return cannot be changed by the user.
Total Returned Value	N17.2	Displays the total stock sales reurn value for the document.

Example:

 
Example:

 

Processing Rules
No special processing rules

History Of Changes

Date	System Version	By Whom	Job	Description
06-Oct-2009	v02.0.0.0	Marchand Hildebrand	t158613	Create Manual