Pages

Showing posts with label Production Issues-EBS. Show all posts
Showing posts with label Production Issues-EBS. Show all posts

Unable to Void a Payment. Void Button on Payments is Greyed Out.

 

Below are the reasons due to which Void Button is disabled on the Payment Workbench form.


1. Payment is Reconciled

When the status of the Payment is 'Reconciled' then the void button will be greyed out. To void a payment, first note the statement number from the show field from the payment then go to cash management and find the statement, and then unreconciled the payment. After this Void Button will be enabled.


2. Prepayment Application / Un-application


If the void button is disabled on a payment and that payment is of Prepayment Invoice then we need to make sure that prepayment is not partially or fully applied. Only after unapplying of prepayment from the invoice, you can void the payment. Until then the void button will be greyed out.


Recoverable Checkbox not Ticked at PO or Receipt Level ??


For Recoverable Checkbox to be enabled at PO and Receipt Level, we need to ensure all the below pre-requisites to be done from setup level point of view.


1. First Party Should be registered in 'First Party Registration' form for the Inventory Organization for which Ship To & Bill To is selected at Purchase Order Level.

2. Third Party of Supplier should be registered in 'Third Party Registration' form.

3. Classification of Item should be done.

4. 'Recoverable' Check Box should be enabled at Tax Type Form Level.

5. 'Recovery Rate' should be 100% at Tax Rate Level.

6. 'Claim Terms' Should be defined for the Tax Type and Inventory Organization with Location.

Transaction Date Cannot be Future Date (Stuck in Transaction Open Interface)

Step 1: Query the record which needs to be updated

SELECT 
TRANSACTION_DATE,  MTI.*  
FROM  MTL_TRANSACTIONS_INTERFACE MTI
WHERE 
TRANSACTION_HEADER_ID='';     ---(From Transaction Open Interface)

Request ID Stuck in AR Interface Lines

SYMPTOM:- When importing sales order from Order Management to Receivable, 'Auto-invoice Import Program' goes in error. Resulting in request id of 'Auto-invoice Import Program' got stored in receivable interface lines and unable to import order in receivables.


Analysis: The standard error due to which this issue occurs is that at time of 'Third Party Registration' of customer where registration number is entered incorrect, which leads in error-ed out of 'Autoinvoice Import Program'.


SOLUTION:-

Alternative 1 :-  

  1. Do RMA for that particular sales order which will bring back the quantity of the item into the inventory. And delete both record of sales order and RMA order from receivable interface lines 
  2. Correct the registration number at 'Third Party Registration Level'.
  3. Create the sales order again and import it in receivables. 

Alternative 2 :-

create table RA_INT_LIN_BKP
as
select *
from RA_INTERFACE_LINES_ALL
where INTERFACE_LINE_CONTEXT = 'ORDER ENTRY'
and INTERFACE_LINE_ATTRIBUTE1 = ''    ------(with Order Number)
and INTERFACE_STATUS is null;

-- 1 row should be backed up

create table RA_INT_SCR_BKP
as
select *
from RA_INTERFACE_SALESCREDITS_ALL
where INTERFACE_LINE_CONTEXT = 'ORDER ENTRY'
and INTERFACE_LINE_ATTRIBUTE1 = ''    ------(with Order Number)
and INTERFACE_STATUS is null;

-- 1 row should be backed up

update RA_INTERFACE_LINES_ALL
set REQUEST_ID = null
where INTERFACE_LINE_CONTEXT = 'ORDER ENTRY'
and INTERFACE_LINE_ATTRIBUTE1 = ''         ------(with Order Number)
and INTERFACE_STATUS is null;

-- 1 row should be updated

update RA_INTERFACE_SALESCREDITS_ALL
set REQUEST_ID = null
where INTERFACE_LINE_CONTEXT = 'ORDER ENTRY'
and INTERFACE_LINE_ATTRIBUTE1 = ''         ------(with Order Number)
and INTERFACE_STATUS is null;

-- 1 row should be updated

commit;