how to Create Purchase order and how to retreive the main details from Purchase Order

Hi All,

Hope you all doing great, 

Create new Purchase Order,
Added Vendor, Site and Warehouse to it,
Added item to Purchase Order line,
To that item we need to give Quantity, Quantity price,
After that we need to confirm it,
Later we need rise the product receipt and give the product name to it,
After that Generate Invoice for the Purchase Order, give the name to Invoice that we generated,
Later match product receipt, update match status and finally Post the Purchase Invoice.
Purchase Invoice Created.

SQL script:
Scenario: Get the PurchID, InvoiceAccount, Invoiceid , LedgerVoucherID, CurrencyCode, Itemid for the Purchase order which is created.

 

Below is the script I have created with joining the 4 tables.

SELECT  PT.PURCHID, PT.INVOICEACCOUNT, VIJ.INVOICEID, VIJ.LEDGERVOUCHER, VIJ.CURRENCYCODE, VIT.ITEMID FROM VENDTABLE VT
JOIN PURCHTABLE PT ON PT.INVOICEACCOUNT = VT.ACCOUNTNUM
JOIN VENDINVOICEJOUR VIJ ON VIJ.PURCHID = PT.PURCHID
JOIN VENDINVOICETRANS VIT ON VIT.PURCHID = VIJ.PURCHID
WHERE PT.PURCHID = '00000125' AND VIJ.INVOICEID = 'IN-00001' 
 SELECT LEDGER, JOURNALNUMBER, VOUCHER FROM SUBLEDGERJOURNALENTRYNOTTRANSFERRED
 WHERE LEDGER = '22565420920'