- Oracle-Developer.com -

Navigation: Home  | Discussion Forums (Get expert advice)  |  Scripts  |  About Us  | Links  | Job Openings  
Unable to print Credit Memos with RAXINV_SEL
Comment on this Topic


Problem Description
-------------------
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.

Navigation:
AR responsibility
Print Documents > Invoices


Solution Description
--------------------
Navigation:
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'.

update ra_cust_trx_types_all
set default_printing_option = 'PRI'
where type = 'CM'
...
..
.
/

This script can be modified to enable more specific changes.


Explanation
-----------
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