How to hard code the barcode Alternate type in Report?

Hi ​@Harry,

Could you please confirm where you want to achieve this? Are you looking to hardcode it on the Stock Items screen as AlternateType = Barcode, or are you trying to display the barcode data in a report?

If you want to set it on the Stock Items screen, you can use Low Code / No Code customization and configure the default value through the Customization Editor.

If your requirement is for a report, I’m not completely sure, but based on my review of the code and database, the barcode value is stored as “BAR” in the backend. You can try using this value as well.

Hi ​@Harry,

You can join with INItemXRef as you are but instead of Barcode, you need to join as ‘BAR’ for AlternateType. Refer to below screenshot. I am not sure which report you are trying to modify but it might duplicate your records in report and for that you will have to add a group by for Inventory or create a sub-report. Let me know if you have any questions or if this helps resolve your issue.

Thanks.