Sales Report - Shipped, Open By Region then Country and so on
We are new to BusinessOne. We have just rolled it out and i have to develop a report in businessobjects using B1 data which resides on sql server 2012. What my requirement is that they need a MTD sales report by customer group, shipped and open.
My question is which tables i need to query to get this information from?
I need all sales that were shipped and are open by customer group for the current month to date.
If i am not clear, please ask for detail and i will try my best again. Thank you.