wordpress stats
Synergix E1 ERP System Updates | NEW EXCEL REPORTS FOR FINANCE MODULE
Year 2018
November 2018

Synergix E1 ERP System Updates | NEW EXCEL REPORTS FOR FINANCE MODULE

02 Nov 2018

Dear Synergix Customers,

We would like to inform all customers that for reports which have been released in Excel format, we will be ceasing support for the PDF format. The reason is that we are focusing our resources on supporting the Excel format, which is more usable in the long-run as your staff can use the Filter/ Sort / Calculation features in Excel easily.

The table below lists the new Excel reports that our Finance developer team has released. On the left are the form codes for the old PDF reports, and on the right are the form codes for the new Excel format. For the reports which you are using, kindly replace the form codes from the PDF version into the Excel version, and you will be able to continue using your reports.

ModuleOld FCOld Report Name (PDF)New FCNew Report Name (Excel)
MT2847Chart of Account Listing4603Chart of Accounts (Excel)
MT2893Service Listing4604Service Listing (Excel)
MT2584Sales Tax Listing4622Sales Tax Listing (Excel)
GL2094Trial Balance By Segment In Home Ccy5022Trial Balance By Segment In Home Ccy (Excel)
GL2075General Ledger Detail Home & Nature Ccy by Account, Period5222General Ledger Detail Home & Nature Ccy by Account, Period (Excel)
GL1469General Ledger Detail Nature & Home By Segment4611General Ledger Detail Home & Nature By Segment (Excel)
GLN.A. –  New Excel report5003Unposted Draft Voucher Listing (Excel)
GL2857Source Journal By Segment5020Source Journal By Segment (Excel)
AP2177Unrealised Exch Gain Loss4605AP Unrealised Exch Gain Loss (Excel)
AP2784Payment Register with Project4606Payment Register with Project (Excel)
AP2635Supplier Ledger with Remarks5023Supplier Ledger with Remarks (Excel)
AP9109Aged Payable by Due Date, Group by Supplier Class, Supplier (Detail & Summary With Nature and Home)5026Aged Payable by Due Date, Group by Supplier Class, Supplier (Detail and Summary With Nature and Home)(Excel)
AP2731Aged Payable by Due Date, Group by Supplier (Detail in Home Currency) (Aged by Month)5108Aged Payable by Due Date, Group by Supplier (Detail with Nature & Home Ccy) (Aged by Month)(Excel)
AP2798Additional Cost BalanceTH6R_AP_000001Additional Cost Balance Report (Excel)
AP2515Input Tax 5219Input Tax (Excel)
AP9307History AP Invoice Summary with Outstanding Amt5080History AP Invoice Summary with Outstanding Amt (Excel)
AP9302History AP Invoice Summary/Detail with Item & Outstanding Amt5103History AP Invoice Summary/Detail with Item & Outstanding Amt (Excel)
APN.A. –  New Excel report5301History AP Invoice & Credit Note Detail Listing (Excel)
AR2643Customer Ledger with Remarks5024Customer Ledger with Remarks (Excel)
AR9108Aged Receivable by Due Date, Group by Customer Class, Customer (Detail & Summary With Nature and Home)5027Aged Receivable by Due Date, Group by Customer Class, Customer (Detail and Summary with Nature and Home)(Excel)
AR2196Aged Receivable, Group by Salesperson, Customer (Summary)2698Aged Receivable, Group by Salesperson, Customer (Summary with Nature & Home) (Excel)
ARN.A. –  New Excel report5302History AR Invoice & Credit Note Detail Listing (Excel)
AR2203Output Tax4558Output Tax (Excel)
FA3050Fixed Asset Schedule Detail2230Fixed Asset Listing Detail (Excel)
FA2195Fixed Asset Schedule Summary2229Fixed Asset Listing Summary (Excel)
FA2589Fixed Asset Disposal by FA Class4608Fixed Asset Disposal by FA Class (Excel)
FA2588Fixed Asset Depreciation4607Fixed Asset Depreciation (Excel)
BB2532Bank Reconciliation Statement4613Bank Reconciliation Statement (Excel)
BB2533Bank Reconcilation History4614Bank Reconcilation History (Excel)
BB2875Bank Reconciliation Discrepancy4626Bank Reconcilation Discrepancy (Excel)
BB2534Bank Recon Statement Check List4615Bank Reconciliation Statement Check List (Excel)
BB7070Bank Book Sales Tax5220Bank Book Sales Tax (Excel)
BBN.A. –  New Excel report4624Cash Book by Bank Account Number (Excel)

If you prefer to view your reports in PDF, you are still able to do so by opening your Excel report and clicking: File > Save As > Save as type: “PDF”.

We apologise for any inconvenience caused during this period of change and should you require any help or clarifications, please contact our Helpdesk at help_taskhub@synergixtech.com.