0032472: Purchase Invoices with Total Gross Amount of 0 created from Procurement Contract Billing Process - Openbravo Issue Tracking System

Openbravo Issue Tracking System - Modules

View Issue Details

ID

Project

Category

View Status

Date Submitted

Last Update

0032472

Modules

Procurement Contracts

public

2016-03-14 19:02

2016-04-01 15:03

Reporter

ngarcia

Assigned To

markmm82

Priority

immediate

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS

5

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Regression date

Regression introduced by commit

Regression level

Review Assigned To

dmiguelez

Support ticket

OBNetwork customer

Regression introduced in release

Summary

0032472: Purchase Invoices with Total Gross Amount of 0 created from Procurement Contract Billing Process

Description

Purchase Invoices with Total Gross Amount of 0 created from Procurement Contract Billing Process

Steps To Reproduce

As group admin role:
   Apply module's dataset
   Create a new Contract Type:
      Service Contract: Y
      Sales Contract: N
   Create a Contract Invoice Schedule
   Create a Procurement Contract
   Fill all the fields in the header (Duration: 12 month, for instance)
   Add a line to it and fill all the fields
   Process it by selecting the option of Generate Invoice Plan
   Launch the Procurement Contract Billing Process for the Contract organization. Select a date range in order to create at least one invoice proposal
   Launch the Create Invoices process and check the created Purchase Invoice has a Total Gross Amount of 0

Proposed Solution

Additional Information

Tags

No tags attached.

Relationships

related to	defect	0032428		closed	markmm82	Openbravo ERP	Wrong Tax Amount and Total Gross Amount in orders created by the Copy Record process if price list includes taxes
related to	defect	0032514		closed	markmm82	Modules	No Tax line created after running "Create Invoice" process in the Procurement Contract Invoice Proposal" window
related to	defect	0032555		new	Triage Omni OMS	Modules	Error shown when trying to complete a Procurement Contract - Mandatory fields can not be left empty, regardless it is not empty.
caused by	feature request	0028366		closed	adrianromero	Openbravo ERP	Add new functionality to calculate taxes per product BOM
related to	defect	0032844		closed	markmm82	Modules	Wrong total net and gross amounts when generating an invoice with the Mass Invoicing process

Attached Files

Issue History

Date Modified

Username

Field

Change

2016-03-14 19:02

New Issue

2016-03-14 19:02

Assigned To

=> Triage Finance

2016-03-14 19:02

Resolution time

=> 1460844000

2016-03-14 19:02

Priority

urgent => immediate

2016-03-14 19:02

Relationship added

caused by 0028366

2016-03-14 19:02

Issue Monitored: networkb

2016-03-15 17:27

Relationship added

related to 0032428

2016-03-16 15:36

Note Added: 0085009

2016-03-17 15:31

Assigned To

Triage Finance => markmm82

2016-03-17 15:31

Status

new => scheduled

2016-03-18 18:53

Note Added: 0085227

2016-03-21 12:07

Note Edited: 0085227

bug_revision_view_page.php?bugnote_id=0085227#r11504

2016-03-21 12:08

Note Edited: 0085227

bug_revision_view_page.php?bugnote_id=0085227#r11505

2016-03-21 12:09

Note Edited: 0085227

bug_revision_view_page.php?bugnote_id=0085227#r11506

2016-03-21 12:11

Note Edited: 0085227

bug_revision_view_page.php?bugnote_id=0085227#r11507

2016-03-21 12:12

Note Added: 0085239

2016-03-21 12:31

Note Edited: 0085239

bug_revision_view_page.php?bugnote_id=0085239#r11509

2016-03-21 12:45

Note Edited: 0085239

bug_revision_view_page.php?bugnote_id=0085239#r11510

2016-03-21 13:13

Note Edited: 0085239

bug_revision_view_page.php?bugnote_id=0085239#r11511

2016-03-21 13:27

Note Edited: 0085239

bug_revision_view_page.php?bugnote_id=0085239#r11512

2016-03-21 13:33

Note Edited: 0085239

bug_revision_view_page.php?bugnote_id=0085239#r11513

2016-03-21 13:42

Note Edited: 0085239

bug_revision_view_page.php?bugnote_id=0085239#r11514

2016-03-21 13:47

Note Edited: 0085239

bug_revision_view_page.php?bugnote_id=0085239#r11515

2016-03-21 13:47

Relationship added

related to 0032514

2016-03-21 13:48

Note Edited: 0085239

bug_revision_view_page.php?bugnote_id=0085239#r11516

2016-03-21 13:48

Note Added: 0085248

2016-03-30 10:07

Relationship added

related to 0032555

2016-04-01 14:39

Checkin

2016-04-01 14:39

Note Added: 0085391

2016-04-01 14:39

Status

scheduled => resolved

2016-04-01 14:39

Resolution

open => fixed

2016-04-01 14:39

Fixed in SCM revision

=> http://code.openbravo.com/erp/pmods/org.openbravo.procurement.contract/rev/1fbaf864028f7967704a068f9b6d22055a71603f [^]

2016-04-01 14:40

Review Assigned To

=> dmiguelez

2016-04-01 14:40

Note Added: 0085393

2016-04-01 14:40

Status

resolved => closed

2016-04-01 15:03

Note Added: 0085397

2016-05-04 10:04

Relationship added

related to 0032844

Notes

As group admin role:
Apply module's dataset
Create a new Contract Type:
Service Contract: Y
Sales Contract: N
Create a Contract Invoice Schedule with this Contract Type with an Invoice Frequency = Annual

Test Plan 1

Go to Business Partner window and check that "La Fruta es la Vida" supplier has a purchase price list "Tarifa La Fruta es la Vida" do not set as "Price Including Taxes".
Check that "Zumo de Naranja Bio 0.33L" product is in that list with a purchase unit price = 0.89

Create a Procurement Contract by selecting contract type created.

Fill in all the fields in the header, as described below:
BP = La Fruta es la Vida
Starting date = 21-03-2016
Duration 3
Duration Unit = Year
Price List = Tarifa la Fruta es la vida

Go to Lines:

Add a line to it by selecting the contract invoice schedule created, Product = Zumo de Naranja 0.33L
Price = 0.89
Quantity = 100
Press Complete.

Process it by selecting the option of Generate Invoice Plan.

Launch the Procurement Contract Billing Process for the organization F&B España

Select a date range in order to create at least one invoice proposal (for instance from 01-01-2016 to 31-12-2016.
Select BP = La Fruta es la Vida.
Press Done.

Check that a new window is opened. Window "Procurement Contract Invoice Proposal".

Select one proposal and run "Create Invoices" process.

Check that a new purchase invoice has been created. For instance 10000887.

Go to that invoice and verify below data:

Invoiced quantity = 100
Unit Price = 0.89
Line Net Amount = 89
Tax 21%
Total Net Amount = 89.00
Total Gross Amount 107.69 (89+21%s/89)
Above is correct.

Go to tax tab and verify it is empty, therefore invoice posting shown below is not correct:
DEBIT 89.00 (60000) Compra de mercaderías
DEBIT 18.69 (90400) Cuenta de cuadre
CREDIT 107.69 (40000) Proveedores.
See issue related: 32514

Test Plan 2

Repeat same steps as test plan 1 but setting "Tarifa La Fruta es la Vida" as Price Including taxes =Yes.

Check that a new purchase invoice has been created. For instance 10000888.

Go to that invoice and verify below data:

Invoiced quantity = 100
Unit Price = 0.7355 (0.89/1.21)
Line Net Amount = 73.55
Tax 21%
Total Net Amount = 73.55
Total Gross Amount 89.00
Above is correct.

Go to tax tab and verify it is empty, therefore invoice posting shown below is not correct:
DEBIT 73.55(60000) Compra de mercaderías
DEBIT 15.45(90400) Cuenta de cuadre
CREDIT 89.00 (40000) Proveedores.
See issue related: 32514