Skip to Content
0
Aug 27, 2020 at 09:28 AM

Need a SQL Qurry for Incomming Payment for both "Pay On Invoice" & " Pay on Account"

65 Views

Dear Experts

I need a query in SQL for Incoming Payment,

am using SAP 9.3

i need the data for tax department Submission

Payment based on Invoice like,,,

Invoice Number, Customer Name, Customer Code, Pay Doc Date, Invoice Date, Amount, Mean of Payment, Tax Amount

Payment based on Account like,,,

Once the Payment is Received ON PAYMENT ACCOUNT , and if its Re-Reconciled then all the same data req as the above one , additionally i need to mark these payment as OAP (On Account Based Payment)

Thanks

Regards

Vinod