Autoinvoice Issue

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
myso
Posts: 45
Joined: Sat Oct 11, 2008 8:27 am
Location: Egypt
Contact:

Autoinvoice Issue

Post by myso »

Hi All
Autoinvoice does not assign invoice number in sequence with Order
number
myso
Posts: 45
Joined: Sat Oct 11, 2008 8:27 am
Location: Egypt
Contact:

Post by myso »

Hi Consultant
Where is replies?
it is a very important issue
if any one can help me plz
jairam.apps
Posts: 48
Joined: Mon Jul 07, 2008 7:52 am
Location: India
Contact:

Post by jairam.apps »

Hi,

There is a specific formate for ERS number generation:

The level of invoice consolidation determines how an invoice will be created for each run of Pay on Receipt AutoInvoice program.

I. For invoices created based on receipt transactions, user can set up invoice consolidation levels for an individual pay site in the Supplier Sites window.

The levels are:
?Pay Site? ?? one invoice is created per supplier pay site for all the transactions that have the same transaction date.

?Packing Slip? ?? one invoice is created per packing slip per supplier pay site for all the transactions that have the same transaction date.

?Receipt? ?? one invoice is created per receipt per supplier pay site. Invoice numbers are created based on the summary level.

The invoice number is of the following format:
?ERS??< X >?< Seq# >
where:
? ERS is the default prefix for Pay On Receipt invoices or any prefix you specify in the profile option

PO: ERS Invoice Number Prefix.

? Seq# is a unique system generated number.
? X depends on the summary level:
? if summary level = Pay Site then X = Invoice Date
? if summary level = Packing Slip then X = Packing Slip Number
? if summary level = Receipt then X = Receipt Number

II. If gapless self?billing invoice (SBI) numbering is enabled, the SBI buying company identifier and selling company identifier are included in the invoice number following the prefix.

There are two setup required for the Gapless Invoice Numbering feature.

1. Setup in the Purchasing options window for the Organization which is using Gapless invoice numbering feature.

Responsibility : Purchasing Super User
Navigation: Setup-Organization-Purchasing Options

a. Click on Control Tab
b. Enter a unique identifier for SBI Buying Company Identifier
c. Check the Gapless Invoice Numbering check box

2. Setup in the Supplier Site window

Responsibility : Payables Super User
Navigation: Suppliers-Entry

a. Enter Supplier Details
b. Enter the Supplier Site details
c. Click on the Purchasing Tab window
d. Enter a unique Identifier for Selling Company Identifier
e. Check the Gapless Invoice Numbering check box

How this Feature works
--------------------------
a. Enter a Purchase Order
b. Receive Against the Purchase Order
c. Run the Concurrent Program - Pay On Receipt Autoinvoice
d. Query the automatic invoice in Payables. Navigation: Invoices-Invoice

How is the invoice Number Generated
----------------------------------------
<Prefix>?<SBI Buying Company Identifier>?<Selling Company Identifier>?<Invoice Type Code>?<Seq #>

For example: ERS-VIS001-FRES001-ERS-1


Let me know if you still have any issues on the same.

soure: metalink - Note :472413.1


Regards,
Jayaram.
myso
Posts: 45
Joined: Sat Oct 11, 2008 8:27 am
Location: Egypt
Contact:

Post by myso »

Thank you so much for your reply but i mean Receivables autoinvoice
not Payable autoinvoice
tgs100
Posts: 624
Joined: Tue Jun 13, 2006 3:42 am
Location: USA
Contact:

Post by tgs100 »

Autoinvoice does not assign invoice number in sequence with Order
. Question is not clear to me.

Invoice number is created from the invoice source setup. If 'Copy document number to Invoice number' is not checked, then automatic transaction numbering will be used. Do you mean the invoice number is not continuous? or do you use the document number as invoice number?

Cheers,
Saravanan
myso
Posts: 45
Joined: Sat Oct 11, 2008 8:27 am
Location: Egypt
Contact:

Post by myso »

for example
trx no 1 must be with order no 23541
trx no 2 must be with order no 23542
trx no 3 must be with order no 23543
trx no 4 must be with order no 23544
after running auto invoice master program
that result
trx no 1 must be with order no 23541
trx no 2 must be with order no 23543
trx no 3 must be with order no 23544
trx no 4 must be with order no 23542
tgs100
Posts: 624
Joined: Tue Jun 13, 2006 3:42 am
Location: USA
Contact:

Post by tgs100 »

Auto invoice will pick up all the eligible lines and then group as per the grouping rule and creates the invoice. The order of picking the interface lines will not be the sales order number and hence the invoice number may not be in the same sequence as sale order.

Cheers,
Saravanan
myso
Posts: 45
Joined: Sat Oct 11, 2008 8:27 am
Location: Egypt
Contact:

Post by myso »

The order of picking the interface lines will not be the sales order number
what does the order of picking interface line depend on?
hint: i am using grouping rule that consider each line in the interface as one invoice
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest