1. Using Financials for EMEA
  2. Manage Receipt Regional Information

Manage Receipt Regional Information

Select which receivable receipts classes must be included in the extract by selecting the appropriate value in the GDF under the Regional Information. The GDF identifies the subcategory of the receipt type for the appropriate classification under C100 and D120 records.

The Descriptive Flexfield Name is JG_AR_CASH_RECEIPTS.

Define the values on your receivable receipt. This table lists the values to be defined on a receivable receipt.

No Column Window Prompt Attribute Value Set Required Purpose
30 RECEIPT_TYPE Receipt Type GLOBAL_ATRIBUTE _NUMBER1 ORA_JEIL_RECEIPT_CLASSES Y

To identify the Receipt type and thus define which other segments will be required to be filled by the user.

The values in the list are:
  • 1-Cash
  • 2-Check
  • 3-Credit card
  • 4-Bank transfer
  • 5-Vouchers
  • 6-Coupon swap
  • 7-Bill
  • 8-Direct debit
  • 9-Other

If values 2 or 3 are selected, then the following segments are required respectively for each value. If values 1,4,5,6,7,8,9 are selected then no other segment is required.
40 CREDIT_DEAL_TYPE Credit Card Deal Type GLOBAL_ATRIBUTE _NUMBER2 ORA_JEIL_DEAL_TYPE N Required if Value of Segment 1 = 3 to identify the credit value type from the relative value-set. The values in the list are: 1.Regular 2.Payments 3.Credit 4.Future debit 5.Other . This field is numeric and you can choose between 1 to 5.
60 CREDIT CLEARING_HOUSE Credit Card Clearing House GLOBAL_ATRIBUTE_NUMBER3 ORA_JEIL_CREDIT_HOUSE N Required if Value of Segment 1 = 3 to identify the credit clearing house from the relative value-set. The values in the list are: 1.Isracard (MasterCard) 2.Visa 3.Diners 4.Amex 6.Leumi Card (MAX Card) This field is numeric and you can choose between 1 to 6.

  1. Navigate to Receivables, Accounts Receivable, and Create Receipt.
  2. Enter the Receipt information.
  3. Click Additional Information and select Receipts for Israel from Regional Information.
    1. Define the lookups for GL Categories exclusion.
    2. Use the validator to ensure that the content in these files is as per the legal requirements. The Open Format files are audit reports, that include all financial activities of the company and they are not restricted to tax information and reporting.
    3. Verify the output.

The generated files print the details for all expected sections based on the content processed as per the prescribed format. They contain information regarding posted entries from general ledger, along with information from various sub-ledgers such as customer invoices and receipts from receivables and supplier invoices from payables.

Open Format for Israel files are available for the ledger, which may be a primary, secondary, or reporting currency ledger with currency as ILS. Hence currency conversion doesn’t happen when generating the files.

Note: If the ledger having currency as ILS is not the primary ledger, then you must consider the subledger level conversion and subledger accounting rules that directly transfers information from the subledgers to the ILS ledger.