Transaction should not be complete via Autoinvoice

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
sirf_kashif
Posts: 2
Joined: Mon Jun 02, 2008 3:39 am
Location: Pakistan

Transaction should not be complete via Autoinvoice

Post by sirf_kashif »

Dear All,
i have written a feeder programe to load data from existing system to AR module via autoinvoice, but the problem is that all transaction through the feeder programe has the status of complete which i don't want.

any help will be appreciated

Regards,
Kashif Ali
admin
Posts: 2117
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

Pl provide the sample data with fields. thanks
sirf_kashif
Posts: 2
Joined: Mon Jun 02, 2008 3:39 am
Location: Pakistan

Post by sirf_kashif »

These are the fields of the ra_interface_lines_all table and values i have used against those fields, works fine except the mentioned problem.

"FIELDS" "VALUE"
interface_line_context, 'AUTOINVOICE-08',
interface_line_attribute1, 'Invoic Reference Name'
interface_line_attribute2, '12102'
interface_line_attribute3, 'Customer Short Name'
interface_line_attribute4, 1 --line number of this item
batch_source_name, 'AUTOINVOICE-08',
set_of_books_id, 1
line_type, 'LINE'
description, 'PRODUCT DESCRIPTION'
currency_code, 'PKR'
amount, 6000
cust_trx_type_name, 'INVOICE'
cust_trx_type_id, '1022'
term_id, '5' --payment terms id
orig_system_bill_customer_id, '1111' --customer id
orig_system_bill_address_id, '2222' --customer address id
conversion_type, 'CORPORATE'
conversion_date, '22-jan-2008'
trx_date, '22-jan-2008'
gl_date, '22-jan-2008'
line_number, '1'
quantity, 2000
unit_selling_price, 3
tax_code, 'ST Tax'
tax_precedence, '1'
uom_code, 'LIT'
uom_name 'LITRES'

Regards,
Kashif Ali
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest