| Summary: | Details of GL Expenses | ||
|---|---|---|---|
| Product: | [01.IMIS] IMIS FORMS AND REPORTS | Reporter: | Sanjay Gupta <sanjay.gupta> |
| Component: | IMIS FORMS AND REPORTS | Assignee: | rahul singh <rahulsingh_it> |
| Status: | RESOLVED FIXED | ||
| Severity: | critical | CC: | mahender.singh, sharad.sharma |
| Priority: | Normal | ||
| Version: | unspecified | ||
| Hardware: | PC | ||
| OS: | Windows | ||
| Database: | Module ID: | ||
| Attachments: |
Draft
Excel file of gl expense report Csv file of gl expense report. Csv file of gl expense report. |
||
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 Created attachment 3046 [details]
Draft
As discussed with you regarding provide the details in attached format for your reference.
Provide LOV for registered / unregistered / All Suppliers
Provide LOV for Main / Sub-Code of ALL GL
Provide reports in CSV & PDF
|
Dear sir, As per discuss with you issue has been resolved.