Thursday, July 12, 2012

Scan Bar Code Data into ERP LN

   We had requirement to scan 2D Bar Code and add records to ERP LN. We got Data Logic GD4400 scanner to scan Bar Codes. We find two way by which we can read Bar Code in ERP LN
1) Reading RS 232 Port and adding records to ERP LN.
2) By putting Data at the point of Cursor(in field)

   In our requirement, user will scan multiple items at a time and then he will confirm the scanned items and then after confirmation data will be sent to respective tables. Bar Code contains comma separated data, that we separated in when.field.change Event of field.
   When we scan Item, scanner put comma separated string in respective field but we need to tab to hit event. We try every single event but nothing works. We tried adding tab at the end of Bar Code Data but in vain.
   In User Manual of Scanner we found programming of scanner. By which we can program scanner. There is List of Bar Code which require to program scanner. First we need to scan Start Mode code so that scanner goes into programming mode after that we can add suffix character by scanning respective character. We set Tab as suffix character and it works. Now user scan Items one by one and item get enter in LN with out tab.

 We are not aware of how to read RS232 port so skip that option.

Friday, February 3, 2012

update.status and update.occ()

When we create session with form field and need to update form field data to table using standard save functionality as "Choice Update.DB". Normally when we use table fields and if we made some changes then system understand the record is modified and update.db will get hit. But whenever we use form fields we need to tell system this field has changed by using following code.

field.:
when.field.changes:
update.status = modify.set
update.occ()

This will force LN to call choice.update.db section.

Suppress Standard Message After Save

This is common requirement while creating update session and updating same by form command. Once we update by using form command function while closing session system display error message "Do you want to save record?".

Now to avoid this we have to tick check box in form command as "Save before Execute" on second form.