Sage200 Expert to assist in definition of metrics for BI project
$250-750 USD
Cerrado
Publicado hace más de 8 años
$250-750 USD
Pagado a la entrega
Hi,
We require a Sage200 expert to let us know where in the database (not API), using SQL, we can define and/or obtain the following information.
All entries in P&L (Not underlying detail)
All entries in Balance Sheet (not underlying detail)
An example of detail behind P&L (marketing)
An example of detail behind Balance Sheet (Cash at bank)
Transaction detail behind a certain P&L code (In this case, default sales code so would include order ref, product Id, qty, cost price, sale price, customer, date etc)
Financial start date
Transaction detail behind purchases and receipts of stock
Stock information and the underlying detail behind it, i.e.
Product sku, name, description, cost price, quantity, available, allocated, warehouse etc.
So the idea is that we will pull all the information directly from a sql db. Please quote a fixed price to achieve the above.
Desired SkillsDatabase, Sage ERP Accpac, SQL