Issue:
While
Creating Payment and Enter Payment Date for Past Open Period getting below
error message
Error:
APP-SQLAP-10026: The Payment Date must be
on or after the System Date.
Resolution:
Navigation:
Payable Responsibility > Setup > Payable Option > Payment Tab >
Check All Pre-Date
Issue: PO Created, Received, Delivered, Partial
Invoiced - PO Status is Closed For Receiving but not Closed. How to Close the PO.
Invoice Amount is not matching with PO amount. That’s why PO not closed.
Step2: Click on receipt and Select Correct Button.
Step3: Put the same Invoice Amount in Correct Quantity Field
& Click on Submit
Step4: Open the PO > Click on Action > Click on Edit
Step5: Add the Header Description for Change Order and Edit the
line amount with same Invoice Amount.
Step6: Click on Submit.
Step7: If change Order required Approval Than User need to
complete the Approval Process After That PO Get closed Automatically.
--SQL to Check PO Detail--
SELECT *
FROM FUSION.PO_HEADERS_ALL
WHERE SEGMENT1 = '900001114637' --ENTER PO NUMBER
--SQL to Check PO Version Details--
SELECT CO_NUM,
VERSION_ID
FROM FUSION.PO_VERSIONS
WHERE PO_HEADER_ID IN
(SELECT PO_HEADER_ID FROM FUSION.PO_HEADERS_ALL WHERE SEGMENT1 = '900001114637' --ENTER PO NUMBER
)
ORDER BY CREATION_DATE DESC
--SQL to Check PO Approval Error--
SELECT TEXT_LINE
FROM FUSION.PO_ONLINE_REPORT_TEXT
WHERE VERSION_ID = 300000225949043 --ENTER THE 1ST VERSION ID RECEIVED FROM ABOVE QUERY
ORDER BY CREATION_DATE DESC