Inter Account Type Transfer {FSAO-2}

If an invoice/credit note has been debited/credited to the wrong debtor/creditor account or account type, but the posting to the General Ledger is correct, this option may be used to create a Transfer between the accounts or account types, to correct the error, using the subsystem control GLA and suspense GLA. This option is made up of 2 parts, "Inter-Account Transfer" and "Query Inter-Account Transfer" (accessed via the "Query" button).

"Inter-Account Transfer" is made up of 2 panel boxes, "From Transaction" and "To Transaction". There is also a seperate field to enter the "To Subsystem".

"Query Inter-Account Transfer" is made up of 4 panel boxes. "Search", "Search Result", "From Transaction" and "To Transaction".

The same program is used for options {FSAO-2}, {FARO-2}, {CMEO-4} and {FPMO5-3} with the exception that the, "from subsystem" is determent by the calling option and the "to system" must be specified by the user.

The option is designed to do inter-account transfers between subsystem PM, SD, AR and/or CM and/or between accounts/account types in the mentioned subsystems.

Important Notes:

If the "from" and "to" subsystem and "from" and "to" person number are the same, the Account Types should be different.
The currency codes of the "from" and "to" person number can be different.
Caution should be taken in using this option because the system will in principle, allow people from one subsystem to change/transfer values to another subsystem.
This transactions, of subsystems SD and AR, can be printed under options {FAROR1-5} and {FSAOR1-7}.

The following is a summary of definitions and actions that must exist before the user can process a document in this option:

Access to the option {USERS-2, USERS-3} on level "Update" as "Select" users cannot use this option.
Transaction Types for inter correction Events {FCSO-7}

The users have no control over the Transaction Type field in this option, it is maintained by the program. Transaction Types must be defined in option {FCSO-7} for the following events.

Event	Description	Type of Document
AC	PM - Credit Creditor Correction	II
AD	PM - Debit Creditor Correction	CD
30	SD - Inter Account Type DT Transfer
31	SD - Inter Account Type CR Transfer
TA	AR - Transfer DT Amount	D
TB	AR - Transfer CR Amount	C
MX	CM - Inter-Account Transfer DT
MZ	CM - Inter-Account Transfer CR

On the Transaction Type definition of the events below, all suspense GLA's must be the same and the control GLA must be null. The system will use the account type GLA as the control GLA.

Event Type	Debit GLA	Credit GLA	Sign of transaction type
AC	Suspense	Control	C
AD	Control	Suspense	D
30	Control	Suspense	D
31	Suspense	Control	C
TA	Control	Suspense	D
TB	Suspense	Control	C
MX	Control	Suspense	D
MZ	Suspense	Control	C

A list of actions the user can perform in this option.

Query a transaction

Insert/Create a transaction

A list of actions the user cannot perform in this option.

Maintain a document

Delete a document

Inter-Account Transfer Example:

Fields in the option:

From and To Subsystem Fields:

Field	Type & Length	Description
From Subsytem	A2	Valid values are PM (Procument Management), SD (Student Debtors), AR (Accounts Receivable) or CM (Meal System). The system will default the subsystem where this program was called. This field is not updateable by the user.
To Subsystem	A2	Valid values are PM, SD, AR or CM. The user must complete this field in order to proceed with the transaction.

Panel Box 1: From Transaction.

Field	Type & Length	Description
Person Type	A1	Valid values are (C)reditor, (D)ebtor, (S)tudent, (P)ersonnel or (O)ther. The program, depending on the "from subsystem", will default "C" for PM, "D" for AR, "S" for SD and the values cannot be changed. In the case of subsystem CM the user must enter one of the following values "S", "P" or "O".
Person Number	N9	If a valid value is entered in this field, the "Person Name, Currency Code and Description, and Currency Rate will display. The General Ledger Note Field will also populate.
Debit/Credit	A1	Valid values are "D-Debit" and "C-Credit". Upon selection of a value, the following fields will populate. Transaction Type, Debit Cost Centre / Credit Cost Centre depending on the value selected, Note,
Transaction Type	N4	The system will supply a valid, appropriate Transaction Type on Debit/Credit value selection, as defined in option {FCSO-7} and the user cannot change this value. The system will use the Transaction Type that was linked to the events as described above and the description of the Transaction Type will display, using the from subsystem and C/D indicator fields.
From Account Type	A4	Enter a valid Account Type for the from subsystem and the account type name will be displayed. A list function will display all valid Account Types and name. Rules if subsystem is SD SD Account Type must be linked to the student in option {FSAO-13}. The account type cannot be one of the default account types that are linked to system operational definition codes SC, SL or SM of the subsystem SD. The list of values will only be restricted to SD accounts types where the "Show Account Type - Yes / No " flag, on the account type {FCSC-21}, is set to Yes.
Debit Cost Centre	A6, A8	The system will default this Cost Centre and Account either from the Transaction Type or the Account Type GLA and the description of the Cost Centre and Account will display.
Credit Cost Centre	A6, A8	The system will default this Cost Centre and Account either from the Transaction Type or the Account Type GLA and the description of the Cost Centre and Account will display.
Payment Agreement	A4	Only mandatory if the from subsystem is SD and the payment agreement must be linked to the From Account Type and student in option {FSAO-13} and the description of the payment agreement will display. A list function will display all valid payment agreements and names for the Account Type and student.
Note	A30	Enter a note to accompany the transaction to the subsystem. The system will default the Transaction Note or Alternate Note, of the transaction type depending on the language indicator of the person number, into the field and the user may change it.
GL Note	A30	Enter a GL note to accompany the transaction to the GL. The system will default the person name into the field and the user may change it.
Currency Code	A3	This fields populates when the user enters a valid Person Type, this is a read only field.
Currency Rate	N7.3	The system will default the currency rate using the person number currency code and the currency definitions in option {FCSO-21}. The user may update the default value if the field Updateable (Y/N) is (Y)es for the subsystem and type of document in option {FCSO-21}, TAB - Subsystem Type of Exchange Rates, if the currency code is not local currency.
Given Currency Value	N15.2	Enter the value to be transferred in the currency of the person number.
Local Currency Value	N15.2	The system will calculate the value for local currency using the given currency times the currency rate.
VAT Rate Code	A2	Enter or select from the list of values the VAT Rate Code linked to the VAT percentage applicable to the inter account transfer. The VAT Rate Code and percentage are maintained in option {FCSC-1}. The system will default the VAT percentage linked to the code into the VAT Rate. The VAT Rate Code on the "TO" tab is not updateable.
VAT Rate	N3.2	The VAT rate applicable to the inter account transfer. If a rate of greater than 0.00 is entered on commit a Father and Output VAT record will be generated. These VAT records are flagged as reported for VAT 201 purposes as the affect on VAT is zero. To ensure that the VAT affect is always zero the "FROM" and "TO" VAT rate's must always be the same therefore the VAT rate on the "TO" tab is not updateable.
Reference	A10	Enter a reference number to accompany the transaction to the subsystem.
Loan Code	A10	Only an active field if the subsystem is AR and the account type AR category is equal to "L" (Student Loans) {FCSC-21}. If active: specify the Loan Code as linked in option {FBLO-22}, TAB Bursary Debtor Detail, to the AR debtor and related student. The system will not allow a Loan code that was fully paid by the debtor.
Reference Date	DD-MON-YYYY	This is the date at which the transaction happened. The system will automatically populate this field.

Panel Box 1: To Transaction.

Field	Type & Length	Description
Person Type	A1	Valid values are (C)reditor, (D)ebtor, (S)tudent, (P)ersonnel or (O)ther. The program, depending on the to subsystem, will default "C" for PM, "D" for AR, "S" for SD and the values cannot be changed. In the case of subsystem CM the user must enter one of the following values "S", "P" or "O".
Person Number	N9	If a valid value is entered in this field, the Person Name, Currency Code and Description, and Currency Rate will display. The General Ledger Note Field will also populate.
Debit/Credit	A1	Valid values are C-Credit and D-Debit. This Field populates automatically based on the user selection (C-Credit and D-Debit) at the From Transaction Panel Box. The value on this Field is the opposite of the user selection at the From Transaction Panel Box. The user cannot update this value..
Transaction Type	N4	The system will supply a valid, appropriate Transaction Type Code, as defined in option {FCSO-7} and the user cannot change this value. The system will use the Transaction Type that was linked to the events as described above and the description of the Transaction Type will display, using the to subsystem and C/D indicator fields.
To Account Type	A4	Enter a valid Account Type for the to subsystem and the account type name will be displayed. A list function will display all valid Account Types and name. Rules if subsystem is SD SD Account Type must be linked to the student in option {FSAO-13}. The account type cannot be one of the default account types that are linked to system operational definition codes SC, SL or SM of the subsystem SD. The list of values will only be restricted to SD accounts types where the "Show Account Type - Yes / No " flag, on the account type {FCSC-21}, is set to Yes. If both from and to subsystem is SD and the person numbers are the same then the from and to accoun types must be different.
Debit Cost Centre	A6, A8	The system will default this cost centre and account either from the transaction type or the account type GLA and the description of the cost centre and account will display.
Credit Cost Centre	A6, A8	The system will default this Cost Centre and Account either from the Transaction Type or the Account Type GLA and the description of the Cost Centre and Account will display.
Payment Agreement	A4	Only mandatory if the the subsystem is SD and the payment agreement must be linked to the To Account Type and student in option {FSAO-13} and the description of the payment agreement will display. A list function will display all valid Payment Agreements and Names for the Account Type and student.
Note	A30	Enter a note to accompany the transaction to the subsystem. The system will default the Transaction Note or Alternate Note, of the transaction type depending on the language indicator of the person number, into the field and the user may change it.
GL Note	A30	Enter a GL note to accompany the transaction to the GL. The system will default the person name into the field and the user may change it.
Currency Code	A3	A display field only. The system will use the currency code of the person type and number
Currency Rate	N7.3	The system will default the currency rate using the person number currency code and the currency definitions in option {FCSO-21}. The user may update the default value if the field Updateable (Y/N) is (Y)es for the subsystem and type of document in option {FCSO-21}, TAB - Subsystem Type of Exchange Rates, if the currency code is not local currency.
Value Given Currency	N15.2	The system will calculate the value for given currency using the local currency divided by the currency rate. The user cannot change the value.
Value Local Currency	N15.2	The system defaults the from local currency into this field and cannot be changed.
VAT Rate Code	A2	Displays the VAT Rate Code as entered on the "FROM" panel box.
VAT Rate	N3.2	Displays the VAT Rate as entered on the "FROM" panel box.
Reference Number	A10	The system defaults the from reference number into this field and cannot be changed.
Loan Code	A10	Only an active field if the subsystem is AR and the account type AR category is equal to "L" (Student Loans) {FCSC-21}. If active: specify the Loan Code as linked in option {FBLO-22}, TAB Bursary Debtor Detail, to the AR debtor and related student. The system will not allow a Loan code that was fully paid by the debtor.
Reference Date	DD-MON-YYYY	The document date of the transaction. The system defaults the from reference date into this field and cannot be changed.

Query Inter-Account Transfer Example:

Query Inter-Account Transfer:

Field	Type & Length	Description
Person Type	A1	Valid values are (C)reditor, (D)ebtor, (S)tudent, (P)ersonnel or (O)ther. The program, depending on the from subsystem, will default "C" for PM, "D" for AR, "S" for SD and the values cannot be changed. In the case of subsystem CM the user must enter one of the following values "S", "P" or "O".
Person Number	N9	This is a Person Number for a Person which a user need to display a transaction record/s for.
Reference Date	DD-MON-YYYY	This is a date during which a specific transaction was performed.
Given Currency Value	N15.2	This is the currency of a person the search is being performed on.
Reference	A10	This is a specific transaction reference as entered by the user when the transfer happened.

Processing Rules
	No special processing rules

Date	System Version	By Whom	Job	Description
17-Apr-2007	v01.0.0.0	Amanda Nell	t130150	New manual format.
23-Jun-2008	v01.0.0.1	Marchand hildebrand	t150393	Add VAT to SD and AR inter account transfers
25-Mar-2009	v01.0.0.1	Ernie van den Berg	t157364	Review the manual.
25-Apr-2009	v01.0.0.1	Marchand Hildebrand	T152121	Review the manual
29-Sep-2017	v05.0.0.0	Ntshabele Morgan	T220063	Update images
27-Jun-2019	v04.1.0.0	Maitakhole Isaac Matshela	T236937	Update spelling mistake.