Question Re: Outstanding Documents Summary in Technology Q&A

Outstanding Documents Summary

Former Member — Mon, 22 Aug 2016 04:31:06 GMT

I'm new in Crystal Report.

I would like to create a report which allows me to view all the outstanding invoices details from each customer.

Basically, I just want to view the outstanding details if the customer's payment code is GIRO.

Else, suppress the information.

Anyone can teach me how to create such report as mentioned above?

Thank you.

Re: Outstanding Documents Summary

Former Member — Mon, 22 Aug 2016 04:55:36 GMT

Hi Agnes,

Go to the report record Selection use below code.

{Table.Customer'payment code}="GIRO"

This wil bring in only required data in report.

Regards

Niraj

Re: Outstanding Documents Summary

Former Member — Mon, 22 Aug 2016 07:02:29 GMT

Hi Niraj Parihar

I would like to create an outstanding document summary from 2014 (300 Standard ERP) (Build 4) (Product Update 4).

I'm new in Crystal Report.

Refer to the attached file (Sage 300 ERP 2014 Application Object Models) but I don't understand which table should I select as data source.

Thank you.

Re: Outstanding Documents Summary

Former Member — Mon, 22 Aug 2016 07:10:21 GMT

Hi Agnes,

As Niraj said, filter records to get required information. Also you said customer wise outstanding, after filtering go in Insert Menu--Groups-- and select Customer code / name etc.. to group on each customer.

Also you can insert summary for each customer by right click on outstanding amount and go in insert-summary-- select Group1 as your summary display in the same menu.

This will give you customer wise outstanding.

Thanks,

Sastry

Re: Outstanding Documents Summary

Former Member — Mon, 22 Aug 2016 07:13:55 GMT

Hi Agnes,

May be you need to consult Data Analyst in your company. or you need to google and find out which table(s) you need to create such report.

Thanks,

Sastry

Re: Outstanding Documents Summary

Former Member — Mon, 22 Aug 2016 08:39:36 GMT

Thank you both.

I'm able to filter the customer group by using the select expert feature.