Customer intercompany invoices
Use this function to manage customer invoicing outside the typical sales cycle.
In this context, you do not manage the order or the receipt note for the stock issue (etc.). When issuing the invoice, the data required for accounting is recorded.
As for customer tracking (open item statements, reminders, payment management, etc.), the process is the same for invoices that come from the complete cycle or that come from entering a BP invoice.
- In this document, the term 'invoice' has a generic meaning: It can be an invoice, a credit note, a debit note, or a credit memo.
- Invoices generated from recurring invoices cannot be deleted if they are used as a reference template (first recurring invoice/original recurring invoice).
In addition, the invoice must not be changed if it is also used as reference invoice. - For the Fixed Assets module:
When the SALINV - Sale invoice to generate parameter (AAS chapter, FAS group) is set to Yes, a BP customer invoice is generated automatically after validating the Asset disposal with a Sales reason. When the issue applies to a main asset and its components, only one customer invoice is generated with as many lines as there are sold assets.
Each asset concerned can be identified using its reference displayed at the level of the Comment field in the invoice line.
The values of some fields taken from the information entered during the asset disposal cannot be modified: The accounting date, the currency and customer of the Header section and the amount, as well as all tax elements of the Lines section.
Specificities linked to customer intercompany invoices
- This function is available only if the INTCO - Intercompany transactions activity code is active.
- Invoices can be generated only if the selected company has INTCPYINV - Intercompany invoices (TRS chapter, INV group) set to "Yes".
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:
- The first account column is linked to the COA of the target company main general ledger.
- For the subsequent COA columns, an entry is made only if there is a COA for this ledger type in the accounting core model of the target company. If not, then the column will be skipped.
- Only the dimension type codes 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.
An 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. - For the column name, the COA name of the source company ledger will always display even if it is different than the target 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 site,
- The invoice type which determines the document category (invoice/credit memo/debit note/credit note), the automatic journal, the journal and journal type that will be used during document posting
See the documentation on the customer invoice type. - The document number (where a manual numbering range is authorized)
- the document posting date, by default that of its receipt in the folder,
- The customer identification code and the control account on saving the document
You can define:
- the invoice header,
- the invoice lines.
After this information is entered, you can Post the invoice to accounting.
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 SIVTYP) |
Enter the invoice type code to reference the invoice category and the entry structure used when validating 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. |
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. |
Customer (field BPR) |
No help linked to this field. |
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) bills installation services for itself and another company (target). A portion of the invoice is revenue for the source company and the other portion of the invoice is revenue due to the target company from the source 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 |
REVENUE - INSTALL |
300.00 |
Using account in Company B |
A |
A1 |
REVENUE - INSTALL |
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 |
REVENUE |
|
700.00 |
|
A1 |
DUE TO COMPANY B |
|
300.00 |
Source due to |
A1 |
ACCOUNTS RECEIVABLE |
1,000.00 |
|
|
Company B
Site |
Legal |
Debit |
Credit |
Description |
B1 |
REVENUE |
|
300.00 |
|
B1 |
DUE FROM COMPANY A |
300.00 |
|
Source due from |
Tab Header
Invoice characteristics
Some fields in the header are used to complete the invoice:
- Amount -tax and Amount +tax fields
By default, entering an amount in either field is optional. This is controlled by the HEAAMTBPC – Cust. inv. header amt. ctrl parameter (TRS chapter, INV group).
When you enter amounts on the invoice lines, these amounts automatically display in the corresponding fields on the Header. If the amounts are different, a warning message displays by default: Totals different from header. Use the WRNMSGBPC – Customer inv. warning msg. parameter (TRS chapter , INV group) to disable the display of this message. - The link between a credit memo and the original invoice using this invoice number, or the link between the credit memo and the credit memo request number from the customer, etc.
- The default analysis for this invoice is then applied to the payments for the BP accounts:
You can define the default dimensions in the invoice header.
See the documentation on Default dimensions.
Open item characteristics
Use the remaining fields to define the open items in the invoice with respect to payment management (pay-by BP identification, payment conditions), to the open item statement management, and to the reminder process.
Once the invoice has been saved, you can click Open items action to view the open items and the status of the related payment.
Detail
Source document date (field BPRDAT) |
Enter the invoice date. This field defaults to today's date. |
Source document (field BPRVCR) |
This field is used to record the number or the reference of the source invoice. |
Spanish invoice type (field INVTYPSPA) |
This field is only available when the sales site is linked to a Spanish company. Use this field to select the type of issued invoice. This information will be sent to the online portal of the Spanish fiscal authorities when transmitting fiscal data from the SII monitoring function. When creating a credit memo, the default credit memo type is determined by the SIIABTYP - SII credit memo type parameter (LOC chapter, SPA group). |
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 field displays a control amount that is compared to the line total during the recording. This amount is mandatory when the HEAAMTBPC – Cust. 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. 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. |
DER code (field SPADERNUM) |
Project (field PJTH) |
After invoice validation, the project reference the invoice is allocated to can no longer be modified. |
VCS number (field BELVCS) |
Field linked to the Belgian legislation. Reminder: 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:
In the case of sales invoices and customer BP invoices, this number is automatically generated and cannot be modified. The generation of the encoding number is performed:
The field is not loaded if the invoice is of pro forma type. If the invoice type is a direct credit memo, the encoding number remains empty. If the invoice type is a credit memo linked to an invoice, the VCS number of the invoice is attached to it. In case of a site modification, the display of field "VCS number" is reinitialized. In the case of a credit memo linked to several invoices, a control prevents the credit memo from being attached to the various invoices. The user must create as many credit memos as there are invoices. |
Field 40 - reason (field FLD40REN) |
Field subject to activity code: KPO - Portuguese localization |
Field 41 - reason (field FLD41REN) |
Field subject to activity code: KPO - Portuguese localization |
Original document no. (field ORIDOCNUM) |
Period start date (field PERDEB) |
To (field PERFIN) |
Block number 3
Status (field STA) |
Printed (field STARPT) |
Tax rule (field VAC) |
Enter the VAT management type associated with the customer invoice. |
Amount type (field SALPRITYP) |
These two radio buttons, initialized from the BP, are used to define whether the amounts on the invoice lines are entered as Tax excl. or Tax inc. The choice between Ex-tax or Tax-incl. is only possible upon invoice creation.
If the DEPMGTMOD - Discount management mode parameter (TC chapter, INV group) has the value Rebate on VAT, the type of amount is Ex-tax by default, regardless of the value of parameter SALPRITYP - Amount/Price type (TC chapter, INV group). You cannot select Tax-incl.. |
Entity/Use (field SSTENTCOD) |
Enter the Entity/use code to calculate the precise tax amount for the customer. This tax code is compatible with the Avalara system and makes it possible to determine the customer type for fiscal purposes. This field is available for all countries. The Entity/Use code can be entered for any delivery address when a document is being processed for a country that is tax-exempt. When the Calculate all
documents connection with SST is set to No and
an Entity/use code is entered, the document is exempt from tax and not subject to processing costs. |
Open items
Factor (field BPRFCT) |
If the invoice is to be factored, enter the code for the factor that will collect for this invoice. You need to enter a factor with a Company and/or Site that is compatible with the Company and/or Site of the open item. By default, the factor code is defined in the customer record. For example:
|
Factor name (field BPRFCTNAM) |
Statement (field XSOI) |
Indicates if the generated open items will have 'to be put on the statement' or not. |
Reminder (field XFLGFUP) |
Indicates if the generated open items will have 'to be relaunched' or not. |
Payment
Pay-by (field BPRPAY) |
This BP indicates the pay-by or paid BP |
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. |
Due date (field DUDDAT) |
Early discounts/Late charges (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. |
Comments (field DES) |
You can manually enter up to three comments. Note: You can add content from the first comment to the Comment field on the Lines tab by entering // in that field on the Lines tab. |
VAT declaration no. (field DCLEECNUM) |
This field is displayed only if the following conditions are met:
This field is initialized:
It can still be modified if it is set up to accept entries at entry transaction level and if the invoice is not validated. |
Mandate reference (field UMRNUM) |
If the company and/or the pay-by BP is modified, the mandate reference is modified accordingly.
|
ISR/QR reference number (field BVRREFNUM) |
This field displays the ISR reference number created for an invoice if the SWICUSBVR - Swiss ISR usage Sales (LOC chapter, SWI group) parameter is set to Yes. If a new invoice is created, the ISR reference number is calculated when the invoice is saved. When the SWICUSBVR parameter is set to Yes, this field only displays a value if an ISR payment term is used and the invoice currency is CHF. If you copy an invoice, the existing ISR number is removed. A new number is created when the copied invoice is saved. Refer to the Swiss legislation guide available from the How to tab of the Online Help Center for a global view of how to use the ISR. |
Payment bank ISR/QR (field PAYBAN) |
This field displays the ISR payment bank determined for the invoice if the SWICUSBVR - Swiss ISR usage Sales (LOC chapter, SWI group) parameter is set to Yes. When the SWICUSBVR parameter is set to Yes, this field only displays a value if an ISR payment term is used and the invoice currency is CHF. The payment bank information is used to print the necessary sender’s bank account information on ISR payment forms. Use this bank account as the destination account when paying the invoice. The ISR payment bank is only considered in the ISR process. The ISR payment bank for the invoice is determined by the Payment bank ISR/QR field in one of the following functions. The system pulls the information from the first entry found.
If you copy an invoice, the existing payment bank is removed and the payment bank determination is repeated when the copied invoice is saved. Refer to the Swiss legislation guide available at the online help center for a comprehensive overview of setup and usage of this function. |
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
The grid in this section is used to characterize 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.
Analytical dimensions.
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.
Grid Details
No. (field NUMLIG) |
It is the line number. |
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. Specificities linked to intercompany invoices (GESBICI and GESBISI functions protected by the activity code INTCO - Intercompany transactions):
|
Company (field CPYLIN) |
Ctrl. (field SAC) |
This check box is only available if the Control check box is selected in the Chart of accounts function (GESCOA). Select this check box to indicate that the account is associated with a BP. |
field ACC1 |
In certain fields on the screens, use of access codes have been incorporated. These codes are used to restrict access to data by certain users. In order that a field can have an access code available to a user, it is necessary that this code is present in this table. As a function of the rights which are assigned to the user, he/she can then consult or modify the field. The access codes are equally used to restrict access to certain functions started by buttons on the screens. It is necessary to assign each access code defined in the grid.
|
BP (field BPRLIN) |
The choice of accounting allocation is determined by:
|
Settlement discount (field FLGDEP) |
This field is used to specify if an invoice line is subject to discount.
|
Amount - tax (field AMTNOTLIN) |
Enter in this field the ex-tax amount of the recorded operation. |
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. |
SST tax code (field SSTCOD) |
Define the default value of the Sage Sales Tax (SST) tax code. This tax code is recognized by the Avalara system and is used to identify line types for fiscal purposes. |
Tax amount (field AMTVAT) |
Enter a tax amount if the standard calculation for the tax amount on the line does not apply. If the tax code changes, these amounts are reinitialized. |
Amount + tax (field AMTATILIN) |
No help linked to this field. |
Sales type (field SALTYP) |
This field is currently no longer used. |
Comment (field DES) |
You can manually enter a comment or add content from another field using the following characters:
In the case of an invoice generated automatically after validating the sales of fixed assets, this field contains the reference of the sold fixed asset and cannot be modified. |
Unit (field UOM) |
The work unit entry is defined is determined when setting up an analytical account. It is associated with a unit specifying its default value (in reporting currency). |
Quantity (field QTY) |
The quantity is automatically calculated by dividing the Ex-tax amount (converted into reporting currency) by the work unit value. |
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) |
This field is used to define the allocation methods for the line amount on the different dimensions of each dimension type.
For instance:
For these two latter cases, it is possible to pre-initialize the allocation with an existing key. The final display is '$'. |
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:
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) |
This field indicates the tax-incl. result including the tax calculation by tax basis. This information appears when printing report ARCTTC2. The detail of the tax incl. calculation is obtained by right click on the total amount. The detailed calculation is stored in tables SVCRVAT and SVCRFOOT. To access the detailed tax statistics based on 'Sage Sales tax' (SST), click the link in the tax-incl. total field. This option is only available if the document is issued by Sage Sales Tax (SST). If SST is used, the recording and cancellation of a fiscal document are taken into account during the:
If the tax is not calculated, the invoice is not created.
|
field CUR2 |
Account
field AFFICHE |
Amount type (field SALPRITYP) |
Account inquiry |
Select this option to access the account inquiry for the account on the line. |
Statistical codes |
Select this option to associate up to three statistical codes to each invoice line and the posting. |
Periodic accruals |
Select this option to open the Accruals management screen to post the line amount, or the tax excluded amount to analytical or general accounting according to a specific schedule. Note: To take advantage of this, you must activate the SVC - Periodic accruals activity code and the SVCFLG - Accruals generation parameter (TC chapter, SVC group) must set to Yes.
|
Account structure |
Select this option to assign an account structure for the line. The account structure is used to predefine the group of accounting and analytical postings for a journal and to load them directly on entry. Applying an account structure can be proposed by default after entering the tax excluded invoice amount. The structure used is the one defined in the customer record in the Financial section. See the documentation on Account structures for further information. As for the amounts, from the assignment coefficients defined in the structure, they are automatically calculated from the tax-excl. amount of the invoice. |
Customer notes |
Select this option to display the note(s) associated with this customer. 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. Up to 20 dimension types can be displayed in the Intercompany dimensions window. An 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 :
BPCINV : Customer BP invoice
BPCINV2 : Customer BP invoice
BPCINVFIN : Final invoice
BPCINVPRE : Prepayment invoice
BPCINVTAX : Customer BP invoice
SIMFACCLI : Simulation customer invoices
FACTRSC : BP invoice list
This can be changed using a different setup.