Thanks Sharan.
regds mallah. On Mon, Oct 9, 2017 at 3:05 PM, Sharan Foga <[email protected]> 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 <[email protected]> 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 <[email protected]> > > 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 <[email protected] > > > > > 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 < > [email protected]> > > >> 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. > > >>> > > >>> > > >>> > > >>> > > >>> > > >>> > > >> > > > > > >
