Skip to main content
Answer

Import scenario of non-stock - Conditional if the Inventory ID exists in the database

  • May 11, 2023
  • 2 replies
  • 115 views

Forum|alt.badge.img+1

Hi !

Is it possible in the import scenario of multiple inventory ID & quantities, to pull up the information to verify if the inventory id exist in the database , and do conditionnal thing like :

IF this_inventory_id_exist_in_the_acu_database THEN

use it

ELSE

take ABC123(existing one)

 

Thanks!

Best answer by raphrf

My goal was in a sale order, to use a dummy item in case the item doesnt exist while importating rows .

We did it by customization

 

2 replies

Forum|alt.badge.img+1

Hi !

Is it possible in the import scenario of multiple inventory ID & quantities, to pull up the information to verify if the inventory id exist in the database , and do conditionnal thing like :

IF this_inventory_id_exist_in_the_acu_database THEN

use it

ELSE

take ABC123(existing one)

 

Thanks!

 

Hey raphrf, I was searching for something else and came across your post.  I’m wondering if you could do this with source restrictions on the import scenario.   

Can you explain what you’re trying to do in more detail as there may be another way to do it.  

 

 

 


Forum|alt.badge.img+1
  • Author
  • Captain I
  • Answer
  • December 9, 2024

My goal was in a sale order, to use a dummy item in case the item doesnt exist while importating rows .

We did it by customization