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 Laura03
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
+20Hello,
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
Thanks Laura, Seems I can target a recordID where there is already an expiry date set, regardless of promotion flag. This works.
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.
Hi
I’ve tested this further. Using only the setup shown in the screenshot I sent earlier works only when the sales price is defined for a single UOM and warehouse.
Your approach is correct - using @@ is required to target the specific line you want to update.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
