GRN Posting Issues

maheshks2010

Hi Experts,

While Posting GRN the error Message (The Purchase Line Table contain field with a code or text value is too large for the SQL server data type:SQL Type:Var Char(50).


Please give solution for this issues.

Thanks In Advance

Thanks & Regards,
maheshks2010

ritesh.singh

Hi Mahesh,

Is this a Customization?

The problem statement suggest that there is a mismatch between two fields (from and to). Please check all the new fields added in purchase line tables.

Chinmoy

This looks like a Field length mismatch problem, compare the fields in Purchase Line, Purch. Rcpt. Line and Purch. Inv. Line tables. These tables must have same length, datatype, etc. for fields with the same Ids.

Chn

maheshks2010

Hi Ritesh/Chinmoy,

The issues is purchases line archive table only Description field length is increased only (Var Char 60)the error is solved and then GRN entry is posted.


Thanks for your valueable suggestions.


Thanks & Regards,
maheshks2010

ritesh.singh

good to know!

you can please mark this post as resolved.