Supplier intercompany invoices

The supplier BP invoice entry function is used to manage the supplier invoicing process outside of the typical sales cycle.
This function cannot be used to manage the order or the receipt note for the stock receipt (etc.). When issuing the invoice, the data required for accounting is recorded.

As for customer tracking (open item statements, payment management, etc.), the process is similarly carried out for invoices that come from the complete cycle or that come simply from the entry of a BP invoice.

For Swiss legislation: Refer to the Swiss localization how to guide for detailed information on setting up and using ISR (Inpayment Slip with Reference) or QR-bills.

Specificities linked to supplier intercompany invoices

If the company is set up for intercompany invoices, a reference to a target company, site, and the dimensions for each line can be entered.

If the target company does not match the source company, the general ledger accounts associated with the target company will be used along with the target company dimensions.
The following occurs if the target company entered on the line is not equal to the source company:

When the invoice is posted, separate journals are generated in the source and target companies using the designated debit and credit accounts from Intercompany account mapping.

Prerequisites

Refer to documentation Implementation

Limitations

When the invoice is entered in tax-inc. mode and an additional or special tax code is present (entered or automatically loaded from the account), the amounts of the three tax levels must be entered manually.

Deleting intercompany invoices is allowed only if the SIVSUP - Invoice/journal deletion parameter (TC chapter, INV group) is set to "Yes" for all companies (source and target).

Screen management

Posting customer BP invoices involves three tabs containing the characteristics of each part of the invoice body.

Header

First, the key accounting information of the invoice must be entered:

  • The document number (where a manual numbering range is authorized)
  • The document posting date, by default that of its receipt in the folder
  • The identification code for the supplier and the control account on saving the document.
  • This information defines:

    After this data has been recorded, click Post to:

    Field descriptions

    Block number 1

    Site (field FCY)

    Enter the site code.

    The site must be a financial site. This determines the site and the company for the entry posting.

    Company (field CPY)
    Name (field CPYNAM)
    Invoice type (field PIVTYP)

     Invoice type code referencing the invoice category as well as the entry structure used upon accounting validation of the invoice.
    Only an invoice type with a legislation and company group consistent with those of the company linked to the given site can be entered.
     

    For further information, click here.

    Document no. (field NUM)

    If the number is left blank, it will be automatically assigned upon validation.

    Block number 2

    Accounting date (field ACCDAT)

    Enter a date to define the accounting date for the generated journal. This field defaults to today's date.

    This date is not necessarily the same date entered for the Source document. For example, for a supplier invoice, the Source document date reflects when the invoice was created by the supplier. In that case, the Accounting date would be different.

    Supplier (field BPR)

    In this field, enter or select the supplier for the invoice using the Lookup tool.

    To search using the auto select option, enter several characters of the supplier name or code and press the Tab or Enter key. The selection window opens with a list of suppliers based on those characters. The results include active and inactive records.

    Auto selection is available if the AUTOSEL – Auto selection parameter (SUP chapter, INT group) is set to Yes.

    Address code (field BPAINV)
    Name (field BPRNAM)
    Control (field BPRSAC)

    Enter the code for the BP (customer or supplier) control account initialized by default with the accounting code for the BP invoice.

    The initialization of the code for the Control field depends on whether or not the BP/Company tab is present in the BP record (GESBPR).

    Account (field SACACC)

    Intercompany invoicing example

    One company (source) pays health insurance for itself and another company (target). A portion of the invoice is an expense of the source company and a portion of that invoice is due to the source company from the target company. When the invoice is entered in the system, the invoice lines in source Company A is as follows:

     Company

     Site

    Legal

    Amount

    Description

     B

     B1

     INSURANCE

     300.00

     Using account in Company B

     A

     A1

     INSURANCE

     700.00

     Using account in Company A

    The invoice is entered in the source. When the invoice is posted in Company A, the resulting journal entries are as follows:

    Company A

     Site

    Legal

    Debit

    Credit

    Description

     A1

     INSURANCE

     700.00

     

     

     A1

     DUE FROM COMPANY B

     300.00

     

     Debit source GL account

     A1

     ACCOUNTS PAYABLE

     

     1000.00

     

    Company B

     Site

    Legal

    Debit

    Credit

    Description

     B1

     INSURANCE

     300.00

     

     

     B1

     DUE TO COMPANY A

     

     300.00

     Credit target GL account

    Supplier Invoice with tax on line example

    When the line associated with the intercompany transaction is taxable, the calculated tax should be based on the target company.
    When the invoice is entered in the system, the invoice lines in source Company A is as follows:

     Company

     Site

    Legal

    Amount

    Tax on line

    Amount
    Ext line amt
     

     B

     B1

     INSURANCE

     300.00

     30.00

     330.00

     A

     A1

     INSURANCE

     700.00

    70.00

     770.00

    The invoice is entered in the source. When the invoice is posted in Company A, the resulting journal entries are as follows:

    Company A

    Site

    Legal

     Debit

    Credit    

     Description

     A1

     INSURANCE

    700.00

     

     

     A1

     DUE FROM COMPANY B

     330.00

     

     

     A1

     Tax (line 2)

     70.00

     

    Source Company COA for Tax accounting code

     A1

     ACCOUNTS PAYABLE

     

     1,100.00

     

    Company B

    Site

    Legal

     Debit

    Credit

     Description

     B1

     Tax (line 1)

     30.00

     

    Target Company COA for Tax accounting code

     B1

     INSURANCE

     300.00

     

     

     B1

     DUE TO COMPANY A

     

     330.00

     

    Tab Header

    Invoice characteristics

    Some fields in the header are used to complete the invoice:

    Open item characteristics

    The remaining fields are used to characterize the payment conditions for the invoice:

  • For the management of open item statements
  • Once the invoice has been saved, you can click the Open items action to view the open items and the payment stage.

    The Status field indicates the status of the invoice with respect to the accounting validation. The Pending status can be selected in order to disable the access to the Validation action and to the invoice selection in the global process.
    The status must be set to Pending for the invoice to be posted manually or globally. This modification is carried out either manually, on a case-by-case basis, or in a more global manner via the appropriate processing.

    See the documentation on Invoices on hold for further information.

    Field descriptions

    Detail

    Source document date (field BPRDAT)

    Enter the invoice date. This field defaults to today's date.

    field TYPVCR
    field CLSVCR
    field SCUVCR
    field SEQVCR
    Source document (field BPRVCR)

    This field is used to record the number or the reference of the source invoice.

    Currency (field CUR)

    This field indicates the invoicing currency. All amounts are entered in this currency.

    Rate (field RAT1)
    field LABEL
    field RAT2
    field CURMLT
    Amount - tax (field AMTNOT)

    This amount is only a control amount that will be compared the line total during the recording.

    This amount is mandatory when the HEAAMTBPS – Supplier inv. header amt. ctrl parameter (TRS chapter, INV group) is set to Ex-tax and Tax -incl. amounts to be entered.

    Amount + tax (field AMTATI)
    Invoice number (field INVNUM)

    This invoice is the one to which the credit memo is allocated.
    Upon accounting validation and according to the value of the LETAUTCNO - Auto match inv ->credit note parameter (CPT chapter, MTC group), the credit memo and invoice can or cannot be matched together.

    Depending on the value of the INVCAN - Cancellation invoice parameter (TC chapter, INV group), thedocument in progress can be of the 'Cancellation invoice' type. In this case, the credit memo and invoice are matched, regardless of the value of the LETAUTCNO parameter.

    Project (field PJTH)
    VCS number (field BELVCS)

    Field linked to the Belgian legislation. 
    It is used to specify the VCS number on an invoice (VCS refers to transfers with structured format communication) and to facilitate bank reconciliation.

    Reminder : the structured communication consists in specifying a single identifier on the invoices that will be used in all the banking exchanges.

    The encoding number is made up of 12 numeric characters:

    • 10 digits (two characters defining the year + eight characters defining a sequence number),
    • 2 control digits calculated according to the check digit modulo 97 rule.

    In the case of purchase invoices and supplier BP invoices, the encoding number is controlled and can be entered. It is performed:

    • If activity code KBE is abled
    • If the BELVCS parameter is set to 'Yes'
    • If the invoice does not have the pro forma type
    • If the supplier is Belgian.

    Warning In case of a site modification, the display of the 'VCS number' field is reinitialized.

    Original document no. (field ORIDOCNUM)

    Block number 3

    Status (field STA)

    No help linked to this field.

    Tax rule (field VAC)

    Enter the VAT management type associated with the supplier invoice.
    Only a tax rule with a legislation and group that are consistent with those of the document can be entered.

    The general principles linked to the multi-legislation setup are detailed here.

    This field is automatically entered if a tax rule is specified in the record of the supplier of the current invoice. This is used, among other things, to obtain a print conditioned by the type of legislation.

    Supplier amount type (field PURPRITYP)

    This flag is initialized based on the business partner. It determines if the amounts on the invoice lines are including-tax or excluding-tax amounts.

    It is only possible to choose between Include tax or Exclude tax when creating the invoice.

    • If you select Exclude tax, a tax-excluding amount is entered on the invoice line. The tax-including amount is calculated.
    • If you select Include tax, the tax-including amount is entered on the invoice line. The tax-excluding amount is calculated.
    If the DEPMGTMOD - Discount management mode parameter (TC chapter TC, group INV) is set to Rebate on VAT, the amount type is always Exclude tax, regarldess of the BP setup or value of the PURPRITYP - Amount type parameter (TRS chapter, INV group). You cannot select Include tax in that case.

    Field 40 - reason (field FLD40REN)

    Field subject to activity code: KPO - Portuguese localization
    It is used to specify the VAT adjustment reason for the field 40, upon generation of the VAT declaration.
    When choosing the reason, the possible values are the values contained in the miscellaneous table 8300.

    Field 41 - reason (field FLD41REN)

    Field subject to activity code: KPO - Portuguese localization
    It is used to specify the VAT adjustment reason for the field 41, upon generation of the VAT declaration.
    When choosing the reason, the possible values are the values contained in the miscellaneous table 8301.

    Open items

    VAT reverse charge (field CEEFLG)

    Indicate whether the tax rule is subject to autoliquidation.

    Fees declaration (field DAS2)

    This field indicates if the entry generated by the invoice is to be taken into account in the declaration of fees or not.

    Statement (field XSOI)

    No help linked to this field.

    Pay approval (field XFLGPAZ)

    This field is used to pre-enter the field "payment approval" of the generated open items.

    Payment

    Pay-to (field BPRPAY)

    Enter the invoice date. This field defaults to today's date.

    Address code (field BPAPAY)
    Due date basis (field STRDUDDAT)

    This is the date from which the payment schedule is calculated.

    Payment term (field PTE)

    This field indicates the payment conditions that will be applied in order to determine the invoice schedule. The latter can be manually modified later on.
    It is only possible to enter a payment term that is consistent with the legislation and the group of the company. 

    The general principles linked to the multi-legislation setup are detailed here.

    Due date (field DUDDAT)
    Discount/Late charge (field DEP)

    Code used by default for the current BP to identify a series of early discount and late charge rates (up to 12) to be applied to a payment according to a number of days early or days late with respect to the open item date.
    Only a discount code consistent with the legislation and company group of the document site can be entered.

    The general principles linked to the multi-legislation setup are detailed in the GRPLEG field help.

    Comments (field DES)
    1099 form (field FRM1099)

    The 1099 form type indicates that a supplier is reportable to the Internal Revenue Service for payments made. Possible valid values are: None. Misc, Dividend or Interest. This value defaults from the supplier to the invoice, but can be changed.

    1099 box (field BOX1099)

    Default box number with respect to which payments must be printed on the 1099 record. Box numbers vary according the 1099 record at use. This value defaults from the supplier to the invoice, but can be changed. Inactive 1099 boxes are not available for selection.

    Amt. subject to 1099 (field AMTSUBJ109)

    Invoice amount subject to a 1099 declaration. This amount is automatically calculated based on the sum of the invoice ex-tax amounts for the detail lines having the 1099 field set to Yes.

    Grid Analytical

    No. (field NUMLIG2)
    Dimension type (field DIE)
    Dimension (field CCE)

    The dimensions entered here will be used as default values for invoice lines.

    Tab Lines

    This grid displays each of the invoice lines from an accounting point of view:

    Nature

    If the account is subject to dimensional accounting, it is necessary to define its nature. At general accounts level, it is possible to define a nature linked automatically to an account. The nature field cannot then be modified.

    See the documentation on General accounts for further information.
    On the other hand, if a nature screen has been defined, it is possible to choose a different analytical nature conforming to the screen.

    Dimension types

    If the accounting amount is not distributed over several analytical dimensions, the 'Allocation' field cannot be assigned. The entry is achieved directly in the following columns, in the dimension concerned, for each of the dimension types.

    Default dimensions can be defined at the level of the nature, but those defined by the default dimension processing have priority.

    See the documentation on the default dimensions.

    Field descriptions

    CAI assignment

    CAI number (field CAI)
    Validity date (field DATVLYCAI)

    Grid Details

    No. (field NUMLIG)
    Site (field FCYLIN)

    The site of each line can be different from the header site. In this case, the generated journal will be balanced site by site using inter-site link accounts.
    It is possible to modify the site on the line and so to carry out the inter-site operations in the same legal company. The reciprocal entries are generated automatically on the reciprocal accounts previously set up.

    Refer to the documentation Reciprocal accounts for further explanations.
    By default, the site proposed is that defined in the invoice entry header.

    Specificities linked to intercompany invoices (GESBICI and GESBISI functions protected by the activity code INTCO - Intercompany transactions):
    When entering intercompany invoices, this field will display only the site of the companies that were defined in Intercompany account mapping.

    • A financial site belonging to another company can be selected.
    • A target company must be mapped to the source company and the invoice parameter INTCPYINV - Intercompany invoices (TRS chapter, INV group) must be set to 'Yes' for the target company.
    Company (field CPYLIN)
    Ctrl. (field SAC)

    No help linked to this field.

    BP (field BPRLIN)

    The choice of accounting allocation is determined by:

    • a control account: the account that is associated with it is displayed by default, the BP must be specified.
    • a general account,
    • a BP: the control account code and the associated account are displayed by default.
    Settlement discount (field FLGDEP)

    This field is used to specify if an invoice line is subject to discount.
    This field can be viewed and accessed only if:

    • a discount code (containing negative rates) is specified on the invoice, 
    • parameters GERDSC - Early discount/late charge and BRIDSC - Discount on tax are disabled.
    Amount - tax (field AMTNOTLIN)

    Enter in this field the ex-tax amount of the recorded operation.
    When the amount is negative, it is passed as a credit in accounting in the case of a supplier invoice and as a debit in the case of a credit memo.
    Warning The invoice cannot have a negative ex-tax and tax-incl. total: it is possible for some on line ex-tax amounts but the ex-tax amount of the header is always positive.

    1099 (field FLG1099)

    The 1099 flag is used to indicate whether a line is submitted to a 1099 declaration. If the supplier must be subjected to a 1099 declaration, the default value of this line will then be positioned to Yes. If a line for this supplier is not subject to 1099, then this flag can be changed to No and the line will not be included in reportable 1099 amount.

    Tax (field VAT)

    When the account on the line is liable for tax, the tax field is accessible for entry. It is initialized with the tax code associated with the account or with the tax code associated with the rule.

    Refer to the documentation on the SAITAX - Tax Code Mandatory parameter (CPT chapter, VAT group).
    Based on the context, it is necessary to verify that this tax code corresponds to the tax actually applicable, or it should be modified. The tax code defines the rate, the rules and the terms for the tax deduction applicable to the operation.

     A contextual menu suggests the option "enter tax".It is possible to specify the taxes other than VAT (additional/special taxes) likely to be assigned to the VAT calculation and therefore the Tax-incl amount.This screen is also used to define from what part of the amount the taxes are deductible.
    Only one tax code consistent with the legislation and the group of the site company can be entered.

    The general principles linked to the multi-legislation setup are detailedhere.


    The Tax incl amount is calculated according to the taxes chosen.

    Tax amount (field AMTVAT)
    Amount + tax (field AMTATILIN)

    No help linked to this field.

    Purchase type (field PURTYP)

    Depending on the journal setup, a different accounting process can be performed based on the purchase type.
    This field can take two values : 'Purchase' or 'Fixed assets'. It is used to define the VAT type applicable on the invoice line and it therefore conditions the VAT account that will be automatically used upon accounting posting of the document.

    Withholding tax (field RITCODSRC)

    Deduction at source code.

    Comment (field DES)

    It is possible to manually enter a comment on the line. By using:

    • " /", the account title is displayed by default,
    • " = ", the previous line title is copied.
    VAT declaration no. (field DCLEECNUM)

    This field is displayed only if the following conditions are met:

    • The KPO - Portuguese localization activity code is active.
    • The company to which the invoicing site is linked manages the Portuguese VAT (the value of the company parameter PORVAT - Portuguese VAT (LOC chapter, POR group) is "yes").
    • This field is not set up as hidden at entry transaction level.

     This field is initialized:

    • on the first line: with the supplier EU VAT number indicated in the invoice header,
    • on each of the next lines: with the EU VAT number indicated on the line preceding the current line or, if not, with that of the supplier indicated in the invoice header.

    It can still be modified if it is set up to accept entries at entry transaction level and if the invoice is not validated.

    Unit (field UOM)
    Quantity (field QTY)

    Upon setting up an analytical nature (Common data/Accounting Tables/Analytical/Natures), whether there is work unit entry is defined, then a default value is attributed to it by specifying its default value (in reporting currency).
    It is this unit that will appear during document entry. The quantity is automatically calculated by dividing the Ex-tax amount (converted into reporting currency) by the work unit value.

     The quantity can be modified.

    Project (field PJTLIN)

    After invoice validation, the project reference the invoice line is allocated to can no longer be modified.

    Cost type (field PCCCOD)
    Distribution (field DSP)

    Defined here are the allocation methods for the line amount on the different dimensions of each dimension type.

    These methods are defined as follows:

    • the entry of an analytical allocation key previously configured,
      See the documentation on Allocation keys for further information.
    • in amount. It is then possible to allocate the amount to as many sub-amounts as required,
    • in percentage. A calculation is performed based on the sum of the coefficients used for the allocation.

    Example: on a basis of 100, a coefficient of 10 will be read as 10 %. But, on a basis of 50, a coefficient of 10 will be equivalent to 20 %.
    For these two later cases, it is possible to pre-initialize the allocation with an already existing key. The final display will be "$".

    field CCE1

    The setup determines if the analytical dimensions can be modified. They are initialized based on the setup of the default dimension.

    In creation mode, if no order line has been entered and the project code is modified, the analytical dimensions are reset based on the setup of default dimensions.

    In creation mode, as in modification mode, if an order line is entered and the project code is modified, the analytical dimensions are not reset.

    Totals

    Discount basis (field BASDEP)

    The discountable base is only displayed if the two following conditions are met:

    • a discount code (containing negative rates) is specified on the invoice, 
    • parameters GERDSC - Early discount/late charge and BRIDSC - Discount on tax are disabled.

    The discountable basis depends on:

     If the user wants to add a discount after saving the invoice, the discount code addition can be performed via button [Open items]. Fields "Discount" and "Discount basis" will be hidden and the discountable basis will be equal to the tax incl total.

    field CUR3
    Total excluding tax (field TOTNOT)
    field CUR1
    Total including tax (field TOTATI)
    field CUR2

    Account

    field AFFICHE
    Supplier amount type (field PURPRITYP)
    Account inquiry

    AFC/GESBIC/40/405

    Statistical codes

    AFC/GESBIC/40/410

    Periodic accruals

    AFC/GESBIC/40/415

    Account structure

    AFC/GESBIC/40/420

    Action icon
    Supplier notes

    Select this option to display the note(s) associated with this supplier. This window could open automatically depending on the setup defined when creating the notes.

    Notes are limited to a screen inquiry and cannot be printed. See the Notes documentation for more information.

    Intercompany dimensions

    The Intercompany dimensions window will automatically appear if different dimensions are found between the source and target company, or by selecting Dimensions from the right-click menu on the line.
    If the source and target companies use the same ledger and exactly the same dimension type and number, the Intercompany dimensions window is not used.
    This window is used to enter the target company’s dimension type values when the dimension types are different between the source and target company.
    Only the dimension types associated with the displayed/entered ledgers can be entered. If the ledger is not displayed, then the dimensions for the target company cannot be entered.

    Up to 20 dimension types can be displayed in the Intercompany dimensions window.

    WarningAn error will occur if dimensions are required for the analytical ledger and the source company does not include an analytical ledger, but the target company does.

    Reports

    By default, the following reports are associated with this function :

    Bullet point  SIMFACFOU : Simulation supplier invoices

    Bullet point  FACTRSF : Supplier invoice list

    This can be changed using a different setup.

    Specific Buttons