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