Dear sir,
           As per discuss with you issue has been resolved.

We Observed that the some expenses not reflected in the said report. like account code 60303-0001

also insert the following column:

1. Description of Item
2. Item Code
3. Quantity
4. GST/ Others
5. Total Bill Value
6. Supplier / Customer Code

Report No. ACCF7080 is not working in P1 directory.
Pl. take it on priority basis.

Dear sir,
         Data of Voucher Type (45,44,4C,J2) also has been added.Please check and confirm.

Dear sir,
         Data of JV has been added and also issue of blank name of suppliers and customers has been fixed.Please check and confirm.

Dear sir,
         Details of GL Expenses in CSV (ACCF7080) is now in erp and rights also given to you please check and confirm.

Created attachment 3098 [details]
Csv file of gl expense report.

Created attachment 3090 [details]
Csv file of gl expense report.

Sir,  
    This data against account_code = '60138' and between '01/04/2022' AND '31/10/2022'.

Dear sir,
          I have attached an excel file of your required report.Please check and confirm.

Created attachment 3088 [details]
Excel file of gl expense report

SELECT SUPPLIER_CODE,SUM(ISSUED_VALUE) ISSUED_VALUE FROM ITEM_STOCK_DETAIL_FIFO_BATCH B
WHERE EXISTS (SELECT '1' FROM GL_POSTING_DETAILS G 	WHERE B.COMPANY 		= G.COMPANY
													AND   B.VOUCHER_TYPE 	= G.VOUCHER_TYPE
													AND	  B.VOUCHER_SERIES	= G.VOUCHER_SERIES
													AND   B.VOUCHER_NO		= G.VOUCHER_NUMBER
													AND   G.VOUCHER_DATE	BETWEEN '01/04/2022' AND '31/10/2022'
													AND   G.ACCOUNT_CODE	= '60138'
													AND   G.SUB_ACCOUNT_CODE= '0003')
GROUP BY SUPPLIER_CODE

ITEM_STOCK_DETAIL_FIFO_BATCH