regarding POS

To err is to be human, to help each other is joy. Tell your Compiere needs in your own words. Let's figure out together.

Moderator: azaharizaman

regarding POS

Postby hema » Wed Oct 27, 2004 4:45 pm

Hi Red1,

I was trying your POS Tutorial. I created two new fields GivenAmt and ChangeAmt in C_Order table. I also checked them as mandatory. Their corresponding System Element where named GivenAmt and ChangeAmt respectively. When I tested the window and tried to save the data, I got the following error "ORA-00904: "GIVENAMT": invalid identifier". I checked the C_ORDER table and found out that the two columns GivenAmt and ChangeAmt were not there.
I had to create those two new columns via SQL. Then it worked.

My question is: How come I was not able to create new columns via the "Table and Column" item from the System Menu?

Many thanks,
Hema
hema
Regular
 
Posts: 81
Joined: Wed Aug 25, 2004 5:21 pm

Postby red1 » Wed Oct 27, 2004 6:43 pm

Hi Hema,
There is one obvious answer :lol:

YOU DID NOT SYNCHRONISE the new fields to the Database.

Hmm, didn't i say so in my tutorial?

regards
red1
red1
Site Admin
 
Posts: 2762
Joined: Tue Jul 06, 2004 3:01 pm
Location: Kuala Lumpur, Malaysia

Postby hema » Thu Oct 28, 2004 4:11 pm

Thanks a lot for reminding me Red1 :)
hema
Regular
 
Posts: 81
Joined: Wed Aug 25, 2004 5:21 pm


Return to Ask RED1 personally

Who is online

Users browsing this forum: No registered users and 2 guests

cron