Hello,
I have an invoice that rejects.This was their explanation:
Like I have mentioned before we are only receiving receiving the ISA and GS segments for this invoice the rest of the segments are not being transmitted due to character turns embedded within the data you are sending us that when our system is translating the data it hits that character turn and stops translating after the GS segment
This is what we are receiving for this invoice via EDI
ISA*00* *00* *01*001495621 *08*9251750000 *120725*1029*U*00401*100004025*0*P*>~ GS*GP*001495621*8019721193*20120725*1029*200004025*T*004010UCS~
How can I fix this ???? , below is the original Invoice Data :
ISA*00* *00* *01*001495621 *08*9251750000 *120725*1029*U*00401*100004025*0*P*>~GS*GP*001495621*8019721193*20120725*1029*200004025*T*004010UCS~ST*880*300005708~G01*20120723*12578113*20120710*882147~G61*AR*CREDIT DEPT*TE*2123760300~NTE*DEL*015135~G23*01*1***2*20120730*10*20120819*30~G25*PP*02~N1*BT*SAFE INC*9*0091372091700~N1*RE*THE TOS CO. INC*9*1828316510000~N3*PO BOX 40 HOUSE ST STATION~N4*NEW YORK*NY*102614050*USA~N1*ST*SAFE INC*9*0091372092537~N3*16900 West Schulte Road~N4*Tracy*CA*95377-8985~G17*24*CA*332.64*004111610915~G69*JUICY DROP POP: LAYDOWN BOX~G17*20*CA*241.92*004111610477~G69*ORG BBP W/MSG 288PCS~G17*8*CA*270.72*004111610903~G69*PPOP 24CT DBOX 576PCS~G31*52*CA*2302.8*LB~G33*1498752~SE*22*300005708~GE*1*200004025~IEA*1*100004025~
Ray, withouth much information given in your post about the nature of your problem, here is something I regularly need to check in data exports: Make sure there is no line feed / carriage return in your data, they mess up the flat files so the target system will be unable to import them. Some users copy data from Excel into NAV fields, whereas Excel appends CR/LF at the end of the cells, which in turn end up in the NAV database. (Do a search in the forum on how to delete CR/LF in CU1 when entering data.) You won't see this in NAV's GUI, but at the latest when you export data, make sure they get scrubbed out:
E.g.:
SubCleanLFCR(OrigFieldContent: Text[250]): Text[250] chrLF := 13; //char chrCR := 10; //char CleanFieldContent := delchr(OrigFieldContent, '=', format(chrLF)); CleanFieldContent := delchr(OrigFieldContent, '=', format(chrCR));
(I use a simple subroutine to send all my fields to in order to be checked, so that I don't have to do this for evey field individually.) Goelu
Im not sure of the response . Im not using the Navision system at the moment . I just have the raw data file that I send through our Lexicom folder .
This was the error on their end :
we are only receiving receiving the ISA and GS segments for this invoice the rest of the segments are not being transmitted due to character turns embedded within the data you are sending us that when our system is translating the data it hits that character turn and stops translating after the GS segment .
Is there characters in the raw dat that shouldnt be there ? Is there a way to get an edited file that I can just cut and paste into a notepad and put in our Lexicom folder.