Hello all,
I want to display the Barcode alternate Type from the Cross Ref tab in the Stock items (IN202500) screen. But unable to do so. i want to hard code in the join to only display the data for Barcode.
Thanks.
Solved
How to hard code the barcode Alternate type in Report?
Best answer by Dipak Nilkanth
Hi
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.
+14Hi
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.
+6Hi
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.
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.