I will build custom report AR aging with addtional descripstion and project in crystal report. what table will be used ?

SOLVED

[sage300erp 2018]

I will build custom report AR aging with addtional  descripstion and project in crystal report. what table will be used ? 

Parents
  • +1
    verified answer

    I think it is ARAGED.  This table is populated only when the AR Trial Balance is run.  You will need to do one of the following.

    1.  Modify a copy of the standard AR trial balance report and put it in a customisation folder

    2.  Create a stand alone report that uses ARAGED.  Then run AR trial balance before running the stand alone report.

    3.  Work out how the to join up the transaction tables AROBL and AROBP and create your own ageing report.  This can be a complicated option if you want to use the cut off date. Otherwise not too bad.

Reply
  • +1
    verified answer

    I think it is ARAGED.  This table is populated only when the AR Trial Balance is run.  You will need to do one of the following.

    1.  Modify a copy of the standard AR trial balance report and put it in a customisation folder

    2.  Create a stand alone report that uses ARAGED.  Then run AR trial balance before running the stand alone report.

    3.  Work out how the to join up the transaction tables AROBL and AROBP and create your own ageing report.  This can be a complicated option if you want to use the cut off date. Otherwise not too bad.

Children