Skip to Content
Aug 17, 2017 at 09:36 AM

How to create a report to display the list of available billboards in crystal report ?

39 Views Last edit Sep 01, 2017 at 12:49 PM 2 rev

Hi experts,

Our project concerns the management of the billboards rental of a communication agency. We managed to achieve this management process in SAP B1 by using the customization tools. We've added two columns in the details table (Start Rental and end Rental) in the marketing documents (sales order, A/R invoice). That's to say, when I select a billboard, I have the possibility to indicate its rental period. So on the same invoice, I have the possibility to select several billboards with different rental periods.

Billboards are non-stock items, not purchase item just sale item. The system works wonderfully. We have created queries to display current, completed and future rentals. But the customer would also like the system to display the list of available billboards (that's to say not affected by a current or future rental).

I give you my idea :

We can create a query to check in INV1 table if a billboard is in current or future rental. If not, we say to the system to display the list of the billboards.

What do you think about this idea ? Is it correct ? Do you have another idea ?

So how can be the query ? Can you write me the query