Skip to main content
Solved

Import Scenario to Delete or Change Expiry on Sales Prices


I have been trying to delete existing Sales Prices or change the expiry date with an import scenario.

I can expiry them OK if the expiry date is null using the follow scenario:
 

But once the expiry date it is set it appears that the existing records cannot be targeted to either delete or change the expiry date.  Is it possible?

There is a post on How to Bulk delete all line items in Sales Prices | Community (acumatica.com), however there may be too many records for this manual method.

Best answer by Laura02

Hello,

We can only import changes that we can enter on the screen. Can you change the expiration dates in Sales Prices or in Sales Price Worksheets?

I found a previous post where Kandy suggests first checking ON the Promotional Checkbox, then changing the Expiration Date.  Once the date is changed and saved, you can import Un-checking the Promotional Checkbox, if needed.

To check/uncheck a box, import a value of True (box checked ON) or False (box unchecked).

 

Hope this helps.

Laura

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

3 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • Answer
  • August 2, 2024

Hello,

We can only import changes that we can enter on the screen. Can you change the expiration dates in Sales Prices or in Sales Price Worksheets?

I found a previous post where Kandy suggests first checking ON the Promotional Checkbox, then changing the Expiration Date.  Once the date is changed and saved, you can import Un-checking the Promotional Checkbox, if needed.

To check/uncheck a box, import a value of True (box checked ON) or False (box unchecked).

 

Hope this helps.

Laura


  • Author
  • Freshman I
  • 6 replies
  • August 4, 2024

Thanks Laura, Seems I can target a recordID where there is already an expiry date set, regardless of promotion flag. This works. 

 


  • Author
  • Freshman I
  • 6 replies
  • August 9, 2024

While the selection may help with performance it is still necessary to target sales price records using every field, otherwise a new record is created. If records already have an expiry date then need @@ExpirationDate and possibly @@IsPromotionalPrice.

 

 


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