This chapter provides overviews of voucher entry and voucher match and cash transactions; and discusses how to:
Print reports for inbound and outbound cash transactions.
Generate the Cash Desk Report (P74P9104).
Repost the Account Ledger tag file.
Work with delinquency fees.
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 set up in the Set Up AP Document Types program (P74P4010), you might enter information about the original document or change an invoice or service date. The system automatically launches the Voucher Additional Information program when you add a voucher or modify an existing, non-posted voucher. You can also access the Voucher Additional Information program from a menu option.
When you delete a voucher, the system deletes the information for the voucher that is stored in the F0411 Header File - POL (F74P011H) table.
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 expenses 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.
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.
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 and discusses how to:
Set processing options for Cash Desk Transaction (P74P9101).
Set processing options for 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 Batch Versions.
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.
Form Name |
FormID |
Navigation |
Usage |
Work With Cash Desk Transactions |
W74P9101A |
Cash Desk Transactions (G74PCASH), Cash Desk Transaction Complete the processing options, 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 (R74P9102) program 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 AA. |
Category Code |
Specify the category code that identifies where the 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, 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 (R74P9104) 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 (F74P9100) table 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 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.
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 F74902T table becomes corrupted, run the Repost Account Ledger Tag File program (R749102) to populate the F74902T table. The F74902T table stores information about the debit and credit amounts in the F0911 table.
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 F0902 table.
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 the existence of balances 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 Enter 1to validate the existence of entries in the F0911 table. |
This section provides an overview of delinquency fees, methods of calculating delinquency fees, the A/R Delinquency Fee Journal For Poland (R74P3B22) program, and the delinquency fee process flow; lists prerequisites; and discusses how to set processing options for PO-Localization Finance Charge Processing (R03B525) (P74P525).
In Poland, the interest rate charged as a delinquency fee on past-due invoices can change over the life of the invoice. For example, the interest rate charged on an invoice that is 90 days past due might be different for the first 30 days than for the last 60 days.
JD Edwards EnterpriseOne software enables you to setup delinquency interest rates with effective dates. The added programs for Poland enables you to apply multiple interest rates to a specific invoice from the due date to the actual payment date or as of date, even when the payment date or as of date is more than 30 days from the invoice date.
Note. The effective due date is always a business day. If the due date occurs on a non-working day such as a Sunday, the effective due date is the immediately previous workday.
The application of delinquency fees to customers or invoices is optional. A company can apply them or not apply them.
The system provides a processing option to enable you to specify whether the system calculates delinquency fees based on the pending amount and the amount of payments that are made after the due date, or based on the open amount (30-day rule method).
The amount of the delinquency fees calculated might be different for each method, depending on whether the interest rate charged increases or decreases from the invoice due date until the invoice is paid in full, and depending on whether the customer makes partial payments.
The system uses these methods of calculating delinquency fees:
Method |
Base amount |
Interest type |
Date from |
Date through |
30 day rule |
Open amounts |
Legal rate |
The latest occurring of the invoice date, shipment date, or delivery date, plus 30 days. |
The earliest occurring of the invoice due date, the as of date, or the date receipt cleared date. Note. A processing option in the PO – Localization Finance Charge Processing (R03B525) (P74P525) program determines whether the system uses the receipt cleared date or standard as of processing. |
Late payment |
Paid amount |
Legal or contract rate |
Invoice due date |
Receipt cleared date. Note. A processing option in the PO – Localization Finance Charge Processing (R03B525) (P74P525) program determines whether the system uses the receipt cleared date or standard as of processing. |
Open invoices |
Pending amounts |
Legal or contract rate |
Invoice due date |
As of date |
The system supports as of processing for the 30 day rule method. When an invoice is fully or partially paid, the system uses the value from the Cleared/Value Date to determine the open amount for which to calculate delinquency fees. If no value exists for the Cleared/Value Date, the system uses the G/L date of the receipt.
Note. All of the calculation methods could be applied to the same invoice.
30 Day Rule Method
The system writes to two additional tables when you use the 30-day rule method to calculate delinquency fees. The Processed Documents in Finance Charge Process table (F74P3B24) includes the ending date for the period for which each fee is calculated for each invoice. The system also writes data to the A/R Fee Journal History Detail for Poland table (F74P3B23). The system uses the information in this table when you generate the A/R Delinquency Fee Journal For Poland (R74P3B22) report.
See Understanding the A/R Delinquency Fee Journal For Poland (R74P3B22) Program.
This graphic shows how the system processes delinquency fees using the 30-day rule method.
30–day Rule Method
When you set the 30 Day Rule processing option to specify that the system uses the 30-day rule method, the system:
Calculates the delinquency fee for the number of days for which the entire invoice amount is overdue.
The system uses the invoice date, shipment date, or delivery date, plus 30 days as the beginning of the period for which it calculates the delinquency fees, and uses the earliest of the invoice due date or the as of date as the end of the calculation period. If the period for which the entire amount is past due spans more than one interest rate as set up in the Define Delinquency Policies program (P03B2501), the system calculates the delinquency fee for the number of days for which the amount is past due for each interest rate in effect.
If a partial payment is made, calculates the delinquency fee for the number of days for which the open amount is overdue up to invoice due date or the as of date, whichever date is earliest.
For the partially paid amount, the system calculates the fees up to the receipt clear date or receipt GL date according to processing option setup.
For example, if the customer makes a 1000 payment on a 10,000 invoice, the system calculates the delinquency fee on 10,000 up to the date on which the amount is paid. The system also calculates delinquency fees on 9000 up to the invoice due date or the as of date, whichever date is earliest. If you set the processing options to use the receipt cleared date, the system uses that date instead of the payment date to determine the number of days for which to calculate the delinquency fee.
If the period for which the entire amount is past due spans more than one interest rate, the system calculates the delinquency fees for the number of days for which the amount is past due for each interest rate in effect. When the final payment is made, the system calculates the delinquency fee from the date of the last delinquency fee calculation until the date of the earliest occurring of the invoice due date, the as of date, or the receipt cleared date or receipt GL date. In the example in this section, the delinquency fees would be calculated on the 9000 that was cancelled in the last receipt.
If the period for which the entire amount is past due spans more than one interest rate, the system calculates the delinquency fees for the number of days for which the amount is past due for each interest rate in effect.
Late Payment and Open Invoice Methods
When you specify that the system does not use the 30-day rule method, the system bases the delinquency fee calculations on the pending amount and the amount and date of the late payments.
This graphic shows how the system calculates delinquency fees when you do not use the 30-day rule method.
Late Payment and Open Invoice Methods
The system:
Calculates the delinquency fee on the lowest open amount from the invoice due date to the execution date.
The lowest open amount is the original invoice amount minus any partial payments.
If the period for which the lowest open amount is past due spans more than one interest rate, the system calculates the delinquency fees for the number of days for which the amount is past due for each interest rate in effect.
Calculates the delinquency fee on the amount of each partial payment for the number of days that the payment amount was past due up to the date receipt cleared date or receipt GL date, depending on the processing options.
If the period for which the partial payment is past due spans more than one interest rate, the system calculates the delinquency fees for the number of days for which the amount is past due for each interest rate in effect.
Examples of Delinquency Fee Calculations
The base software calculates delinquency fees for open amounts from the due date to the as of date, uses only one interest rate, and calculates delinquency fees on late payments from the due date to the payment date.
When you complete the process for calculating delinquency fees for Poland, the system either uses the 30-day rule method to calculate the delinquency fees or calculates the delinquency fees based on the pending and late payment amounts.
Suppose you issued an invoice and received payment for the invoice with these factors in effect:
Invoice amount is 10,000.
Invoice is issued on August 19.
30-day due date is September 18.
The interest rate in effect on September 18 is 15 percent.
The interest rate changes to 20 percent on October 1.
The customer makes these payments:
1000 on September 26.
500 on October 10.
October 24 is the As Of processing date.
The system makes these calculations when you enable the 30-day rule method:
When the 1000 payment is made on September 26, determines and applies to the 10,000 original invoice amount a daily delinquency fee based on an interest rate of 15 percent and multiplies it by 8 days (September 18 through September 26).
When the interest rate changes on October 1, determines and applies to the open amount of 9000 a daily delinquency fee based on an interest rate of 15 percent and multiplies it by 4 days (September 27 through September 30).
When the payment of 500 is made on October 10, determines and applies to the open amount of 9000 a daily delinquency fee based on an interest rate of 20 percent and multiplies it by 10 days (October 1 through October 10).
When you calculate the delinquency fees on October 24, determines and applies to the open amount of 8,500 a daily delinquency fee based on an interest rate of 20 percent and multiplies it by 14 days (October 10 through October 24).
The system makes these calculations for based on pending amounts and late payments (the 30-day rule method is not enabled):
For the 1,000 paid on September 26, determines a daily delinquency fee based on an interest rate of 15 percent and multiplies it by 8 days (September 18 through September 26).
For the 500 paid on October 10:
Determines a daily delinquency fee based on the interest rate of 15 percent and multiplies it by 12 days (September 18 through September 30).
Determines a daily delinquency fee based on the interest rate of 20 percent and multiplies it by 10 days (October 1 through October 10).
For the 8,500 open amount up to the As Of execution date, October 24:
Determines a daily delinquency fee based on the interest rate of 15 percent and multiplies it by 12 days (September 18 through September 30).
Determines a daily delinquency fee based on the interest rate of 20 percent and multiplies it by 24 days (October 1 through October 24).
The system automatically runs the A/R Delinquency Fee Journal For Poland program (R74P3B22) and the Delinquency Fee Journal Program (R03B22) when you run the Generate Delinquency Fee program (R03B525). The A/R Delinquency Fee Journal For Poland program, reads the A/R Fee Journal History Detail for Poland table (F74P3B23) and generates a report that lists the standard information that the system includes in the report for the Delinquency Fee Journal program plus selected information from the F74P3B23 table.
This table describes the fields in the F74P3B23 table:
Heading |
Descriptions |
Included in R74P3B22 Report |
Policy Number/Line Number |
Lists the policy name used to determine the delinquency fee calculations and the line number if multiple lines for the policy are generated. The policy number appears in the standard report; the line number is specific to the Polish process. |
Yes |
Delinquency Fee Date Used (data item P74DBEG) |
When using the 30-day rule method, the system calculates the beginning date on the latest of the invoice date, the shipment date, or the delivery date, plus 30 days. This field contains a 1 if the beginning date of the calculation is based on the invoice date plus 30 days, contains 2 if the beginning date is based on the shipment date plus 30 days, and contains 3 if the beginning date is based on the delivery date plus 30 days. |
Yes |
Period Number (data item P74PN) |
When using the 30-day rule method, the system indicates when more than one receipt is processed during the period for which an interest rate is effective. For the first receipt within the effective date range of an interest rate, the system writes 1 to this field, for the second receipt, the system writes 2, and so on. |
No |
Begin Period (data item P74BPE) and End Period (data item P74EPE) |
When using the 30-day rule method, the system generates periods for each receipt in the date range and writes the beginning date and ending date used for the delinquency fee calculation. |
Yes |
Number of Rule (data item P74NRUL) |
If the invoice has past due or open amounts that span more than one interest rate period (rule), the system indicates for which period the record is written. The system writes 1 if the record is created for the first rule, writes 2 if the record is created for the second rule, and so on. |
No |
Date From Fee Calculated (data item P74FFC) and Date Thru Fee Calculated (data item P74TFC) |
The system writes the beginning and ending dates for the period for which the fees are calculated. |
Yes |
To apply different interest rates to invoices:
Set up delinquency fee policies using the Define Delinquency Policies program (P03B2501).
Set the processing options for the PO-Localization Finance Charge Processing (R03B525) program (P74P525) using a version that has the same name as the version of the Generate Delinquency Fees program (R03B525) that you use to process delinquency fees for Poland.
If you do not set up corresponding versions, the system uses version ZJDE0001 of the P74P525 program.
Set the processing options for the Add Invoice - PO (P7433B11) program in which the Issue Place processing option is set to the issue place from which the system generates the legal number for the fees invoice.
Run the Generate Delinquency Fee program (R03B525).
See Running the Print Delinquency Notices Program.
When the country code is set to PL (Poland), the system reads the processing options for the PO-Localization Finance Charge Processing (P74P525) program and calculates delinquency fees.
If the Late Payment Delinquency Fee processing option in the Generate Delinquency Fee program is blank so that the system does not calculate late payment fees when you run the Generate Delinquency Fee program, run the Late Payment Delinquency Fees program (R03B221) to generate delinquency fees.
Run the Review Delinquency Notices program (P03B22) to generate a report that can be used to review and approve the delinquency fees.
Note. The system automatically runs the A/R Delinquency Fee Journal For Poland program (R74P3B22) and the Delinquency Fee Journal Program (R03B22) when you run the Generate Delinquency Fee program (R03B525).
Before you complete the tasks in this section:
Verify that the value in the Localization Country Code field in the in User Profile Revisions program (P0092) is set to PL (Poland).
Set the processing options for Add Invoice - PO (P7433B11).
Set up corresponding versions of the Generate Delinquency Fee program (R03B525) and the PO-Localization Finance Charge Processing (R03B525) program (P74P525).
Verify that the workday calendar and due date rules are set up.
Access the PO – Localization Finance Charge Processing (R03B525) program from the Accounts Receivable (G74P03B) menu. The system launches a program that enables you to set the processing options.
General
Policy |
Enter the policy name set up in the Define Delinquency Polices program (P03B2501) that the system uses to apply delinquency fees. |
Company |
Enter the company name associated with the policy that the system uses to apply delinquency fees. If you leave this processing option blank, the system uses company 00000. |
Cleared/Value Date |
Enter 1 to use the value in the Cleared/Value Date field on the Receipt Entry form of the Standard Receipts Entry program (P03B102) to calculate the fees when you enter 1 for the 30 Day Rule processing option. The system uses this value only when a value exists in the Receipts Header table (F03B13). If no value exists, the system uses the G/L date. Leave this processing option blank to use the G/L date to calculate the delinquency fees. |
30–Day Rule
30 Day Rule |
Leave this processing option blank to base delinquency fee calculations on the open amount and late payment amounts. Enter 1 to calculate delinquency fees based on the late payments plus 30 days. |
Customer Selection
Customer Master Category Code Number |
Enter the address book category code in which exists customer data for applying delinquency fees. |
Customer Master Category Code Value |
Enter the value that exists in the category code identified in the A/B Category Number processing option what identifies the customers for which you process delinquency fees. |
RF Generation
Version |
Enter the version of the Add Invoice - PO (P7433B11) program in which the Issue Place processing option is set to the issue place from which the system generates the legal number for the fees invoice. |