Refer to documentation ImplementationUse this function to generate:
The 1099 file is divided into two parts:
You can generate the 1099 file amounts to be declared. Any person who paid fees, commissions, and other remunerations to a third party within the framework of their job must declare all these amounts.
From the current issuing site, the assigned company of this site is moved up based on the extraction parameters. Typically the 1099 issuing site is the declaring site of the assigned company. This information is used to calculate the S10 segments.
Then, for each company to be processed:
As of 2024, the records are separated by a line break at the end of each TBSBI record, which lengthens the file. As a result, you need to modify the file format as described below.
See the PROCÉDURE BILATÉRALE DE TRANSFERT DES DÉCLARATIONS DE SALAIRES ET/OU HONORAIRES SOUS PROCÉDÉ INFORMATIQUE for more details.
Go to > Declarations > Fee Declaration > Others
In the Fee declaration parameters function (GESTFT) and for all TDSBI code records add a technical field with an alphanumeric length of 2 and enter this formula: Chr$(13)+Chr$(10)
For the Annual Declarations Collection Information System update, the address much match the postal format exactly. This applies to all address in France including overseas departments (DOM). Overseas territories (TOM) and foreign countries are exempt.
Two important address considerations:
As a result, you have 2 options without changing the data structure:
Option 1 Adjust the bilateral TDS procedure file settings:
Change the file settings to only provide the 2 required pieces of address information.
In the Fee declaration parameters function (GESTFT), apply the changes in green to the cells of the TDSBI record - fee line.
This same configuration must be applied to the fields in positions 182 to 188 for the TDSBI record – Establishment Header, as well as to the fields in positions 131 to 137 and 288 to 294 for the TDSBI record – Company Header.
Option 2 Adjust the company and site addresses and DAS2 information:
Populate the addresses in the available fields so that this format matches the standardized format. This can be done in the Provider record, or via an export of the providers followed by restructuring of the addresses in a spreadsheet and re-importing.
Adjust the content of the Street number field (STREETNUM) in the Company, Site, and Provider records so that it contains the street number with four digits. For example, if the street number is 16, change it to 0016; if it is empty, fill it with 0000; and so on.
Adjust the content of the Street field (STREET) in the various Company and Site records to ensure it complies with the structure below. Refer to the administration’s documentation for more details. Note that the rules applicable to addresses outside mainland France and the overseas departments (DOM) remain unchanged.
| Position | Length | Content | Comment |
|---|---|---|---|
| 1 | 4 | Type of road | This must match the postal format exactly. |
| 5 | 1 | = space | |
| 6 | 21 | Street name |
For the fee provider addresses, adjust the Street number and Street fields in the Fee Provider records as described above.
The standard PRV import/export template allows for the export and update import of fee providers. It may be advisable to make a copy of this template to retain only the necessary information: the provider code and all data related to the address.
A standardized management of addresses is essential in exchanges between companies, administrations, and banks. Sage X3 can implement this change, which requires modifying the data structure in upcoming releases of the current version.
As of the 2024 R1 release, the the DAS2 data was restructured by creating the Type of road field, linked to a miscellaneous table. The TDSBI file configuration was updated with the use of this new field and the new formatting.
The 1099 extraction works on the basis of a list of companies supplied upon starting. The extracted fee lines are those that are recorded either directly on the 1099 sites of these companies, or on financial sites attached to these 1099 sites. The site registration numbers should be entered for the latter. In the same way, it should be checked that there are fees to be declared on each of the 1099 sites.
The 1099 declaration conveys information on the contractors that the extractor cannot load from the suppliers. This information should be entered before the 1099 file is generated. It is especially the case for:
The checks carried out on the 1099 file by the French administration are more extensive than for the Service Supplier File-Standard. Compliance with the standard is strict, and there are no controls for this. There are websites that can be used to download checking tools that should be implemented before submitting the file.
Refer to documentation Implementation
This function is used to control and generate the Service Supplier File (TDS).
Two types of Service Supplier File generation are possible:
There are new structural rules for the file as of 2024. Each TBSI entry is now followed by a carriage return, this will mechanically lengthen the size of the file.
The file name is generated using this format: PRAAAAMMJJ-HHHHHX.EXT:
Another file is created in parallel that is only used for processing: PRYYYYMMDD-TTTTTX.
There are new naming rules as of January 2023. You need install the patch to be compliant with these new naming rules.
Two files are generated in the log file according to the naming rules.
You need to full file name, including the extension, to generate the DAS2 report.
The file name is generated using this format
Selection
| Test file (field TEST) |
| Select this checkbox to generate a test file. The letter "T" is added to the end of the file name. |
| All companies (field ALLCPY) |
|
Select this checkbox to include all companies. To run this process for a single company, do not select this checkbox. |
| (field TDSFLG) |
|
Select the TDS option for the type of 1099 file to generate. Only the normal declaration is possible. |
Grid Companies
| Code (field CPY) |
|
Enter or select the company code. |
DADS-U
| Group (field GRP) |
| Enter the structure for the 1099 file to be used. |
| Type (field TYPFIL) |
| This is the type of declaration and cannot be modified. |
Block number 4
| Sending branch (field SENFCY) |
| Enter the declaration site issuing the 1099 file. It needs to be one of the companies in the list. |
| TDS year (field YEA) |
| Enter the year for the declaration. |
File generation
| field TYPEXP |
|
Select the location where the file is saved.
Client: on your local machine Server: a location on a shared server
|
| Back-up directory (field VOLFIL) |
| Enter the directory path. |
The only error messages are the generic ones.
Refer to documentation Implementation