By using this website, you agree to our Terms of Use (click here)
Currently, our pricing is managed outside of Acumatica and we have a nightly IS configured to load changes in prices. I'm trying to use the Sales Prices screen (AR02000) to update (or add) pricing. In my IS, I am setting the Price Type and Price Code. If I just try and add the line item using LineNumber = -1, I get an error if there is already an entry there because the price does not have an expiration date. What I would like to do is update the row (if it exists) or add a new one if it does not exist. I might not even be adding these in the right place. Am I missing something simple?
Have you looked in the Import Scenarios course on Acumatica University? There are some line update examples in there. Can't remember off the top of my head, but you might have to use LineNumber=2 to make it happen.