2009年2月26日星期四

This is a terrible week

A terrible Week in my life! and a unhappy birthday.

2009年2月23日星期一

Free tool for viewing/testing JDE Objects

JDE Objects Browse
Author:Craig Welton
Version:1.0
Latest Update: 2/9/2009

Object Browser for XE through E90. Examine and test JDE objects from a simple, intuitive framework.
Current Features:
  • Updated user interface with dockable panes
  • Business Function testing
    • Paste parameters from clipboard (copied from jdedebug.log)
    • Save/Load parameters to/from a file
  • Data Browser for tables and business views
  • UBE Launcher with report interconnect values
  • Data Structure spec browsing
  • Table spec browsing
  • Business View spec browsing
  • Integrated Data Dictionary property tool
Download site:
http://www.patwel.com/downloads/index.htm

Objects View(APPL,BL,BSFN,BSVW,DSTR,GT,TABLE,UBE):

Data Browse

Test UBE

Test BSFN:
BSFN Specification(View Attachment):



2009年2月22日星期日

2009年2月5日星期四

Inter company sales Report

Report ID:R4210IC, The data can be filter in following:
BC Date -Actual Ship Date (F4211) is equal to Null (DD:ADDJ) OR
BC Status Code -Next (F4211) is equal to "999" (DD:NXTR) OR
BC Document - Original (F4211) is not equal to Zero (DD:ODOC) OR
BC Sales Order Status 15 (F4211) is equal to "1" (DD:SO15) OR
BC Other Quantity (1/2) (F4211) is equal to "1,2" (DD:OTQY) OR
BC Units - Future Quantity Committed (F4211) is not equal to Zero (DD:SONE)

BC Inter Branch Sales (F4211) is not equal to "2"
And (DD:SO01)
BC Inter Branch Sales (F4211) is not equal to "4" (DD:SO01)