Advances Edit MGFT

Entering Advances

The Advance screen MGFT lets you enter:

You can amend or cancel advances and match advances to existing expense claims or refunds.

When you create an advance, any amount that is not allocated to a claim for that advance appears on the next payment schedule as a negative amount. This method ensures that the employee's expenses are not paid without accounting for outstanding advances.

To create an advance using a payment schedule, click the check box at Generate Payment on the Advance screen MGFT. Leaving this field blank indicates that you have already made the payment. You can attach this type of advance to a payment schedule in payment processing, reducing the amount paid on an expense claim. The advance appears in payment processing as a negative amount.

After you enter the advance, the system assigns a reference number to the advance.

If the advance requires a payment, the status is Awaiting Payment and the system issues the payment during the next automatic payment run. If you cancel an advance, the status is Cancelled.

You can generate foreign currency advances using the Advance screen MGFT but not multi-currency advances. You must create a separate advance for each currency.

Entering an Advance that will Create a Payment

  1. Enter Company, if different to the default and Employee, System Reference or Advance Reference in the selection window and click Edit | Insert from the pull-down menu.
  2. Enter the following fields on the Main format of the Advance screen MGFT:
    1. Enter an Employee code, up to twelve characters. The system displays the employee's name and first two address lines when you right click.
    2. Enter an Advance Reference number, up to 16 alphanumeric characters. The system checks the database for the same transaction reference for this employee. If recording an off-system advance, for example from petty cash or a handwritten cheque, enter the petty cash voucher number or cheque number. If you are adding an unpaid advance, enter an internal reference number.
    3. In Generate Payment, click the check box to generate payments automatically.
    4. If you are using ICA, enter an element that is associated with the employee. 
    5. In Advance Value, enter the payment value. This value can be negative if recording a refund or zero if recording bank charges. The default is zero.
    6. If desired, enter any optional fields. Fields on the Currency format are optional. Enter additional information on this format by clicking the Currency tab.

Click Update to enter the advance. If there are warnings, accept the warnings by clicking Warnings | Accept Warnings and clicking the Update button again.

Amending an Advance

  1. Enter Company, if different to the default, in the selection window and either Employee, System Reference or Advance Reference and click OK.
  2. Select the advance you want to amend and click Edit | Amend.
  3. Enter changes on the Advance screen MGFT.
  4. Click Update to accept the changes to the screen. If there are warnings, accept the warnings by clicking Warnings | Accept Warnings and clicking Update again.

Entering a Paid Advance

  1. Double-click Accounts Payable Main Menu on the e5 Main Menu.
  2. Double-click Expense Ledger Menu on the Accounts Payable Main Menu.
  3. Double-click Advances on the Accounts Payable Expenses Menu.
  4. Enter Company, if different to the default and Employee, System Reference or Advance Reference in the selection window and click Edit | Insert from the pull-down menu.
  5. Enter the following fields on the Main format of the Advance screen MGFT:
    1. Enter an Employee code, up to twelve characters. The system displays the employee's name and first two address lines when you right click
    2. Enter an Advance Reference number, up to 16 alphanumeric characters. The system checks the database for the same transaction reference for this employee. If recording an off-system advance, for example from petty cash or a handwritten cheque, enter the petty cash voucher number or cheque number. If you are adding an unpaid advance, enter an internal reference number.
    3. In Advance Value, enter the payment value. This value can be negative if recording a refund or zero if recording bank charges. The default is zero.
  6. Click Update to enter the advance. If there are warnings, accept the warnings by clicking Warnings | Accept Warnings.

Entering Advance Refunds

An employee might not use an entire advance. The employee returns the unused portion, which you then enter into the system. To enter an advance refund, follow the same steps as entering a paid advance. However, you must enter a negative amount for the Advance Value on the Advance screen MGFT. Also enter a negative amount in Gross Amount on the Advance Allocation screen MGFT.

Allocate the advance refund to the original advance to reduce the unallocated balance. You can enter a minus sign before or after the amount to record the negative amount.

If the advance value is less than the employee minimum payment value, a warning message appears. You can accept the warning by clicking Warnings | Accept Warnings.

Cancelling an Advance

You may need to cancel an advance after it is issued.

  1. Double-click Accounts Payable Main Menu on the e5 Main Menu.
  2. Double-click Expense Ledger Menu on the Accounts Payable Main Menu.
  3. Double-click Advances on the Accounts Payable Expenses Menu.
  4. Enter Company, if different to the default Employee in the selection window and click OK.
  5. Select the advance you want to cancel and click Edit | Cancel.
  6. Click Update on the Advance screen MGFT.

Matching Advances to Expense Claims

You can match advances to expense claims to assure that the employee receives the correct payment. When you match an advance to an expense claim, the status of the expense changes to Fully Paid or Partially Paid and the status of the advance changes to Fully Allocated or Partially Allocated. The status of advances and expense claims depends upon how much of the advance you allocate to the expense claim.

  1. Double-click Accounts Payable Main Menu on the e5 Main Menu.
  2. Double-click Expense Ledger Menu on the Accounts Payable Main Menu.
  3. Double-click Advances on the Accounts Payable Expenses Menu.
  4. Enter Company, if different to the default, in the selection window and either Employee, System Reference or Advance Reference and click OK.
  5. Select the advance with which you want to match a claim and click Edit | Amend.
  6. Click Allocation on the Advance screen MGFT to access the selection window.
  7. Enter System Reference, Transaction Ref, From Entry Date or To Entry Date at the selection window and click the Fetch button to list the claims that matched your entry.
  8. Select the expense claim with which you want to match an advance on the Advance Allocation screen MGFT and perform the following action(s) as necessary:

The system displays an asterisk (*) beside each transaction you marked and displays Advance Value.

  1. Click Update to accept the changes to the screen.

Screen Specific Actions (Header)

Action

Description

GO CURRENCY CALCULATION

Click Go | Curr Calc to display the Calculation Enquiry screen MAGU which shows how a base currency value is derived from a foreign value. This action is only available when using foreign currency or when the batch currency is not the base currency.

GO ALLOCATION

Click Go | Allocation to display the Advance Allocation screen MGFT. This action is only available if Generate Payment on the Advance screen MGFT is blank.

Screen Specific Actions (Allocation)

Action

Description

INQUIRE ACCOUNTS PAYABLE

Click Inquire | Accounts Payable to display the Supplier Transaction screen MGEA, for viewing the current supplier account.

GO HEADER

Click Go | Header to display the Miscellaneous Payments Header screen MGGM.

RETRIEVE TRANSACTIONS

Click Retrieve | Transactions to display a selection window for retrieving transactions for allocation. Enter System Reference, Transaction Reference, From Entry Date and To Entry Date and click the Fetch button to retrieve the required transaction.

TRANSACTION PAY

Select a transaction and click Transaction | Pay to select the transaction for allocation. The status of the selected transaction becomes F/Paid.

TRANSACTION AMEND AND PAY

Select a transaction and click Transaction | Amend Pay to amend the Gross Advance and selects the transaction for allocation. The transaction status becomes P/Paid or F/Paid.

TRANSACTION NO PAY

Select a transaction and click Transaction | No Pay to deselect the marked transaction which reduces the advance value to zero.

SEARCH OR/AND

These actions are used with search fields on the Advance Allocation screen MGFT to retrieve criteria you enter. Click Search | And and enter two or more fields to retrieve transactions that meet the criteria. Click Search | Or and enter two or more search fields to retrieve transactions meeting one or the other.

GO CURRENCY CALCULATION

Click Go | Curr Calc to display the Calculation Enquiry screen MAGU which shows how a base currency value is derived from a foreign value. This action is only available when using foreign currency or when the batch currency is not the base currency.

If not described in this topic, click on a field and press F1 to view help. See Common Fields for more information.

Fast prompt allows you to quickly view a list of options for certain fields.

NOTE Field visibility can be defined by your System Administrator, so not all fields documented may be shown.

See Using the Command Line on opening the screen without going through the menu.

See also

Accounts Payable Advances List MGFS

Accounts Payable Home Page