Need help? Contact us
The best tool to control foreign trade operations. This system will allow you to carry the inventories of your foreign trade operations in compliance with legal provisions.
The system has interfaces and automatically receives all the information from the SAT through an interface with Data Stage. You can also connect to the WEB SERVICE of the one-stop shop for COVES in E-DOCUMENTS. It has an audit module that helps you constantly monitor your next due dates, lack of information, inconsistencies in captures, etc. In addition, it allows you to make reconciliations between your information captured in annex 24 vs annex 30.
The user manual is located within the system in the help button located at the bottom left of the main menu.
The second button is the one that will open the user manual in pdf.
The datastage interface can be found in Annex 24 – Interfaces – data-stage
1. The DataStage query in .zip format sent by the sender [email protected] must be copied, pasted in a location that the system can read and unzipped into a folder.
2. When opening the application to load the DataStage it mentions that you can drag the unzipped folder or search for it with the browser.
3. With the folder selected, click the process button (second button), you must leave the two boxes below active, one is to store the query as data and the other to be able to reconcile.
4. The interface will start to read, analyze and load the information. At the end of loading the information, the application will ask a couple of questions:
1. The first Do you want to update the data for the information that comes in the query?
If the answer is NO only charge you the missing petitions
If the answer is YES It will replace the petition data that is in the system with the information that the datastage brings
It will confirm that the missing motions have been loaded or that they have been replaced.
2. The second question is, do you want to bill with the DataStage information?
The answer depends on the management of each company.
Answer NO; It is for companies that their inventory control is by part number the answer and it will be necessary to upload the invoices of each request by part number
Answer YES; It is for companies that their inventory control is by tariff fraction so that the interface loads the invoices by fraction (instead of the part number).
At the end it will confirm that the process was completed satisfactorily
The system allows the user to select the imports that will be affected by a given export. To do this, the user must identify, depending on the type of operation, the button on the right side that appears as a magnifying glass called "selective download".
Pressing this button will bring up a table with all the input records that can be downloaded.
There, the user will be able to make filters with the data that coincide with his search, either by request, date, regime, supplier, part number, etc. Once the record to be downloaded has been identified, it must be selected with the cursor and added to your invoice for download with the “select” button.
You can repeat this operation as many times as necessary to complete your invoice for download, or by using the "Ctrl" key simultaneously when selecting with the cursor, you can select several records before pressing the "select" button.
Once you have selected the records to download in your invoice detail, indicate "exit", then the system will show you the information of the records that will be downloaded. There, the user can change the amount to be downloaded for a smaller amount or the value of the merchandise to be downloaded. The amount cannot be greater than the available balance in the selected record.
It is very simple, if we want to disapply an export, return or regime change invoice in particular, it is necessary to enter the petition in editing mode. Subsequently, select the invoice that you want to unapply and locate the "unapply selective download" button. By pressing this button, the system will return the balance to the imports that were affected by this invoice, however, it will not delete the relationship that exists with the affected imports, so if you press the save button again, it will be selectively downloaded again from the same way, unless you select the game, delete it completely, and re-enter it.
It is important to point out that this option will only unapply those invoices that were selectively downloaded..
This case is because the petition has a rectification to which its invoice(s) are transferred, you can locate which is the petition that is rectifying it, putting its consecutive number in the last column of the petition catalog.
It is important to point out that this option will only disapply those invoices that were selectively downloaded.
Filter by its consecutive in the last column
Request R1 that is rectifying it
Request R1 with invoices enabled and indicating which request is being rectified
Once the datastage is loaded, the system can reconcile what it has against what the datastage brings, this in the Audit menu – Reconciliation vs Glosa.
The first step is to select in the text menu of the interface the option queries, Click on choose date, it must be a period in which the datastage is already loaded in the system
Once the period to be reviewed has been selected, the reconciliation allows you to quantitatively audit the pedimentos, the first option in the menu of Pedimentos – Pedimentos in Integra and not in glosa, they are pedimentos that would be left over because of some error the system captured and they do not coincide with the pedimentos that are in the datastage.
In the second menu option Pedimentos - Pedimentos in glosa and not in Integra, they are pedimentos that are yet to be registered in the system.
Values can also be audited, the first option of the menu of Values – Values at pedimento level, It will compare values that are in the system request header against datastage, values such as dta, prevalidator, entry and payment date, etc.
In the second menu option Values – Values at game level, here you can audit the values of the items of the request as quantity umc/umt, unit of measure umt/umc, IGI, VAT, commercial value, customs value, etc.
The reconciliation will indicate a correct value, it should be noted that this value is the one that the datastage brings, but it is recommended to check against the physical request and make a decision on what value to leave registered in the system.
The last option of the audit is to know which datastage you have loaded into the system with the option of Files in system.
All the information reflected in the reconciliation can be exported to Excel with the X button.
If the report of all the structures that are in the IPS system can be generated, this is in Annex 24 – Catalogs – Products (structure).
The first step is to select in the text menu of the interface the option queries, Click on choose date, it must be a period in which the datastage is already loaded in the system.
Click the printer button on the button bar for the catalog, the first structure of the catalog will be printed, we close it and there will be a filter box where the number zero should be at the beginning and the letter Z at the end
With this, all the multilevel structures will be generated.
You can export to Excel or PDF, with the envelope button on the report toolbar, preferably it should be exported to an application destination.
To be able to modify or delete an invoice import that is affected by download, first you have to unapply it, for this it is necessary to investigate which export(s) are downloading it, you can check it in the download query, range of initial and final invoices, the name of the import invoice and activate the apply filter to imports check.
Annex 24 – queries – downloads
If there are many export invoices that are affecting you, you can unapply by date range and if there are few you can unapply the export invoices one by one, this in the process of unapplying downloads. Annex 24 – Processes – Unapply download.
By dates, within that range must be the invoices to disapply, invoice filter as it appears by default
By invoice, you must close the initial and final invoice filter for each export invoice that is going to be unapplied, a range of dates where each invoice is, do this for each export invoice that is going to be unapplied.
To be able to modify or delete an export invoice, it is unapplied directly in the unapply download process as in the previous image.
The system connection to the database is through ODBC data sources.
The name of the DSN should be called “Integra” and select the driver according to the database if it is ACCESS must be selected “Microsoft Access Driver (*.mdb)” and select the database that is called impexp.mdb the user must have full privileges on the folder where the database is.
If the database version is in SQL, the DSN should be called “Integra” the driver to select is “SQL Server”, the authentication is through Windows, the user must already have security access in the SQL instance of the server in which the system database is located
Users must have the following permissions on the database of integra: db_datareader, db_datawriter, db_owner y public.
The first process is to load or capture the CTM in the system, after this is to download the CTM in Annex 24 – processes – downloads, Invoice range in initial and final number of the CTM, in date range a large period (all year) where that CTM is.
Once finished you can check if I downloaded that CTM something from section A in Annex 24 – queries – downloads, starting and ending invoice range the CTM number, date range as it appears by default (blank).
Once the query is generated, it is filtered in the annex by A and if it returns data, you can enter the CTM and freeze section A, so that the download does not move