Entity to hold data for occurrence information for certain kind of Invoices

[Anil Patel-3]

Hi,
It will be nice to be able to Store data about frequency on certain  
invoices (Sales or Purchase). If we know frequency on a Invoice then a  
Service can be scheduled that will watch for Invoice events and  
automatically create invoice from template. In cases when those  
invoice need manual intervention then such events should show up in  
upcoming invoice list in a screenlet on main screen of Ar/Ap app.

I need help to model such table. I can see some thing on lines of  
ProductMaint table.
templateInvoiceId   *   String, VARCHAR(20)  
invoiceTypeId String, VARCHAR(20)
intervalQuantity Double, DOUBLE
intervalUomId String, VARCHAR(20)
repeatCount


Regards
Anil Patel

[David E Jones]

Could the ShoppingList for recurring automatic orders be used for  
this? It would be an order that leads to an invoice instead of just an  
invoice, but there is already infrastructure in place including a  
service that periodically creates the orders automatically from the  
Shopping Lists.

If that doesn't work so well, we should at least use fields that  
follow the pattern there, which uses the RecurrenceInfo entity (which  
there is code to work with) and such.

-David


On Feb 22, 2008, at 9:32 PM, Anil Patel wrote:

> Hi,
> It will be nice to be able to Store data about frequency on certain  
> invoices (Sales or Purchase). If we know frequency on a Invoice then  
> a Service can be scheduled that will watch for Invoice events and  
> automatically create invoice from template. In cases when those  
> invoice need manual intervention then such events should show up in  
> upcoming invoice list in a screenlet on main screen of Ar/Ap app.
>
> I need help to model such table. I can see some thing on lines of  
> ProductMaint table.
> templateInvoiceId   *   String, VARCHAR(20)  
> invoiceTypeId String, VARCHAR(20)
> intervalQuantity Double, DOUBLE
> intervalUomId String, VARCHAR(20)
> repeatCount
>
>
> Regards
> Anil Patel