Hi All,

Is there anyway to add the ship to codes of a customer to the aged receivables report in AR without creating a custom report? We are using AR 8.1A

Thanks!

Cam

Hi Cam,

The Ship-to code is not saved on AR transactions, so it is not possible to get this on any of the standard reports in AR, such as the Aged Trial Balance or Overdue Receivables reports, even with modifications.

To get this, you would have to create a custom Crystal report based on AR transactions that links to the source invoice application data (OE or Invoices) to load the ship-to code from there. You will find that this will be a very slow report as it links one transaction file to another.

If you use Adagio Receivables 9.0A, you could use a Batch Optional Field to store the ship-to code on the invoice. This would make the custom report a lot simpler as you would not have to link to a different transaction file. This optional field would not be automatically populated by OE/Invoices but must be manually entered.