This chapter provides an overview of cash transactions and discusses how to:
Print reports for inbound and outbound cash transactions.
Generate the Cash Desk Report (P74P9104).
Work with vouchers for Poland.
Repost the Account Ledger tag file.
Print value-added tax (VAT) reports for Poland.
Print the self-invoice for Poland.
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.
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.
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).
Before you perform the tasks in this section:
Verify that the Localization Country Code field in your User Display Preferences is set to PL (Poland).
Verify that specific accounts for cash are set up.
Verify that legal numbering is set up for legal document types for cash transactions.
See (CZE, HUN, POL, and RUS) Setting Up Legal Numbering for Legal Documents.
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. |
Processing options enable you to specify the default processing for programs and reports.
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. |
Processing options enable you to specify the default processing for programs and reports.
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. |
Access the Work With Cash Desk Transactions form.
Select a record, and then select Print Report from the Row menu.
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).
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.
Select Cash Desk Transactions (G74PCASH), Cash Desk Report.
Processing options enable you to specify the default processing for programs and reports.
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. |
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. |
This section provides an overview of vouchers for Poland and discusses how to:
Set processing options for Voucher Additional Information (P74P0411H).
Enter additional voucher information for Poland.
You use the standard voucher entry programs to enter vouchers for Poland. You then use the Voucher Additional Information program (P74P411H) to enter additional information about the voucher that the system uses when you produce the purchase registers for tax 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 a menu option. (Accounts Payable (G74P04), 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.
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.
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.
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.
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.
Tax Dates for Vouchers
To declare the VAT that appears on posted and unposted voucher 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.
Assign the specific voucher types to vouchers for which you need the ability to change the tax liability date.
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. |
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. |
Enter additional information about the voucher. |
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.
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. |
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. |
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).
See Also
Reposting the Account Ledger and Recalculating a Fiscal Year
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).
Select General Ledger (G74P09), Repost Account Ledger Tag File.
Processing options enable you to specify the default processing for programs and reports.
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. |
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).
Each month, 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 (P74P4010) program to associate additional information with the UDC values that represent the vouchers that you pay.
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.
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 the reporting period specified. 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 of the company.
Title.
VAT purchase register.
Reporting period (month and year).
Date and time of printing.
Program ID.
Page number.
For each detail line, this report includes:
Sequential register number.
Date of receipt of the invoice.
Date of issuing the invoice.
Invoice number.
VAT registration number of the vendor.
Name and address of the vendor.
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.
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.
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.
VAT Sales Report
The VAT Sales report includes information about the standard and correction invoices generated for the selected period by legal document and tax percentage. You must run this report on a monthly basis.
In the Header section, this report includes the:
Program ID.
Version name.
Version title.
Name of the company.
Address of the company.
Title of the VAT sales register.
Reporting period (month and year).
Date of printing.
Program ID.
Page number.
For each detail line, this report includes the:
Sequential register number
Sales date.
Invoice date.
Invoice number.
Document type.
Buyer's VAT registration number.
Buyer's name and address.
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.
Verify that UDC 74P/IM is set up.
Select Accounts Payable (G74P04), VAT Purchase Domestic Register.
Processing options enable you to specify the default processing for programs and reports.
Select
Fiscal Year |
Specify the last two digits of the fiscal year for which you generate the report. For example, for the year 2010, enter 10. |
Fiscal Period |
Specify the accounting period for which you generate the report. |
Company Number |
Specify the company for which you generate the report. |
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. |
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. |
3. 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. |
Select Accounts Payable (G74P04), VAT Purchase Import Register.
Processing options enable you to specify default processing values.
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. |
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. |
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. |
Select Accounts Payable (G74P04), VAT Purchase Register - Paid Vouchers.
Processing options enable you to specify the default processing for programs and reports.
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. |
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. |
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. |
Select Accounts Receivable (G74P03B), VAT Sales.
Processing options enable you to specify the default processing for programs and reports.
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 Legal Company |
Specify the accounting period or the legal company for which you produce the report. |
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. |
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. |
This section provides an overview of the self-invoice and discusses how to run the Self Invoice program (R74P0440).
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.
Select Accounts Payable (G74P04), Self Invoice.