Invoice entry

  1. In the menu, expand Base Modules Accounts Payable > Entry and double-click AP Invoice Entry. APE010 Invoice Entry/Maintenance selection panel appears. 
  2. Enter/select the following information, as necessary.
Field Description
Company

A Company number is allocated to associate the creditor with a specific company. The default company number is taken from TMSAP/CONO and can be overridden. A Payment Cycle is specified by Company. The Company number can also default from the original transaction as in the case of Already Paid Invoices

Period  In Invoice/Credit Note Entry process the current accounting period for the Accounts Payable module defaults.  Default accounting periods are found in TMSAP/PERIOD.  The default is updated by the month end processing routine. Postings are allowed for the current and next month’s accounting period, thus reducing bottlenecks at the beginning of the accounting month. The system displays the message: WARNING … period keyed in is next month’s. 
Creditor 

The Creditor number uniquely identifies the creditor. The system can automatically generate account numbers for new creditors using the format of Company number, Creditor type plus 10 numeric characters.  The starting number defaults from the last number on file and will automatically increase by 1 when a new record is filed. In TMSAP/CN Creditor number creation formula, the user indicates whether numbers are to be automatically generated or allocated manually.

The number file AP-CREDNO is used when generating a creditor account number.

 
  1. Click OKAPE010 Invoice Entry/Maintenance panel appears.
View fields on this panel
Field Description
Cred ref  This can be a manual creditors invoice number (or Credit note or Claim number) taken from a document presented rather than the system generated Invoice/Credit Note number.  The creditor’s transactions in both the current and history files are checked to ensure duplicate invoices are not processed.  If a reference has already been used the message: Duplicate creditor reference already exists displays. 
Authorisation

For Invoice/Credit Note Entry processing a user defined, default authorisation code displays, if the invoice Authorisation control switch has been set to Yes. This switch is set in TMSAP/AUTHCTL. This field does not display if the switch is set to No. The default can be overridden.

The default Authorisation code is established in TMSAP/AUTC-DFT and can be overridden in this panel.

An authorisation code is used to indicate who must authorise invoices for payment. The list of authorised people prints on the Authorisation Sheets and the order in which the initials are printed is used to guide the sequence of the paperwork from one authorised person to the next. Once the required authorisations have been obtained the invoice can be approved for payment via the Maintain Unapproved Invoices program. Up to 10 people can be nominated for each authorisation code.

Document date 

The document date defaults to the current system date and should be overridden to reflect the Invoice/Credit Note date. The payment due date is calculated using this date plus the Payment terms parameters.

For example if the Document date is Sept 21 and the Payment terms are 30 days from invoice date, the Due date will be Oct 30. 

Exch rate  This is conversion factor from one currency to another. 
Document total  Creditors Invoice/Credit Note total is entered as the Document total.  For credits the amount defaults from the original invoice but can be changed prior to the invoice being approved. This total invoice/credit note value is inclusive of GST.  This creditors invoice total is the cheque value for Already Paid Invoices
Tax category

The Tax categories define the specific tax registration status of the individual creditors by applying the appropriate rules to handle each classification. The creditors tax category is established on the Creditors masterfile and defaults in various processes.  A range of categories can be selected for inclusion on a payment slip.

Tax file number 

The Invoice Entry/Maintenance program has been enhanced to cater for the Australian GST by inserting a Tax file number field on the header panel and changing the way in which the system uses the value in the Document total and Tax amount fields.

The Tax file number defaults from the creditors masterfile.  Whether or not an entry is permitted in this field depends on the Tax category associated with that creditor.  In the case of miscellaneous creditors, a Tax category permitting ABN overrides is required and an entry is permitted in this field which is validated according the ABN validation rules (also established in the Tax category).

Tax amount

In Invoice/Credit Note Entry processing, the GST component of the invoice value, which is included in the Document Total at the header level, is calculated and displays in this Tax amount field.  The calculated value can be overridden and if, when validating the rate entered, the system finds it does not agree with the control file setup, the message Warning… Tax rate is different from Default Rate displays.  However the Tax amount gets updated from the detail tax on invoice/credit note approval. This is to ensure the header and the detail tax balance, especially in instances where the tax rate is different for different items (e.g. in Europe). 

The tax amount is posted to the Tax Accrual General Ledger Account in the subsidiary ledger when the invoice is approved. 

Discount amount  The discount amount entered in the header field is posted to a General Ledger Discount Account defined on TMSAP/DSCA. When the invoice/credit note is approved, this amount is posted to the subsidiary ledger from where it updates the General Ledger as part of the end of the day routine.
Recipient inv In the case of Royalties, related payments where an invoice is not presented by the creditors or payee, a Recipient invoice can be produced. The Recipient invoice field must be set to 1 for Yes in this case. The words TAX INVOICE print on the invoice.
Payment terms 

A Payment terms code is mandatory on the Creditors masterfile and this code displays as the default in all transactions.  It can be overridden if necessary.

In Invoice/Credit Note Entry, payment terms are used to calculate the Payment due date of a Creditors Invoice/Credit Note.  The calculation is based on the Document date entered when the invoice is captured and the Payment terms code conditions.  Each code defines the time period the code covers, if this period is measured in days or months and if the period is to be calculated starting from the date of the invoice or from end of month.

A system defined code of 00 is used to indicate prompt payment.  In this case the due date will display as 00/00/00. The default will be the Prompt Payment terms code.

The following message displays if the code entered is not found on the control file: Invalid due code - not defined on control file.

Comments The comment field can be used for any special instructions or notations relating to the creditors invoice being entered. These comments can print on the payment remittance if the system is set-up to do so.
Dft particulars

This is a facility for notes or explanations for each accounting entry/line of the G/L dissection as a Journal Notation. In Invoice/Credit Note Entry, the Default particulars as entered on the header panel default for each line of the General Ledger dissection. This default can be overridden on a line by line basis. It is useful for expenses or period changed invoices.

To display the Tax fields instead of this Particulars field on the G/L dissection panel, select the function that switches between the two. Which field displays as the default depends on the settings in TMSAP/TAX-MODE.

On the G/L dissection panel, an additional panel displays, requiring the entry of a project’s commitment number and the amount to be allocated to this project.  The total allocated amount should equal the General Ledger total.

For expense allocations, entry of the particulars is mandatory if the account entered exists on TMSGL/PTCL-LNK.

Dft G/L A/C A General Ledger Account code can be entered here to carry through to the details lines if required.
  1. Enter the invoice details, as necessary.
  2. Click OKAPE010 Invoice Entry/Maintenance panel to allow expenses to be allocated directly to GL account appears.
View fields on this panel
Field Description
Process no.  A system generated sequential number used to mark each document entered into the system.  This number is incremented each time and is maintained on a system control file.  Transactions can be accessed via the Process number or the Document number
Gross disc  The discount amount entered in the header field is posted to a General Ledger Discount Account defined on TMSAP/DSCA.  When the Invoice/Credit Note is approved, this amount is posted to the subsidiary ledger from where it updates the General Ledger as part of the end of the day routine. 
Doc amount This is the total invoice/credit note amount including any applicable tax amounts. In Paid Invoice entry, this is the total payment amount.
Net total  The Net total is the portion of the invoice value that is dissected across expense accounts excluding tax. It is the total of the all the detail Amounts on the dissection panel of Invoice/Credit Note Entry.
Remain amount

On the dissection panel of Invoice/Credit Note Entry, the Remain amount defaults as the Document amount less Net total & Tax total. It will show as full Doc amount if the document value has been not been allocated. 

As General Ledger Accounts and the applicable amounts to be posted to these accounts are entered, the Remain amount reduces.

If the Remain amount is not zero, the Invoice or Credit Note cannot be approved and has to be maintained via the Maintain Unapproved Invoices option.

Tax total 

Total value of all the detail line GST. As allocations are made across General Ledger accounts or dissections this amount will be updated to reflect the running tax total. The tax total will automatically post to the General Ledger accounts established on the Tax code for the Tax category

GL account 

A valid General Ledger Account number is required for posting the expense or creditors/stock accrual value.  If Accounts have already been entered, these can be changed.  The amounts apportioned across the General Ledger accounts can also be changed.  Posting to the Creditor balances occurs after all entries are validated, and the General Ledger update takes place during the end of the day processing.

When the invoice is for stock purchased, be sure to use the correct account.  If no General Ledger Accounts are entered the invoice is filed as Unapproved.  To change the status to an Approved invoice by entering the Accounts, use the Maintain Unapproved Invoices program.

Amount 

The total document amount must be distributed across one or more General Ledger Accounts prior to the document being approved.  These GL dissection amounts display in base currency.

In Invoice/Credit Note Entry, these amounts are totaled and balanced against the document total.  The Remain amount field indicates the discrepancy between these two values.  Invoices that have discrepancies are not accepted.

For a tax invoice, this amount will be used to calculate the tax amount based on the rate of tax which is established in the control file. 

Particulars  Defaults from the header panel but can be overridden. 
The default Tax code displays in the T column and comes from the Tax category code in the Creditor masterfile.  The Tax code can be overridden at this point to cater for portions of an invoice that attract a rate that differs from the default rate.  This caters for the differentiation between taxable items and non taxable items.  The header tax value can then be overridden if necessary.  Also the line detail tax values can be amended to cater for calculated rounding differences. 
Tax  The GST component of the Invoice value, which is included in the Document amount at the header level, is calculated and displays in this field.  The calculated value can be overridden. 
View available functions on this panel
 Function Description 
Detail This function displays the Tax and Withholding tax information per line. 
Format  There are two different formats that can be used to record details and they are each selected through the Format function. The first format displays tax information line by line and the second displays a shortened GL description beside the GL account.  TMSAP/APE010 is used to establish which format displays as the default. 
Approve  This function is used to manually approve a credit or invoice updating the status from U to O. To skip the authorisation process click this function so that the invoice can be approved at entry time. This function will update the Tax amount on the header  from the invoice/credit note detail lines. This is to ensure the header and the detail tax balance, especially in instances where the tax rate is different for different items (e.g. in Europe). 
Header  This function will take you from the details entry panel to the header entry panel. 
Reject  This function is used to manually reject an invoice or credit note giving it a status R. 
Text  This function displays APM909 Journal Header Text 
  1. Enter the remaining information, as necessary.
  2. Click OK. The invoice number is generated and displayed.
Note If Authorisation codes are in use, this Document number prints on the Authorisation Sheet.  When the invoice is approved, this Document number becomes the system Invoice Number.