Update Multiple Stock Item’s Tariff Code based on Stock Group : QNE Software Sdn. Bhd.

Update Multiple Stock Item’s Tariff Code based on Stock Group Print

Created by: Faradyana Azman

Modified on: Fri, 18 Dec, 2020 at 10:58 AM

1. Go to File > Utilities > QNE Management Tools

2. QNE will prompt another application (QNE Management Tools)

3. Go to Tools > Intelligence SQL Queries

4. Tick checkbox named ‘Overwrite Generated SQL’

5. Copy script from below update Stock set SSTTariffCode = '8504402000' /*Replace content 8504402000 with your Tariff

Code*/ where GroupCode = 'SW' /*Replace content SW with your Stock Group Code*/

6. Paste into Queries column

7. Click on Execute button to execute the query.

8. Click Exit button to close QNE Management Tools

9. You can go to Stock > Stock Items > search and open the Stock Items under defined Stock Group

10. Your selected Stock Group’s Stock Item’s Tariff Code is now updated accordingly

Refer attachment for details

Faradyana is the author of this solution article.

Did you find it helpful? Yes No

Update Multiple Stock Item’s Tariff Code based on Stock Group Print