ledger/test/baseline/opt-pivot.test
2014-05-11 10:00:53 +02:00

148 lines
4.7 KiB
Text

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