Prev
Next
Forums Lawson Add-Ins for Microsoft Office

upload reconciliation on CB80 error

Sort:
You are not authorized to post a reply.
Author
Messages


harold_c











Basic Member



Posts: 9




Basic Member



1/23/2017 3:25 PM

    The first line of the upload works but the rest has this error: This form action valid on open transactions only (_f51r0).

    Each transaction number is uniquely assigned.  I searched in Infor's KB but showed only 1 result; recommending to add a field 19 (Position to field).  However, I could not find that field in the currently available fields for upload (maybe it's renamed?, possible fields: _f29,PT-CBT-TRANS-NBR; (H),_F0,TC; tried but to no avail)

    How do you upload your reconciliation into CB80?

    Any help is appreciated.

    Thank you.

    Harold



    Carol S











    Basic Member



    Posts: 12




    Basic Member



    2/12/2018 11:54 PM
      Hi Harold,

      I see this is an old post so you may not need this information any longer. You need to have the transaction field twice in your spreadsheet. Map one to the PT-CBT-TRANS-NBR and map the other the trans # field. This should work.
      Carol Sanguinetti
      You are not authorized to post a reply.