How Due Date is Calculated for Standard Accounts Payables Invoices? (Part 2 - Payment Terms)

Many times when implementation is over key users or users in charge with reporting are starting to raise more in depth questions about setup and logic behind each value option available for different fields. One I have come across recently is about How due date is calculated for standard account payables invoices?

The answer is quite simple at high level: payment term on top of terms date (start date when Payables calculates the due and discount dates for invoice scheduled payments). But this answer raise new questions like:

1. Which are available terms date options?
2. How terms date is defaulted at invoice level?
3. How much flexibility payment term have in regards of configuration?

This article will answer to third question. First two questions are addressed by a previous post.

Question

How payment terms are defaulted at invoice level?

Answer

Supplier Site > Supplier > Payables System Setup (if populated). Anyway user may change it.

Steps

Step 1 - Payment term setup – examples

Step 1.1 - Payment term setup – calendar example

Step 2 - Payment term in action

Step 2.1 - Payment term calendar based - in action

Live Demo

This video shows how to apply all the steps. Enjoy!

If you liked this article feel free to share it with your fellows. Thank you! 

For some other helpful videos check my YouTube Channel. 

To receive notifications for new articles follow me

Or subscribe by email

Email Address

How Due Date Is Calculated for Standard Accounts Payables Invoices? (Part 1 - Terms Date)

Many times when implementation is over key users or users in charge with reporting are starting to raise more in depth questions about setup and logic behind each value option available for different fields. One I have come across recently is about How due date is calculated for standard account payables invoices?

The answer is quite simple at high level: payment term on top of terms date (start date when Payables calculates the due and discount dates for invoice scheduled payments). But this answer raise new questions like:

1. Which are available terms date options?
2. How terms date is defaulted at invoice level?
3. How much flexibility payment term have in regards of configuration?

This video will answer to the above first two questions and show some real examples about how due date is calculated. Third one is treated in a separate post.

Setup configuration

Let’s first have a look to setup configuration. Payables has following available options for deriving Terms Date Basis:

• System - Current date of your Payables system, automatically filed by system
• Goods Received. Date you receive goods for invoices you match to purchase orders, manually entered by user
• Invoice - invoice date, automatically filed by system
• Invoice Received - Date you receive an invoice, manually entered by user

The default value for Terms Date Basis is required during Payables System Setup and this value will be automatically inherit by all new suppliers.

Demo

• Enter invoice when Terms Date Basis = Invoice Received at site level 
• Enter invoice when Terms Date Basis = Goods Received at site level 
• Enter invoice when Terms Date Basis = Invoice at site level 
• Enter invoice when Terms Date Basis = System at site level

If you liked this article feel free to share it with your fellows. 

For some other helpful videos check my YouTube Channel. 

To receive notifications for new articles subscribe to this blog.

Email Address 

How to Use Account Hierarchy Manager to Maintain Account Structure?

I found Account Hierarchy Manager feature as a friendly and more flexible way to maintain accounting flex field structure for both adding new child or parent values to hierarchy and changing hierarchy structure.

Hierarchy export functionality is also included in case you need to save for later reference or for offline review.

For those interested about this subject I create below video following next steps:

1. Open Account Hierarchy Manager (AHM) under GL responsibility
2. Select desired account structure and open natural account segment
3. Move child values from one parent to a different parent
4. Arrange your screen for a better view over values properties
5. Create a new account under an existing parent
6. Export hierarchy for selected parent
7. Drag and drop child between hierarchies
8. Just checking that changes are visible into standard screen

Account Hierarchy Manager setup overview

Oracle eBusiness Suite R12 standard documentation for The Account Hierarchy Manager

With the Account Hierarchy Manager you can graphically create, maintain, and review account structure hierarchies. You can define new parent and child segment values, as well as change parent/child dependencies. You can also create new rollup groups from the Account Hierarchy Manager and have your changes reflected automatically in both the Key Segment Values and Rollup Groups windows.

Attention: The General Ledger profile option, GL AHM: Allow Users to Modify Hierarchy must be set to Yes if you want to modify and save account hierarchies.
See: Setting General Ledger Profile Options, Oracle General Ledger User Guide

Attention: When you change parent/child relationships that affect existing summary accounts, run the Incremental Add/Delete Summary Templates program to update your summary account balances.
See: Maintaining Summary Accounts, Oracle General Ledger User Guide

Attention: You can only use the Account Hierarchy Manager for segments with value sets using Independent validation.

Attention: There are two applications that allow you to graphically create and modify account hierarchies and related information stored in General Ledger. The Account Hierarchy Manager is accessed through the General Ledger Navigator. Applications Desktop Integrator's Account Hierarchy Editor is a client server application accessed from your desktop.

See: The Account Hierarchy Editor, Applications Desktop Integrator User Guide

Prerequisites

• Define the profile option Gateway User ID. See: Oracle Applications User's Guide.
• Define the profile option Guest User Password. See: Oracle Applications System Administrator's Guide.
• Define the profile option GL AHM: FND Schema Name. See: Oracle General Ledger User Guide. 
• Define the profile option GL AHM: Database Host. See: Oracle General Ledger User Guide.
• Define the profile option GL AHM: Database Port. See: Oracle General Ledger User Guide.
• (Optional) Define the profile option GL AHM: Allow User to Modify Hierarchy. See: Oracle General Ledger User Guide.

If you liked this article feel free to share it with your fellows. 

For some other helpful videos check my YouTube Channel. 

To receive notifications for new articles subscribe to this blog.

Email Address 

How to Setup Default Template for an Oracle eBS Report with Multiple Templates?

When you create multiple XML/BI publisher templates for same report in Oracle eBusiness Suite, end user is requesting a specific template to be the default one.

In this video I show to you a short example how to fulfil this requirement.

Steps:

1. Get short name for Payables Posted Payment Register report
2. Create a new template for Payables Posted Payment Register report
3. Verify if new template is visible for Payables Posted Payment Register
4. Set up new template as default for Payables Posted Payment Register
5. Test that new template will be as default when report is run

If you liked this article feel free to share it with your fellows. 

For some other helpful videos check my YouTube Channel. 

To receive notifications for new articles subscribe to this blog.

Email Address 

How to Copy or Generate Multiple Invoices From an Existing Receivable Transaction in Oracle eBS R12?

In different occasions I met people that were keying monthly or on a regular bases receivable transactions/invoices for same customer having same amount and under same contractual conditions.

Even if is not quite same amount but all the other information (customer, lines details) are similar you can successfully use the Copy To functionality in Oracle eBS Accounts Receivables.

Steps

1. Find the invoice / transaction you want to copy
2. Copy same invoice using Daily option
3. Copy same invoice using Monthly option
4. Copy same invoice using Annually option
5. Review generated transactions - output file
6. Review generated transactions - workbench

If you liked this article feel free to share it with your fellows. 

For some other helpful videos check my YouTube Channel. 

To receive notifications for new articles subscribe to this blog.

Email Address 

How to Find Invoice Receipt From Transaction Workbench in Oracle eBusiness Suite R12?

This video will walk you through invoice receipt details starting from receivables transactions workbench or from Account Details screen.

Steps included:

1. Find a paid receivables transaction / invoice
2. Transaction balance due details
3. Invoice has three receipt actions on it
4. Review each receipt details
5. Same details may be found from Account Details screen

If you liked this article feel free to share it with your fellows. 

For some other helpful videos check my YouTube Channel. 

To receive notifications for new articles subscribe to this blog.

Email Address