Announcement

Collapse
No announcement yet.

Get Journal for Specific Order #

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Get Journal for Specific Order #

    Is there a way to get Update 'UB' journal records for a journal date range Jan 31 - Feb 1, for my order table, for a specific order # ?

    like FROM MYORDERS WHERE ORDER# = 123456

  • #2
    when you work with a journal, all your file data is dumped into 1 field JOESD. This article explains how to copy your journal receiver to a fully defined data base. then you can use SQL for journal stuff like UB as well as data stuff like order = 12345
    https://www.mcpressonline.com/progra...-made-readable

    Comment


    • #3
      Thanks !

      Comment

      Working...
      X