Project Code field in Cash Flow screen

[mlbechard]

I would like to know which field in the BankTransactions table contain the Project Code field data in the Cash Flow screen.

I know that the search for the Project Code field do a select SQL statement in th prproject table but once selected, in which field this information is registered in the BankTransaction table.

Thanks in advance

 

[dgillz]

I'm pretty sure this field is not in BankTransactions, I believe it is in Gbkmut. The screen itself holds this data, but when you save the record, some data goes to bankTransactions and some goes to Gbkmut.

I will be able to test this later on tonight. Peter may chime in as I am real sure he knows the answer.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[crystalreporting]

Field is 'Project' table is 'gbkmut'. If your Cashflow entry affects multiple GL accounts (including those that wash in and out) then all of the corresponding gbmkut records will have the Project field value.

Peter Shirley
Macola Consultant, PA and surrounding states.

http://www.erpessentials.com

 

[mlbechard]

Thank you! I really appreciate your help!