Has anyone encountered the following - If I copy the Item Class name from different places it gives me different values and I’m wondering why, and which one is the appropriate one to use if I’m trying to use the Item Class name as a FILTER for my Ecommerce Export Filter.
I have a class ID defined as such::
Now...if I copy the value from different places, I get the following ‘versions’:
“PURCHASED -MISC” (If I copy from the Stock Item Summary Screen)
“PURCHASED_-MISC______ “ (if I copy from the Item Class)
“PURCHASED MISC” (If I copy from the Stock Item General Tab of the item).
why does this happen?
Page 1 / 1
HI @kkeating24
The reason is because of how the item classes are segmented in Acumatica.
I’ve come across this numerous times. If you copy from the item class screen, it add the spaces for the segments even if they are empty.
HI @kkeating24
The reason is because of how the item classes are segmented in Acumatica.
I’ve come across this numerous times. If you copy from the item class screen, it add the spaces for the segments even if they are empty.
at least I’m not alone. How do we know which one to use for filtering?
What are you filtering?
in the commerce Entities screen, trying to setup an Export Filter for Stock Items by Item Class
HI @kkeating24
It’s the same value, it is just represented differently on different screens because of their configuration not being the same.
I’ve explained what’s going on in this topic:
Taking value from the entry screen (in your case - Item Classes) is a safe bet. 1 note though - those underscores you copied are actually spaces, just underlined for visibility.
Here’s an example - I’ve created a new Item Class on my instance:
Value copied from the field: PUR_-_MI__
Here’s how it looks in the database:
Value copied from the database: “PUR - MI “ (quotes are here to show you spaces).
To find the record from your code, you can use value without trailing spaces, that doesn’t create any problem. So, using my previous example, “PUR - MI” will be fine.
@andriitkachenko - interesting you say that, I did some testing yesterday and the ONLY value that worked the Commerce Entity - Export Filtering screen was “PURCHASED MISC”, with no dashes.
@kkeating24 I’m genuinely surprised. I checked with my “PUR - MI “ class, and it is shown with a dash everywhere.
What is the description of your Item Class?
Do you have other Item Classes “PURCHASED” or similar?
I’d also check on a separate instance to make sure it’s not a configuration issue. Because showing/removing trailing spaces is one thing, but removing characters from the center of the string is unexpected, as it should be considered a different entity.
Hello,
I noticed yesterday two different results when copying/pasting the same field when the source was “Grey”/Inactive versus when the source was selected/in focus.
I copied a value from a document/transaction and the field I copied from the line was gray/inactive: when I pasted the data, it contained extra characters like Underscores/spaces that I could not see in the source data.
I tried again, this time I double-clicking to activate the source field before copying, and the pasted data looked perfectly correct. It wasn’t Item Class field I copied - was likely stock item id or warehouse location.
I am using Firefox browser on a PC, in case that makes a difference.
Laura
@kkeating24 not alone. I encountered this issue in the past with the segmentation. Glad you got it figured out.
@kkeating24 I’m genuinely surprised. I checked with my “PUR - MI “ class, and it is shown with a dash everywhere.
What is the description of your Item Class?
Do you have other Item Classes “PURCHASED” or similar?
I’d also check on a separate instance to make sure it’s not a configuration issue. Because showing/removing trailing spaces is one thing, but removing characters from the center of the string is unexpected, as it should be considered a different entity.
There are definitely a few variables for this that make me wonder if it is a downstream impact from those changes - we actually encountered errors in other parts of Acumatica using the “-” in the item class. So an update was made (not sure how/what exactly, I can get more info next week) but it was a broad item class ID update to remove the ‘-’.
The item class I was copying is a SUB class of a master item class...and yes there are multiple item classes that have the same initial segment “PURCHASED - “
Not sure if there is a solid all encompassing fix for this...just bringing awareness.
