summaryrefslogtreecommitdiff
path: root/test/baseline/opt-pivot.test
blob: 595d8066aa13d725d4dcd4dcf7d90a4a923bd16f (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148

2014-01-01 * Opening balance
    Assets:Cash                               25.00 GBP
    Equity:Opening balance                   -25.00 GBP

2014-05-01 * Sell to customer AAA
    ; Customer: AAA
    ; Invoice: 101
    Assets:Receivables                        10.00 GBP
    Income:Sale                              -10.00 GBP

2014-05-02 * Sell to customer BBB
    ; Customer: BBB
    ; Invoice: 102
    Assets:Receivables                        11.00 GBP
    Income:Sale                              -11.00 GBP

2014-05-03 * Sell to customer AAA
    ; Customer: AAA
    ; Invoice: 103
    Assets:Receivables                        12.00 GBP
    Income:Sale                              -12.00 GBP

2014-05-04 * Sell to customer CCC
    ; Customer: CCC
    ; Invoice: 104
    Assets:Receivables                        15.00 GBP
    Income:Sale                              -15.00 GBP

2014-05-05 * Money received from customer AAA for invoice 101
    ; Customer: AAA
    ; Invoice: 101
    Assets:Cash                               10.00 GBP
    Assets:Receivables                       -10.00 GBP

2014-05-05 * Sell to customer DDD
    ; Customer: DDD
    ; Invoice: 105
    Assets:Receivables                        20.00 GBP
    Income:Sale                              -20.00 GBP

2014-05-07 * Money received from customer CCC for invoice 104
    ; Customer: CCC
    ; Invoice: 104
    Assets:Cash                               15.00 GBP
    Assets:Receivables                       -15.00 GBP

2014-05-08 * Partial payment received from customer DDD for invoice 105
    ; Customer: DDD
    ; Invoice: 105
    Assets:Cash                               15.00 GBP
    Assets:Receivables                       -15.00 GBP

test bal assets:receivables --pivot Invoice
           28.00 GBP  Invoice
           11.00 GBP    102:Assets:Receivables
           12.00 GBP    103:Assets:Receivables
            5.00 GBP    105:Assets:Receivables
--------------------
           28.00 GBP
end test

test bal assets:receivables --pivot Invoice --flat
           11.00 GBP  Invoice:102:Assets:Receivables
           12.00 GBP  Invoice:103:Assets:Receivables
            5.00 GBP  Invoice:105:Assets:Receivables
--------------------
           28.00 GBP
end test

test bal assets:receivables --pivot Invoice --empty
           28.00 GBP  Invoice
                   0    101:Assets:Receivables
           11.00 GBP    102:Assets:Receivables
           12.00 GBP    103:Assets:Receivables
                   0    104:Assets:Receivables
            5.00 GBP    105:Assets:Receivables
--------------------
           28.00 GBP
end test

test bal assets:receivables --pivot Invoice --empty -p "until 2014-05-05"
           48.00 GBP  Invoice
           10.00 GBP    101:Assets:Receivables
           11.00 GBP    102:Assets:Receivables
           12.00 GBP    103:Assets:Receivables
           15.00 GBP    104:Assets:Receivables
--------------------
           48.00 GBP
end test

test bal assets:receivables --pivot Invoice --empty -p "until 2014-05-06"
           58.00 GBP  Invoice
                   0    101:Assets:Receivables
           11.00 GBP    102:Assets:Receivables
           12.00 GBP    103:Assets:Receivables
           15.00 GBP    104:Assets:Receivables
           20.00 GBP    105:Assets:Receivables
--------------------
           58.00 GBP
end test

test bal assets:receivables --pivot Customer
           28.00 GBP  Customer
           12.00 GBP    AAA:Assets:Receivables
           11.00 GBP    BBB:Assets:Receivables
            5.00 GBP    DDD:Assets:Receivables
--------------------
           28.00 GBP
end test

test bal assets:receivables --pivot Customer --flat
           12.00 GBP  Customer:AAA:Assets:Receivables
           11.00 GBP  Customer:BBB:Assets:Receivables
            5.00 GBP  Customer:DDD:Assets:Receivables
--------------------
           28.00 GBP
end test

test bal assets:receivables --pivot Customer --empty
           28.00 GBP  Customer
           12.00 GBP    AAA:Assets:Receivables
           11.00 GBP    BBB:Assets:Receivables
                   0    CCC:Assets:Receivables
            5.00 GBP    DDD:Assets:Receivables
--------------------
           28.00 GBP
end test

test bal assets:receivables --pivot Customer --empty -p "until 2014-05-05"
           48.00 GBP  Customer
           22.00 GBP    AAA:Assets:Receivables
           11.00 GBP    BBB:Assets:Receivables
           15.00 GBP    CCC:Assets:Receivables
--------------------
           48.00 GBP
end test

test bal assets:receivables --pivot Customer --empty -p "until 2014-05-06"
           58.00 GBP  Customer
           12.00 GBP    AAA:Assets:Receivables
           11.00 GBP    BBB:Assets:Receivables
           15.00 GBP    CCC:Assets:Receivables
           20.00 GBP    DDD:Assets:Receivables
--------------------
           58.00 GBP
end test