Agile-Developer

Agile Developer

Branch Dropdown Iss...
 
Notifications
Clear all

Branch Dropdown Issue Across Inventory Module Screens

6 Posts
2 Users
0 Likes
79 Views
Posts: 481
Topic starter
(@banupriya)
Noble Member
Joined: 9 months ago

We require your assistance with the following issue:

In the desktop version of the Inventory Module, the Branch dropdown in the Material Requisition Note screen displays all branches as shown below. However, in the web version, the Branch dropdown only displays a single branch, despite logging in with the same user (Admin). We are encountering the same issue across all screens in the Inventory Module. Please provide an urgent solution, as this matter is critical.

5 Replies
Posts: 490
Admin
(@axpertsupport)
Reputable Member
Joined: 1 year ago

Please resave the screen, clear the Redis and temporary caches, and also clear the memory database for that screen in the web application. Afterward, refresh the dropdown button. If the issue persists, let me know.

Reply
Posts: 481
Topic starter
(@banupriya)
Noble Member
Joined: 9 months ago

Thank you for your prompt response. We have already followed all the steps you recommended. Please investigate the issue further and provide an alternative solution.

Reply
Posts: 490
Admin
(@axpertsupport)
Reputable Member
Joined: 1 year ago

Could you please provide the definition for that field?

Reply
Posts: 481
Topic starter
(@banupriya)
Noble Member
Joined: 9 months ago

Please find the requested query below.

SELECT a1.locationid, a1.locationname, a1.locationcode

FROM location a1

WHERE isnull (active, 'F') = 'T'

AND isnull (git, 'F') <> 'T'

AND isnull (technicianstock, 'F') <> 'T'

AND isnull (customerstock, 'F') <> 'T'

AND :m_alllocation = 'T'

UNION

SELECT a1.locationid, a1.locationname, a1.locationcode

FROM location a1, AXUSERLOCATIONS ul

WHERE a1.locationid = ul.locationid

AND CAST (ul.axusersid AS varchar (50)) = :m_userid

AND isnull (active, 'F') = 'T'

AND isnull (git, 'F') <> 'T'

AND isnull (technicianstock, 'F') <> 'T'

AND isnull (customerstock, 'F') <> 'T'

ORDER BY locationname

Reply
Page 1 / 2
Share: