0036846: Cannot complete an inter-company invoice if the target organization or one of their parents are not Legal With Accounting

Openbravo Issue Tracking System - Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0036846

Modules

Intercompany Documents

public

2017-09-13 12:52

2017-09-14 12:58

Reporter

ngarcia

Assigned To

AtulOpenbravo

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Regression date

Regression introduced by commit

Regression level

Review Assigned To

aferraz

Support ticket

OBNetwork customer

Regression introduced in release

Summary

0036846: Cannot complete an inter-company invoice if the target organization or one of their parents are not Legal With Accounting

Description

Cannot complete an inter-company invoice if the target organization or one of their parents are not Legal With Accounting.

In INTERCO_CREATE_INVOICE the source organization is being used for checking the period is open instead of the target organization:

          SELECT AD_GET_DOC_LE_BU('C_INVOICE', p_record_ID, 'C_INVOICE_ID', 'LE')
          INTO v_org_bule_id
          FROM DUAL;

Steps To Reproduce

As group admin role:
   Use the Initial Org Setup process to create a Legal Without Accounting organization with F&B International Group as parent organization, set created organization as ready.

   Create the required master data in F&B International Group organization:
      Price Lists (one for sales and one for purchase)
      Business partners and locations (one customer and one vendor). Assign previously created price list. Set default Payment Terms
      Tax Category and Tax Rate
      Product. Add price to it in both price lists
      Document Type: Inter-company Sales Invoice and Inter-company Purchase Invoice

   Configure Inter-company:
      Add the following Inter-company relation to the Inter-company Sales Invoice document type:
         Source Organization: F&B España, S.A
         Target Organization: the previously created one
         Target Document Type: Inter-company Purchase Invoice

      Assign previously created customer to previously created organization
      Assign previously created vendor to F&B España, S.A

   Create a Sales Invoice for F&B España S.A. and previously created customer
   Select Inter-company Sales Invoice document type
   Add previously created product
   Try to complete it and check the following error is shown:
      Error:
      The Period does not exist or it is not opened

Proposed Solution

Check if changing the query with the following one works:

          SELECT ad_get_org_le_bu(v_matchingOrg, 'LE')
          INTO v_org_bule_id
          FROM DUAL;

Additional Information