What is the import scenario actual formula to leave the “Default Receipt To” blank? in Stock Item
Best answer by marilizevanzyl
View originalWhat is the import scenario actual formula to leave the “Default Receipt To” blank?
Userlevel 2
Hi
Hope you are doing well.
Here is the one that worked for me, this is on 2022 R2, so the formula is “=Null”:
Please let me know if it worked for you, if not your welcome to share your import scenario with me and then I can have a look further.
Kind Regards
Marilize
Userlevel 2
Hi
Hope you are doing well.
Here is the one that worked for me, this is on 2022 R2, so the formula is “=Null”:
Please let me know if it worked for you, if not your welcome to share your import scenario with me and then I can have a look further.
Kind Regards
Marilize
What should I put in the Excel file template? Should I also put "Null"?
Hi
No, you put nothing in the Excel template if you want to make it blank, only the formula on the Import Scenario.
Userlevel 7
+12
Hi
You can put any dummy value in the excel and map the =’Null’ in the Import scenario
if you want to pass blank detais then you import scenario should have Null https://www.augforums.com/forums/everything-else/setting-a-field-to-empty-or-null/
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.