Print Periodic Vendor Statement Tab

This section includes the fields and descriptions for the Print Periodic Vendor Statement tab.

Selection Criteria Island

Field Description
Company No. In these fields, you can specify a range of company numbers. The statistics will only be based on vendor entries with settling companies within the specified range.
Vendor No. In these fields, you specify a range of vendor numbers. The statistics will only include vendors within this range.
Vendor Group In this field, you select a vendor group. The statistics will only include vendors in this group.
Department In this field, you select a department. The statistics will only include vendors assigned to this department.
Language In this field, you designate the language of the vendor. The language is used for printouts and statistics.

Language codes are maintained in the window Popup Fields window in the Set-Up module.

Country In this field, you select a country. The statistics will only include vendors from this country.
Control Account The control account is a reference to two G/L accounts - a Vendor control account and an account for non-balanced entries.

All vendor entries are posted to the General Ledger, to the control account referred to here. Accounts payable is thus a specification of A/P control accounts in the General Ledger.

You can use the control accounts to group your vendors in the General Ledger—for example, in foreign and domestic vendors.

The account for non-balanced entries is used to manage your accounts when item deliveries and invoices are not received at the same time. When you approve item deliveries to the warehouse, the inventory value account is debited and the non-balanced entries account is credited. When the vendor invoices are registered at a later date, the items are credited to the Vendor control account and debited to the account for non-balanced entries. You thus avoid any accounting problems, when items are delivered in one posting period and the corresponding vendor invoice is received in another.

References to control accounts are specified by means of dimension combinations in the window Popup fields in the Set-Up module.

Currency In this field, you select a currency. The statistics will only include vendors with this currency as standard currency.
Statistic 1-4 In these fields, you can specify a range of statistics codes in each of the four statistics categories. The statistics will only include vendors with statistics codes within the given range.

Derived Dimensions Island

Field Description
Dimension Comb. In these fields, you can specify a range of dimension combination numbers. The printout will only include vendors for which the field “Dimension Comb. No.” in the window Vendor Information Card contains a value within the specified range.

Selection Criteria, Dimensions Island

Field Description
Location The functionality of these fields is similar to that of the field “Dimension Comb.” above.
Entity The functionality of these fields is similar to that of the field “Dimension Comb.” above.
Project The functionality of these fields is similar to that of the field “Dimension Comb.” above.
Purpose The functionality of these fields is similar to that of the field “Dimension Comb.” above.
Spec. 1-3 The functionality of these fields is similar to that of the field “Dimension Comb.” above.
Local Spec. 1-3 The functionality of these fields is similar to that of the field “Dimension Comb.” above.

Period Island

Field Description
Month/Yr. In this field, you enter the month and year of the desired statement. The month must be entered in numbers, that is, “1” is for January, “2” is for February, and so on. The desired year must be entered in four figures, for example, 2002. By using the vendor number, the month, and the year, Maconomy transfers the balance and the activity of the month.

Currency Island

Field Description
Reporting Currency In this field, you can specify in which currency the statistics should be displayed. Amounts in the statistics will be converted into and displayed in this currency. If the current user has been assigned to a company in the window Users, Maconomy suggests the company base currency of the company in question.

When converting amounts into the selected currency, Maconomy uses the exchange rates for purchases valid on the date entered in the field “Exchange Rate Date” below, and the exchange rate table used is the exchange rate table for purchases selected in the window System Information in the Set-Up module. Please note that Maconomy performs currency conversion even though the original amount has been registered in the same currency as the one specified in this field, which may give rise to discrepancies between the registered amounts and the amounts shown in this window.

Exchange Rate Date In this field, you can specify an exchange rate date. When converting amounts into the reporting currency, Maconomy uses the exchange rates valid on this date according to the exchange rate table for purchases selected in the window System Information in the Set-Up module for conversion of currency amounts. See also the field “Reporting Currency.”
Exchange Rate Table Specify the exchange rate table to use in the reports.

Print Control Island

Field Description
Layout In this field, you can select which layout to use for the printout. If no additional layouts for the current printout have been added in the window Print Layout in the Set-Up module, “Standard” is the only option.
Include Vendors Where Current Balance = 0 With this check box you can indicate whether you want to include vendors with a balance of zero at the date of printing. If you check the box, all vendors are included. If you leave this field blank, the printout will only include vendors with a credit or debit balance. A credit balance is shown as a positive amount, and a debit balance is shown as a negative amount.

Extra Fields Island

Field Description
Popup 1-5 In each of these fields, you can specify a vendor pop-up value.

The printout will only include vendors for which the values in the fields “Popup 1-5” in the window Vendor Information Card correspond to the values specified here. However, if you leave a given pop-up field blank, vendors with any value in the field in question are included.