General configuration of the product for France

Use these steps to perform general configuration of SyteLine for France.

  1. Specify this general setup information for the sites using the France Country Pack.
    Note: If you have a company or branch that has operations in France, you can set up a separate site (accounting entity) for that company/branch with a France main address, using the Euro as the domestic currency. Add the new site and define its parameter and master data, as described in the SyteLine Multi-Site Implementation Guide. Keep the information below in mind as you follow that guide.
    Form Setup/Notes
    Multi-Currency Parameters If this site is based in France, set Domestic Currency to EUR (euro).
    Optional Modules Enable the France Country Pack.
    Chart of Accounts See Setting up accounting for France.

    Ensure that you include accounts for these areas:

    • Federal Tax payable
    • VAT A/R Received
    • VAT A/P Paid
    Accounting Periods In accordance with French law:
    • Each period must begin on the first day of the month and end on the last day of the month.
    • An accounting year cannot be expressed over a period of more than 23 months.
    • Accounting entries can only be entered for the current fiscal year or the previous fiscal year for closing purposes.
    Prov/States Define French provinces.
    Groups Select the FR Loc group. Add to that group all users who need to access the FEC File Export form or who need to access the FEC File Logical Folder.
    General Parameters
    • Select these options:
      • Post to Journal, required for inventory variation reporting
      • Activate EU Reporting, required to generate EU documents such as the European Supplemental Statistical Declaration
      • Use Analytical Ledger, required to meet French GAAP posting specifications
      • Secure Control Accounts, required to prevent user access to control accounts in transaction forms
    • If you want to use Multiple Financial Sets of Books, select that option.
    • Specify the FEC File Logical Folder, which is then displayed as the default logical folder on the FEC File Export form
    • Specify this information, which is used on many French forms and reports:
      • In the Business Identification Number field, specify the 14-digit SIRET number for the company and establishment.
    • If this site is based in France, specify a French address in the Address area.
    Tax Parameters
    • Set your company's Tax ID (Fed ID). For French companies, this ID is made up of a 2-digit data processing code plus the SIREN, to form an 11-digit number. (The FR prefix is added by the system.)
    • Select Prompt for Tax System.
    • Set up the Cash Rounding Factor if final cash invoices must be rounded up or down. If this factor is greater than zero, then the Cash Only flag is prompted for on the Billing Terms form. When a customer order is entered with a billing term where the Cash Only flag is selected, then the final invoice is rounded to the nearest Cash Rounding Factor amount. The special rounding calculation is only performed as regular, credit memo, or adjustment invoices are printed and posted. This rounding is not made anywhere else in the system.
    • Specify the Agent Vendor to identify the taxing agent.
    • Specify a SSD File Logical Folder to use when the Supplementary Statistical Declaration (SSD) file is generated on the EU Supplementary Statistical Declaration Report form.
    • Specify the SSD Dispatch Interchange ID and the SSD Dispatch Arrival ID.
    Tax Systems Set up an item-based tax system with Tax Mode set to Item and description set to VAT.

    Select these options for that tax system:

    • Prompt on Line Item
    • Active for Purchasing
    • Apply to Progressive Billing
    • Record Zero Rated
    • Tax Discount Allowance

    Set Tax ID Prompt Location to Both.

    In the Labels area, specify these labels:

    • Tax Code Label and Description: VAT Code
    • Tax Code Item Label and Description: Apply VAT
    • Freight Tax Code Label and Description: Freight
    • Misc Tax Code Label and Description: Misc Code
    • Surcharge Tax Code Label and Description: Surcharge
    • Amount Label: VAT Amt
    • Accumulated Amount Label: VAT Amt
    • Tax ID Label: VAT ID
    Tax Codes
    • Define a VAT tax code where the Tax Code Type is set to Rate and the Tax Rate is set to the VAT percentage.

      Select Include Price and Deductible for this tax code.

      Assign accounts to the AR Tax Account and AP Tax Account fields for this rate-type tax code.

    • Define another tax code for European purchases, where the Tax Code Type is set to Exemption.

      Select Deductible and Assess on Return for this tax code, and set an Acquisition VAT account.

    • Define any local exemption tax codes. In this case, specify the exemption number in the code description.
    • If needed, define a Rate type tax code where Transfer VAT is selected, to enable VAT recognition upon bank reconciliation. Specify a VAT percentage, select Include Price and Deductible and assign accounts to the AR Tax Account, AP Tax Account, VAT AR Received and VAT AP Paid fields for this rate-type tax code.

    Domestic sales (sales within a country) use only the rate-based code, and no exempt codes. Sales within the EU use both the rate-based and exempt codes. The exempt codes always cause the VAT to be zero percent.
    Tax Systems Return to this form and select the item-based tax system you created earlier. In the Tax Codes area of the form, specify the rate-based tax code (defined above) for these fields:
    • Item Tax Code
    • AR/AP Tax Code
    • Freight Tax Code
    • Misc Tax Code
    • Commission Tax Code
    • Non-A/P Tax Code
    • Non-A/R Tax Code
    Currency Codes You can set format masks for different currencies on this form, to specify the number of digits after the decimal point.
  2. On the Process Defaults form, set Enable audit logging to 1 to enable audit logging for use with the JET report.
  3. Set up at least one vendor for whom the country code is France.
    For France vendors, verify that these fields are set as shown in the table:
    Field on Vendors form Condition
    Vendor Numeric only; 6 digits or less
    Vendor Description (Main area) Must exist
    Postal/ZIP (Main area) Must exist
    City (Main area) Must exist
    Country (Main area) Must exist. The EU Code is set automatically when the record is saved, based on the country.
    FOB (General area) Specify the free on board location. This is the location at which title for the goods purchased passes from the vendor to the buyer
    VAT ID (Taxes area) The ID for French companies must be an 11-digit number. (The FR prefix is added by the system.)

    After you save the record, the VAT Validation button should be displayed. Click it to verify the ID. **
    EU Reporting fields (Taxes area) Specify the appropriate information in these fields: NOTC, Secondary NOTC, and Delivery TermsFOB
    Note: ** For the VAT Validation buttons to work, the Validate EU VATIN event handler must be active on the Event Handler Activation form.
  4. Set up at least one customer for whom the country code is France.
    For France customers, verify that these fields are set as shown in the table:
    Field on Customers form Condition
    Customer Numeric only; 6 digits or less
    Customer Description (Main area) Must exist
    Postal/ZIP (Main area) Must exist
    City (Main area) Must exist
    Country (Main area) Must exist. The EU Code is set automatically when the record is saved, based on the country.
    VAT ID (Taxes area) The ID for French companies must be an 11-digit number. (The FR prefix is added by the system.)

    After you save the record, the VAT Validation button should be displayed. Click it to verify the ID. **
    Note: ** For the VAT Validation buttons to work, the Validate EU VATIN event handler must be active on the Event Handler Activation form.
  5. On the Customer Ship-Tos form, if the VAT ID is identical for all of a customer's ship-to addresses, just copy the VAT ID without validation. If the VAT ID is not identical, specify the VAT ID and validate it as you did on theCustomers form.
Next steps: Read through the Requirements section of this guide. That section explains the country-specific requirements, and points to help topics you can use to set up SyteLine.