Skip to main content
Solved

What is the import scenario actual formula to leave the “Default Receipt To” blank?


pandachan48
Jr Varsity II
Forum|alt.badge.img

What is the import scenario actual formula to leave the “Default Receipt To” blank? in Stock Item

 

 

Best answer by marilizevanzyl

Hi @pandachan48 

 

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

View original
Did this topic help you find an answer to your question?

4 replies

Forum|alt.badge.img
  • Jr Varsity II
  • 51 replies
  • Answer
  • October 9, 2023

Hi @pandachan48 

 

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


pandachan48
Jr Varsity II
Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 31 replies
  • October 9, 2023
marilizevanzyl wrote:

Hi @pandachan48 

 

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"?


Forum|alt.badge.img

Hi @pandachan48 

No, you put nothing in the Excel template if you want to make it blank, only the formula on the Import Scenario.


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

Hi @pandachan48 

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings