Copy and paste this to SQL Server Enterprise Manager:
select distinct a.custnmbr,a.LSTTRXDT,a.lsttrxam,b.sopnumbe
from rm00103 a
join sop30200 b
on a.custnmbr = b.custnmbr and
a.LSTTRXDT = b.docdate
/* show in ascending order */
order by custnmbr asc
This blog was created to help Program leads, solution architects and administrators of different enterprise solutions including ERP, CRM, SCM, WMS, PLM, Business Intelligence and many more.
Tuesday, September 15, 2009
Subscribe to:
Posts (Atom)
e-Commerce discount types
In the world of retail today every retailer is trying to find ways and be creative to attract online customers. To attract your attention an...
-
The first time that you log in to Microsoft Dynamics GP 9.0, you can select to have default information that is specific to your job display...
-
This month Microsoft announced the availability of Dynamics GP 2013 demo which you can download here . Most of the improvements were geare...
-
I've filled out the survey and chose the functionalities I think would benefit a lot of industries. Below is a summary of the survey I s...