495
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
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,436
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
