Cindy,

Re: It would be simple to create a view that divides the amounts into DBs and CRs to use for display.

I'm moving forward slowly on this project. I am a total neophyte with accounting but am a decent foxpro programmer.

If I have plus and minus amounts in one field in a transaction table, I get a bit lost in figuring out if it's a DR or CR, depending on the account type. What would your recommend as the "simplest" setup to get the view your mentioned in the posting above?

Any help is most certainly appreciated!




>>Users prefer to "see" DB and CR columns; on forms and reports.
>>
>>"Internally", you could use a single field ... However, you have to weigh the effort it will take, from a programming POV, to constantly be "converting" from a single field to dual fields for display purposes.
>
>It would be simple to create a view that divides the amounts into DBs and CRs to use for display.