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 <mallah.raj...@gmail.com> 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 <mallah.raj...@gmail.com>
> 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 <mallah.raj...@gmail.com>
> > 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 <mallah.raj...@gmail.com>
> >> 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.
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>
> >
>
