Vendor Pending Transactions

weixin_34111790

于 2019-07-04 13:02:11 发布

阅读量1.1k

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/GoDevil/archive/2008/08/08/1263796.html

本文介绍了一个快速函数，用于验证特定供应商是否有待处理的交易。通过查询凭证和支付凭证交叉引用表，该函数能确定供应商是否存在状态为'P'、'R'且未关闭的交易，以及是否被选中或标记为负数凭证总和。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

A quick function that will allow you to verify if a specific vendor has any pending transaction(s).

Function vendor_pnding_transactions();

      &VENDOR = VENDOR_ID;

      SQLExec("select 'X' from ps_voucher a, ps_pymnt_vchr_xref b where a.voucher_id = b.voucher_id and a.business_unit = b.business_unit and a.vendor_id = :1 and a.entry_status in ('P', 'R')and a.close_status = 'O' and b.pymnt_selct_status in ('N', 'D', 'R')", &VENDOR, &EXISTS);

      If All(&EXISTS) Then

         Error Messagebox(0,"",0,0,("Vendor has pending transaction(s).");

      End-If;

End-Function;