Got a ticket that FWITBAL was not showing current balance for period selected in owag. It worked correctly in other database instances. I grabbed the form to look at the source and saw that the current balance was coning from the view fgvtbl1. The fiscal period field in the keyblock area was an OUS addition to the form. The field got picked up by fgrparc. I looked at the view fgvtbl1 and couldn’t see where fiscal period played a role anywhere in the current balance calculation. Finally figured out owag did not have the same view as the other databases which had an undocumented mod. Once I put the correct view in owag, it worked. I documented the mod of fgvtbl1 and put it in the tree of the databases under views. I don’t know how many more of these undocumented mods are out there but I sure wasted a lot of time on this one.
