Hi, Experts,
I am generating a query to connect each BP with some certain accounts. Should anyboday tell me the code of the BP code field?
For example,
When I was generating the query to Get BP Code of Last AP Invoice, the query statement is:
Select top 1 T0.CardCode from OPCH T0 order by T0.DocNum desc
the code of the document # is 'T0.DocNum', and the talbe name is 'OPCH'.
Thanks!
Lorrie