问题描述
因此，我现在正在使用Dynamics GP 2013中的表单，该表单未在表单的列表中公开显示项目的行项目顺序，并且正在寻找找到此数字的正确方法，以便我可以通过它与SQL查询一起在表格中查找非常具体的项目.我知道订单项序列是16384的倍数，但是在这些形式中，似乎有一种已知的方式将其传递给每个单独项目的SQL查询.有些订单仅列出一个项目，在这种情况下，显而易见的是，但我们正在谈论的是成千上万个不同的订单，范围从一个订单项到多达一百个订单项，我需要能够找到当该项目成为焦点时，每个项目的确切行.有没有人遇到过类似的问题，您试图在其中查询包含订单项序列和SOP编号的SQL表?
So I am now working with a form in Dynamics GP 2013 that does not openly display the line item sequence of an item in a list on the form, and am looking for the proper way to find this number so that I can pass it along to a SQL query to find a very specific item among a table. I know the line item sequence is a multiple of 16384, but in these forms, there seems to be know way to pass that along to the SQL query for each individual item. Some orders have just one item on the list, by which in those circumstances it is obvious, but we are talking about thousands of different orders, that range from one to upwards of a hundred line items, and I need to be able to find the exact line for each item when that item is brought into focus. Has anyone had a similar issue like this, where you are trying to query an SQL table with the line item sequence and SOP number?
推荐答案
您必须使用参数sop编号和sop类型查询销售明细表(sop行)，此外，如果您知道该商品，也可以将其包含在where子句中，因此查询将列出所有项目或所选项目的行数.
You have to query sales detail (sop line) table with parameters sop number and sop type, further if you know the item you can also include it in where clause, so the query will list down all the items or no of lines for the selected item.
选择*从SOP10200其中SOPTYPE = 3AND SOPNUMBE ='STDINV2338'
SELECT * FROM SOP10200where SOPTYPE=3AND SOPNUMBE='STDINV2338'
SOP Type= 3 is for Invoice
2 for Order
1 for Quote
如果您也知道商品编号.
If you know item number too.
SELECT * FROM SOP10200
where SOPTYPE=3
AND SOPNUMBE='STDINV2338'
AND ITEMNMBR='URG001'
如果您知道项目说明等其他信息，也可以查询.
If you know any other information like description of item etc, you can also query.
SELECT * FROM SOP10200
where SOPTYPE=3
AND SOPNUMBE='STDINV2338'
AND ITEMDESC='Green Phone'
这篇关于Microsoft Dynamics GP 2013:如何查找订单项序列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！