Logo

Welcome

Welcome to HandsonERP.com

This site provides video based training of Oracle Financials.
Learn concepts and functionality in a step by step manner.

Login

HandsonERP - Oracle E-Business Suite Training
Welcome, Guest
Please Login or Register.    Lost Password?
Please post inquiries related to lessons content here. All questions and inquiries related to the website should be submitted directly using Contact form in the top menu.
Go to bottom Post Reply Favoured: 0
TOPIC: Re:AR AutoAccounting question
#1979
dave (User)
Expert Boarder
Posts: 109
graphgraph
User Offline Click here to see the profile of this user
AR AutoAccounting question 12 Years, 10 Months ago  
In AR , i have to setup auto accounting rule .. where by when the invoice/Transaction is entered in CAD currency - i want to use recievbles account XXXXX
and when then the transaction/invoice is entered in USD then i want to use receivables account - YYYYY

please advice how can i achieve that

Thanks
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#2015
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:AR AutoAccounting question 12 Years, 10 Months ago  
First of all what is the business need?
Why do you want to put CAD balance in one account while USD balance in another? You can do balance reporting in total currency as well as in entered currency.
You can create two transaction types. One with XXX receivables account and one with YYY. Use the first transaction type for CAD transactions and the other for USD. Setup accounting engine to derive receivables account from transaction type.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#2024
dave (User)
Expert Boarder
Posts: 109
graphgraph
User Offline Click here to see the profile of this user
Re:AR AutoAccounting question 12 Years, 10 Months ago  
Hi Hasan

Thanks for the advice !
Business reason: there is requirement to manage the clients identified in two different account: one for national clients and other one for foreing clients,

The second part is to manage the currency of each transaction

Right now i am deriving receivables account from Site level
because of intercompany trx's and each intercompany has its own receivables account
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#2032
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:AR AutoAccounting question 12 Years, 10 Months ago  
If you want to use Receivables accounts based on the type of clients (nations vs foreign) then you can consider setting up AutoAccounting to derive Receivables from Bill-To Site. Specify receivables account at bill-to site according to the type of the client.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#2033
dave (User)
Expert Boarder
Posts: 109
graphgraph
User Offline Click here to see the profile of this user
Re:AR AutoAccounting question 12 Years, 10 Months ago  
Hi

Thats what i have done - i have chosen Site inmy autoaccountuing rules..

sonow i have same clients in both CAD and USD so then ihave to create site for each client and specify receivables accountat site level

please let me know if i am wrong
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#2037
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:AR AutoAccounting question 12 Years, 10 Months ago  
That is what I said in my last post.
Client A - Local - Receivables Account - XXXX
Client B - International - Receivables Account - YYYY
AutoAccounting for Receivables Account -> Bill-To-Site
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop
 
Copyright © 2009
SAP Training| Online Information Technology Training| Free IT Tutorials| Oracle Financials| Oracle Applications Training| Free Tutorials| Free Training| Excel Tutorial| Information Technology Tutorials| SQL Tutorial| PL/SQL Tutorial| Project Management Training| JDeveloper Tutorial| Oracle DBA Tutorial| Ruby on Rails Tutorial| Resources