problems with syntax
this script was borrowed from dr. wayne and works well
it copies line items from "sales order" to an invoice
the order lines have 2 field "ordered" & "shipped"
when the invoice is entered the "shipped" on the invoice line items is
posted the shipped field on the order line item
(by orderno & line no)
some invoices do not have all the items shipped
when the next inv is prepared for the same order,
it should filter out those order lines that ordered shipped
and not copy them to the inv line
the index filter that i had works as far as filtering those items to
be copied, but plays havoc on the inv totals because the filter is still
active??
i did not show the whole script because the rest creates the blob and
copies the line items
this all works, no problem and my deepest thanks to dr wayne for showing
the way
i just want to filter the order items to be copied
again, researched the board, which is great, pick up so much,
but could not find anything close to adopt
appreciate all help in the past and future
dim filter as c 'do i need this
dim hdr as p
dim items as p
dim ol as p
dim soh as p
dim old_parent as b
dim count_items as n
dim i as n
hdr=table.current(1) ' this is the inv hdr
items=table.current(2) 'this is the order items to be copied
ol=table.current(3) 'this is the inv items
items.filter="quantityshipped" 'trying to filter items to be copied
items.order=""' ?
items.query()' ?
'items.index_primary_put("qs") 'this sets the index/filter for the items copied
'but creates problems w/inv totals
count_items = count(Sol3->Order_No,GRP->INVHDR3)
'the rest of the script creates the blob and copies the items
this script was borrowed from dr. wayne and works well
it copies line items from "sales order" to an invoice
the order lines have 2 field "ordered" & "shipped"
when the invoice is entered the "shipped" on the invoice line items is
posted the shipped field on the order line item
(by orderno & line no)
some invoices do not have all the items shipped
when the next inv is prepared for the same order,
it should filter out those order lines that ordered shipped
and not copy them to the inv line
the index filter that i had works as far as filtering those items to
be copied, but plays havoc on the inv totals because the filter is still
active??
i did not show the whole script because the rest creates the blob and
copies the line items
this all works, no problem and my deepest thanks to dr wayne for showing
the way
i just want to filter the order items to be copied
again, researched the board, which is great, pick up so much,
but could not find anything close to adopt
appreciate all help in the past and future
dim filter as c 'do i need this
dim hdr as p
dim items as p
dim ol as p
dim soh as p
dim old_parent as b
dim count_items as n
dim i as n
hdr=table.current(1) ' this is the inv hdr
items=table.current(2) 'this is the order items to be copied
ol=table.current(3) 'this is the inv items
items.filter="quantityshipped" 'trying to filter items to be copied
items.order=""' ?
items.query()' ?
'items.index_primary_put("qs") 'this sets the index/filter for the items copied
'but creates problems w/inv totals
count_items = count(Sol3->Order_No,GRP->INVHDR3)
'the rest of the script creates the blob and copies the items
Comment