Skip to main content
Solved

Import Scenario to delete Sale Prices by UOM


Hi everyone,

I'm having issue trying to configure an Import Scenario to delete all the sales prices with the same UOM.

I have a huge list to delete and one by one its no efficient 

Best answer by ChandraM

@alejandradiaz68 Try using linenumber=-2 (for delete) and @@UOM variable to delete the lines with a specific UOM in the import scenario.

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

4 replies

Eric Ratté
Jr Varsity I
Forum|alt.badge.img+1
  • Jr Varsity I
  • 25 replies
  • October 5, 2024

Hi,

 

It doesn’t seem to be possible to use an import scenario for that screen.

 

However, you can select multiple records by clicking on the first line to select it, and then, select the last one of the page by holding the SHIFT key and clicking on it. Clicking on the Delete icon will then delete the records selected.

 

For the page to load almost 100 records, you can unzoom it at 25% via your browser. Don’t forget to filter you data to list only the records to be deleted before unzooming.


Forum|alt.badge.img+8
  • Captain II
  • 366 replies
  • October 5, 2024

Hi @alejandradiaz68 

 

Not too sure with this functionality, however, would exporting to excel, then deleting all the unit prices there and reuploading the sales price worksheet work?

 

Aleks


Forum|alt.badge.img+8
  • Semi-Pro I
  • 715 replies
  • October 7, 2024

As shown below, an import scenario is possible for the Sales prices screen.
 

 


Forum|alt.badge.img+8
  • Semi-Pro I
  • 715 replies
  • Answer
  • October 7, 2024

@alejandradiaz68 Try using linenumber=-2 (for delete) and @@UOM variable to delete the lines with a specific UOM in the import scenario.


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