Report of table joins

General
1

can you help me create the report using joins in accu360 because i not understand which column we join in order to get report

2

Can please write it properly what you want to do ? I mean what report you need

3

i want to create query report by using joins

4

i want to create query report by using joins but i don’t know which column between two table make association for example table of sales order and sales invoice if want to join what column will be used.

5

Hi Isaya. If you want to join Sales Order and Sales Invoice You can use the name which will be the same for both the tables and also check for the reference in the respective doc of Sales Invoice You will find it easily there. Try it

6

okey thank you now i understand mr madhu

1 Like
7

and what can be the reference doctype of this report

8

Every Sales Invoice Created by Sales Order so you reference for Sales Invoice will be Sales Order You can find it by it name

1 Like
9

now i already create the the report thanks mr madhu

1 Like
10

Great that’s working. Feel free to ask anything.