Announcements
559
im creating Xmlport to get output of the sales header table and sales line table in TXT file
all the sales header table is ok , but when i added the sales line table i got the below error
*This post is locked for comments
1-i need to filter from the Location in the line not in the header
2-i need to remove the double Quotations from one filed only not from all of them
I'm not sure I understand No 1. If you only need to filter with location and you don't need any line information, there is a location code on the header as well (field no 28) that you can filter with.
Add the location code to filters:
2 Remove the field delimiter from the xmlport properties.
Thanks a a lot , that solve the issue
i have 2 questions
1- in the below screen shots the i added location from the sales line , and i don't want to have the location in the output , i only use it to filter the data , how can i do that ?
2- the out put will be like below
SO000012","09/17/19","01613","English Guernsey Cattle Societ","Scotsbridge House, Scots Hill","Rickmansworth","","GBR"
every thing is OK but i need to have the date ( 09/17/19) with out the double quotation to be like that :
09/17/19
You need to indent the fields under the SalesLine, just like you did for the Sales header fields. The Test field is set to use the Sales Line:: Description but it is not intended under it. Indent that field and any other fields you add for the sales line.
Hi,
You need to indent the line under Sales Line and it will compile.
Tero
#1
Community Member
108
#2
Mohamed Amine Mahmoudi
100
Super User 2025 Season 1
#3
manish.yadav
6
Share
Report
All responses (
Answers (
