Task Explanation

We Have Product, ProductAssoc and ProductPrice Tables

Using these tables i need the get a productId from Product table and 
ProductIdTo 
from ProductAssoc table Based on the ProductId

and From the Product Price Table we need to grab Price Column value and insert 
into Invoice item

we need to create a invoiceitem 
and the modification files to be done are 

Application\Accounting\script\org\ofbiz\accounting\invoice\InvoiceServices.xml
Application\Accounting\servicedef\Services_invoice.xml

       AddPackage(ProductId)-----CheckAssociations(based on ProductId in 
ProductAssociation table)------get Price(from ProductPrice)if yes----insert 
into 
invoiceitem---if no goto end------end





Reply via email to