ERPstuff - Oracle EBS Community

Hi,

A payment can have multiple invoices. If through EDI file the EFT payment information is sent to bank.The payment number in oracle AP is different from payment number in Bank statement file we recieve from Bank in BAI2 format.

Then Oracle user guide says Invoice number and payment amount will ...

What is the meanig , use, difference between Cash Pooling, Positioing, Fore Casting, Cash Flow?

If both the payments go to same supplier , then create invoice for Rs10 and for payment Rs110 , attach/ apply these Rs100 and Rs10 invoices

Accounting is "Recording of Transactions". Transaction is an "Event of financial nature". When there is a happening related to financial implication , then those happenings are to be recorded. This is the definition of accounting.

The unfortunate part is..

In case of recording prepayment invoice ...

You can comfortably use DATA LOADER. No technical persons help is required. Data Loader download is freely available.

Other way ( if you do not have Cash Management, If CM is not there then also not advisable. Accounting wise this is OK).

Create Prepayment for Rs200

Prepay Dr
Liability Cr

Pay

Liability Dr
Cash Cr

Create standard invoice with cash account in Distribution

Cash Dr
Liability Cr

Apply prepayment ...

check are there any cross validation rules or disabled sigment values for any of the distribution lines ( check is that code comination is valied and alive) . Also check equality of Dr and Cr amount.

There is one standard report %chart%Listing% OR %segment%listing% (exact name I don't remember I dont have facility to view PDF now) gives COA for each sigment values along with heirarchies.

All the periods in the budget period range should be available in calander accounting. i.e. Budget can be defined only for the periods which are defined in calander attached to that SOB or Ledger.

The cheque payment will be only on the name of either creditor or bank.
The parties to whom you have to pay are different for Rs100 and Rs10. You can not club them with single cheque payment. Secondly , the bank statement received from bank shows two separate lines for Rs100 and Rs10. If you have ...

-- For advances from Customers Account, run queries seperatly for AR source items and nonAR source items.

-- AR source items query gives balances as of required date.--the query is


select B.REFERENCE_4 "TRX NO",
K.CUSTOMER_NAME,
SUM(NVL(B.ACCOUNTED_DR,0)-NVL(B.ACCOUNTED_CR,0) )"NET",
min(a ...

Hai,

In AP you can take Accounts payables trial balance report, that gives back dated aging report which has to match with GL figure as on the date. This gives for Liability Acount. Similarly for AP prepayments Prepayments register or you can have a query.

In AR Aging 7 buckets or aging 4 buckets ...

Many people are getting this doubt. The simple way of understanding...

Here there are two parties in Debit/Credit Memo. For convenience let us say one party is Maker and the Second Party is Recipient.


1. Maker- Party which prepares or makes or raises Debit / Credit memo
2.Reciepent - Party which ...

Dear Hisham,

Thanks . But my problem is , all other holds can be released by any user/responsibility , but the authority to release this specific hold should be available only to specific responsibility/user.

Is there any workflow like that for this problem?

Regards
RS

Hai,



Our requirement is AP invoice hold release should be allowed only by specific user or responsibility. Is it possible?

Invoice is to be created and a hold is to be kept at the time of entry. This hold is only to restrict payment against invoice. And this invoice should not stop accounting ...