Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Is it possible to sort on the invoice amount column on the Invoice Review form (PAXINRVW) in Release 11.5?

April 26, 2017column form invoice paxinrvw possible release review sort

0

Posted

Is it possible to sort on the invoice amount column on the Invoice Review form (PAXINRVW) in Release 11.5?

1 Answer

0

Posted

A design change was made in Oracle Projects Release 11.5 to have brackets around the negative amounts in the invoice amount column. In order to accommodate the brackets, it was necessary to make the invoice amount column an alphanumeric column. It is not possible to sort numerically on alphanumeric columns; hence, the invoice amount is not available for sorting. Q7. Why do I receive ORACLE error during DRAFT INVOICE GENERATION, cursor=29 code=-20001:, ORA-20001: Your system parameters are not defined for Oracle errors when running PRC: Generate Draft Invoices (PAIGEN)? A: This error is received when Order Entry (OE) system parameters have not been setup for the current operating unit. The Receivables tax calculation requires an Inventory Master Organization for the following purposes: a. Defaulting the tax code from a Product (Inventory Item) b. Applying tax based on the characteristic/classification of an inventory organization location. c. Applying exemptions/exceptions (discounted t