Refund of Customer's Security Deposit
Refund of Customer's Security Deposit
Hi,
Can anyone tell me the process of refunding customer's security deposit.
Thanks
Can anyone tell me the process of refunding customer's security deposit.
Thanks
-
- Posts: 194
- Joined: Tue May 15, 2007 7:45 am
- Location: United Arab Emirates
Hi Guys
I suggest hereafter for every Positng you make follow certain norms like mentioning the application version also
Following is possible if you are in 11.5.10
There are two ways of doing this
a) You create Customer as a Supplier and make Payment in Payables and perform AP/AR netting functionality which create respective debit and credit memo and accounts get knocked off if you want to use an check printing
b) If you are willing to use Manual check then adopt the following
(i) You might have created an Invoice with Deposit Transaction Type
The entries will be
Receivables
To Revenue (You might have attached a Liability account)
(ii) When you receive cash for the deposit
Cash/Bank A/c Dr
To Receivables
(iii) Now to make the Payment
Create a Negative Miscellaneous Receipt and in the Distribution Line
attach the Liability account used in Invoice Creation Process
The entry will be
Revenue (liability A/c) Dr
To cash / Bank
Hope this helps
Regards
Sivakumar
I suggest hereafter for every Positng you make follow certain norms like mentioning the application version also
Following is possible if you are in 11.5.10
There are two ways of doing this
a) You create Customer as a Supplier and make Payment in Payables and perform AP/AR netting functionality which create respective debit and credit memo and accounts get knocked off if you want to use an check printing
b) If you are willing to use Manual check then adopt the following
(i) You might have created an Invoice with Deposit Transaction Type
The entries will be
Receivables
To Revenue (You might have attached a Liability account)
(ii) When you receive cash for the deposit
Cash/Bank A/c Dr
To Receivables
(iii) Now to make the Payment
Create a Negative Miscellaneous Receipt and in the Distribution Line
attach the Liability account used in Invoice Creation Process
The entry will be
Revenue (liability A/c) Dr
To cash / Bank
Hope this helps
Regards
Sivakumar
HI,
thank you siva and karthick
I have one more doubts?.
How to create customer as supplier?
Every employee is considered as supplier, then only we are going to make a payment??
For that we are mention under classification tab type as employee?..
Then only payables allow to pay the money to employee for (reimbursement type of invoice )
My doubts is where I mention the customer and number?
I search all the tab,there is no customer name,numbers are not come the LOV.
I need to run any program for the same ?..
If ?Yes ? tell me the program name..
When i run the program?at which module?( Supplier Customer Netting Report )
Actually, this program is aviable at AR and AP
Share you are ideas ?? ASAP
thank you siva and karthick
I have one more doubts?.
How to create customer as supplier?
Every employee is considered as supplier, then only we are going to make a payment??
For that we are mention under classification tab type as employee?..
Then only payables allow to pay the money to employee for (reimbursement type of invoice )
My doubts is where I mention the customer and number?
I search all the tab,there is no customer name,numbers are not come the LOV.
I need to run any program for the same ?..
If ?Yes ? tell me the program name..
When i run the program?at which module?( Supplier Customer Netting Report )
Actually, this program is aviable at AR and AP
Share you are ideas ?? ASAP
-
- Posts: 18
- Joined: Thu Jul 19, 2007 1:07 am
- Location: India
Hi
Friends,
I'm new to oracle and this ERP Stuff also.I'm searching for jobs in oracle finacials. Please help me to acheive my goal
I've some doubts
1.How can we set up - If a supplier as customer
Give me the detailed steps
2.What is the difference between EFT and a Wire?
3.When we enter a refund with prepayment by raising debit/credit memo,
what account should be take to raise a dummy invoice.
AR
1. How can we set a sales returns?
2. What are the detailed steps for Auto Invoice?
3.What are the interfaces available in AP,GL,AR?
I'll wait for ur early reply.
Surya[:)]MBA
Friends,
I'm new to oracle and this ERP Stuff also.I'm searching for jobs in oracle finacials. Please help me to acheive my goal
I've some doubts
1.How can we set up - If a supplier as customer
Give me the detailed steps
2.What is the difference between EFT and a Wire?
3.When we enter a refund with prepayment by raising debit/credit memo,
what account should be take to raise a dummy invoice.
AR
1. How can we set a sales returns?
2. What are the detailed steps for Auto Invoice?
3.What are the interfaces available in AP,GL,AR?
I'll wait for ur early reply.
Surya[:)]MBA
-
- Posts: 194
- Joined: Tue May 15, 2007 7:45 am
- Location: United Arab Emirates
Hi
Create a new supplier with the same name of the Customer and in the General Tab you find customer number as one of the field. In this field enter your Customer number. This way supplier and customer get linked
Now create the transactions mentioned above and and run the Supplier Customer netting report from Payables.
Hope this helps
Regards
Sivakumar
Create a new supplier with the same name of the Customer and in the General Tab you find customer number as one of the field. In this field enter your Customer number. This way supplier and customer get linked
Now create the transactions mentioned above and and run the Supplier Customer netting report from Payables.
Hope this helps
Regards
Sivakumar
-
- Posts: 18
- Joined: Thu Jul 19, 2007 1:07 am
- Location: India
-
- Posts: 50
- Joined: Wed May 16, 2007 7:21 am
- Location: India
Hi,
I did saw couple of point , so thought would also share my thoughts around them.
I) I think , On creating AR Invoice and giving Liability Account in Revenue may not be a good idea for long term as it might have an
audit objects ... just a thought as audiors may have a question there and would also limit future ad-hoc reporting capabilities.
However just a thought ,,,, this is more of a business process related question as in an organization there should be proper
process laid out to handle such type of situations. This would not only able to satisfy Auditors but also ensure better book
keeping. As Approvals process (may be through Workflow or a document related manual process) would ensure in reducing
the changes of overpayment.
Also it might answer (may be indirectly) as how to ensure that he is not overpayed .... presence of Process & Approvals on that
front may help in ensuring that ...may be not on the system side fully but certainly on the audit side.
So in that case .. either the AP AR netting , or using some Intermediate Clearing account to transfer the amount from AR to
Clearing and creating Invoice in AP and knocking out balance of that Intermediate clearing ... or the option suggested by
Sivakumar ...any of them would be able to suffice the business needs.
II ) the following are my thoughts to Surya's points
1.How can we set up - If a supplier as customer
I Think :
======
a) Upto 11.5.10 .. i you dont links Suppliers to Customer
b) In R12 ... since Suppliers have been moved to TCA ... may be there could be some link
* I think the important point may ... the Tax Indentified number for Supplier and Customer in there setups should be some .
This seems more of a process Issue and proper process should be there on maintenance side otheriwise there may be an Issue
on TAX side .
2.What is the difference between EFT and a Wire?
I Think :
======
EFT is electronic file which is sent to bank and against that bank creates transaction. Example could be - a electronic file that
you send to bank and bank creates payment against that . Since it is directly sent to bank that is why if you notice on Oracle
Apps side Suplier Account number is mandatoty if your payment method is Electronic.
Wire basically is used whereever there is any third paty involved . Eg- You send the details of payment to a third party or
clearning agent and that further process the check on your behalf with the suppliers
3.When we enter a refund with prepayment by raising debit/credit memo,
what account should be take to raise a dummy invoice.
I Think :
======
a) When you have created Pre-Payment & Paid it
Debit Pre-Payment Expenses
To Cash
* [Prepay Inv- Pre-pay Exp to Liability , Payment Liability to Cash]
b) When you create a Refund, you would Create a Debit Memo . In this i would suggest you to Misc Expenses Account or Any
Expenses which is used to knocking out these transactions .. as after this net impact on that account would be Zero.
Debit Liability
To Expenses [Assume Misc Exp]
When you would create a Refund
Debit Cash
To Liability
c) Now when you create Dumy Invoice
Debit Expenses [Enter Misc Exp]
To Liability
>> Then , apply the orignal Prepayment to this Dummy Invoice ..otherwise that pre-payment would always be available
Thus , after Pre-payment Application
Debit Liability
To Pre-pay Expense
So , in this way you can can also close the Dummy as well as pre-payment Expenses.
AR
2. What are the detailed steps for Auto Invoice?
I Think :
======
Auto Invoice depends upon your data that you intend to Import
For Eg- If you intend to Import TAX , Freight lines - Then you need to configure DFF
Configre DFF
Configure Grouping Rules
Configure Line Orderring Rules
Configure System Options
Configure Transaction Types
Configure Transaction Sources
Incase if you want system to create accounting lines then Auto Accounting rules
If you want to Import data with Accounting rule and Invoicing rule , then you may need to create that also
3.What are the interfaces available in AP,GL,AR?
I Think :
======
AP - Invoice Interface , Interface for Importing Credit Card Related Transactions , Supplier Interface
AR - Invoice , Receipt , Tax Rates , Customer Interface
GL - GL Interface , Exchange Rate Interface
I did saw couple of point , so thought would also share my thoughts around them.
I) I think , On creating AR Invoice and giving Liability Account in Revenue may not be a good idea for long term as it might have an
audit objects ... just a thought as audiors may have a question there and would also limit future ad-hoc reporting capabilities.
However just a thought ,,,, this is more of a business process related question as in an organization there should be proper
process laid out to handle such type of situations. This would not only able to satisfy Auditors but also ensure better book
keeping. As Approvals process (may be through Workflow or a document related manual process) would ensure in reducing
the changes of overpayment.
Also it might answer (may be indirectly) as how to ensure that he is not overpayed .... presence of Process & Approvals on that
front may help in ensuring that ...may be not on the system side fully but certainly on the audit side.
So in that case .. either the AP AR netting , or using some Intermediate Clearing account to transfer the amount from AR to
Clearing and creating Invoice in AP and knocking out balance of that Intermediate clearing ... or the option suggested by
Sivakumar ...any of them would be able to suffice the business needs.
II ) the following are my thoughts to Surya's points
1.How can we set up - If a supplier as customer
I Think :
======
a) Upto 11.5.10 .. i you dont links Suppliers to Customer
b) In R12 ... since Suppliers have been moved to TCA ... may be there could be some link
* I think the important point may ... the Tax Indentified number for Supplier and Customer in there setups should be some .
This seems more of a process Issue and proper process should be there on maintenance side otheriwise there may be an Issue
on TAX side .
2.What is the difference between EFT and a Wire?
I Think :
======
EFT is electronic file which is sent to bank and against that bank creates transaction. Example could be - a electronic file that
you send to bank and bank creates payment against that . Since it is directly sent to bank that is why if you notice on Oracle
Apps side Suplier Account number is mandatoty if your payment method is Electronic.
Wire basically is used whereever there is any third paty involved . Eg- You send the details of payment to a third party or
clearning agent and that further process the check on your behalf with the suppliers
3.When we enter a refund with prepayment by raising debit/credit memo,
what account should be take to raise a dummy invoice.
I Think :
======
a) When you have created Pre-Payment & Paid it
Debit Pre-Payment Expenses
To Cash
* [Prepay Inv- Pre-pay Exp to Liability , Payment Liability to Cash]
b) When you create a Refund, you would Create a Debit Memo . In this i would suggest you to Misc Expenses Account or Any
Expenses which is used to knocking out these transactions .. as after this net impact on that account would be Zero.
Debit Liability
To Expenses [Assume Misc Exp]
When you would create a Refund
Debit Cash
To Liability
c) Now when you create Dumy Invoice
Debit Expenses [Enter Misc Exp]
To Liability
>> Then , apply the orignal Prepayment to this Dummy Invoice ..otherwise that pre-payment would always be available
Thus , after Pre-payment Application
Debit Liability
To Pre-pay Expense
So , in this way you can can also close the Dummy as well as pre-payment Expenses.
AR
2. What are the detailed steps for Auto Invoice?
I Think :
======
Auto Invoice depends upon your data that you intend to Import
For Eg- If you intend to Import TAX , Freight lines - Then you need to configure DFF
Configre DFF
Configure Grouping Rules
Configure Line Orderring Rules
Configure System Options
Configure Transaction Types
Configure Transaction Sources
Incase if you want system to create accounting lines then Auto Accounting rules
If you want to Import data with Accounting rule and Invoicing rule , then you may need to create that also
3.What are the interfaces available in AP,GL,AR?
I Think :
======
AP - Invoice Interface , Interface for Importing Credit Card Related Transactions , Supplier Interface
AR - Invoice , Receipt , Tax Rates , Customer Interface
GL - GL Interface , Exchange Rate Interface
-
- Posts: 18
- Joined: Thu Jul 19, 2007 1:07 am
- Location: India
Hi
Thanq for giving a detailed reply for my doubts.
I'll give u one case:
I sold 10 mobiles to my customer @ 4000/- each. After receiving the payment
I found:
1.if the customer wanted to return all the mobiles,
2.if the customer wanted to reurn 2 of them,
3.if the custmoer( is the supplier to me with other business deal for which I need to pay 4000/- for one trx)nwants to return 2 of them
Regards,
Surya
Thanq for giving a detailed reply for my doubts.
I'll give u one case:
I sold 10 mobiles to my customer @ 4000/- each. After receiving the payment
I found:
1.if the customer wanted to return all the mobiles,
2.if the customer wanted to reurn 2 of them,
3.if the custmoer( is the supplier to me with other business deal for which I need to pay 4000/- for one trx)nwants to return 2 of them
Regards,
Surya
Hi Sive,
As per early discussion ?.
I did very thing but I run the report at Payables ?supplier/customer netting report?
I?m getting an print view message as ?No Data Found?
I can?t able to catch what is the problem for one?
The customer balance again show the same balance?..
I try so many time in test machine but getting same?.
Could you share ?..
As per early discussion ?.
I did very thing but I run the report at Payables ?supplier/customer netting report?
I?m getting an print view message as ?No Data Found?
I can?t able to catch what is the problem for one?
The customer balance again show the same balance?..
I try so many time in test machine but getting same?.
Could you share ?..
Dear Babu
To see the impact of Customer Supplier Netting off report, Customer and Supplier Tax Identification Number must be same.
Step 1. Update your Customer with the Tax Registration Number
Step 2. Update your Supplier with the Tax Registration Number which you have used in Customer defining
Step 3: Currency of the Supplier as well Customer must be one and same. Then only System nets off the balances.
Then, run and see the report output
Upendra DOnepudi
To see the impact of Customer Supplier Netting off report, Customer and Supplier Tax Identification Number must be same.
Step 1. Update your Customer with the Tax Registration Number
Step 2. Update your Supplier with the Tax Registration Number which you have used in Customer defining
Step 3: Currency of the Supplier as well Customer must be one and same. Then only System nets off the balances.
Then, run and see the report output
Upendra DOnepudi
-
- Posts: 54
- Joined: Tue Jul 24, 2007 1:00 am
- Location: India
hi
you define a supplier same as customer,and define a clearing account,generate a creditmemo to reduce the customer balance and generate a debit memo to pay the customer in ar.
then switch to ap to pay the supplier using the same clearing account in distributions to refund the security deposit
regards
rao
apps functional consultant
you define a supplier same as customer,and define a clearing account,generate a creditmemo to reduce the customer balance and generate a debit memo to pay the customer in ar.
then switch to ap to pay the supplier using the same clearing account in distributions to refund the security deposit
regards
rao
apps functional consultant
Hi,
In R12, there is no need to create the supplier as a customer. Do a simple refund if you want to refund your customers. It would come to the Payables workbench as a Payment Request type of Invoice and then you can pay off the Invoice like a simple payment.
Go through the details in the user guide how to do it. Its fairly simple.
Regards,
Dibyajit
In R12, there is no need to create the supplier as a customer. Do a simple refund if you want to refund your customers. It would come to the Payables workbench as a Payment Request type of Invoice and then you can pay off the Invoice like a simple payment.
Go through the details in the user guide how to do it. Its fairly simple.
Regards,
Dibyajit
Who is online
Users browsing this forum: No registered users and 1 guest