Pls. I want a report to show all transaction including Credit Memo. I want to use the Sales Inv. header / Purchase Inv. Header to generate the report but Credit memo made are not reflected. How do I do it Pls. Charles
You would have to include the tables where the data is stored - Sales Cr.Memo Header Sales Cr.Memo Line Purch. Cr.Memo Hdr. Purch Cr.Memo Line Your report would then be ordered perhaps by Customer/Vendor then all invoices then all credits. If you needed to sort them by date order - then you may have to drop them into a temport table and report upon the tempory table.
Depending of the data you want to print you could try to use “Customer Ledger Entry” and “Vendor Ledger Entry” table as there you have (at least the total) values regarding credits and invoices in one table.
Thank you all…I will try all suggestion