Accounts Payable > Invoice Processing > AP Invoice Posting

AP Invoice Posting

You use this program to:

  • Process invoices, credit notes and debit notes received from your supplier

  • Process adjustments to suppliers' accounts

  • Approve registered invoices, credit notes and debit notes (these transactions are maintained using the AP Invoice Registration program)

  • Match Accounts Payable invoices to GRNs (Goods Received Notes)

Toolbar and menu

Field Description
Options  
Preferences This enables you to indicate your preferences for this program (see Preferences).
Change Period Select this to use the Change Posting Period program to change the posting period to which the transactions are posted.
Default Dates Select this to define a default due date and default discount date to apply to all transactions for this run of the program (see Default Dates).
Default Branch Select this to indicate the default AP branch against which the transactions are to be processed (see Default Branch).
New Select this to enter a new transaction.

If you entered transaction details, but did not post the transaction, then the message: Do you want to save your changes? is displayed. If there is no undistributed amount on the GL Distribution pane and you select Yes to this question, then the entry is posted. If you select No, then the transaction is discarded, the fields are cleared and focus is set to the Supplier field.

Transaction type

Indicate the type of transaction you want to process.

The following transaction types are available:

  • Invoice
  • Credit note
  • Debit note
  • Adjustment
  • Approve invoice
  • Approve credit note

  • Approve debit note

See also: Notes and warnings.

Supplier Enter the code of the supplier for whom you want to process the transaction.
Edit Transaction Details

Select this to edit information in the Transaction and GRN Matching panes.

This is enabled only after you select the GL Distribution function.

All entries in the GL Distribution pane are cleared.

GL Distribution Select this to distribute the transaction amount(s) to individual General Ledger accounts.

If you selected the GRN matching required option, then you need to complete the GRN matching process before the GL Distribution option becomes available.

Once you select the GL Distribution option, the Transaction pane is disabled. The transaction values will have been validated and the contents of the GL Distribution pane are dependent on these values. Changes can therefore only be made by selecting the New option and re-entering the transaction information.

Post

Select this to post the transaction to the supplier's account.

This option is only available when the Undistributed value in the GL Distribution pane is zero.

If you distributed the tax across multiple General Ledger tax accounts on an Exclusive basis and the entered tax amount does not match the tax calculated by the system, then you must apply the difference to one of the tax codes until the difference is zero.

Print Journal Select this to use the AP Invoice Journal Report program to generate the report of AP journals created during the current run of the program.

This is only available after at least one transaction is posted.

Preferences

This screen is displayed when you select the Preferences option.

Field Description
Distribution  
G/L distribution in foreign currency

Select this to post the General Ledger distribution entries in the currency of the supplier when you process transactions for foreign currency suppliers.

Save Preferences Select this to save these preferences against your operator code. The preferences are saved until next you change them.
Close Select this to save the preferences for the current run of the program only.

Default Dates

This screen is displayed when you select the Default Dates option.

[Note]

These dates override any date normally calculated according to the invoice terms held against the supplier.

Field Description
Discount date

Enter the Discount date you want to apply to your transactions.

[Note]

A default discount date is applied only if Invoice terms are defined for the supplier (Supplier Maintenance - Supplier Details).

Due date Enter the Due date you want to apply to your transactions. This is the date on which the invoice is due for payment.
OK Select this to accept the information you entered and to return to the previous screen.
Clear

Select this to clear any entered values in the Due date and Discount date fields.

The dates are reset to 00/00/00, which means that default dates are not specified for transactions during this run of the program.

Default Branch

This screen in displayed when you select the Define Branch option.

Field Description
Branch selection  
Use branch defined against each supplier Select this to use the AP branch defined against the supplier for the transaction (Supplier Maintenance).
Override supplier's branch Select this to ignore the branch defined against the supplier and to indicate a different branch.
Branch Indicate the AP branch code you want to use for the transaction(s).
OK Select this to accept your selections and to return to the previous screen.
Cancel Select this to ignore any changes you made and to return to the previous screen.

Transaction

  • When GRN matching is not required:

    • The contents of the Transaction pane are validated when you select the GL Distribution function from the toolbar. You cannot proceed if any errors are encountered. The GL Distribution pane is only enabled when no errors are encountered.

    • Once the GL Distribution pane is enabled, only the Transaction reference, Journal notation and Hold invoice fields are enabled. When approving an invoice, only the Journal notation and Hold invoice fields are available.

      The rest of the Transaction pane is disabled, but can be re-enabled by selecting the Edit Transaction Details option from the toolbar. However, all information in the GL Distribution pane will be lost.

  • If your Accounts Payable module is linked to the General Ledger, then the listview is populated with default values and ledger accounts as follows:

    • Merchandise and Freight lines as entered on the Transaction pane

    • If GRN matching is not required:

      The Freight and Merchandise Ledger codes defined against the supplier (Supplier Maintenance) are used. If these are not defined, then the Default Freight and Default Merchandise GL control accounts defined on the Payables tab of the General Ledger Integration program are used.

      When none of these are defined, then you must manually enter the ledger codes. These ledger codes cannot be control accounts. This is prevented by the AP Invoice Posting regardless of the IMPGLB.IMP file.

    • When GRN matching is required:

      The first Ledger code listed is the GRN suspense account defined in the GRN field on the Inventory tab of the General Ledger Integration program.

    Therefore, the default GL accounts and values that populate the GL Distribution window are directly related to the data that is entered in the Transaction pane and the GRN pane.

    When you select the Edit Transaction Details button, the changes that you make to either of these panes can result in the GL default account being different or being of a different value from what was originally populated in the GL Distribution pane. The GL Distribution pane is cleared so that it can be correctly re-populated with default accounts and values that reflect the changes that the operator makes in the Transaction or GRN pane.

Field Description
Transaction details  
Transaction type This indicates the transaction type currently being processed.
Registered Cr/Dr note

Use the Select option to use the Browse on AP Registered Credit and Debit Notes program to indicate the registered credit or debit note to approve.

You must re-establish the debit or credit note if it was not linked to an existing supplier invoice when it was added in the AP Invoice Registration program.

Invoice

Enter the supplier's document number according to the transaction type you are processing:

Transaction Type Consideration
Invoice

Enter the supplier's invoice number.

The message: 'Invoice already on invoice file' is displayed if the invoice number already exists against the supplier.

Credit note

Enter the invoice number to which the credit note applies.

You can re-establish the invoice details if the invoice no longer exists in the Accounts Payable system.

Debit note

Enter the invoice number to which the debit note applies.

You can re-establish the invoice details if the invoice no longer exists in the Accounts Payable system.

Adjustment

Enter the invoice number to which the adjustment applies.

The invoice must exist in the Accounts Payable system.

Approve invoice

Enter the Registered invoice number you want to approve.

The Registered invoice number must already exist (see AP Invoice Registration).

Approve credit note This displays the credit note number selected under Registered Cr/Dr note.
Approve debit note This displays the debit note number selected under Registered Cr/Dr note.

See Tax considerations in Notes and warnings.

Entry number This indicates the entry number of the transaction and is determined by the system.
Branch This defaults to the branch associated with the supplier (Supplier Maintenance) or the branch that you entered to override the supplier's branch (see Default Branch).
Transaction amount Enter the total transaction amount including tax.

Changing this amount recalculates the Tax amount or QST amount.

This field is disabled for an Approve invoice, Approve credit note or Approve debit note transaction.

You need to use the AP Invoice Registration program to maintain a registered invoice, credit note or debit note.

Freight charge Enter the applicable freight charge amount.
Miscellaneous charge Enter the applicable miscellaneous charge amount.
Transaction reference

Optionally enter a free format reference for the transaction.

This reference is used as the transaction reference for both the Work in Progress detail transaction reference and the Purchase Order history of receipts reference.

For example:

You can use a reference of 'Take on' when you use the Accounts Payable module for the first time and you are posting invoices to be able to balance with the General Ledger totals.

When you re-establish an invoice and you leave this field blank, then the reference of RESTAB is entered by the system.

The reference is printed on the AP Invoice Journal Report and is displayed when you query the supplier's invoices, or if you do an Adjustment, Credit note, Debit Note or Approval. In addition, the reference can be printed on your Remittance Advice (AP Check Format).

This field is disabled for an Approve invoice, Approve credit note or Approve debit note transaction.

Journal notation

Enter the description of the transaction that you want to print on the AP Invoice Journal Report.

For example:

A description of items received, the receiving warehouse and Purchase Order number, or a description relating to an Adjustment, Debit note, Credit note or Approval.

Manual check required Select this to enter payment details for a manual check.

This only applies to the transaction types of Invoice and Approve invoice.

Manual check details

Edit

Select this to enter the manual check details for an invoice you are posting against the supplier (e.g. C.O.D invoices that you post to the supplier's account).

See Manual Check Details for details.

GRN matching required

Enable this to match the transaction to a GRN (Goods Received Note) that was previously entered against a Purchase Order for the Supplier.

GRN matching only applies when the GRN suspense system is required (Purchase Orders Setup - GRN tab) and GRN matching is required for the supplier (Supplier Maintenance - Purchasing tab).

You can deselect this option if you are allowed access to the operator activity: AP Untick GRN matching required (Security Activities).

Hold invoice Select this to place the transaction on hold.

This does not apply if you selected the Manual check required option.

Discount
[Note]

These fields are disabled for an Approve invoice, Approve credit note or Approve debit note transaction.

Amount subject to discount Indicate the portion of the invoice amount subject to a discount.

This defaults to the Transaction amount entered.

Discount based on percentage Select this to override the default discount amount value calculated by the system and base the discount amount on the Discount percentage entered.
Discount percentage Enter the discount percentage you want the system to use to calculate the discount amount.
Discount amount Enter the discount amount if you want to override the amount calculated by the system.

This field is disabled when you select the Discount based on percentage option.

Discount adjustment Enter the discount amount if you want to override the amount calculated by the system.

You can enter the new discount amount at the Discount adjustment field, or use the Discount based on percentage option to allow the system to calculate the amount according to a percentage.

You can only post a negative discount adjustment when a discount was applied to the invoice originally.

Dates
[Note]

These fields are disabled for an Approve invoice, Approve credit note or Approve debit note transaction.

Invoice date Indicate the invoice transaction date.

When processing an invoice, this defaults to the current system date, but can be changed. This date is typically the date printed on the supplier's document.

Changing this date recalculates the Tax amount or QST amount based on the tax effective rates defined in the Tax Effective Rates program.

In addition, this date is used to determine the tax/QST rate for Settlement discount when the Calculate tax using historical tax rate option is enabled (Accounts Payable Setup).

[Note]

For Credit notes, Debit notes and Adjustments, this displays the Invoice date.

Changing this date when processing a Credit note, a Debit note or an Adjustment, changes the Invoice record which may affect the ageing of the original invoice.

Discount date

When processing invoices, the system determines the Discount date for each transaction according to the Invoice Terms of the Supplier (Supplier Maintenance), but this can be changed.

If you make a payment to the Supplier before or on the Discount date, you qualify for a discount on the invoice, as it is set up in the Invoice Terms of the Supplier.

You can only access the Discount date field if a Discount amount, Discount adjustment or Discount percentage was entered.

If you entered a default Discount date (Default Dates), then that date is displayed in this field. This only applies to the Invoice transaction type.

For Credit notes, Debit notes and Adjustments, this displays the Invoice discount date. This field is enabled when the Discount amount is non-zero or the Original discount amount against the invoice is non-zero (i.e. there was discount when the invoice was originally captured). The Original discount is displayed in the Information pane.

[Note]

Changing this date when processing a Credit note, a Debit note or an Adjustment, changes the Invoice record which may affect the ageing of the original invoice.

Due date This indicates the date on which the Invoice is due for payment.

If you entered a default Due date (Default Dates), then that date is displayed in this field.

For Credit notes, Debit notes and Adjustments, this displays the Invoice due date.

[Note]

Changing this date when processing a Credit note, a Debit note or an Adjustment, changes the Invoice record which may affect the ageing of the original invoice.

Tax

The following cause the QST amount and Tax amount to be recalculated:

  • Changing the Transaction amount

  • Changing the Invoice date

    When you change the Invoice date, the program uses that date to ascertain the tax rate to use (i.e. the current rate or an historical rate) to calculate the tax value.

    The default order in which the fields are set in the pane means that the Invoice date is requested before the Tax value.

    The program cannot ascertain when the calculated tax value is overridden, so it recalculates the tax value each time the invoice date is changed and repopulates the Tax value field.

  • Changing the Nationality

  • Changing Acquisition

  • Changing the QST code

  • Changing the Tax code

  • Selecting the Calculate button at the QST amount field.

  • Selecting the Calculate button at the Tax amount field.

The Nationality and Acquisition fields only apply if the EC VAT system is enabled (Tax Options - General tab), and the Supplier's nationality code is defined as an EC member (Supplier Maintenance).
Nationality This defaults to the nationality defined against the supplier, but can be changed.
Acquisition This option applies if the supplier's nationality code differs from your SYSPRO company nationality code (Company Maintenance - General tab).
OptionDescription
NoSelect this if your supplier does not have your VAT details and the invoice includes VAT which cannot be reclaimed.
YesSelect this if the supplier has your VAT details and the invoice does not include VAT because you self-charge the VAT and reclaim it.

If you select this option, then the Tax code and Tax amount fields are disabled.

Tax basis

The tax basis can only be changed if GRN matching required is not selected.

Option Description
Exclusive Select this if you want the system to automatically subtract the tax amount from the calculated merchandise amount.

When GRN matching required is selected, then the tax basis defaults to Exclusive and cannot be changed.

Inclusive Select this if you want the total merchandise amount to include the tax amount.
QST amount

If you selected the option: QST calculated on tax, then second tier tax is calculated on the (selling price + Tax).

The second tier tax portion of the transaction is calculated using the Transaction amount and the rate held against the second tier tax code as follows:

((Transaction amount of tax) / (100 + tax%)) x Tax%

If the option: QST calculated on tax is deselected, then the second tier tax portion of the transaction is calculated on the selling price only.

The tax portions of the transaction are calculated as follows:

  1. Total tax rate % = QST tax rate % + Tax rate %

  2. Taxable value = (Transaction amount * 100) / (100 + Total tax rate %)

  3. QST amount = QST tax rate % * Taxable value

  4. Tax amount = Tax rate % * Taxable value

This second tier tax amount is posted to the Default second tier tax Ledger code (General Ledger Integration - Accounts Payable tab) if the option: Disburse tax amount over single G/L tax account is selected (Accounts Payable Setup - Tax tab). If the option: Disburse tax amount over multiple G/L tax accounts is selected, then the second tier tax amount is posted to the A/P tax ledger code defined against the entered QST code (Browse on Tax Codes).

The tax amount entered here is posted to the Input tax Ledger code (General Ledger Integration - Accounts Payable tab) if the option: Disburse tax amount over single G/L tax account is selected (Accounts Payable Setup - Tax tab). If the option: Disburse tax amount over multiple G/L tax accounts is selected, then the second tier tax amount is distributed to the A/P tax ledger code defined against each second tier tax code entered in GL Distribution.

This amount is recalculated according to the tax effective rates in the Tax Effective Rates program when the Invoice date is changed. It is also changed when the Transaction amount is changed.

QST only applies to local currency transactions.

QST code

This field is displayed if the option: Second tier tax is set to Required (Accounts Payable Setup - Tax tab) and the supplier is a local currency supplier.

If the QST code is blank or invalid, then 0 % is assumed for the QST rate.

This field defaults to the second tier tax code defined on the Tax tab of the Accounts Payable Setup program.

The system automatically calculates the second tier tax amount according to this tax code.

Tax codes are maintained using the Tax Codes Setup program.

QST calculated on tax

Select this to calculate the second tier tax on the Selling price plus tax.

Deselect this to calculate the second tier tax on the Selling price only.

This field is displayed if the option:Second tier tax is set to Required (Accounts Payable Setup - Tax tab) and the supplier is a local currency supplier.

This field defaults to the setting at the Second tier tax calculated on tax option defined on the Tax tab of the Accounts Payable Setup program.

Tax code

When the EC VAT system is not required, the default tax code is the Default code for Tax that is defined in Accounts Payable (Accounts Payable Setup - Tax tab).

If the Tax code is blank or invalid, then 0 % is assumed for the tax rate.

The Descriptive tax code must be used if defined (Descriptive Tax Codes).

If the setup option: EC VAT system required is selected (Tax Options - General tab) and the setup option: Supplier default tax code required is selected (Accounts Payable Setup - Tax tab), then this field defaults to the tax code defined against the supplier (Supplier Maintenance). If the option: Supplier default tax code required is not selected, then this field defaults to the Default tax code defined on the Tax tab of the Accounts Payable Setup program. If the transaction is defined as an acquisition, then this field is disabled.

If the setup option: EC VAT system required is selected (Tax Options - General tab), and the transaction is for an Acquisition transaction, then this field is disabled.

When processing a transaction for a foreign currency supplier, this field is only enabled if the option: Allow tax entry for foreign currency suppliers is selected (Accounts Payable Setup - Tax tab).

The system automatically calculates the Tax amount according to this tax code. Tax codes are defined using the Tax Codes Setup program.

To change the code you must indicate that a Global tax file is required (General Ledger Setup - General tab), or that a Tax distribution file is required in Detail or Summary (Accounts Payable Setup - Tax tab).

[Note]

If the Transaction amount is equal to the Tax amount, then this field can be left blank. However, if no tax code is selected, then a space is printed in the Tax Code field of the AP Tax Distribution Report report.

See Tax considerations in Notes and warnings.

Tax amount

The system calculates the Tax amount, using the Transaction amount value and the rate held against the Tax code to calculate the tax portion of the transaction.

The tax calculation is performed as follows:

((Total value inclusive) / (100 + tax %)) x Tax %

If the option: Second tier tax is set to Required (Accounts Payable Setup - Tax tab), then the second tier tax amount is deducted from the Total invoice value inclusive before the tax amount is calculated. If second tier tax is required, then the tax is calculated as follows:

(Total value inclusive - second tier tax amount) / (100 + tax%) x Tax %

To change the tax amount, you must indicate that a Global tax file is required (General Ledger Setup - General tab), or that a Tax distribution file is required in Detail or Summary (Accounts Payable Setup - Tax tab).

When processing a transaction for a foreign currency supplier, this field is only enabled if the option: Allow tax entry for foreign currency suppliers is selected (Accounts Payable Setup - Tax tab).

If the setup option: EC VAT system required is selected (Tax Options - General tab), and the transaction is for an Acquisition transaction, then this field is disabled.

The tax amount entered here is posted to the Input tax Ledger code (General Ledger Integration - Accounts Payable tab) if the option: Disburse tax amount over single G/L tax account is selected (Accounts Payable Setup - Tax tab).

If the option: Disburse tax amount over multiple G/L tax accounts is selected, then the tax amount is distributed to the A/P tax ledger code defined against each tax code (Browse on Tax Codes) entered in G/L Distribution.

[Note]

If the Transaction amount is equal to the Tax amount, then this field can be left blank. However, if no tax code is selected, then a space is printed in the Tax Code field of the AP Tax Distribution Report report.

This amount is recalculated according to the tax effective rates in the Tax Effective Rates program when the Invoice date is changed. It is also changed when the Transaction amount is changed.

Notation

Enter a notation to describe the Tax amount and/or ledger code when it is posted to the General Ledger.

The notation is printed on the AP Invoice Journal Report and General Ledger reports and displays in GL Query.

This only applies if the Ask notation per detail distribution entry option is selected (Accounts Payable Setup - General tab).

Foreign currency  
Exchange rate

This indicates the exchange rate to use for the transaction.

This is the rate at which foreign currency transactions are converted to your local currency equivalent, before being posted into the General Ledger.

You can only access this field when all of the following apply:

  • you are processing an invoice for a foreign currency supplier
  • the exchange rate against the currency is not set to Fixed (Currencies)
  • the currency is not triangulated
Fixed exchange rate Select this to fix the exchange rate for the transaction to the rate in the Exchange rate field.

Manual Check Details

This screen is displayed when you select the Edit option at the Manual check details field.

[Note]
  • You cannot enter payment details for an invoice that is on hold.
Field Description
Accept and Close Select this to save the information you entered and to return to the previous screen.
Cancel Select this to ignore any information you entered and to return to the previous screen.
Payment information  
Bank Indicate the code of the bank on which the check was drawn.
Gross payment This defaults to the Transaction amount entered on the previous screen, but can be changed.
Use Defaults Select this to apply the Gross payment and Discount amount calculated in the Transaction pane of the previous screen.

You typically use this function if you changed these amounts on the Manual Check Details screen and now want to restore them to the original values.

Payment run

Indicate the discount amount taken from the payment.

This defaults to the discount calculated on the previous screen, but can be changed.

Check date Indicate the payment date reflected on the manual check.
Payment run

This field is only enabled if you are using the Payment Cycle Maintenance program to process supplier payments and your Payment run numbering method is set to Manual (Accounts Payable Setup - General tab).

Enter a payment run number for the manual check.

The payment run number must be unique (i.e. you cannot use an existing payment run number).

If your Payment run numbering method is set to Automatic (Accounts Payable Setup - General tab), then the system allocates the next payment run number when you post the transaction.

Check number Indicate the number on the manual check.
Withholding tax information This section only applies if the tax option: Withholding tax required (Tax Options - Withholding tab) is selected and a valid withholding tax code is defined against the supplier (Supplier Maintenance - Supplier Details).
Taxable amount

If the option: Automatic calculation of withholding tax is not selected (Tax Options - Withholding tab), then you use this field to enter the amount of the transaction which is subject to tax. Alternatively, you can use the Calculate function to calculate the taxable amount.

If the option: Automatic calculation of withholding tax is selected (Tax Options - Withholding tab), then the taxable amount is automatically displayed. The calculated amount can be changed.

When the taxable amount is automatically calculated, if you select the Manual Check function before you enter any G/L Distribution entries, then the Taxable amount is calculated as: Payment amount - discount. The reason is that the program needs the tax code of the first G/L distribution entry to calculate the invoice tax amount. If you select the Manual Check function after you enter the G/L Distribution entries, then the program uses the tax code against the first G/L distribution entry to calculate the invoice tax amount. In this case, the taxable amount is calculated as: Payment amount - tax on invoice - discount.

Calculate

Select this to automatically calculate the Taxable amount based on the current transaction values.

If the option: Automatic calculation of withholding tax is not selected, then the taxable amount is calculated as: Payment amount - discount amount)

If the option: Automatic calculation of withholding tax is selected, then the taxable amount is calculated as: (Gross payment - invoice tax amount - discount).

When the taxable amount is automatically calculated, if you select the Manual Check function before you enter any G/L Distribution entries, then the Taxable amount is calculated as: Payment amount - discount. The reason is that the program needs the tax code of the first G/L distribution entry to calculate the invoice tax amount. If you select the Manual Check function after you enter the G/L Distribution entries, then the program uses the tax code against the first G/L distribution entry to calculate the invoice tax amount. In this case, the taxable amount is calculated as: Payment amount - tax on invoice - discount.

Withholding tax code

This defaults to the Withholding tax code defined against the supplier (Supplier Maintenance - Supplier Details), but can be changed.

The Tax amount is not automatically recalculated when you change the Tax code. You need to select the Calculate function to re-calculate the Tax amount.

The Tax code determines the tax rate to use (see Browse on Tax Codes).

Tax amount

If the option: Automatic calculation of withholding tax is not selected (Tax Options - Withholding tab), then you use this field to enter the amount of tax you are withholding from the invoice being paid. Alternatively, you can use the Calculate function to calculate the tax amount.

If the option: Automatic calculation of withholding tax is selected (Tax Options - Withholding tab), then the tax amount is automatically displayed. It is calculated as: ((Taxable amount * withholding tax rate) / 100).

The calculated amount can be changed.

Calculate

Select this to automatically calculate the Tax amount, based on the current transaction values entered.

The tax amount is calculated as: ((Taxable amount * withholding tax rate) / 100).

Tax rate % This indicates the rate defined against the tax code used (Browse on Tax Codes).

Information

Field Description
Supplier information This displays information defined against the Supplier you entered.
Invoice information This displays information recorded against the transaction you have entered.
Posting information  
Posting period Indicates the period and year to which the transaction will be processed.
Journal Indicates the AP journal number created for the transactions processed during the current run of the program.
Recap totals Displays transaction totals for the current run of the program.

GRN Matching

This is enabled when the GRN Matching required option is enabled in the Transaction pane.

All values are displayed in the currency of the supplier when matching GRNs for a foreign currency supplier and the preference G/L distribution in foreign currency is selected.

Once GRN matching is complete, the GL Distribution function can be selected.

[Note]
  • The database is only updated with changes made in the grid when you select the Post function.

  • This is an editable grid, not an editable form and can therefore not be customized (e.g. changing the tabbing sequence).

Field Description
GRN Enter the GRN you want to match to the invoice.

Each GRN entered is validated and added to the end of the grid. GRNs currently displayed are not affected.

Only lines with the GRN you entered are displayed in the listview, enabling you to select the required lines you want to match.

A message is displayed when:

  • no unmatched GRNs exist for the supplier

  • the GRN period is later than the current AP period

  • the GRN period is later than the posting period selected

  • no GRNs exist for the supplier

  • the GRN is already listed in the grid

  • the GRN entered is not on file

  • the GRN has already been added to the listview

Load Multiple GRNs
[Note]

When you use one of these options, the GRN Matching listview is cleared (including any changes made) and replaced with the GRNs that comply with the selections made.

Range of GRNs Enables you to indicate a range of GRNs to display.
All GRNs Displays all GRNs for the supplier.

A GRN is excluded from the listview when:

  • it is already matched

  • the posting period in which the GRN was captured is after the current AP posting period

  • the posting period in which the GRN was captured is after the posting period selected when you loaded the AP Invoice Posting program (Options - Change Period)

  • the GRN was created in an Inventory period later than the current Accounts Payable period

Value to Match This is the transaction value to be matched to the GRN and is calculated as:

Transaction amount less Freight charge less Miscellaneous charge less Tax amount

This always displays the value as at the time you selected the GRN Matching option in the Transactions pane. It is not reduced as you select lines to match. The values currently matched are displayed in the footer section of the grid.

Match All Lines

Enables you to simultaneously select all the detail lines in the grid to match to the invoice.

  • All Match check boxes are enabled.

  • The Outstanding value is moved to the Matched value and the Merch matched value.

  • The Outstanding qty is moved to the Matched qty.

  • Lines previous marked as Partial match are marked as fully matched (i.e. the Partial match tick is removed).

This is enabled when at least one row is displayed in the listview.
Remove All GRNs Clears the listview.
Reload GRNs Resets any changes made to the lines and redisplays them. All changes made to the grid are lost.
GRN Adjustment

Uses the GRN Adjustment program to maintain details of Goods Received Notes.

[Note]

A warning is displayed that all changes made to the grid will be lost.

You can select to cancel or continue.

Match

A tick in this checkbox indicates that the GRN line is selected for matching and allows you to change the Merch matched value for the line.

You can toggle between selecting and deselecting each line.

This is set to enabled when you select the Match All Lines option.

Partial match

Select this to match only a part of the selected GRN quantity or value to your transaction.

This allows you to change the Matched qty, Matched value and Merch matched value fields in the grid.

The Match check box must be ticked before you can select this option.

Goods Received Note This indicates the GRN number for the line.
Outstanding value

This is calculated as follows:

Outstanding value (in local currency) = Current GRN value (in local currency) - Value matched to date (in local currency)

When performing GL Distribution in foreign currency, then it converts the Outstanding value in local currency to Outstanding value (in foreign currency) using the exchange rate entered in AP Invoice Posting.

Matched qty This defaults to the Outstanding qty for the GRN and can only be changed when the Partial match checkbox is ticked.

Indicate the quantity of the line item that you want to match for the GRN line.

Matched value This defaults to the Outstanding value for the GRN and can only be changed when the Partial match checkbox is ticked.

Indicate the value you want to match for the GRN line.

The total of this column, for all GRN lines selected for matching, is compared to the invoice merchandise value. Any difference between the two causes a purchase price variance. See Purchase price variance under Notes and warnings.

Merch matched value This defaults to the Outstanding value for the GRN and can only be changed when the Match checkbox is ticked.

Indicate the merchandise value you want to match for the GRN line.

The total of this column, for all GRN lines selected for matching, is compared to the Value to Match field. See GRN variance under Notes and warnings. The value in this column has nothing to do with the purchase price variance value calculation.

Load a Range of GRNs

This is displayed when you select the Load Multiple GRNs function.

Although this is an editable form, it cannot be customized. It is not a dockable pane.

Field Description
Load Replaces the currently displayed GRNs in the listview with the range of GRNs indicated.
Cancel Returns to the listview as it was.
From GRN Indicate the first GRN you want to display.
To GRN Indicate the last GRN you want to display.

GL Distribution

The GL Distribution grid enables you to distribute the portions that make up the total transaction amount to General Ledger accounts.

When you select the GL Distribution option from the toolbar, the contents of the Transaction pane are validated and the GL Distribution pane is enabled if no errors were found.

This is an editable grid, not an editable form and can therefore not be customized (e.g. changing the tabbing sequence).

If your Accounts Payable module is linked to the General Ledger, then the listview is populated with default values and ledger accounts as follows:

  • Merchandise and Freight entered on the Transaction pane

    If GRN matching is not required, then:

    • the Freight and Merchandise Ledger codes defined against the supplier (Supplier Maintenance) are used

      or if not defined,

    • the Default Freight and Default Merchandise GL control accounts defined on the Payables tab of the General Ledger Integration program.

    • When none of these are defined, you must manually enter the ledger codes. These ledger codes cannot be control accounts. This is prevented by the AP Invoice Posting program regardless of the IMPGLB.IMP file.

    When GRN matching is required, the first Ledger code listed is the GRN suspense account defined on the Inventory tab of the General Ledger Integration program.

  • Miscellaneous charge

    Amounts must be manually distributed.

  • Tax

    To distribute the taxable portion of the transaction amount you must indicate that a Global tax file is required (General Ledger Setup - General tab), or that a Tax distribution file is required in Detail or Summary (Accounts Payable Setup - Tax tab).

    To distribute the taxable portion for foreign currency suppliers you have to select the option Allow tax entry for foreign currency suppliers (Accounts Payable Setup - Tax tab).

If you selected the preference: G/L distribution in foreign currency, then the values displayed on the GL Distribution pane are in the currency of the supplier.

Once the GL Distribution process is complete, you can select the Post function.

Field Description
Delete Select this to remove the highlighted entry from the list of distribution entries.
Issue to Job Select this to post amounts for non-stocked related amounts (such as freight and miscellaneous charges) directly to a Work in Progress job.

You can only post to a job when the Accounts Payable and Work in Progress modules are in the same period.

See Issue to Job.

Apply Undistributed Select this to distribute the undistributed amount to the Ledger code currently selected.
Undistributed

This indicates the amount which must still be allocated to General Ledger codes.

When the this amount reaches zero, the system calculates the tax portion.

Each GL Distribution Entry has a Tax code associated with it, which is used to calculate the Tax amount per entry on an Exclusive or Inclusive basis. All these amounts are added up to produce the Total tax amount on the transaction.

Ledger code This indicates the General Ledger code to which the amount must be distributed.
Description This indicates the description of the Ledger code.
Amount This indicates the amount to distribute to the Ledger code.

You can either enter separate amounts to be posted against different ledger codes, or select the Apply Undistributed function to assign the undistributed value shown on the screen to the ledger code selected.

If you selected the preference: G/L distribution in foreign currency, then the General Ledger distribution entries for Invoices, Credit notes, Debit notes and Adjustments processed for foreign currency suppliers are processed in the currency of the supplier.

Tax code

This indicates the tax code to use to determine the applicable tax amount for that distribution entry.

  • If the EC VAT system is not required, then the system first tries to find a tax code against the ledger code you selected.

    If this is not defined or if Accounts Payable is not integrated to the General Ledger, then the tax code entered in the Transaction pane is used. If that tax code is blank, then the Default code that was set up for Invoice posting in Accounts Payable Setup (Accounts Payable Setup - Tax tab) is used.

  • If the setup option: EC VAT system required is selected (Tax Options - General tab) and the setup option: Supplier default tax code required is selected (Accounts Payable Setup - Tax tab), then this field defaults to the tax code entered on the Transaction pane.

    If the option: Supplier default tax code required is not selected and Accounts Payable is integrated to the General Ledger then the system first tries to find a Tax code against the ledger code that you selected.

    If a tax code is not defined against the ledger code or if Accounts Payable is not integrated to the General Ledger, then the tax code you entered in the Transaction pane is used.

    If that tax code is blank, then the Default code that was set up for Invoice posting in Accounts Payable Setup (Accounts Payable Setup - Tax tab) is used. If the transaction is for an acquisition, then this field is disabled.

When processing a transaction for a foreign currency supplier, this field is only enabled if the option: Allow tax entry for foreign currency suppliers is selected (Accounts Payable Setup - Tax tab).

If you change the Tax code for a specific General Ledger entry, then the system recalculates the tax amount for that entry according to the new code entered.

If you are using Withholding tax (Tax Options) and you disburse the invoice value to multiple G/L expense accounts and use different tax rates against the entries, then when the withholding tax amount is calculated for payment purposes, the calculation only uses the first tax code entered.

Job

This indicate the job number to which the amount was posted. It is only displayed if you issued the amount to a job (see Issue to Job).

Tax only Enable this to allocate the entire value in the Amount column as a tax value. This field is not displayed by default, but must be added to the listview, using the Field Chooser option, if required.

This field is not available when:

This field is disabled when:

  • processing a foreign currency transaction and the option and Allow tax entry for foreign currency suppliers is disabled (Accounts Payable Setup)

  • EC VAT system required is enabled and the Tax option Acquisition is set to Yes in the Transaction pane

When you enable Tax only and the option: Disburse tax amount over single GL tax account is enabled (Accounts Payable Setup) then:

  • the Ledger code column defaults to the Input tax GL code defined for Payables in the General Ledger Integration program and cannot be changed.

  • the value entered in the Amount column is posted as a tax value.

When you enable Tax only and the option: Disburse tax amount over multiple GL tax accounts is enabled (Accounts Payable Setup) then:

  • the correct tax code column must entered in the Tax code field.

  • the Ledger code column defaults to the AP Tax ledger code defined against the entered Tax code (Tax Codes Setup).

The Apply Undistributed option is disabled when you are using Exclusive tax and posting the entire value as a tax amount. With exclusive tax the value in the Amount column does not include tax, so the undistributed value must not be affected.

Refer to Report Details or Report Details for details of imbalances which can occur by posting Tax only entries.

Issue to Job

This pane is enabled when you select the Issue to Job option from the GL Distribution pane.

The Work in Progress files/tables are only updated when you select the Post function.

Field Description
New Select this to reset all fields in the pane and to enter a new Job number.
Job Indicate the job number to which the amount must be posted.

The job must exist and be confirmed in the Work in Progress module and must not be on hold.

Issue to Job

Select this to allocate the materials to the job.

The following message is displayed when you select this option:

"Is this allocation complete?"

Select Yes if all material allocations for the job are now complete. The system returns to the GL Distribution pane.

Select No if there are additional material allocations to be issued to the job. The system returns to the GL Distribution pane.

Select Cancel to return to the Issue to Job pane.

Cancel and Close Select this to cancel out of this pane and to return to the GL Distribution pane.
Job details  
Job This indicates the job number to which the amount must be posted.
Job description This indicates the job description.
Purchase order options  
Purchase order required

Select this if a purchase order was raised for the non-stocked item. The Purchase order and Line fields are enabled for you to enter these details.

Deselect this if no purchase order relates to the non-stocked item.

Purchase order Indicate the purchase order number on which the non-stocked item was ordered.
Line Indicate line number (within the purchase order) relating to the non-stocked item.
Subcontract options  
Subcontract operation

Select this if the non-stocked item is linked to a subcontract operation. The Operation and Operation complete fields are enabled.

Deselect this if the non-stocked item is not linked to a subcontract operation.

Operation Indicate the operation number to which the item must be allocated.
Operation complete Select this if you are making the final issue of the item to the subcontract operation. i.e. If there are no outstanding material allocations for the operation.
Posting details  
Non-stocked code Indicate the code for the non-stocked item.
Description Indicate the description for the Non-stocked code.
Product class Indicate the product class for the non-stocked item.
Tax code

The system uses the tax code to determine the applicable tax amount.

The default Tax code is defined in Tax Options for Non-stocked items (Tax Options).

If you selected a Tax basis of Inclusive in the Transaction pane, then you can change this code.

Quantity to issue Indicate the quantity of the non-stocked item that must be allocated to the job.
Currency of value to issue  
Value of issue

Enter the value of the non-stocked item that you want to issue to the job from your transaction.

This value defaults to the Undistributed amount from GL Distribution pane.

Hierarchy For hierarchical jobs, you must indicate the hierarchy to which the amount must be issued (see Hierarchies for Job).

Notes and warnings

Program access

  • You can only run this program when the Input tax GL code is defined (General Ledger Integration - Payables tab). The message Accounts Payable - Input tax account is displayed when this code is not defined.

Tax considerations

  • The Tax code field is not displayed in the Transaction grid if the Tax distribution method is set to Not required (Accounts Payable Setup). This applies even if you manually drag the Tax code field into the grid.

  • Where applicable, the letters QST are replaced by whatever you entered at the Second tier tax - Description field (Accounts Payable Setup - Tax tab).

  • The warning message: Tax Relief already processed on this invoice is displayed when you process a Credit note, Debit note or Adjustment against an invoice which was processed by the AP Tax Relief program.

    Such adjustments either increase or decrease the invoice balance, which can cause the Tax relief/recovery account (General Ledger Integration - Payables tab) to be out of balance. The onus is on you to manually adjust the Tax relief/recovery account.

GL Analysis considerations

  • If the GL analysis required option is enabled for a ledger account used in this program (General Ledger Codes or GL Structure Definition) then the GL Analysis program is displayed when you post the transaction, so that you can enter the analysis details.

    The Ask Me Later function is only available when the option: Force GL Analysis - GL journal posting is enabled for the sub-module (General Ledger Integration - General Ledger tab).

    General Ledger analysis entries are always distributed in the local currency, regardless of the currency in which the original transaction is processed.

Restrictions and limits

  • Credit notes

    You cannot post a Credit note against an invoice which:

    • has a manual check posted against it

    • is on hold

    • has been released for payment

  • Adjustments

    You cannot post an Adjustment transaction type to the invoice once Manual Check Details have been posted for the invoice.

  • Approve credit note

    You cannot approve a credit note which has been released for payment.

GRN variance

The total of the Merch matched value column, for all GRN lines selected for matching, is compared to the Value to Match field (i.e. the invoice merchandise value net of tax, freight and miscellaneous charges). If the difference between the two values exceeds the maximum permitted variance according to the GRN variance option (Accounts Payable Setup) then the following warning is displayed when you select the GL Distribution option: Acceptable variance is exceeded. Ok to continue.

If a password is defined against the field: AP Entry of a GRN matching value exceeding permitted GRN variance (Password Definition), then the password must be entered before the warning can be overridden. This applies to stocked and non-stocked lines.

If the Purchase Price Variance - Ignore rounding less than is set to a percentage (Accounts Payable Setup) and the variance calculated is less than this percentage, then the variance is posted to the GRN suspense account and not to the Purchase price variance account.

Purchase price variance

A purchase price variance occurs when there is a difference between the Value to Match and the total of the Matched value column, for all GRN lines selected for matching.

Usually the purchase price variance is posted to a separate General Ledger account. However, the setup option: Ignore rounding variance less than (%) (Accounts Payable Setup) enables you to define a percentage below which variances are not posted separately, but are added to either the GRN suspense account or the Merchandise account, depending on how integration between Inventory and the General Ledger is defined (General Ledger Integration):

  • If Inventory is integrated to the General Ledger and the difference between the Value to Match and the total matched value is less than the percentage defined (Accounts Payable Setup), then the variance is posted to the GRN suspense account. If the variance is not less than the percentage defined, then the variance is posted to the Purchase Price Variance account (General Ledger Integration - Inventory tab).
  • If Inventory integration to the General Ledger is defined as Not linked to GL - Report only and the difference between the value to match and the total matched value is less than the percentage defined (Accounts Payable Setup), then the variance is posted to the merchandise account. If the variance is not less than the percentage entered here, then it must be manually allocated to a ledger code.
  • If Inventory is linked to the General Ledger as: Not linked to GL - no distribution report, then nothing is posted to the General Ledger).

Activity considerations

Operator access to the following activities within this program can be restricted. You configure this using the Operator Maintenance program.

Activity Description
AP Invoices Controls whether an operator can process an Invoice using the AP Invoice Posting program.
AP Credit notes Controls whether an operator can process a Credit note using the AP Invoice Posting program.
AP Debit notes Controls whether an operator can process a Debit note using the AP Invoice Posting program.
AP Adjustments Controls whether an operator can process an Adjustment using the AP Invoice Posting program.
AP Approve invoices Controls whether an operator can select the Approve invoice option in the AP Invoice Posting program.

eSignature considerations

Electronic Signatures provide security access, transaction logging and event triggering. This enables you to increase control over your system changes.

Access to the following eSignature transactions within this program can be restricted at Operator, Group, Role or Company level. You configure this using the Electronic Signatures program.

eSignature Transaction Description
AP Post invoice

Controls access to the Post Transaction function for Invoices in the AP Invoice Posting program.

AP Post credit note

Controls access to the Post Transaction function for Credit notes in the AP Invoice Posting program.

AP Post debit note

Controls access to the Post Transaction function for Debit notes in the AP Invoice Posting program.

AP Post adjustment

Controls access to the Post Transaction function for Adjustments in the AP Invoice Posting program.

AP Approve registered invoice

Controls access to the Post Transaction function when approving invoices in the AP Invoice Posting program.

AP Invoice placed on hold

Controls access to the Hold function in the Payment Cycle Maintenance, AP Release Invoices to Pay by Review, AP Invoice Posting and Supplier Invoices programs.

AP Override GRN variance

Controls access in the AP Invoice Posting program after entering the GRN details and selecting the GL Distribution option.

This can be used to prevent/detect/log an operator overriding the maximum GRN variance defined in the Accounts Payable Setup program.

When the eSignature is set to Denied and the acceptable GRN variance is exceeded, the message: Acceptable variance exceeded. Operator is denied access to continue is displayed after entering the GRN details and selecting the GL Distribution option.

A GRN variance arises when there is a difference between the supplier's invoice value (net of tax, freight and miscellaneous charges) and the total merchandise value of the GRN line(s) you select to match.

AP Approve registered credit note

Controls access to the Post Transaction function when approving credit notes in the AP Invoice Posting program.

AP Approve registered debit note

Controls access to the Post Transaction function when approving debit notes in the AP Invoice Posting program.

Inserting Application Help

You would typically follow this procedure to display help for the current program in a customized pane that can be pinned to the program window.

Information includes step-by-step instructions for the various functions available within the program, including a brief overview of what the program does, what setup options are required and how to personalize the program.

  1. Open the program for which you want to insert application help into a customized pane.

    This functionality is only available for a program that has panes.

  2. Right-click any form field.

    You can also click the triangle menu icon that appears in the title area of a pane.

  3. Select Insert Application Help from the context-sensitive menu.

    The application help appears in a pane within your program. You can reposition the pane using the docking stickers or pin it to the program window.

Removing the Application Help pane

If you no longer want to display application help in a pane for your current program, you can simply remove it.

  1. Select the Close icon in the right-hand corner of the application help pane.

  2. Confirm that you want to delete the pane.