Item Created Using SQL but not appearing in ITEM List

1

Dear all,

I created an Item using the following SQL INSERT Statement.

Capture
Capture1204×99 4.61 KB

Despite being in the Database, It is appearing in the Item List.

Should the Item appear in the Item list after an SQL Insert or any suggestion how to make it apear?

2

I’ve tested it on a virtual test machine and it works!
I’ve used the following sql query:

INSERT INTO `tabItem` (`name`, `item_code`, `item_name`, `item_group`) VALUES('1234567891', 'ABC', 'DEF', 'Consumable');

grafik
grafik1161×237 10.6 KB

Which version of frappe/erpnext do you use?

3

@joelios The ERPNext Version I am using is V11

Version

Best Regards,
Kartive

4

Ok, i’ve tested it on V12, i will try V11 now

5

@joelios I will test on V12.

6

It work also on V11 at my side! :face_with_raised_eyebrow:

Did you do reload the webbrowser and/or ERPNext Reload?

7

@joelios No I did not reload.

8

Try this, maybe it is a webbrowser caching problem

9

Sure @joelios I will try this and confirm.