Author Archives: All Oracle Apps

eBiz Tax Query with ZX Tables

eBiz Tax Query with all ZX tables:

 

 Thanks Rajanikanth Yeturi for Providing the Query.


 

Related posts:

Remit-To Address

Remit-To Address:

Setting Up a Remit-To Address

Define remit-to addresses to let the customers know where to send payment for their invoices.  Receivables uses the addresses that is defined in the Remit To Addresses window to provide default remit-to information when transactions are entered.

Define System Options and Profile Options

a. Responsibility: Receivables Manager
Navigation: Setup > System > System Options
Select the Miscellaneous Tab and enter values for the following:

If you check the Print Remit-To Address box in the System Options window, Receivables prints the remit-to address that you define here on your dunning letters and statements.  The width and height (in characters) of your customer’s remit-to address in your printed dunning letters is 8 characters (height) by 30 characters (width)

Responsibility: System Administrator
Navigation: Profile > System
You can only enter information in the alternate name field when defining a Remit-to Address if the profile option AR: Customers – Enter Alternate Fields is Yes.


Receivables also uses the alternate name to sort customer names in certain
reports if the profile option AR: Sort Customer Reports by Alternate Fields is Yes.

b. Navigate to the Remit-To Address Form

Responsibility: Receivables Manager
Navigation: Setup > Print > Remit To Address > Create Remit-To Address

   Re-Query the Remit-To Address

After you apply and save you will be returned ot the Remit-To Address search window.  Enter the country name and select Go.

Now create the Receipts From Postal Codes:

Optionally Enter a State and/or range of Postal Codes for each country. You can
define multiple assignments for a remit-to address that has the same country or
state, but different postal code ranges.

Assigning a Default Remit-To Address

Define default remit-to addresses to ensure that:

  • Receivables is able to provide a default remit-to address when you enter transactions
  • AutoInvoice will not reject invoices because it is not able to determine a remit-to address

You can only have one default remit-to address for each country or Country + State combination.

Note:  It is a best practice to set up a default remit-to address even if you do not anticipate requiring this value.  If for example you have a default remit-to for the United States, you can also define alternate remit-to address to be used with different zip-code ranges which take priority over the default due to their more granular definitions.

Related posts:

Receivables Accounting Periods

Receivables Accounting Periods

Open or close periods in the accounting calendar to control the recording of accounting information for these periods. Since the objective of AutoInvoice is to create new transactions, the goal is to have these transactions impact open GL periods.

An accounting calendar is made up of accounting periods that control the recording of accounting information into these periods.  The status of the accounting period determines whether or not a transaction entry and journal entry can impact your general ledger.

Following are the valid statuses for a period:

  • Closed

Journal entry, posting, and transaction entry are not allowed unless the accounting period is reopened. Receivables verifies that there are no unposted items in this period. Receivables does not let you close a period that contains unposted items.

  • Close Pending

Similar to Closed, but Close Pending does not validate for unposted items. Journal entry, posting, and transaction entry are not allowed unless the accounting period is reopened.

Note: Before using the Close Pending status, you must run Revenue Recognition for transactions with accounting rules.
  • Future

This period is not yet open, but you can enter transactions in this period. However, you cannot post in this period until you open it.

  • Not Opened

This period has never been opened and journal entry and posting are not allowed. The Revenue Recognition program can, however, create revenue distributions in Not Opened periods, if required by an accounting rule.

  • Open

 Journal entry and posting are allowed.

Responsibility: Receivables Manager
Navigation: Control > Accounting > Open/Close periods

Source: Metalink.oracle.com

Related posts:

Receivables System Options

Receivables System Options

The settings in System Options that impact AutoInvoice are in the Trans and Customers tab. The following screenshot shows recommended settings for fields in the ‘AutoInvoice’ Section. Also highlighted is the Grouping rule we defined earlier.

Log file message level = 10 provides the most detailed debug messages, and is useful when you are debugging or troubleshooting.

Responsibility:
 Receivables Manager
Navigation: Setup > System > System Options

Related posts:

Receivables Customer Profile Classes

Receivables Customer Profile Classes:

Setting up a customer profile class enables to default information into new customer records and enhances ability to quickly setup and define new customers.

Use Customer Profiles to group customer accounts with similar creditworthiness, business volume, payment cycles, and late charge policies.

Responsibility: Receivables Manager
Navigation: Customers > Profile Classes

setup information impacting Late Charges:

Information in the Profile Class Amounts tab allows you to set default values for various Currency/Amount related fields. The details you provide in the Currency Rates and Limits section help you define thresholds for how much business you can conduct with a customer in this profile class and receipt and statement amounts. In the Tolerance section you define data that is used for Late Charge calculation.

Related posts: