How to Use the Administration Cross Table

The settings are divided between the groups 'Source Data' and 'Target Data'. The source data specifies the administration that incurs the costs (De Koning Montage bv). The target data specifies the administration that carries out the work. This person therefore justifies the hours on a production order in administration 001 of Metaalbedrijf De Koning.

• The target administration has the source administration as a creditor (supplier) and must pay it for its services.
• The source administration has the target administration as a debtor (customer) and receives money from him for the work performed.

Source data

• Source Administration. Indicate here the administration in which the hours will be booked (the administration that incurs the costs). After internal invoicing, an ooutstanding item debtor is created in this administration.
• Debtor. The debtor no. under which the source administration is stated in the target administration.
• Sales Group. The sales group that is addressed in the source administration for internal invoicing.
• Inventory Group. The inventory group that is addressed in the source administration for internal invoicing.
• VAT. The VAT code that applies.
• Coverage Man. The percentage by which the costs of man-hours are increased.
• Coverage Machine. The percentage by which the costs of machine hours are increased.
• Commercial Surcharge. The percentage of net + coverage. This may be calculated on the amount including man coverage and machine coverage.

Target data

• Target Administration. Indicate here the administration where the production order is located for which hours (costs) must be accounted for. After internal invoicing, an outstanding creditor item is created here.
• Creditor. The creditor no. under which the source administration is stated in the target administration.
• Suspense Account Outsourcing. The suspense account that is addressed in the target administration.
• VAT. The VAT code that applies.
• Coverage. The percentage by which the costs of (internal) outsourcing are increased.
• Commercial Surcharge. The percentage of net + coverage. This may be calculated on the amount including man coverage and machine coverage.