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
|