Open the Get Item Ledger Entries window.

Finds the item ledger entries between the Fiscal Year Ending Date and the Gen. Journal Template, which are defined on the Options FastTab. One line per entry is created in the Intrastat Jnl. Line table. Only one line is inserted if the customer or vendor is in another EU country/region.

This batch job must be used in connection with reporting to Intrastat. All companies in the European Union must report their trade with other EU countries/regions. In your country/region, you must report the movement of goods to the statistics authorities every month, and the report must be delivered to the tax authorities.

If the item ledger entry is a sales shipment that is not yet invoiced, the amount is calculated as quantity multiplied by the item unit price. If you have chosen Yes in the Price Includes VAT field, the item sales price is reduced by the VAT amount.

If the item ledger entry is a purchase receipt that is not yet invoiced, the amount is calculated as quantity multiplied by item unit cost.

The batch job includes item entries from the inventory application area and the job application area.

The batch job includes item ledger entries but not general ledger entries. If you have entries of this type that concern Intrastat, you must type the entries in manually. For example, your company bought a computer for internal use from another EU country/region. The computer would not be entered in inventory but posted directly to a general ledger account. This type of entry must be typed manually in the Intrastat journal.

The completed ledger entries can be printed to a diskette that can be sent to Intrastat and the tax authorities by means of the Intrastat - Make Disk Tax Auth batch job. Before you start the batch job, you can print a checklist with the Intrastat - Checklist report. You can also choose to print a report with the information that is transferred to the printed form from the statistics authorities; the report is called Intrastat - Form. All the batch jobs and reports can be accessed from the Shortcut iconIntrastat Journal window.

Options

Field Description

Starting Date

Enter the first date of the period from which the item ledger entries are retrieved. The batch job includes all entries from this date to the ending date.

Ending Date

Enter the last date of the period from which the item ledger entries are retrieved. The batch job includes all entries from the starting date to this date.

Cost Regulation %

Enter a cost regulation percentage to cover freight and insurance. The statistical value of every line in the journal is increased by this percentage.


Tip


TRIMIT Add-on:

The following options have been added to the Get Item Ledger Entries batch job:

Assortment Level:
Here you specify whether Assortment quantity shall be interpreted as the quantity of Assortments or the quantity of Items in the Assortment BOMs.
If the parameter is set to Assortment, quantity will be interpreted as quantity of Assortments.
If the parameter is set to Component, quantity will be interpreted as quantity of Items included in the BOMs of the Assortments.

Use Item Price/Cost from Item if Price = 0:
When you set a check mark in this field, the program will use the Unit Price of the Item Card if the Unit Price is missing in a Sales Shipment Line and it will use the Unit Cost of the Item Card if the unit cost is missing in a Purch. Rcpt. Line.

Use Net Weight from Item if Weight = 0:
When you set a check mark in this field, the program will use the Net Weight of the Item Card if the Net Weight is missing in the Sales Shipment Line / Purch. Rcpt. Line.

See Also