~tempo-openerp/+junk/loewert-report-name

I check that the debtor account has 2 new lines with -180 and -70 as amount_currency columns and that their credit columns are respectively 162 and 63

203

204

I check that my write-off is correct. 9 debit and 10 amount_currency

205

206

!python {model: account.voucher}: |

207

voucher = self.search(cr, uid, [('name', '=', 'First payment: Case 1 USD/USD'), ('partner_id', '=', ref('base.res_partner_19'))])

208

voucher_id = self.browse(cr, uid, voucher[0])

209

move_line_obj = self.pool.get('account.move.line')

210

move_lines = move_line_obj.search(cr, uid, [('move_id', '=', voucher_id.move_id.id)])

211

for move_line in move_line_obj.browse(cr, uid, move_lines):

212

if move_line.amount_currency == -180.00:

213

assert move_line.credit == 162.00, "Debtor account has wrong entry."

214

elif move_line.amount_currency == -70.00:

215

assert move_line.credit == 63.00, "Debtor account has wrong entry."

216

elif move_line.amount_currency == 10.00:

217

assert move_line.debit == 9.00, "Writeoff amount is wrong."

218

elif move_line.amount_currency == 240.00:

219

assert move_line.debit == 216.00, "Bank entry is wrong."

220

else:

221

assert False, "Unrecognized journal entry"

222

223

I check the residual amount of Invoice1, should be 20 in amount_currency

224

225

!python {model: account.invoice}: |

226

invoice_id = self.browse(cr, uid, ref("account_invoice_jan"))

227

move_line_obj = self.pool.get('account.move.line')

228

move_lines = move_line_obj.search(cr, uid, [('move_id', '=', invoice_id.move_id.id), ('invoice', '=', invoice_id.id), ('account_id', '=', invoice_id.account_id.id)])

229

move_line = move_line_obj.browse(cr, uid, move_lines[0])

230

assert (move_line.amount_residual_currency == 20.0) , "Residual amount is not correct for first Invoice"

231

232

I check the residual amuont of Invoice2, should be 30 in residual currency and 24 in amount_residual

233

234

!python {model: account.invoice}: |

235

invoice_id = self.browse(cr, uid, ref("account_invoice_feb"))

236

move_line_obj = self.pool.get('account.move.line')

237

move_lines = move_line_obj.search(cr, uid, [('move_id', '=', invoice_id.move_id.id), ('invoice', '=', invoice_id.id), ('account_id', '=', invoice_id.account_id.id)])

238

move_line = move_line_obj.browse(cr, uid, move_lines[0])

239

assert (move_line.amount_residual_currency == 30.0) , "Residual amount is not correct for first Invoice"

240

241

On the first April, I create the second voucher of payment with values 45 USD, journal USD,

242

243

!record {model: account.voucher, id: account_voucher_2_case1, view: view_vendor_receipt_form}:

244

account_id: account.cash

245

amount: 45.0

246

company_id: base.main_company

247

journal_id: bank_journal_USD

248

249

partner_id: base.res_partner_19

250

period_id: account.period_3

251

date: !eval time.strftime("%Y-04-01")

252

payment_option: 'with_writeoff'

253

writeoff_acc_id: account.a_expense

254

comment: 'Write Off'

255

256

I fill amounts 20 for the invoice of 200$ and 30 for the invoice of 100$

257

258

!python {model: account.voucher}: |

259

import netsvc, time

260

vals = {}

261

voucher_id = self.browse(cr, uid, ref('account_voucher_2_case1'))

262

data = []

263

for item in voucher_id.line_cr_ids:

264

if item.amount_unreconciled == 20.00:

265

data += [(item.id, 20.0)]

266

else:

267

data += [(item.id, 30.0)]

268

for line_id, amount in data:

269

self.pool.get('account.voucher.line').write(cr, uid, [line_id], {'amount': amount})

270

assert (voucher_id.state=='draft'), "Voucher is not in draft state"

271

272

I check that writeoff amount computed is -5.0

273

274

!python {model: account.voucher}: |

275

voucher = self.search(cr, uid, [('name', '=', 'Second payment: Case 1'), ('partner_id', '=', ref('base.res_partner_19'))])

276

voucher_id = self.browse(cr, uid, voucher[0])

277

assert (voucher_id.writeoff_amount == -5.0), "Writeoff amount is not -5.0"

278

279

I confirm the voucher

280

281

!python {model: account.voucher}: |

282

import netsvc

283

voucher = self.search(cr, uid, [('name', '=', 'Second payment: Case 1'), ('partner_id', '=', ref('base.res_partner_19'))])

284

wf_service = netsvc.LocalService("workflow")

285

wf_service.trg_validate(uid, 'account.voucher', voucher[0], 'proforma_voucher', cr)

286

287

I check that the move of my second voucher is valid

288

289

!python {model: account.voucher}: |

290

voucher = self.search(cr, uid, [('name', '=', 'Second payment: Case 1'), ('partner_id', '=', ref('base.res_partner_19'))])

291

voucher_id = self.browse(cr, uid, voucher[0])

292

move_line_obj = self.pool.get('account.move.line')

293

move_lines = move_line_obj.search(cr, uid, [('move_id', '=', voucher_id.move_id.id)])

294

for move_line in move_line_obj.browse(cr, uid, move_lines):

295

assert move_line.state == 'valid', "Voucher move is not valid"

296

297

I check that my debtor account is correct

298

299

I check that the debtor account has 2 new lines with -20 and -30 as amount_currency columns and their credit columns are respectively 19 and 28.5

300

301

I check that my currency rate difference is correct. 8.5 in credit with no amount_currency

302

303

I check that the total reconcilation created entries as expected

304

305

I check that my writeoff is correct. 4.75 debit and 5 amount_currency

306

307

!python {model: account.voucher}: |

308

voucher = self.search(cr, uid, [('name', '=', 'Second payment: Case 1'), ('partner_id', '=', ref('base.res_partner_19'))])

309

voucher_id = self.browse(cr, uid, voucher[0])

310

move_line_obj = self.pool.get('account.move.line')

311

move_lines = move_line_obj.search(cr, uid, [('move_id', '=', voucher_id.move_id.id)])

312

reconcile_a = reconcile_b = False

313

for move_line in move_line_obj.browse(cr, uid, move_lines):

314

if move_line.amount_currency == -20.00:

315

assert move_line.reconcile_id.id, "The invoice of 200$ is not fully reconciled"

316

reconcile_b = move_line.reconcile_id.id

317

elif move_line.amount_currency == -30.00:

318

assert move_line.reconcile_id.id, "The invoice of 100$ is not fully reconciled"

319

reconcile_a = move_line.reconcile_id.id

320

for move_line in move_line_obj.browse(cr, uid, move_lines):

321

if move_line.amount_currency == -20.00:

322

assert move_line.credit == 19.00, "Debtor account has wrong entry."

323

elif move_line.amount_currency == -30.00:

324

assert move_line.credit == 28.50, "Debtor account has wrong entry."

325

elif move_line.amount_currency == 5.00:

326

assert move_line.debit == 4.75, "Writeoff amount is wrong."

327

elif move_line.debit == 11.5 and move_line.account_id.reconcile:

328

assert move_line.amount_currency == 0.0 and move_line.reconcile_id.id == reconcile_a, "Exchange difference entry for the invoice of 100$ is wrong"

329

elif move_line.credit == 11.5:

330

assert move_line.amount_currency == 0.0

331

elif move_line.debit == 31.0 and move_line.account_id.reconcile:

332

assert move_line.amount_currency == 0.0 and move_line.reconcile_id.id == reconcile_b, "Exchange difference entry for the invoice of 200$ is wrong"

333

elif move_line.credit == 31.0:

334

assert move_line.amount_currency == 0.0

335

elif move_line.amount_currency == 45.00:

336

assert move_line.debit == 42.75, "Bank entry is wrong."

337

else:

338

assert False, "Unrecognized journal entry"

339

340

I check the residual amount of Invoice1, should be 0 in residual currency and 0 in amount_residual and paid

341

342

!python {model: account.invoice}: |

343

invoice_id = self.browse(cr, uid, ref("account_invoice_jan"))

344

move_line_obj = self.pool.get('account.move.line')

345

move_lines = move_line_obj.search(cr, uid, [('move_id', '=', invoice_id.move_id.id), ('invoice', '=', invoice_id.id), ('account_id', '=', invoice_id.account_id.id)])

346

move_line = move_line_obj.browse(cr, uid, move_lines[0])

347

assert (move_line.amount_residual_currency == 0.0 and move_line.amount_residual == 0.0 and invoice_id.state == 'paid') , "Residual amount is not correct for first Invoice"

348

349

I check the residual amuont of Invoice2, should be 0 in residual currency and 0 in amount_residual and paid

350

351

!python {model: account.invoice}: |

352

invoice_id = self.browse(cr, uid, ref("account_invoice_feb"))

353

move_line_obj = self.pool.get('account.move.line')

354

move_lines = move_line_obj.search(cr, uid, [('move_id', '=', invoice_id.move_id.id), ('invoice', '=', invoice_id.id), ('account_id', '=', invoice_id.account_id.id)])

355

move_line = move_line_obj.browse(cr, uid, move_lines[0])

356

assert (move_line.amount_residual_currency == 0.0 and move_line.amount_residual == 0.0 and invoice_id.state == 'paid') , "Residual amount is not correct for second Invoice"

Older »