Skip to main content
Solved

How to remove item sales categories using an import scenario (Stock Item Screen)

  • July 19, 2023
  • 4 replies
  • 169 views

Forum|alt.badge.img

Hi all,

I’m trying to create an import scenario that will help me remove all the categories in all the stock items. But I can’t find the action for delete.

 I have a file of stock items with their category description.

Also, I would like to ask if there’s a way I can have an excel file from Acumatica that includes stock items with their category description? I’m trying the generic inquiry but doesn't seem to work.

Thanks in advance.

Best answer by Kandy Beatty

HI @bernadeth58 

You will need to map this way:

 

4 replies

Jeff96
Captain II
Forum|alt.badge.img+4
  • Captain II
  • 268 replies
  • July 19, 2023

Hi all,

I’m trying to create an import scenario that will help me remove all the categories in all the stock items. But I can’t find the action for delete.

 

Since it’s an attribute, if you import the item without anything in the excel file where the attribute should be, it will override it (test it on one item first)

 

 Also, I would like to ask if there’s a way I can have an excel file from Acumatica that includes stock items with their category description? I’m trying the generic inquiry but doesn't seem to work

 

You need to build a export scenario


Kandy Beatty
Captain II
Forum|alt.badge.img+17
  • Captain II
  • 2229 replies
  • Answer
  • July 19, 2023

HI @bernadeth58 

You will need to map this way:

 


Kandy Beatty
Captain II
Forum|alt.badge.img+17
  • Captain II
  • 2229 replies
  • July 19, 2023

Hi @bernadeth58 

Try this GI also for the Item Sales Categories:

 


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 67 replies
  • July 20, 2023

thank you so much @kandybeatty49