Sales Report - Shipped, Open By Region then Country and so on

[former_member196901]

Hi All,

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.

[kothandaraman_nagarajan]

Hi,

Please use below tables and link as shown below

ORDR and  RDR1 for sales order

ODLN and DLN1 for delivery order

ORDR T0  INNER JOIN RDR1 T1 ON T0.DocEntry = T1.DocEntry left join DLN1 T2 on T2.[BaseEntry]  = T1.docentry and T2.[BaseLine]  =  T1.[LineNum] INNER JOIN ODLN T3 ON T2.DocEntry = T3.DocEntry

Thanks & Regards,

Nagarajan

[former_member196901]

Thank you Nagarajan,

Does that mean that ORDR and RDR1 tables has all open orders info?

And

ODLN and DLN1 has all shipped orders info?

Thanks.

[kothandaraman_nagarajan]

Hi,

Yes.

Thanks & Regards,

Nagarajan

[former_member196901]

Just found out we do not have a delivery note created for our deliveries. Deliveries are confirmed with invoices or something like that?

[kothandaraman_nagarajan]

Hi,

Please advice your exact process flow.

OR open any closed sales order and right click--choose relation ship and post screen shot this map here.

Thanks & Regards,

Nagarajan