If GAC errors out it

If GAC errors out it means one of two things...
 

1. Its an item that has uplift.

        (2 credits per one debit)
This is the rare case.
1,Query tk_gac_interface by transaction_id
2,remove uplift entry
3. Adjust dollars per Kriss Hunts instruction
 
Example Below
 
select transaction_id, base_transaction_value from mtl_transaction_accounts  where transaction_id = 15131018;update  mtl_transaction_accounts set base_transaction_value = -42.66 where transaction_id = 15131018and base_transaction_value = -41.09
 
delete from mtl_transaction_accountswhere transaction_id = 15131018and base_transaction_value = -6.16
 
select segment1 from mtl_system_items m, mtl_material_transactions twhere m.inventory_item_id = t.inventory_item_idand m.organization_id = t.organization_idand t.transaction_id = 15513879
 
 
 
No MTA transactions
 
1. Derive Item Number
 
select segment1 from mtl_system_items m, mtl_material_transactions twhere m.inventory_item_id = t.inventory_item_idand m.organization_id = t.organization_idand t.transaction_id = 15513879
 
2. UPDATE through hammer manager
 
update tk_gac_interface
set interfaced_flag = 'Y'
where transaction_id = 15513879