How to manage billboards in sap business one ?

[former_member441176]

I have a project that concerns a billboard rental company. The customer wants to see in the system which billboards are already rented and their periodicity and what others are available for rental ? I had the idea to go through the sales blank agreement to follow the billboard during its rental period. What do you think ?

In this case, should I create my billboards as items in the system? If so, will they be inventory items or non-inventory items?

[michaelhaak]

Hi Jeni,

maybe you could use 3 UDFs (date) in a sales order line: start, planned end, real end.

Then you could connect the item number and the UDFs with Excel-Gantt chart or another Gantt chart.

For this case, every billboard has to be a separate item number.

For Example:

------------------------

Sales Order 1000

BB4711 > Start = 01-01-2017 > planned End = 02-02-2017 > real end = 02-02-2017

BB4712 > Start = 01-01-2017 > planned End = 02-02-2017 > real end = NULL

------------------------

Sales Order 1001

BB4711 > Start = 01-01-2018 > planned End = 02-02-2018 > real end = NULL

------------------------

Sales Order 1002

BB4711 > Start = 02-02-2017 > planned End = 04-04-2017 > real end = 03-03-2017

BB4713 > Start = 01-01-2017 > planned End = 02-02-2017 > real end = NULL

----------------

You could list the items ordered by item number. Now you can see for every item if it is used or free, you can see if you have an overlap or an overdue.

Regards

Michael

[former_member441176]

Thanks Mr. Michael Haak,

I think I'll exploit your solution track this week-end. And I'll come back to you next week.

[Johan_H]

Hi Jeni,

You can also look into using Service Contracts, or Down Payment Invoices. At any rate, I recommend that you set up a test database, and simply try your solution. That is the best way to make sure there won't be any surprises, and it will allow you to find possible extra benefits.

If you setup each billboard (location) as its own item, it would suffice to make it a sales item only. Alternatively you can setup an item for each type of billboard, in which case it can be an inventory and purchase item as well. That would allow you to know how many billboards of each type are out there, and it would allow you to also replace billboards, and purchase new ones. Additionally you could setup a warehouse for each city, or region, etc., so you can track how many billboards of what type are where.

Alternatively you can look into a ready made addon for rental businesses.

Regards,

Johan