For example, A job created on 28-May-2021 Job number as BOMEXP210738 and job date is 29-APR-2021, for the same Job created an invoice as BOMINV210500175, Voucher date is 01-MAY-21 and GL date is 02-MAY-21, created an Purchase invoice in the same job and voucher number as BOMPI210600967, Voucher Date as 01-JUN-21 and GL date is 01-JUN-21.
This case, while you run the job reports from 23-May-21 to 29-May-21 for a week, the system will job details for FI215001 along with that Invoice and Purchase Invoice details, But if you run the Accounts ledger reports for same date range from 23-May-21 to 29-May-21, the system will display only that Purchase invoice because of the Purchase Invoice GL date on 28-May-21, So Accounts ledger related report, Like Job ledger always picks the details based on Ledger date.
1. All voucher report
2. A/R OS reports
3. A/P OS reports
4. Combined Aging Summary report.
5. General ledger statement.
The general ledger statement will display the All the Trail balance transaction will display based on GL date, not based on Job date/Shipment date/Voucher date.
• Job based report will not match with General ledger statement.• Trail balance, Balance sheet, profit and Loss reports will match with General ledger statement if both report date range is same ledger wise it will match
Job Reports
1. All shipment reports
All shipment reports always display based on selected date, type like as below screen shot. It will not match with any accounts receivable or Payable or Ledger transaction reports, because all shipment reports based on Shipment date/Job date/ATD/ETD/ETA/ATA/shipment created date and accounts report based on GL date and Voucher date.
This report will not match with a Balance sheet or Trail balance