4 Working with Localizations for Poland

This chapter contains the following topics:

4.1 Understanding Cash Transactions

You work with cash transactions in the JD Edwards EnterpriseOne Accounts Payable, JD Edwards EnterpriseOne Accounts Receivable, and JD Edwards EnterpriseOne General Accounting systems.

To work with cash transactions in these systems, you:

  • Enter vouchers or enter receipts for invoices.

  • Pay the vouchers or invoices from a cash account.

  • Use the Cash Desk Transaction (P74P9101) program to print a report for an inbound or outbound transaction.

  • Use the Cash Desk Report program to print a record of all cash transactions for a specified period.

4.2 Printing Reports for Inbound and Outbound Cash Transactions

This section provides an overview of printing cash desk transaction documents, lists prerequisites, and discusses how to:

  • Set processing options for a Cash Desk Transaction (P74P9101).

  • Set processing options for the Cash Desk Transaction Document (R74P9102).

  • Select transactions to print.

4.2.1 Understanding How to Print Cash Desk Transaction Documents

You use the Cash Desk Transaction program (P74P9101) to select and print cash desk transaction documents. When you select Cash Desk Transaction from the Cash Desk Transactions menu (G74PCASH), the system displays the processing options. When you click OK on the processing options template, the system displays the Work With Cash Desk Transactions form. You then select the record to print and select Print Report from the Row menu to launch the Cash Desk Transaction Document (R74P9102) program and print the report.

When you run the Cash Desk Transaction Document program (R74P9102) from the Work With Cash Desk Transactions form, the system prints a report that includes:

  • Name of the company issuing the document

  • Document type

  • Whether the transaction is inbound or outbound

  • Document number

  • Cash account number and description

  • Transaction date, amount, and description

  • Transaction amount, printed literally

  • Cashier ID

  • Person responsible for the transaction

You access the processing options for the Cash Desk Transaction Document program from the Batch Versions program (P98305W).

4.2.2 Prerequisites

Before you perform the tasks in this section:

4.2.3 Form Used to Work with Cash Transactions

Form Name FormID Navigation Usage
Work With Cash Desk Transactions W74P9101A Cash Desk Transactions (G74PCASH), Cash Desk Transaction

Complete the processing options, and then click OK.

Select records to print or reprint.

4.2.4 Setting Processing Options for a Cash Desk Transaction (P74P9101)

Processing options enable you to specify the default processing for programs and reports.

4.2.4.1 General

Version

Specify the version of the Cash Desk Transaction Document program (R74P9102) that the system uses to print the report. If you leave this processing option blank, the system uses version XJDE0001.

Ledger Type

Specify the ledger type for general ledger transactions. If you do not complete this processing option, the system uses ledger AA.

Category Code

Specify the category code in which cash accounts are defined.

4.2.5 Setting Processing Options for the Cash Desk Transaction Document (R74P9102)

Processing options enable you to specify the default processing for programs and reports.

4.2.5.1 General

Number of Copies

Enter the number of copies to print. If you leave this processing option blank, the system prints two copies.

Document Type Inbound

Enter a document type from the Document Type (00/DT) UDC table to specify the document type for inbound transactions. If you do not specify a document type, the system uses document type KP.

Document Type Outbound

Enter a document type from the Document Type (00/DT) UDC table to specify the document type for outbound transactions. If you do not specify a document type, the system uses document type KW.

4.2.6 Selecting Transactions to Print

Access the Work With Cash Desk Transactions form.

Select a record, and then select Print Report from the Row menu.

4.3 Generating the Cash Desk Report

This section provides an overview of the Cash Desk Report and discusses how to:

  • Run the Cash Desk Report program.

  • Set processing options for the Cash Desk Report (R74P9104).

4.3.1 Understanding the Cash Desk Report

You run the Cash Desk Report program (R74P9104) to print a list of the cash transactions for a specified period. The system prints only transactions that appear in the Cash Desk Transaction table (F74P9100) and prints debit transactions as cash receipts and credit transactions as cash issues.

In the header area of the report, the system lists:

  • The name of the company issuing the report

  • The report name and number

  • The name of the person printing the report

  • The number and description of the cash account

  • The currency code

  • The beginning balance

In the detail area, the report lists for each cash desk transaction report:

  • The legal number of each inbound or outbound cash transaction

  • The GL date of each transaction

  • The document type

  • The document description

  • The amount of inbound and outbound transactions, in separate columns

  • The closing balance of the cash account

4.3.2 Running the Cash Desk Report Program (R74P9104)

Select Cash Desk Transactions (G74PCASH), Cash Desk Report.

4.3.3 Setting Processing Options for Cash Desk Report (R74P9104)

Processing options enable you to specify the default processing for programs and reports.

4.3.3.1 Select

Account Number

Enter the account number for which you run the report.

Ledger Type

Enter the ledger type for which you run the report. If you leave this processing option blank, the system uses ledger type AA.

Reporting Begin Date

Enter the first day of a range of dates that the system uses to select records to process.

Reporting End Date

Enter the last day of a range of dates that the system uses to select records to process.

Mode

Leave this processing option blank to print in proof mode; the system does not validate the closing balance and the closing date when you run the report in proof mode. Enter 1 to print in final mode. The system prints the report and validates the closing balance and closing date.

Company

Enter the company for which you run the report.

Document Type

Enter a value that exists in the Document Type (00/DT) UDC table. The system uses the next numbering scheme associated with the document type that you specify.

4.3.3.2 Localization Options

Report Title

Enter the report title that prints in the header area of the report. You can enter up to 100 characters.

Report Title (Continuation)

Enter additional text that the system appends to the text that you enter in the Report Title processing option.

4.4 Working with Vouchers for Poland

This section provides an overview of vouchers for Poland and discusses how to:

  • Set processing options for Voucher Additional Information (P74P411H).

  • Enter additional voucher information for Poland.

4.4.1 Understanding Vouchers for Poland

You use the standard voucher entry programs to enter vouchers for Poland. Then, you use the Voucher Additional Information program (P74P411H) to enter additional information about vouchers that the system uses when generating the Purchase Registers for tax reporting and for unified audit files reporting. For example, depending on the document type that you set up in the Set Up AP Document Types program (P74P4010), you might enter information about the original document or change an invoice or tax liability date.

You can access the Voucher Additional Information program by one of these methods:

  • The system automatically launches the Voucher Additional Information program when you add a voucher or modify an existing, non-posted voucher.

  • You can access the Voucher Additional Information program from two menu options:

    • Accounts Payable (G74P04), Voucher Additional Information

    • Unified Audit File (G74P50), Work with Voucher Additional Information

  • You can select an existing voucher in on the Enter Voucher - Payment Information form and then select Regional Info from the Row menu.

The system saves the additional information for Poland in the F0411 Header File - POL (F74P411H) and Poland Header Tag File - POL (F74P412H) tables.

4.4.1.1 Voucher Types

In the Document Type (00/DT) UDC table, set up document types for these types of vouchers:

  • Purchases

  • Purchases corrections

  • Customs documents

  • Employee expenses

  • Employee expense corrections

    The system enables you to enter as many corrective documents as needed, but the total value of all corrections combined with the original documents must not be less then zero. You cannot enter a correction for a correction.

  • Vouchers for which VAT is deferred to a different accounting period.

    You can change the tax liability date only for vouchers for which the document type is set up as a voucher that allows changes to the date.

4.4.1.2 Additional Voucher Information

The fields that appear on the Voucher Additional Information form vary, depending on the type of voucher for which you are entering information. The voucher type determines the information that the system includes in the VAT registers. Each voucher type must have its own document type defined in the Document Type (00/DT) UDC table.

4.4.1.3 Voucher Match

You use the Voucher Match program (P4314) to match vouchers to purchase orders for Poland. Additionally, you must enter information that is used for VAT reporting in the Voucher Additional Information program (P74P411H). The system automatically launches the Voucher Additional Information program when you add a voucher or modify an existing, non-posted voucher. Or, you can access the Voucher Additional Information program from a menu option.

4.4.1.4 Deleting Voucher Information

When you delete a posted voucher, the system does not delete the information for the voucher that is stored in the F0411 Header File - POL table (F74P411H) and F0411 Tag File Header-POL table (F74P412H). When you delete a voucher that is not posted, the system deletes the records from the F74P411H (if the voucher has additional information) and F74P412H tables.

4.4.1.5 Tax Dates for Vouchers

To declare the VAT that appears on posted and unposted vouchers in the appropriate VAT period, you might need to change the tax liability date for the vouchers. Many situations might require you to process vouchers in one period and report the VAT in another period. Changing the tax liability date to the date in the appropriate VAT reporting period assures that the VAT is correctly reported.

You can change the tax liability date only for vouchers for which the document (voucher) type is set up as a voucher that allows changes to this date. To enable changes to the tax liability date for a voucher type:

  • Set up voucher types in the Document Type (00/DT) UDC table.

  • Use the Set Up AP Document Types program (P74P4010) to specify whether the system enables changes to the tax liability date of vouchers that are assigned a specific voucher type.

    See Setting Up Voucher Types.

  • Assign the specific voucher types to vouchers for which you need the ability to change the tax liability date.

4.4.1.6 Categorizing Vouchers for Unified Audit Files (Release 9.1 Update)

To generate the Sales and Purchase VAT Registers and the VAT invoices XML files for reporting unified audit files, you must reclassify vouchers according to the prescribed categories mentioned in the audit file format for Poland.

You reclassify vouchers for audit file reporting using the fields in the UAF Info 1 and UAF Info 2 tabs in the Voucher Additional Information program (P74P411H). You can reclassify vouchers when you create a new voucher record using the Standard Voucher Entry program (P0411). After you set up the voucher information, the system automatically displays the Voucher Additional Information program (P74P411H) when the Localization Country Code in your user profile is set to PL (Poland).

You can also access the Voucher Additional Information program (P74P411H) as a standalone program.

The system stores the reclassified voucher information in the Reclassified Posted Vouchers table (F74P507).

See Section 4.4.5, "Reclassifying Vouchers for Unified Audit Files (Release 9.1 Update)".

4.4.1.7 Categorizing Fixed Asset Transactions for Unified Audit Files (Release 9.1 Update)

The prescribed format for the Purchase VAT Register XML file includes information about transactions related to fixed assets. Therefore, you must classify the vouchers (and the lines in the vouchers) that are for fixed assets before you generate the Purchase VAT Register XML file.

When all the transaction lines in the voucher are for fixed assets, you can use the Fixed Assets Flag in the Set Up AP Document Types program (P74P4010) to specify that the document type for the voucher is related to fixed assets.

See Section 3.6.3, "Setting Up Voucher Types for Poland,".

You can also selectively specify each voucher line as either related or not related to fixed assets by using the Fixed Asset Information program (P74P506). If you specify this information at the line level, the system uses the transaction-level information that you enter in the P74P506 program and overrides the document type-level information in the P74P4010 program for those transactions.

You can access the P74P506 program by clicking the Fixed Asset Info on the Row menu of the Work With Voucher Additional Information form.

4.4.2 Forms Used to Enter Additional Voucher Information in Poland

Form Name FormID Navigation Usage
Work With Voucher Additional Information W74P411HB Accounts Payable (G74P04), Voucher Additional Information

Set the processing option on the Processing Options form, and click OK.

Alternate navigation:

Unified Audit File (G74P50), Work with Voucher Additional Information

Review information about existing vouchers and pay item lines included in the vouchers.

Select a voucher to which to add additional information.

Entry Voucher Additional Information W74P411HA Select a voucher on the Work With Voucher Additional Information form and click Select.

Alternate navigation:

Access the Standard Voucher Entry program (P0411). On the Supplier Ledger Inquiry form, select a record in the grid and click Select. Then, on the Enter Voucher-Payment Information form, click Regional Info on the Row menu.

Enter additional information about the voucher.

Enter information in the fields on the UAF Info 1 and UAF Info 2 tabs to reclassify vouchers for the Sales and Purchase VAT Registers and VAT Invoices unified audit files.

(Release 9.1 Update) Fixed Asset Information W74P506A On the Work With Voucher Additional Information form, select a voucher line and click Fixed Asset Info on the Row menu. Specify whether the pay item lines in the voucher are related or not related to fixed assets.

4.4.3 Setting Processing Options for Voucher Additional Information (P74P411H)

Select Accounts Payable (G74P04), Voucher Additional Information.

Set this processing option to establish a default value for the tax liability date. For voucher types that you set up to enable changes to the tax liability date, the system allows changes to the default value established. For voucher types that are not set up to enable changes to the tax liability date, the system writes the default value to the F74P412H table and does not enable changes to the value.

4.4.3.1 Process

1. Tax Liability Date

Enter 1 to use the invoice date to update sales. Enter 2 to use the service date. Enter 3 or leave this processing option blank to use the GL date.

4.4.4 Entering Additional Voucher Information for Poland

Access the Entry Voucher Additional Information form.

You can change the information or enter a value in these fields only when the fields are enabled in the Set Up AP Document Types program (P74P4010).

Orig Doc Co (original document company)

Enter the address book number of the company that issued the document on which the voucher is based. For example, if the voucher is for a tax payment, enter the address book number of the taxing authority.

Orig Do Ty (original document type)

Enter the document type of the document on which the voucher is based. For example, if the voucher is to pay a supplier, enter the document type of the invoice from the supplier.

Original Document

Enter the identifying number from the document on which the voucher is based.

Rel Add. Number (related address number)

Enter the address book number for the alternate address for the payment. For example, when withholding taxes, the related address number might be the address book number for the tax authority.

Invoice Date

Change the date of the invoice, if necessary.

Tax Liability Date

Change the date on which the VAT is to be reported, if necessary.

4.4.5 Reclassifying Vouchers for Unified Audit Files (Release 9.1 Update)

Access the Entry Voucher Additional Information form and use the fields in the UAF Info 1 and UAF Info 2 tabs to reclassify vouchers to support reporting requirements for Sales and Purchase VAT Registers and VAT Invoices unified audit files.

Cash Accounting Scheme

Select this option to classify vouchers where the cash accounting scheme (according to Article 19a Paragraph 5 Section 1 or Article 21 Paragraph 1 of the VAT Act) applies.

Reverse Charge Mechanism

Select this option to classify vouchers where reverse charge mechanism applies.

Article Number

Specify a value from the Article Number UDC table (74P/AN) that specifies the article associated with a certain tax type. The system classifies the invoices associated with the article number that you specify in this field. Values are:

Blank: No article applies

100: Self-assessed tax by customer

129: VAT refund or international shipment

Article 106c of VAT Act

Select this option to classify vouchers to which the case described in Article 106c of the VAT Act applies. When you select this option, the system classifies those transactions that are created by an enforcement authority to settle taxes from the debtor for violation of tax laws in the supply of goods and services.

When you select this option, the system enables the Enforcement Body Representative field and you must enter a value in this field.

Enforcement Body Representative

Enter the address number of the enforcement body representative who is responsible for the case described in Article 106c of the VAT Act. The system enables this field when you select Article 106c of the VAT Act option.

Taxpayer Representative Issued Invoices

Select this option to classify vouchers that are issued by a representative of the taxpayer.

When you select this option, the system enables the Taxpayer Representative field and you must enter a value in this field.

Taxpayer Representative

Enter the address number of the taxpayer's representative. The system enables this field when you select the TaxPayer Representative Issued Invoices option. This is a required field if enabled.

Goods or Services VAT Exempt

Select this option to classify vouchers for transactions where the supply of goods or services are exempted from VAT (according to Article 43 Paragraph 1, Article 113 Paragraph 1 and 9 of the VAT Act).

When you select this option, the system enables the Legal Article Act, Legal Article 2006/112/WE, and Other Legal Article fields. You must enter values in these fields.

Legal Article Act

Enter a value that indicates the appropriate legal article of the VAT Act that is related to the exemption of VAT for goods and services. The system enables this field when you select the Goods or Services VAT Exempt option. This is a required field if enabled.

Legal Article 2006/112/WE

Enter a value that indicates the appropriate legal article of the 2006/112/WE directive that is related to the exemption of VAT for goods and services. The system enables this field when you select the Goods or Services VAT Exempt option. This is a required field if enabled.

Other Legal Article

Enter a value that indicates other legal articles that are related to the exemption of VAT for goods and services. The system enables this field when you select the Goods Or Services VAT Exempt option. This is a required field if enabled.

Self Billing

Select this option to classify self-issued invoices or vouchers. This case is according to Article 106d Paragraph 1 of the VAT Act.

Intracommunity Triangular Transaction

Select this option to classify vouchers that are issued by the second taxpayer in an intracommunity triangular transaction.

Tourist Services

Select this option to classify vouchers for tourist services where the tax amount is calculated based on a profit margin.

Used Goods/Works Of Art/Collector's Items/Antiques

Select this option to classify certain vouchers (issued for used goods, works of art, collector's items, or antiques) where the tax amount is calculated based on a profit margin.

When you select this option, the system enables the Polish Descriptions field and you must enter a value in this field.

Polish Descriptions

A user-defined description in Polish language that must be included in the vouchers for used goods, works of art, collector's items, or antiques). Examples are:

procedura marzy: towary uzywane

procedura marzy: dziela sztuki

procedura marzy: przedmioty kolekcjonerskie i antyki

The system enables this field when you select the Used Goods/Works Of Art/Collector's Items/Antiques option. This is a required field if enabled.

New Means of Transport

Select this option to classify vouchers issued for a new means of transport for the intracommunity supply of goods.

When you select this option, the system enables the Authorization Date, Mileage, and Working Hours fields. You must enter values in these fields.

Authorization Date

Enter the authorization date of a new means of transport. The system enables this field when you select the New Means Of Transport option. This is a required field if enabled.

Mileage

Enter a value that indicates the mileage of a new means of transport when the intracommunity supply is through land vehicles. The system enables this field when you select the New Means Of Transport option. This is a required field if enabled.

Working Hours

Enter the number of working hours of a new means of transport when the intracommunity supply is through vessels or aircraft. The system enables this field when you select the New Means Of Transport option. This is a required field if enabled.

4.5 Working with Voucher Match Automation for Poland (Release 9.1 Update)

This section provides an overview of voucher match automation (VMA) for Poland and discusses how to enter additional voucher information for automatically matched vouchers.

4.5.1 Understanding Voucher Match Automation for Poland

The VMA process enables you to use six different automation rules to automatically match invoice lines to receipts and purchase orders, and then create vouchers. You can specify the automation rule in the supplier master record or in the A/P Batch Voucher Entry program (P0411Z1).


Note:

The VMA process supports voucher logging for many transactions. However, the system does not support voucher logging for Polish transactions. If you set the processing options to generate logged vouchers, the system prints a blank report and does not perform any matching.

When you use the VMA process for Polish transactions, you must enter additional voucher information before the process will match receipt lines to invoice lines. You use the Batch Voucher Additional Information program (P74P411Z) to enter the additional information, which is used in VAT reports. The system saves the information that you enter to the F0411Z1 Batch Tag File - POL table (F74P411Z).

The system uses the document type for the voucher to validate the additional information that is required for the voucher. You set up the document types in the Set Up AP Document Types program (P74P4010) and specify in that program the additional information that is required for each document type. Because you enter the additional information before you run the VMA process and document type is still not assigned during batch input, the system can not validate the information you enter based on document type. Instead, the VMA process validates the information entered based on the document type setup in the Set Up AP Document Types program when you run the process. If the information entered is valid and the record is successfully matched in final mode of the VMA process, the system saves the additional information for Poland from the F0411Z1 Batch Tag File - POL table (F74P411Z) to the F0411 Header File - POL (F74P411H) and F0411 Tag File Header POL-04 (F74P412H) tables. If the information entered it is not valid, the system prints a message on the report output directing you to look for the error message in the Work Center.


Note:

Review the setup for each document type in the Set Up AP Document Types program ( P74P4010). If you enter information into the Batch Voucher Additional Information program using the document type setup in the Set Up AP Document Types program as a guide for determining the required information, the record should have the correct information required for Polish VAT reporting and should pass the country-specific validations when you run the VMA process.


Processing options determine whether the system completes matches for invoice lines without errors when other lines in a batch have errors. See "Setting Processing Options for the Voucher Match Automation Process" in the JD Edwards EnterpriseOne Applications Procurement Management Implementation Guide.

4.5.2 Prerequisites

Before you can use the VMA process, you must:

  • Set up the supplier master record of the suppliers for whom you want to enable the VMA process.

    See "Voucher Match Automation Setup for Suppliers" and "Defining Supplier Purchasing Instructions" in the JD Edwards EnterpriseOne Applications Procurement Management Implementation Guide.

  • Populate the Voucher Transaction - Batch Upload (F0411Z1) table with the supplier invoice records.

    You can populate the F0411Z1 table using a batch upload process, by scanning invoices, or other methods. The value in the Automation Flag field must be 1 for the transactions that you want to process using the VMA process. You can set a processing option for the A/P Batch Voucher Entry program (P0411Z1) to automatically assign the value 1 to the Automation Flag field for all records that you add to the table.

  • Enter in the Batch Voucher Additional Information program the additional voucher information required for VAT reporting in Poland.

4.5.3 Forms Used to Enter Additional Voucher Information for VMA Vouchers

Form Name Form ID Navigation Usage
Work With Store & Forward Vouchers W0411Z1A Batch Voucher Processing (G04311), Batch Voucher Revisions Locate, select, and delete batch vouchers.
W74P411ZB Voucher Entry Additional Info On the Work With Store & Forward Vouchers form, select Regional Info from the Row menu. Enter the additional information required for VAT reports.

4.5.4 Entering Additional Information for VMA Vouchers

Original Document No (original document number)

Enter the identifying number from the document on which the voucher is based.

Original Document Type (unlabeled)

Enter the document type of the document on which the voucher is based. For example, if the voucher is to pay a supplier, enter the document type of the invoice from the supplier.

Original Document Company (unlabeled)

Enter the address book number of the company that issued the document on which the voucher is based. For example, if the voucher is for a tax payment, enter the address book number of the taxing authority.

Address Number Label

Enter the address book number for the alternate address for the payment. For example, when withholding taxes, the related address number might be the address book number for the tax authority.

Invoice Date

Change the date of the invoice, if necessary.

Tax Liability Date

Change the date on which the VAT is to be reported, if necessary.

4.6 Reposting the Account Ledger Tag File

This section provides an overview of the Repost Account Ledger Tag File program and discusses how to:

  • Run the Repost Account Ledger Tag File program.

  • Set processing options for Repost Account Ledger Tag File (R749102).

4.6.1 Understanding the Repost Account Ledger Tag File Program

If you have never run trial balance reports or if the data in the Account Balance Tag File table (F74902T) becomes corrupted, run the Repost Account Ledger Tag File program to populate the F74902T table. The F74902T table stores information about the debit and credit amounts in the Account Ledger table (F0911).

After you run the Repost Account Ledger Tag File program for the first time, the system updates the values in the F74902T table when it updates the Account Balances table (F0902).

4.6.2 Running the Repost Account Ledger Tag File Program

Select General Ledger (G74P09), Repost Account Ledger Tag File.

4.6.3 Setting Processing Options for Repost Account Ledger Tag File (R749102)

Processing options enable you to specify the default processing for programs and reports.

4.6.3.1 Mode

Process Mode

Specify the processing mode. Values are:

1: Proof mode.

2: Final mode. The system updates the F74902T table.

Check F0902 Balance

Specify whether to validate balances. Values are:

Blank: Suppress validation.

1: Validate that balances appear in the F0902 table before writing balances to the F74902T table.

Check F0911 Missing Entries

Specify whether to validate transactions. Values are:

Blank: Suppress validation.

1: Validate that the F0911 table contains entries.

4.7 Printing VAT Reports for Poland

This section provides an overview of tax processing for Poland, lists a prerequisite, and discusses how to:

  • Run the VAT Purchase Domestic Register program.

  • Set processing options for VAT Purchase Domestic Register (R74P0410).

  • Run the VAT Purchase Import Register report.

  • Set processing options for VAT Purchase Import Register (R74P0420).

  • Run the VAT Purchase Register - Paid Vouchers report.

  • Set processing options for VAT Purchase Register - Paid Vouchers (R74P5010).

  • Run the VAT Sales report.

  • Set processing options for VAT Sales (R74P03B1).

4.7.1 Understanding Tax Processing for Poland

Periodically you must produce VAT reports that display the transactions to which VAT applies. JD Edwards EnterpriseOne software provides four VAT reports for Poland:

  • VAT Purchase Domestic Register (R74P0410)

  • VAT Purchase Import Register (R74P0420)

  • VAT Purchase Register - Paid Vouchers (R74P5010)

  • VAT Sales (R74P03B1)

When you enter vouchers, you use specific document types for vouchers and enter additional information that is used in the VAT reports. You specify the type of information that must be entered for a voucher by using the Set Up AP Document Types () program to associate additional information with the UDC values that represent the vouchers that you pay.

See Setting Up Voucher Types.

To correctly include tax information for imported goods, you must set up the Customs Tax Categories (74P/IM) UDC table to create a cross-reference between tax rate/areas and types of taxes or fees on imported goods. The system uses the special handling code in the (74P/IM) UDC to define the type of taxes and fees associated with a tax rate/area when you process VAT reports.

The system determines which posted vouchers to include in each report by the document type, tax rate/area, and item numbers on the vouchers. You set the data selection for each report to indicate the combination for document type, tax rate/area, and item numbers to include. Generally, each voucher is included in only one report.

4.7.1.1 VAT Purchase Domestic Register Report

The VAT Purchase Domestic Register report includes information about standard vouchers, corrective vouchers, and expense vouchers. This report lists by document and tax percentage all of the vouchers generated during a specified period of time. The report includes a column that indicates whether a detail line is for intracommunity or non-intracommunity VAT.

In the Header section, this report includes the:

  • Name and address of the company

  • Title

  • VAT purchase register

  • Reporting period (date range)

  • Program ID

  • Version ID

  • Page number

  • Date and time of printing

  • User name

  • Ledger type

For each detail line, this report includes:

  • Sequential register number

  • Tax date

  • Invoice number

  • Invoice date

  • Document number

  • Document type

  • Document company

  • Vendor (supplier) Tax ID

  • Vendor number

  • Name and address of the vendor

  • Intracommunity indicator

  • Each VAT rate and VAT amount in a separate line by each invoice number

  • Gross and net amount by each VAT rate

    You set a processing option to determine whether the system prints the gross amount with or without the VAT amount for intracommunity transactions.

  • Gross total amount, net total amount, and VAT total amount by each invoice number

  • Gross total amount, net total amount, and VAT total amount for the page of report

  • Gross total amount, net total amount, and VAT total amount for the report by each VAT rate

When you run the VAT Purchase Register program, the system:

  • Groups all of the detail lines by the VAT rate, and prints only totals for each tax rate.

  • Distinguishes between a tax rate of Exempt and a tax rate of 0 percent.

  • Retrieves the vendor address number from the Taxes table (F0018) if the document type for the voucher is defined as an employee expense.

  • Prints only the intracommunity VAT, only the non-intracommunity VAT, or both types of VAT, depending on the values in the processing options.

4.7.1.2 VAT Purchase Import Register Report

The VAT Purchase Import Register report includes information about standard and corrective vouchers created for imported goods. This report lists, by document and tax percentage, all of the vouchers for imported goods for the reporting period specified.

The supporting document for vouchers that the system includes in the VAT Purchase Import Register report is often a customs document. Because the taxes and fees on the voucher are paid to a duty agency, the vendor information that appears on the report is the information that was entered for the customs document. Information about the vendor from whom the goods were purchased is stored in the F0411 Header File - POL table (F74P411H).

The import register includes the:

  • Sequential register number

  • Date of customs duty clearance

  • Vendor's name and address

  • Amount due to vendor

  • Amount of customs duty

  • Packaging tax

  • Amount of excise tax

  • VAT taxable amount

  • VAT amount for tax groups

  • Total liability, net total amount, total duty, total import tax, total excise tax, and total VAT amount for each invoice number

  • Total net amount and VAT total amount for the page of report

  • Total net amount and VAT total amount for the report by each particular VAT rate

4.7.1.3 VAT Purchase Register - Paid Vouchers Report

The VAT Purchase Register - Paid Vouchers report includes information about all vouchers that were paid in the specified period. The report lists, by document and tax percentage, all of the paid standard vouchers, correction vouchers, and expense vouchers.

4.7.1.4 VAT Sales Report

The VAT Sales report includes information about the standard and correction invoices generated for a selected period of time by legal document and tax percentage. In the case of Intracommunity transactions, the report also splits transactions by service category codes and goods items separately.

In the Header section, this report includes the:

  • Program ID

  • Version name

  • Name of the company

  • Reporting period (date range)

  • Address of the company

  • Title of the VAT sales register

  • Version title

  • Page number

  • Date and time of printing

  • User name

  • Ledger type

For each detail line, this report includes the:

  • Sequential register number

  • Sales date

  • Invoice date

  • Legal company

  • Legal document type

  • Issue place

  • Legal document number

  • Buyer tax ID

  • Buyer's registration number

  • Buyer's name and address

  • Service description in separate lines by each EU service. In the case of invoices entered from Accounts Receivable, the system retrieves the service description from the Remarks field. In the case of invoices entered from Sales Order, the system retrieves the information from the service description category code.

  • VAT amount and VAT rate, including 0% and exempt transaction

  • Gross and net amounts by each EU service

  • Each particular VAT rate and VAT amount in the separate line by each invoice number

  • Gross and net amounts by each particular VAT rate

  • Gross total amount, net total amount, and VAT total amount by each invoice number

  • Gross total amount, net total amount, and VAT total amount for the page of report

  • Gross total amount, net total amount, and VAT total amount for the report by each particular VAT rate

In addition to the information specified for the sales purchase register, the correction registers also include a reference to the original invoice. Document type selection and tax rate/area control which entries are included on this report.

When you run the VAT Purchase Register program, the system:

  • Summarizes all pay items for each document by VAT rate.

    The system prints as many detail lines as needed to reflect the different VAT rates that were entered for a particular document. For example, if a document contains three VAT rates, the system prints three detail lines for the document. If all detail lines on a document have the same VAT rate, the system prints one detail line.

  • Groups all lines of document by VAT rate.

    Totals only are printed for each tax rate.

  • Distinguishes a tax rate of Exempt from a tax rate of 0 percent.

  • Prints on one page all detail lines for a document type and document number.

  • Prints only the intracommunity VAT, only the non-intracommunity VAT, or both types of VAT, depending on the values in the processing options.

4.7.2 Prerequisites

Verify that UDC 74P/IM is set up.

Verify that the EU service codes for items are set up.

4.7.3 Running the VAT Purchase Domestic Register Report

Select Accounts Payable (G74P04), VAT Purchase Domestic Register.

4.7.4 Setting Processing Options for VAT Purchase Domestic Register Report (R74P0410)

Processing options enable you to specify the default processing for programs and reports.

4.7.4.1 Select

Date From

Specify the first date of a range of dates that the system uses for selecting records to process. The system considers the date type defined in the Based on Date processing option (see Process).

Date To

Specify the last date of a range of dates that the system uses for selecting records to process. The system considers the date type defined in the Based on Date processing option (see Process).

Company Number

Specify the company for which you generate the report.

4.7.4.2 Process

Rows per Page

Specify the number of lines that the system prints on each page of the report. If you leave this processing option blank, the system prints 30 lines per page.

Based on Date

Specify the date that the system uses when selecting records to process. Values are:

Blank or 3: GL date.

1: Invoice date of the records.

2: Service or tax date.

4: Tax liability date.

Report By Country
Country for Company Information

Enter a value from UDC table 00/EC to specify the country for which you want to run the report. The system retrieves company information with address number defined in the Company Address Number for Tax Reports program (P00101) for the country that you specify in this processing option. If you leave this field blank, the system retrieves the company information from address book related to company in the Companies program (P0010) and the system does not enable the country processing. (Release 9.1 Update)

Tax Rate/Area Processing

Specify whether to process tax rate/areas for the country specified in the Report By Country processing option. Values are:

Blank: Prevent tax rate/areas additional filtering.

1: To enable an additional filter excluding the tax rate/areas that were not identified for that country in the Alternate Tax Rate/Area by Country program (P40082). (Release 9.1 Update)

4.7.4.3 Print

Vendor's Mailing Address

Enter 1 to print the vendor's mailing address on the report.

Leave this processing option blank to suppress printing of the vendor's address.

Intra-community Transaction

Enter 1 to print only intracommunity VAT transactions.

Enter 2 to print only non-intracommunity VAT transactions.

Leave this processing option blank to print both intracommunity and non-intracommunity VAT transactions.

Gross Amount for Intra-community Transaction

Enter 1 to print the intracommunity VAT amount. Leave this processing option blank to suppress printing of the intracommunity VAT amount.

4.7.5 Running the VAT Purchase Import Register Report

Select Accounts Payable (G74P04), VAT Purchase Import Register.

4.7.6 Setting Processing Options for VAT Purchase Import Register (R74P0420)

Processing options enable you to specify default processing values.

4.7.6.1 Select

Fiscal Year

Specify the last two digits of the fiscal year for which you produce the report. For example, for the year 2010, enter 10.

Fiscal Period and Company Number

Specify the accounting period or the company for which you produce the report.

4.7.6.2 Process

Rows per Page

Specify the number of lines that the system prints on each page of the report. If you leave this processing option blank, the system prints 30 lines per page.

Date Type

Specify the date that the system uses when processing the report. Values are:

Blank or 3: GL date.

1: Invoice date of the records.

2: Service or tax date.

4: Tax liability date.

Report By Country
Country for Company Information

Enter a value from UDC table 00/EC to specify the country for which you want to run the report. The system retrieves the address book details for the company set up for the specified country. If you leave this field blank, the system retrieves the address book information for the company specified in the transactions from the Address Book table. (Release 9.1 Update)

Tax Rate/Area Processing

Specify whether to process transactions based on the country specified in the Country By Company information:

Blank: Prevent tax rate/areas additional filtering.

1: To enable an additional filter excluding the tax rate/areas that were not identified for that country in the Alternate Tax Rate/Area by Country program (P40082). (Release 9.1 Update)

4.7.6.3 Print

Vendor' Mailing Address

Enter 1 to print the vendor's mailing address on the report. Leave this processing option blank to suppress printing of the vendor's address.

4.7.7 Running the VAT Purchase Register - Paid Vouchers Report

Select Accounts Payable (G74P04), VAT Purchase Register - Paid Vouchers.

4.7.8 Setting Processing Options for VAT Purchase Register - Paid Vouchers (R74P5010)

Processing options enable you to specify the default processing for programs and reports.

4.7.8.1 Select

Start Date and End Date

Specify the first date of a range of GL dates, or the last date of a range of GL dates that the system uses for selecting records to process.

Tax date from and Tax date To

Specify the first date of a range of tax service dates, or the last date of a range of tax service dates that the system uses for selecting records to process.

4.7.8.2 Process

Rows per Page

Specify the number of lines that the system prints on each page of the report. If you leave this processing option blank, the system prints 30 lines per page.

Date Type

Specify the date that the system uses when processing the report. Values are:

Blank or 1: Service tax date.

2: Tax liability date.

Report By Country
Country for Tax/Rate Area Processing

Enter a value from UDC table 00/EC to specify the country for which you want to run the report. The system applies an additional filter excluding the tax rate/areas which were not identified for that country in the Alternate Tax Rate/Area by Country program (P40082).

Leave this field blank to prevent tax rate/areas additional filtering. (Release 9.1 Update)

4.7.8.3 Print

Vendor's Mailing Address

Enter 1 to print the vendor's mailing address on the report. Leave this processing option blank to suppress printing of the vendor's address.

Validate Payment Terms

Enter 1 to validate payment terms. Leave this processing option blank to process without validation.

4.7.9 Running the VAT Sales Report

Select Accounts Receivable (G74P03B), VAT Sales.

4.7.10 Setting Processing Options for VAT Sales (R74P03B1)

Processing options enable you to specify the default processing for programs and reports.

4.7.10.1 Select

Date From

Specify the first date of a range of dates that the system uses for selecting records to process. The system considers the date type defined in the Date Type processing option (see Process).

Date To

Specify the last date of a range of dates that the system uses for selecting records to process. The system considers the date type defined in the Date Type processing option (see Process).

Legal Company

Specify the legal company for which you produce the report.

4.7.10.2 Process

Rows per Page

Specify the number of lines that the system prints on each page of the report. If you leave this processing option blank, the system prints 30 lines per page.

Process Future Period VAT

Enter 1 to process records for which VAT is due in a future period. Enter 2 to process records for corrective invoices only. Leave this processing option blank to suppress processing of future period VAT.

Date Type

Specify the source of the dates that the system uses to select records to process. Values are:

Blank or 3:G/L date

1: Invoice date

2: Service/tax date

4: Tax liability date

Mode

Enter 1 to process in final mode. Leave this processing option blank to process in proof mode.

Category Code for Service Description

Enter the category code number to display the service description in the report. If you leave this field blank, the system uses category code 1 as the default value.

See EU Service Transaction Description.

Report By Country
Country for Company Information

Enter a value from UDC table 00/EC to specify the country for which you want to run the report. The system retrieves company information with address number defined in the Company Address Number for Tax Reports program (P00101) for the country that you specify in this processing option. If you leave this field blank, the system retrieves the company information from address book related to company in the Companies program (P0010) and the system does not enable the country processing. (Release 9.1 Update)

Tax Rate/Area Processing

Specify whether to process tax rate/areas for the country specified in the Country for Company Information processing option. Values are:

Blank: Prevent tax rate/areas additional filtering.

1: To enable an additional filter excluding the tax rate/areas that were not identified for that country in the Alternate Tax Rate/Area by Country program (P40082). (Release 9.1 Update)

4.7.10.3 Print

Vendor Mailing Address

Enter 1 to print the vendor's mailing address on the report. Leave this processing option blank to suppress printing of the vendor's address.

Intra-community Transactions

Enter 1 to print only intracommunity transactions. When you enter 1, the system calls the VAT Purchase Domestic Register program to print the intracommunity transactions.

Enter 2 to print only non-intracommunity transactions.

Leave this processing option blank to print both intracommunity and non-intracommunity transactions.

Print Intra-community lines

If the value in the Intra-community Transactions processing option is blank or 1, enter the version name of the VAT Purchase domestic Register program (R74P0410) to run. If you leave this processing option blank, the system uses version ZJDE0001.

4.8 Printing the Self-Invoice for Poland

This section provides an overview of the self-invoice and discusses how to run the Self Invoice program (R74P0440).

4.8.1 Understanding the Self-Invoice for Poland

Run the Self Invoice program to generate a report that shows the exempted VAT for intracommunity VAT transactions. Run this program for each voucher that includes exempted intracommunity VAT amounts; you cannot consolidate multiple vouchers on a single self-invoice.


Note:

You can make changes to a self-invoice that you printed previously, and then reprint the invoice. However, you cannot reprint the original invoice after you have made changes to a self-invoice.

The self-invoice includes:

  • Invoice number

    This number does not need to match the voucher number of the invoice for which you generate the self-invoice.

  • Sales and invoice dates

  • Supplier information, including the name, address, and tax ID

  • Currency and exchange rate of the transaction

  • Net amount in domestic and foreign currency

  • VAT rate and amount

  • Invoice title

  • Document number, type, and company

  • Print date

4.8.2 Running the Self-Invoice Program

Select Accounts Payable (G74P04), Self Invoice.

4.9 Using Additional Reports for Poland

In addition to the reports specified as part of a process in other sections of this implementation guide, these reports exist for Poland.

Additional reports for value-added taxes exist.

See Printing VAT Reports for Poland.

Report ID and Report Name Description Navigation
R74P03B61

AR Trial Balance Report

Lists all accounts receivable transactions by currency, company, account, and supplier. General Ledger (G74P09), AR Trial Balance
R74P0450

AP Trial Balance

This report lists all accounts payable transactions by currency, company, account, and supplier or customer. You use this report to verify data in offset and vendor accounts. You can print the report in summary or detail mode. General Ledger (G74P09), A/P Trail Balance.
R74P9010

GL Trial Balance by Object

Lists information about transaction posted to the general ledger. General Ledger (G74P09), GL Trial Balance by Obj
R74P9015

GL Trial Balance by Category Code

Prints the same information as the General Ledger by Object report, but it presents information by category code instead of object account. For example, the General Ledger by Category Code report has three level breaks (one for each category code) instead of one level break like the General Ledger by Object report.

The system prints the information for account category codes 21, 22, and 23, as applicable.

General Accounting (G74P09), GL Trial Balance by Category Code
R74P9020

Transaction Journal

Lists all journal entries and assigns a register number to them by company and fiscal year. General Ledger (G74P09), GL Transaction Journal
R74P9030

Bank Register

Lists bank transactions. General Ledger (G74P09), Bank Register

4.9.1 R74P03B61 - AR Trial Balance Report

The AR Trial Balance report (R74P03B61) lists all accounts receivable transactions by currency, company, account, and supplier. You use this report to verify data in offset and vendor accounts. You can print the report in summary or detail mode.

When you run the AR Trial Balance report, the system writes data from the F03B11 and F03B14 tables to the F74P03BW table, and then prints the formatted data on the report.

4.9.1.1 Summary Mode

When you run the report in summary mode, the system prints this information in the report header:

  • Reporting period

  • Company number

  • Company description

  • Currency code

The system prints this information in the report detail section:

  • Vendor's address book number

  • Vendor name

  • Opening balance for the report period (debit or credit)

  • Opening balance for the year (debit or credit)

  • Account turnover

  • Year to date debit or credit

  • Cumulative balance (debit or credit)

4.9.1.2 Detail Mode

When you run the report in detail mode, the system prints this information in the report header:

  • Reporting period

  • Company number

  • Company description

  • Currency code

For each detail line, the system prints this information in the report detail section:

  • Document type

  • Document number

  • Document date

  • Transaction amount

  • Transaction description

Additionally, the detailed report lists a subheading that precedes the list of transactions for an account. The subheading shows the supplier's address book number and name. The report also has a summary line for each account that lists the year opening balance, the net change in the account for the month, the year to date balance and the accumulated balance.


Note:

Before you run this report, post accounts receivable transactions.

4.9.2 Processing Options for AR Trial Balance (R74P03B61)

Processing options enable you to specify the default processing for programs and reports.

4.9.2.1 Select

Fiscal Year

Specify the fiscal year for which the system selects records to process.

Fiscal Period From

Specify the first period in a range of periods that the system uses to select records to process.

Fiscal Period Thru

Specify the end period in a range of periods that the system uses to select records to process.

Company Number

Specify the company number for which the system selects records to process.

Date From

Specify the first date in a range of dates that the system uses to select records to process. The system uses this processing option if you leave the Fiscal Period From and the Fiscal Period Thru processing options blank.

Date Thru

Specify the last date in a range of dates that the system uses to select records to process. The system uses this processing option if you leave the Fiscal Period From and the Fiscal Period Thru processing options blank.

4.9.2.2 Process

Report Appearance

Enter 1 to print all detail lines for the accounts. Leave this processing option blank to print account totals.

Currency Type (Release 9.1 Update)

Specify the report currency type, whether transaction currency or domestic currency. Enter 1 to print all transactions (domestic or foreign) in domestic currency. Leave this processing option blank to print transactions by transaction currency (base currency for domestic transactions, and foreign currency for foreign transactions).

4.9.2.3 Print

Account Print Format

Specify the format in which the system prints account numbers on the report. Values are:

1: Account number

2: Short Account ID

3: Unstructured account

Account Suppress Mode

Enter 1 to suppress printing accounts which have no transactions since the beginning of the current year. Enter 2 to suppress printing accounts which have no transactions in the current period. Leave this processing option blank to print information for all accounts.

4.9.3 R74P0450 - AP Trial Balance

The AP Trial Balance report lists all accounts payable transactions by currency, company, account, and supplier or customer. You use this report to verify data in offset and vendor accounts. You can print the report in summary or detail mode.

When you run the AP Trial Balance report, the system writes data from the F0411 table and the F0414 table to the F74P04W table and then prints the formatted data on the report.

You must post your transactions before running the AP Trial Balance report.

4.9.3.1 Summary Mode

When you run the report in summary mode, the system prints the following information in the report header:

  • Reporting period

  • Company number

  • Company description

  • Currency code

The system prints the following information in the report detail section:

  • Vendor's address book number

  • Vendor name

  • Opening balance for the report period (debit or credit)

  • Opening balance for the year (debit or credit)

  • Account turnover

  • Year to date debit or credit

  • Cumulative balance (debit or credit)

4.9.3.2 Detail Mode

When you run the report in detail mode, the system prints the following information in the report header:

  • Reporting period

  • Company number

  • Company description

  • Currency code

For each detail line, the system prints the following information in the report detail section:

  • Document type

  • Document number

  • Document date

  • Transaction amount

  • Transaction description

Additionally, the detailed report lists a subheading that precedes the list of transactions for an account. The subheading shows the vendor's address book number and name. The report also has a summary line for each account that lists the year opening balance, the net change in the account for the month, the year to date balance and the accumulated balance.

4.9.4 Processing Options for AP Trial Balance (R74P0450)

Processing options enable you to specify the default processing for programs and reports.

4.9.4.1 Select

Fiscal Year

Specify the fiscal year for which the system selects records to process.

Fiscal Period From

Specify the first period in a range of periods that the system uses to select records to process.

Fiscal Date Thru

Specify the end period in a range of periods that the system uses to select records to process.

Company Number

Specify the company number for which the system selects records to process.

Date From

Specify the first date in a range of dates that the system uses to select records to process. The system uses this processing option if you leave the Fiscal Period From and the Fiscal Period Thru processing options blank.

Date Thru

Specify the last date in a range of dates that the system uses to select records to process. The system uses this processing option if you leave the Fiscal Period From and the Fiscal Period Thru processing options blank.

4.9.4.2 Process

Report Appearance

Leave this processing option blank to print account totals. Enter 1 to print all detail lines for the accounts.

Rebuild Work Table

Leave this processing option blank to append new records to the table. Enter 1 to clear the table before writing new records to the table.

4.9.4.3 Print

Account Print Format

Specify the format in which the system prints account numbers on the report. Values are:

1: Account number

2: Short Account ID

3: Unstructured account

Account Suppress Mode

Enter 1 to suppress printing accounts which have no transactions since the beginning of the current year. Enter 2 to suppress printing accounts which have no transactions in the current period. Leave this processing option blank to print information for all accounts.

4.9.5 R74P9010 - Trial Balance by Object

The GL Trial Balance by Object report (R74P9010) lists information about transaction posted to the general ledger. This report reads the F0901 table, the F0911 table, and the F0006 table, and prints the transactions for the specified reporting period by object account.

The GL Trial Balance by Object report contains:

  • Account transactions (detail)

  • Account balances (summary)

  • Account numbers and names

  • Columns for open balances, period and year-to-date turnover, and period closing balance

  • Totals for each open balance, period and year-to-date turnover, and period closing balance

4.9.6 Processing Options for GL Trial Balance by Obj (R74P9010)

Processing options enable you to specify the default processing for reports.

4.9.6.1 Select

1. From Period

Specify how the system determines the balances included in the report.

Enter 0 or leave this option blank to use the first period of the current fiscal year as the beginning period for balances. The system prints all current year transactions for all accounts plus debit and credit totals by period for the current fiscal year. The balance forward totals for balance sheet accounts are from inception through the end of the previous fiscal year.

Enter 1 to use the current period as the beginning period. The system prints a balance forward total of the previous activity for the current fiscal year and transactions for the current period only for each account. The report does not print all account activity for the year. The balance forward total reflects the year-to-date amounts through the end of the previous period for profit-and-loss accounts. For balance sheet accounts, the report reflects the inception-to-date amounts through the end of the previous period.

2. From Date

Specify the beginning date in a range of dates that the system uses to select records to process. If you leave this processing option blank, the system uses the date of the period specified in the From Period processing option.

3. Thru Fiscal Year

Specify the ending fiscal year in a range of years. The system uses the range to select records for the report. Enter the last two digits of the fiscal year, for example, enter 07 for the year 2007.

If you enter 0 for the From Period processing option, the year that you enter for this processing option must be the same as the year specified for the Beginning of Fiscal Year field in the Company Names & Numbers program (P0010). If the year you specify is not the same, the report does not include a line item for balance forward amounts.

4. Period Number

Specify the period number that the system uses to select records to process.

5. Thru Date

Specify the end date in a range of dates that the system uses to select records to process. If you leave this processing option blank, the system uses the date of the period specified in the From Period processing option.

6. Subledger

Specify the subledger for which the system processes records. Enter a specific subledger, or enter * to processes records for all subledgers. Leave this processing option blank to process records that do not have subledgers.

7. Subledger Type

Specify the subledger type that the system uses when selecting records to process. The value that you enter must exist in UDC table 00/ST. You must complete this processing option if you entered a specific subledger in the Subledger processing option.

8. Ledger Type

Specify the ledger type that the system uses to select records to process. The value that you enter must exist in UDC table 09/LT. If you leave this processing option blank, the system selects records with a ledger type of AA.

4.9.6.2 Print

1. Account Number Format

Specify the format in which the system prints account numbers on the report. Values are:

1: Account number.

2: Short account ID.

3: Unstructured account.

2. Accounts with Zero Balances

Leave this processing option blank to print information for all accounts. Enter 1 to omit accounts with a zero balance.

4.9.6.3 Currency

1. Currency Code

Specify the currency code of the records that the system selects for processing. Enter a specific currency codes to select only records with the specified currency code. Leave this processing option blank to select records for all currency codes.

2. Currency Code From

Specify an as if currency code. The currency code must exist in the F0013 table. The system prints amounts on the report in the currency you specify, instead of the currency in which the records are stored.

Leave this processing option blank to print amounts in the currency in which they are stored.

3. As-of Date

Specify the date that the system uses when processing records in an as-if currency. If you leave this processing option blank, the system uses the date in the Thru Date processing option.

4.9.6.4 Localization

1. Report Title

Enter a title that the system prints on the report. You can enter as many as 60 characters. If you leave this processing option blank, the system does not print a title.

2. Report Title Continuation

Enter additional text for the title of the report. You can enter as many as 60 characters.

3. Company Number

Specify a company number to print the company name and number on the report.

4. Accounts Detail

Leave this processing option blank to print all detail lines for the account. Enter 1 to print a summary with a total for the account.

4.9.7 Processing Options for GL Trial Balance by Category Code (R74P9015)

The processing options for the GL Trial Balance by Category Code report are the same as those for GL Trial Balance by Object Report, with one additional processing option.

See Processing Options for GL Trial Balance by Category Code (R74P9015).

4.9.7.1 Localization

5. Category Code for Trial Balance

Specify the category code that the system uses to select records to process. Values are 21, 22, or 23.

4.9.8 R74P9020 - Transaction Journal

The Transaction Journal lists all journal entries and assigns a register number to them by company and fiscal year. It consolidates all of the information for a company. The report includes:

  • Report name

  • Company name

  • Code and name of the transaction ledger

  • Name of the program producing the report

  • Reporting period

  • Date and time report was printed

  • User who printed the report

4.9.9 Processing Options for Transaction Journal (R74P9020)

Processing options enable you to specify the default processing for reports.

4.9.9.1 Default

Processing Mode

Leave this processing option blank to run the report in proof mode. Enter 1 to run the report in final mode without titles and headers. Enter 2 to run the report in final mode and print titles and headers.

Registration Number

Enter 1 to have the system assign a registration number to each individual line entry. Leave this processing option blank to have the system assign a registration number to each document.

Adjustment Registration Date

Specify the adjustment registration date. If you leave this processing option blank, the system assigns the GL date of the adjustment.

Next Available Registration Number

Specify how the system assigns the next available registration number for adjustments entered in the prior year. Enter 1 to use the next available registration number from the fiscal year of the general ledger adjustment date, which is the next available registration number from the previous year.


Note:

You should not use this processing option. Instead, leave this processing option blank to use the next available registration number from the current year.

4.9.9.2 Select

From Date

Specify the first date of a range of dates that the system uses to select records for the report.

Thru Date

Specify the end date for a range of dates that the system uses to select records for the report.

Company Number

Specify the company for which the system retrieves general ledger records. If you leave this processing option blank, the system uses company 00000.

4.9.9.3 Print

Account Number

Specify whether the system includes account numbers from an alternate chart of accounts on the report. Values are:

Blank: Use account numbers from the standard chart of accounts and prints them in the BU.OBJ.SUB format.

21: Use account numbers from the chart of accounts set up in category code 21.

22: Use account numbers from the chart of accounts set up in category code 22.

23: Use account numbers from the chart of accounts set up in category code 23.

4.9.9.4 Currency

Currency Code

Specify a currency code for as if processing. Enter a valid currency code from the F0013 table. The system processes all records in the currency you specify instead of in the currency in which the records are stored.

If you leave this processing option blank, the system uses the currency code in which the records are stored.

As-of Date

Specify the date that the system uses to retrieve the exchange rate for as if processing. If you leave this processing option blank, the system uses the date in the Thru Date processing option.

4.9.9.5 Localization

Report Title

Enter the title that you want the system to print on the report. The maximum number of characters you can enter is 60. If you need additional characters, complete the Report Title (continuation) processing option.

Report Title (continuation)

Enter additional text for the report title. You can enter as many as 60 characters.

Ledger Type

Specify a ledger type that the system uses to select records. Enter a valid code from UDC table 09/LT. If you leave this processing option blank, the system uses the AA ledger type.

4.9.10 Processing Options for Bank Register (R74P9030)

Processing options enable you to specify the default processing for reports.

4.9.10.1 Select

1. From Period

Specify the balances that the system includes in the report.

0: Use the first period of the current fiscal year as the beginning period. This is the default value. The report prints all current year transactions for all accounts plus debit and credit totals by period for the current fiscal year. The balance forward totals for balance sheet accounts are from inception through the end of the previous fiscal year.

1: Use the current period as the beginning period. The report prints a balance forward total of the previous activity for the current fiscal year and transactions for the current period only for each account. The report does not print all account activity for the year. The balance forward total reflects the year-to-date amounts through the end of the previous period for profit and loss accounts. For balance sheet accounts, the report reflects the inception-to-date amounts through the end of the previous period.

2:Use the first period of the first fiscal year (when General Accounting processing began) as the beginning period. If you enter 2, the report prints transaction information from the date when General Accounting processing began through the current period.

2. From Date

Specify a beginning date in a range of dates for the system to use when selecting records to print on this report. If you leave this processing option blank, the system uses the value specified in the From Period processing option.

3. Thru Fiscal Year

Specify the ending fiscal year in a range of years that the system uses to select records for this report. Enter the last two digits of the fiscal year. For example, enter 07 for the year 2007.

If you enter 0 (for year-to-date balances) for the From Period processing option and you enter a year for this processing option, the year must be the same as the year specified in the Beginning of Fiscal Year field in the Company Names & Numbers program (P0010). Otherwise, the report does not include a line item for balance forward amounts.

4. Period Number

Specify a period number for the system to use to select records for this report.

5. Thru Date

Specify an ending date in a range of dates for the system to use to select records to print on this report. If you leave this processing option blank, the system uses the value specified in the From Period processing option.

6. Subledger and 7. Subledger Type

Specify the subledger for which the system processes records. Enter a specific subledger or enter * to process records for all subledgers, including blank subledgers. Leave this processing option blank to process records that do not have subledgers.

Specify a subledger type from UDC table 00/ST. If you specify a value in the Subledger processing option, you must enter a subledger type for this processing option.

8. Ledger Type

Specify a ledger type from UDC table 09/LT. If you leave this processing option blank, the system uses ledger type AA.

9. Document Type

Complete this processing option in conjunction with the Ledger Type processing option to specify a document type from UDC table 00/DT. If you leave this processing option blank, the system selects all document types.

If you do not specify a ledger type for the Ledger Type processing option, the system ignores the value in this processing option.

4.9.10.2 Print

1. Account Number Format

Specify the format in which the system prints the account number. Values are:

1: Print the account number in business unit.object.subsidiary format.

2: Print the short account ID.

3: Print the third (unstructured) account number.

2. Accounts with zero balance

Leave this processing option blank to print information for all accounts. Enter 1 to suppress printing for accounts with a zero balance.

3. Posted Transactions

Leave this processing option blank to print posted transactions only. Enter 1 to print both posted and unposted transactions.

4.9.10.3 Currency

1. Currency Code

Specify the currency code of the records that the system selects for processing. Enter a specific currency codes to select only records with the specified currency code. Leave this processing option blank to select records for all currency codes.

2. Currency Code From

Specify an as if currency code. The system prints amounts on the report in the currency you specify, instead of the currency in which the records are stored. Leave this processing option blank to print amounts in the currency in which they are stored.

3. As-of date

Specify the date that the system uses when processing records in an as if currency. If you leave this processing option blank, the system uses the date in the Thru Date processing option.

4.9.10.4 Localization Options

1. Report Title

Enter a title that the system prints on the report. You can enter as many as 60 characters. If you leave this processing option blank, the system does not print a title.

2. Report Title (continuation)

Enter additional text for the title of the report. You can enter as many as 60 characters.

3. Bank Register Number

Specify the bank register number that the system prints in the header area of the report. If you leave this processing option blank, the system does not print a register number.

4.10 Working with Split VAT Payments Report (R704012) (Release 9.1 Updates)

The Split Voucher VAT report (R704012) includes information about the voucher lines added with the split VAT amount. The R704012 report also displays error in the setup for the processed transactions.

For each detail line, this report includes the:

  • Vendor Number

  • Alpha Name

  • Document Number/Type/Company

  • Gross Amount

  • Tax Amount

  • Taxable Amount

  • Pay Status

  • Pay Item

  • G/L Account Number

  • Split Percentage

  • Payee

  • Remarks

  • Error Description

When you run the Split Voucher VAT report, the system:

  • Processes the vouchers with the pay status specified in the processing options of the report. If the pay status is not specified in the processing options, the vouchers with pay status % are processed.

  • Calculates the split amount from the tax amount of the voucher based on the split percentage specified in the Split VAT - Work with Supplier Information program (P704012).

    See, Section 3.13, "Setting Up Split VAT for Supplier (Release 9.1 Updates)".

  • Adds a line with the split VAT amount to be deducted from the original voucher line.

  • Adds a line with the split VAT amount to be paid to the payee specified in the processing options of the report. If the payee address is not specified in the processing options, the payee address specified in the P704012 program is used.

    Updates the account for which the account ID is specified in the processing options of the report with the split VAT amount.

    If the account ID is not provided, the account associated with the G/L offset provided in the processing options of the report is updated. If the account ID and G/L offset are not provided in the processing options of the report, the account associated with the G/L offset specified in the P704012 program is updated.

  • Updates the pay status of the new line with the split VAT amount to be paid to the payee address specified in the processing options of the report. The pay status is updated with the value specified in the Split Pay Status processing option of the report.

  • Updates the pay status of the original line of the voucher and the new line with the split VAT amount to be deducted from the original line. The pay status is updated with the value specified in the Pay Status processing option of the report.


Note:

The system does not include transactions with zero tax amount in the R704012 report.

4.10.1 Prerequisites for the Split Voucher VAT Report

Before you complete the tasks in this section:

  • Ensure that the setup for split VAT payment is available in the Split VAT Setup - Work with Supplier Information program (P704012).

  • Set up the processing options for the Split Voucher VAT report (R704012).

4.10.2 Setting Processing Options for Split Voucher VAT Report (R704012)

Processing options enable you to specify the default processing for programs and reports.

4.10.2.1 Pay Status

The value you specify for pay status must exist in the Pay Status Codes UDC table (00/PS).

Pay Status

Specify the pay status you want to assign to the original line of the voucher, and the new line with the split VAT amount to be deducted from the original line.

Split Pay Status

Specify the pay status you want to assign to the line with the split VAT amount to be paid to the payee or tax authority.

Voucher Pay Status

Specify the pay status of the voucher lines for which you want to run the report.

4.10.2.2 G/L Offset

G/L Offset

Specify the G/L offset for which the associated account must be updated for the split VAT payment. If the account ID is specified, the system updates the account for which the account ID is provided and does not update the account associated with the G/L offset.

The G/L offset must be available in the Work With Automatic Accounting Instructions program (P0012).

Account ID

Specify the account ID to be updated for the split VAT payment.

The account ID must be available in the Work With Accounts program (P0901).

4.10.2.3 Payee Address Number

Payee Address Number

Specify the address number of the payee to which the split VAT amount must be credited.

If you do not provide a payee address in the processing option and the Split VAT Setup - Work with Supplier Information program (P704012), the system updates account of the supplier.

The payee address number must be available in the Work With Supplier Master program (P04012).

4.10.2.4 Remarks

Remarks

Specify the remarks to be included in the report for the split VAT amount line.

4.10.3 Running the Split Voucher VAT Report

From the Localization module (G70), select General Localizations (G7000), Split VAT (G7005), and then Split Voucher VAT (R704012).