Sage 100

 View Only
  • 1.  VI job into AR Invoice Entry. The Item Codes in t

    Posted 12-06-2018 13:15
    VI job into AR Invoice Entry. The Item Codes in the input file are longer than the 30 character Misc codes I setup - I just used the first 30 characters. I keep getting an error that the Item Code is longer than 30 characters on my import. I have tried clicking on the Substring for Source and Record and only selecting 30 characters, I have tried a Line Temp field which I said was only 30 characters long (again based on the substring but also changed the Length field) and I have then tried doing a Mid(temp,1,30) on that Line temp field as a calculation of the Item Code. I have flipped the Skip Data Source Truncation off and on. I have flipped the computer off repeatedly. I have screamed obscenities that would mortify my mother and made my dogs vacate the room. And yet, and yet. It still tells me that my item code is more than 30 characters. Anyone have any suggestions except hang it up for the day and try again tomorrow? (OH, and that Employee Key issue from the other day - once I got Sage logged in with me to see it, the *horribly blue expletive deleted* VI job worked just fine.)


  • 2.  RE: VI job into AR Invoice Entry. The Item Codes in t

    Posted 12-06-2018 13:18
    This is just off the top of my head, but does the ""/"" take up one of the characters in A/R?


  • 3.  RE: VI job into AR Invoice Entry. The Item Codes in t

    Posted 12-06-2018 13:18
    Are you taking into account that the Misc Item Code must start with a ""/""?


  • 4.  RE: VI job into AR Invoice Entry. The Item Codes in t

    Posted 12-06-2018 13:19
    You should try a 29 character item ...


  • 5.  RE: VI job into AR Invoice Entry. The Item Codes in t

    Posted 12-06-2018 13:23
    Omg. 29 vs 30. OMG OMG OMG OMG. Now I have to go apologize to the dogs.... THANK YOU EVERYONE!!!!!!!!!!!!!!!!!!!!!!!!!!


  • 6.  RE: VI job into AR Invoice Entry. The Item Codes in t

    Posted 12-06-2018 13:25
    Wow, you guys are quick. I agree. I know that the ""/"" comes out in exports and shows up in the database. Also, you are talking about pre-defined miscellaneous item codes (starting with a ""/"") and not the ones you can do on the fly that start with an asterisk, right?


  • 7.  RE: VI job into AR Invoice Entry. The Item Codes in t

    Posted 12-06-2018 16:31
    Ray - Sent you a chat.