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.
