Skip to Content
0

How to create a query to display the list of available billboards in SAP Business One ?

Aug 16, 2017 at 09:34 AM

22

avatar image
Former Member

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

Urgent!!!!

rental.png (35.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers