Error 3163

[imtmub]

Hi All,
Our company has ERP it developed in MsAccess and SQL. It has all the modules like Plan, Manufacturing, sales, purchase, finance and HR. All the modules are working fine. Now i got some new problem like 3163 error "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data." when i m trying to Issue raw material to Workorder. For issue we have the form called FormIssue when its open we need to enter Workorder id . That workorderid calls appropriate BOM to issue the raw material.
I am getting the error for only one workorder and the rest is don't have a problem.

I checked all the records for the purticular raw material everything is correct like other raw material.


Thanks
Mohammed


.

[MMcCarthy]

Hi All,
Our company has ERP it developed in MsAccess and SQL. It has all the modules like Plan, Manufacturing, sales, purchase, finance and HR. All the modules are working fine. Now i got some new problem like 3163 error "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data." when i m trying to Issue raw material to Workorder. For issue we have the form called FormIssue when its open we need to enter Workorder id . That workorderid calls appropriate BOM to issue the raw material.
I am getting the error for only one workorder and the rest is don't have a problem.

I checked all the records for the purticular raw material everything is correct like other raw material.


Thanks
Mohammed


.

One of the numbers is too big or one of the text fields is too long.

[imtmub]

One of the numbers is too big or one of the text fields is too long.

Thats true. But i m using get value from another table fields. Both table fields has same properties. Do u know anyother way to check.

Thanks
Mohammed

[imtmub]

Thats true. But i m using get value from another table fields. Both table fields has same properties. Do u know anyother way to check.

Thanks
Mohammed

Anybody has the answer for this . pls help me to solve

[MMcCarthy]

Anybody has the answer for this . pls help me to solve

If it's only the one work order try entering it manually to see where the problem is.