Sage 100

 View Only
  • 1.  Customer is on v2013 Advanced. Last night the con

    Posted 07-30-2015 18:29
    Customer is on v2013 Advanced. Last night the controller imported Job#1= item codes, descriptions, product line and vendor div & code, standard price, standard cost, allow returns=Y (some were new items, some were updating existing items). Then did a second import using VI Job#2= item code, PL, vendor div/code. Not sure why she does both jobs when they seem to duplicate. These were new jobs similar to a set of previous jobs. The only thing different between these 2 import jobs and previous import jobs is that Sage gave them a process to use in the import to replace a ""@"" symbol in the description with a carriage return (pix of VI job attached). Today in Item Inquiry and in Item Maintenance, if they try to scroll with the arrows they get a popup ""Do you want to save changes"". If they are in Inquiry, obviously there hasn't been any changes. If they answer Yes, they get the standard ""You don't have rights to create the record"". In Item Maintenance, it throws the popup about saving changes, but if they click Yes, it accepts it as expected. What is causing Item Inquiry & Maintenance to throw the 'Save Changes"" message? It seems to only be happening on items that were added or updated last night via the import.


  • 2.  RE: Customer is on v2013 Advanced. Last night the con

    Posted 07-31-2015 04:08
    These imports are messy. I'd definitely combine into a single import. Temp1 should be cleared on each record. Replacing @ with a carriage return may create an extended description, so not sure if that's desired. And replacing the product line may impose product line defaults on fields that are not being imported. Try printing the item audit report to see if a change other than the imported fields is occurring.


  • 3.  RE: Customer is on v2013 Advanced. Last night the con

    Posted 08-02-2015 23:59
    To further expand on what Mark said importing a $0D$ (that is a CR) would definitely try to create an ExtendedDescriptionKey. On 1 of the problem items look at that field in CI_Item then also in CI_ExtendedDescription. See if it's in one place but not another.


  • 4.  RE: Customer is on v2013 Advanced. Last night the con

    Posted 09-16-2015 13:31
    @AlnoorCassim and @NancyHanson I realize this is an old post but it was helpful to me in that I was looking for a way to add carriage returns during the import process. but we also were getting the ""Do you want to save changes"" message after the import. we realized after some testing that the message only comes up if carriage return was in the description prior to the 31st character. we had to pad a bunch of spaces in the descriptions to make sure that the first carriage return happened after the 31st character. just thought I would add to the post for others (and myself if I do this again and forget that I already struggled through this )