need help in overriding GL account for certain sales invoice items.

[Rajesh Mallah]

Hi Everyone ,

Hope everything is going great .
I had to take a temporary detour from the
OfBiz implementation project , now back to it.

I had created a new Chart of Accounts (COA) for my organisation
and trying to setup using exclusively the new (COA). I have been
mostly successful but when

I am trying to "Quick Ship Entire Order" after following steps:
(1) placing an order from the ecommerce.
(2) "Receive Payment" in Order screen

I get an error of FKEY violation which demands that the combination of
(gl_account_id , organisation_party_id) should be present in the
gl_account_organisation.

>>>>> excerpt of error
(ERROR: insert or update on table "acctg_trans_entry" violates foreign key
constraint "accttxent_glacog"   Detail: Key (gl_account_id,
organization_party_id)=(410000, 10000) is not present in table
"gl_account_organization".)). Rolling back transaction.
<<<<<<



considering the document

https://cwiki.apache.org/confluence/display/OFBENDUSER/12.1.4.5+Sales+Invoice

I have already added override entries (based on new COA)
for all global entries that referred to "410000" , Invoice Discount (Sales)
But instead of using the overridden one it tends to use the original ones.

As evident i have not included items of demo COA into the new
INTERNAL_ORGANISATION that i created.


any help is solicited.


regds
mallah.

[Rajesh Mallah]

Hi ,

We had to manually add the following overrides for invoice_item_type_id in
Entity invoice_item_type_gl_account

ITM_PROMOTION_ADJ   "Invoice Item Promotion(Sales)"    and
INV_FPROD_ITEM           "Invoice Finished Good Item(Sales)"


to temporarily solve it.

shall keep posted


regds
mallah.





On Sat, Oct 7, 2017 at 4:16 PM, Rajesh Mallah <[hidden email]>
wrote:

> Hi Everyone ,
>
> Hope everything is going great .
> I had to take a temporary detour from the
> OfBiz implementation project , now back to it.
>
> I had created a new Chart of Accounts (COA) for my organisation
> and trying to setup using exclusively the new (COA). I have been
> mostly successful but when
>
> I am trying to "Quick Ship Entire Order" after following steps:
> (1) placing an order from the ecommerce.
> (2) "Receive Payment" in Order screen
>
> I get an error of FKEY violation which demands that the combination of
> (gl_account_id , organisation_party_id) should be present in the
> gl_account_organisation.
>
> >>>>> excerpt of error
> (ERROR: insert or update on table "acctg_trans_entry" violates foreign key
> constraint "accttxent_glacog"   Detail: Key (gl_account_id,
> organization_party_id)=(410000, 10000) is not present in table
> "gl_account_organization".)). Rolling back transaction.
> <<<<<<
>
>
>
> considering the document
>
> https://cwiki.apache.org/confluence/display/OFBENDUSER/
> 12.1.4.5+Sales+Invoice
>
> I have already added override entries (based on new COA)
> for all global entries that referred to "410000" , Invoice Discount (Sales)
> But instead of using the overridden one it tends to use the original ones.
>
> As evident i have not included items of demo COA into the new
> INTERNAL_ORGANISATION that i created.
>
>
> any help is solicited.
>
>
> regds
> mallah.
>
>
>
>
>
>

[Rajesh Mallah]

UPDATE: { correction }

it was possible to add override for

 "INV_FPROD_ITEM           "Invoice Finished Good Item(Sales)"

only for ITM_PROMOTION_ADJ  it is a problem as it does not appear in
the dropdown for "Invoice Item Type"  in

Org GL account settings -> "Setup" -> "GL Account Defaults" -> "Sales
Invoice"

regds
mallah.








On Sat, Oct 7, 2017 at 6:59 PM, Rajesh Mallah <[hidden email]>
wrote:

> Hi ,
>
> We had to manually add the following overrides for invoice_item_type_id in
> Entity invoice_item_type_gl_account
>
> ITM_PROMOTION_ADJ   "Invoice Item Promotion(Sales)"    and
> INV_FPROD_ITEM           "Invoice Finished Good Item(Sales)"
>
>
> to temporarily solve it.
>
> shall keep posted
>
>
> regds
> mallah.
>
>
>
>
>
> On Sat, Oct 7, 2017 at 4:16 PM, Rajesh Mallah <[hidden email]>
> wrote:
>
>> Hi Everyone ,
>>
>> Hope everything is going great .
>> I had to take a temporary detour from the
>> OfBiz implementation project , now back to it.
>>
>> I had created a new Chart of Accounts (COA) for my organisation
>> and trying to setup using exclusively the new (COA). I have been
>> mostly successful but when
>>
>> I am trying to "Quick Ship Entire Order" after following steps:
>> (1) placing an order from the ecommerce.
>> (2) "Receive Payment" in Order screen
>>
>> I get an error of FKEY violation which demands that the combination of
>> (gl_account_id , organisation_party_id) should be present in the
>> gl_account_organisation.
>>
>> >>>>> excerpt of error
>> (ERROR: insert or update on table "acctg_trans_entry" violates foreign
>> key constraint "accttxent_glacog"   Detail: Key (gl_account_id,
>> organization_party_id)=(410000, 10000) is not present in table
>> "gl_account_organization".)). Rolling back transaction.
>> <<<<<<
>>
>>
>>
>> considering the document
>>
>> https://cwiki.apache.org/confluence/display/OFBENDUSER/12.1.
>> 4.5+Sales+Invoice
>>
>> I have already added override entries (based on new COA)
>> for all global entries that referred to "410000" , Invoice Discount
>> (Sales)
>> But instead of using the overridden one it tends to use the original ones.
>>
>> As evident i have not included items of demo COA into the new
>> INTERNAL_ORGANISATION that i created.
>>
>>
>> any help is solicited.
>>
>>
>> regds
>> mallah.
>>
>>
>>
>>
>>
>>
>

[Rajesh Mallah]

Hi  ,

I was able to assign the GL ACCOUNT from

"Global GL Settings" => "INVOICE ITEM TYPE"

this solved the problem with resorting to any hackery.

regds
mallah.




On Sat, Oct 7, 2017 at 7:30 PM, Rajesh Mallah <[hidden email]>
wrote:

> UPDATE: { correction }
>
> it was possible to add override for
>
>  "INV_FPROD_ITEM           "Invoice Finished Good Item(Sales)"
>
> only for ITM_PROMOTION_ADJ  it is a problem as it does not appear in
> the dropdown for "Invoice Item Type"  in
>
> Org GL account settings -> "Setup" -> "GL Account Defaults" -> "Sales
> Invoice"
>
> regds
> mallah.
>
>
>
>
>
>
>
>
> On Sat, Oct 7, 2017 at 6:59 PM, Rajesh Mallah <[hidden email]>
> wrote:
>
>> Hi ,
>>
>> We had to manually add the following overrides for invoice_item_type_id
>> in
>> Entity invoice_item_type_gl_account
>>
>> ITM_PROMOTION_ADJ   "Invoice Item Promotion(Sales)"    and
>> INV_FPROD_ITEM           "Invoice Finished Good Item(Sales)"
>>
>>
>> to temporarily solve it.
>>
>> shall keep posted
>>
>>
>> regds
>> mallah.
>>
>>
>>
>>
>>
>> On Sat, Oct 7, 2017 at 4:16 PM, Rajesh Mallah <[hidden email]>
>> wrote:
>>
>>> Hi Everyone ,
>>>
>>> Hope everything is going great .
>>> I had to take a temporary detour from the
>>> OfBiz implementation project , now back to it.
>>>
>>> I had created a new Chart of Accounts (COA) for my organisation
>>> and trying to setup using exclusively the new (COA). I have been
>>> mostly successful but when
>>>
>>> I am trying to "Quick Ship Entire Order" after following steps:
>>> (1) placing an order from the ecommerce.
>>> (2) "Receive Payment" in Order screen
>>>
>>> I get an error of FKEY violation which demands that the combination of
>>> (gl_account_id , organisation_party_id) should be present in the
>>> gl_account_organisation.
>>>
>>> >>>>> excerpt of error
>>> (ERROR: insert or update on table "acctg_trans_entry" violates foreign
>>> key constraint "accttxent_glacog"   Detail: Key (gl_account_id,
>>> organization_party_id)=(410000, 10000) is not present in table
>>> "gl_account_organization".)). Rolling back transaction.
>>> <<<<<<
>>>
>>>
>>>
>>> considering the document
>>>
>>> https://cwiki.apache.org/confluence/display/OFBENDUSER/12.1.
>>> 4.5+Sales+Invoice
>>>
>>> I have already added override entries (based on new COA)
>>> for all global entries that referred to "410000" , Invoice Discount
>>> (Sales)
>>> But instead of using the overridden one it tends to use the original
>>> ones.
>>>
>>> As evident i have not included items of demo COA into the new
>>> INTERNAL_ORGANISATION that i created.
>>>
>>>
>>> any help is solicited.
>>>
>>>
>>> regds
>>> mallah.
>>>
>>>
>>>
>>>
>>>
>>>
>>
>

[Sharan Foga]

Hi Rajesh

The Global template is the master and the organisation GL settings are the overrides. In some cases such as the one you found, there isn't a way to set the value in the organisation settings so it needs to be done at the master template level.

Thanks
Sharan


On 2017-10-08 06:45, Rajesh Mallah <[hidden email]> wrote:

> Hi  ,
>
> I was able to assign the GL ACCOUNT from
>
> "Global GL Settings" => "INVOICE ITEM TYPE"
>
> this solved the problem with resorting to any hackery.
>
> regds
> mallah.
>
>
>
>
> On Sat, Oct 7, 2017 at 7:30 PM, Rajesh Mallah <[hidden email]>
> wrote:
>
> > UPDATE: { correction }
> >
> > it was possible to add override for
> >
> >  "INV_FPROD_ITEM           "Invoice Finished Good Item(Sales)"
> >
> > only for ITM_PROMOTION_ADJ  it is a problem as it does not appear in
> > the dropdown for "Invoice Item Type"  in
> >
> > Org GL account settings -> "Setup" -> "GL Account Defaults" -> "Sales
> > Invoice"
> >
> > regds
> > mallah.
> >
> >
> >
> >
> >
> >
> >
> >
> > On Sat, Oct 7, 2017 at 6:59 PM, Rajesh Mallah <[hidden email]>
> > wrote:
> >
> >> Hi ,
> >>
> >> We had to manually add the following overrides for invoice_item_type_id
> >> in
> >> Entity invoice_item_type_gl_account
> >>
> >> ITM_PROMOTION_ADJ   "Invoice Item Promotion(Sales)"    and
> >> INV_FPROD_ITEM           "Invoice Finished Good Item(Sales)"
> >>
> >>
> >> to temporarily solve it.
> >>
> >> shall keep posted
> >>
> >>
> >> regds
> >> mallah.
> >>
> >>
> >>
> >>
> >>
> >> On Sat, Oct 7, 2017 at 4:16 PM, Rajesh Mallah <[hidden email]>
> >> wrote:
> >>
> >>> Hi Everyone ,
> >>>
> >>> Hope everything is going great .
> >>> I had to take a temporary detour from the
> >>> OfBiz implementation project , now back to it.
> >>>
> >>> I had created a new Chart of Accounts (COA) for my organisation
> >>> and trying to setup using exclusively the new (COA). I have been
> >>> mostly successful but when
> >>>
> >>> I am trying to "Quick Ship Entire Order" after following steps:
> >>> (1) placing an order from the ecommerce.
> >>> (2) "Receive Payment" in Order screen
> >>>
> >>> I get an error of FKEY violation which demands that the combination of
> >>> (gl_account_id , organisation_party_id) should be present in the
> >>> gl_account_organisation.
> >>>
> >>> >>>>> excerpt of error
> >>> (ERROR: insert or update on table "acctg_trans_entry" violates foreign
> >>> key constraint "accttxent_glacog"   Detail: Key (gl_account_id,
> >>> organization_party_id)=(410000, 10000) is not present in table
> >>> "gl_account_organization".)). Rolling back transaction.
> >>> <<<<<<
> >>>
> >>>
> >>>
> >>> considering the document
> >>>
> >>> https://cwiki.apache.org/confluence/display/OFBENDUSER/12.1.
> >>> 4.5+Sales+Invoice
> >>>
> >>> I have already added override entries (based on new COA)
> >>> for all global entries that referred to "410000" , Invoice Discount
> >>> (Sales)
> >>> But instead of using the overridden one it tends to use the original
> >>> ones.
> >>>
> >>> As evident i have not included items of demo COA into the new
> >>> INTERNAL_ORGANISATION that i created.
> >>>
> >>>
> >>> any help is solicited.
> >>>
> >>>
> >>> regds
> >>> mallah.
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>
> >
>

[Rajesh Mallah]

Thanks Sharan.


regds
mallah.

On Mon, Oct 9, 2017 at 3:05 PM, Sharan Foga <[hidden email]> wrote:

> Hi Rajesh
>
> The Global template is the master and the organisation GL settings are the
> overrides. In some cases such as the one you found, there isn't a way to
> set the value in the organisation settings so it needs to be done at the
> master template level.
>
> Thanks
> Sharan
>
>
> On 2017-10-08 06:45, Rajesh Mallah <[hidden email]> wrote:
> > Hi  ,
> >
> > I was able to assign the GL ACCOUNT from
> >
> > "Global GL Settings" => "INVOICE ITEM TYPE"
> >
> > this solved the problem with resorting to any hackery.
> >
> > regds
> > mallah.
> >
> >
> >
> >
> > On Sat, Oct 7, 2017 at 7:30 PM, Rajesh Mallah <[hidden email]>
> > wrote:
> >
> > > UPDATE: { correction }
> > >
> > > it was possible to add override for
> > >
> > >  "INV_FPROD_ITEM           "Invoice Finished Good Item(Sales)"
> > >
> > > only for ITM_PROMOTION_ADJ  it is a problem as it does not appear in
> > > the dropdown for "Invoice Item Type"  in
> > >
> > > Org GL account settings -> "Setup" -> "GL Account Defaults" -> "Sales
> > > Invoice"
> > >
> > > regds
> > > mallah.
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > On Sat, Oct 7, 2017 at 6:59 PM, Rajesh Mallah <[hidden email]
> >
> > > wrote:
> > >
> > >> Hi ,
> > >>
> > >> We had to manually add the following overrides for
> invoice_item_type_id
> > >> in
> > >> Entity invoice_item_type_gl_account
> > >>
> > >> ITM_PROMOTION_ADJ   "Invoice Item Promotion(Sales)"    and
> > >> INV_FPROD_ITEM           "Invoice Finished Good Item(Sales)"
> > >>
> > >>
> > >> to temporarily solve it.
> > >>
> > >> shall keep posted
> > >>
> > >>
> > >> regds
> > >> mallah.
> > >>
> > >>
> > >>
> > >>
> > >>
> > >> On Sat, Oct 7, 2017 at 4:16 PM, Rajesh Mallah <
> [hidden email]>
> > >> wrote:
> > >>
> > >>> Hi Everyone ,
> > >>>
> > >>> Hope everything is going great .
> > >>> I had to take a temporary detour from the
> > >>> OfBiz implementation project , now back to it.
> > >>>
> > >>> I had created a new Chart of Accounts (COA) for my organisation
> > >>> and trying to setup using exclusively the new (COA). I have been
> > >>> mostly successful but when
> > >>>
> > >>> I am trying to "Quick Ship Entire Order" after following steps:
> > >>> (1) placing an order from the ecommerce.
> > >>> (2) "Receive Payment" in Order screen
> > >>>
> > >>> I get an error of FKEY violation which demands that the combination
> of
> > >>> (gl_account_id , organisation_party_id) should be present in the
> > >>> gl_account_organisation.
> > >>>
> > >>> >>>>> excerpt of error
> > >>> (ERROR: insert or update on table "acctg_trans_entry" violates
> foreign
> > >>> key constraint "accttxent_glacog"   Detail: Key (gl_account_id,
> > >>> organization_party_id)=(410000, 10000) is not present in table
> > >>> "gl_account_organization".)). Rolling back transaction.
> > >>> <<<<<<
> > >>>
> > >>>
> > >>>
> > >>> considering the document
> > >>>
> > >>> https://cwiki.apache.org/confluence/display/OFBENDUSER/12.1.
> > >>> 4.5+Sales+Invoice
> > >>>
> > >>> I have already added override entries (based on new COA)
> > >>> for all global entries that referred to "410000" , Invoice Discount
> > >>> (Sales)
> > >>> But instead of using the overridden one it tends to use the original
> > >>> ones.
> > >>>
> > >>> As evident i have not included items of demo COA into the new
> > >>> INTERNAL_ORGANISATION that i created.
> > >>>
> > >>>
> > >>> any help is solicited.
> > >>>
> > >>>
> > >>> regds
> > >>> mallah.
> > >>>
> > >>>
> > >>>
> > >>>
> > >>>
> > >>>
> > >>
> > >
> >
>