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. >>> >>> >>> >>> >>> >>> >> >
