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