- Oracle-Developer.com -
Home | Discussion Forums (Get expert advice) |
About Us | Links | Job Openings
Unable to print Credit Memos with RAXINV_SEL|
Comment on this Topic
You are running the Invoice Print Selected Invoices (RAXINV_SEL) report. The parameter 'Open Invoices Only' is set to 'No'. The report produces no information for a Credit Memo or range of Credit Memos except the headings and the Currency.
Print Documents > Invoices
Setup > Transactions > Transaction Types
Query up all Transaction Types with class Credit Memo.
Check if the Printing Option field is set to 'Not Print' or 'Print'
for those transaction types to which the Credit Memos you are trying
to print belongs.
If set to 'Not Print', the Credit Memo for the Transaction Type will not
be printable but the field can be changed to 'Print' from 'Not Print'.
This will enable new Credit Memo's created after the change to be printable.
What follows is a datafix to print already existing Credit Memos in the system. Execute the following sql to change all existing Credit Memo's from 'Not Print' to 'Print'.
set default_printing_option = 'PRI'
where type = 'CM'
This script can be modified to enable more specific changes.
When a Credit Memo/Invoice/.. is created in AR, the documents are tied to a Transaction Type and inherits the values setup for the Transaction Type including the Printing Option flag. If the Printing Option field is set to 'Not Print', the document will not be printable from any report.
Comment on Unable to print Credit Memos with RAXINV_SEL
Owned and Operated by Varun Jain, Inc, www.varunjaininc.com
Copyright ©2007 Oracle-Developer.com