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
Transaction should not be complete via Autoinvoice
-
sirf_kashif
- Posts: 2
- Joined: Mon Jun 02, 2008 3:39 am
- Location: Pakistan
-
sirf_kashif
- Posts: 2
- Joined: Mon Jun 02, 2008 3:39 am
- Location: Pakistan
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
"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
Who is online
Users browsing this forum: No registered users and 2 guests