Sales Order Backlog Report

system · January 30, 2012, 7:22pm

The BkLog XML datatable is generated at runtime by the SO Backlog reporting 4GL program. The problem seems to be that the zDataField records for that DataTable are set to External = true which is incorrect.

Run the following SQL to make the BkLog fields available to link to:

UPDATE zDataField
SET External = 0
WHERE DataTableID = 'BkLog' and External = 1

--- In vantage@yahoogroups.com, "Patrick Parker" <pbparker@...> wrote:
>
> So, a question for the sales order backlog report in 8.03.404 for
> anyone that can help. It's now a Crystal report, the data definition
> is listed as SOBacklog.
>
> I'm trying to modify it because it's pulling in a ShortPartNum which
> truncates the part numbers after so many characters. We need the full
> length part numbers in the report.
>
> However, when I go to the report definition, it's referencing a table
> called BkLog - which doesn't exist in the database as far as I can
> see. Anyone know either where this table is or how I can
> access/modify how the data is being populated. Would like to get full
> part numbers listed in our report.
>

system · February 23, 2006, 3:42pm

Anyone know what table are used for this report?

system · February 23, 2006, 3:53pm

There may be others, but The OrderHed, OrderRel, OrderDtl, Customer are
the main ones. ProdGrup
And SalesTer are also in there for added filtering.

system · February 23, 2006, 3:54pm

Customer, OrderHed, OrderDtl, OrderRel

-----Original Message-----
From: Ace_Man <ace_man@...>
To: vantage@yahoogroups.com
Sent: Thu, 23 Feb 2006 20:42:20 -0000
Subject: [Vantage] Sales Order Backlog Report

Anyone know what table are used for this report?

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.

(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links

[Non-text portions of this message have been removed]

system · February 23, 2006, 3:56pm

I use Customer, OrderDtl, OrderHed, OrderRel, and ShipTo

-----Original Message-----
From: Ace_Man [mailto:ace_man@...]
Sent: Thursday, February 23, 2006 3:42 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Sales Order Backlog Report

Anyone know what table are used for this report?

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

SPONSORED LINKS

Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>

Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>

_____

YAHOO! GROUPS LINKS

* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .

_____

[Non-text portions of this message have been removed]

system · February 23, 2006, 4:39pm

Thanks for everyone that responded.. that helped a lot.

system · April 13, 2007, 12:01pm

We're running Vantage 6.10, I've been asked to 'revise' our standard Sales Order Backlog report, the problem is I can't find it!
Not available thru Report Style Maintenance, I'm guessing that it is non-editable, buried in the application.

Can anyone shed any light?

---------------------------------
Ahhh...imagining that irresistible "new car" smell?
Check outnew cars at Yahoo! Autos.

[Non-text portions of this message have been removed]

system · April 13, 2007, 12:47pm

Order Management/reports. Make sure you have the user rights to see it.
The info for the menu structure maintenance under utilities is:

Parent Menu ID: OMMN400
Order Sequence: 20 Enabled is checked
Security: the same as other Order Management Reports have. You can
customized with Menu Security later.
Program: Check Menu Item, Program Name: om/omr40.w and check mark Run
Persistent.

Is there a possibility that the program was deleted? Good luck.

Mario E. Aguirre - IT Manager
Lakin General Corporation, Inc.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of Bill Jackson
Sent: Friday, April 13, 2007 10:33 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Sales Order Backlog Report

We're running Vantage 6.10, I've been asked to 'revise' our standard
Sales Order Backlog report, the problem is I can't find it!
Not available thru Report Style Maintenance, I'm guessing that it is
non-editable, buried in the application.

Can anyone shed any light?

---------------------------------
Ahhh...imagining that irresistible "new car" smell?
Check outnew cars at Yahoo! Autos.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

system · April 13, 2007, 1:22pm

The Sales order backlog is a progress report which is un-editable. It can
be duplicated in Crystal or Progress report builder. If you dup it in
report builder, be advised report builder ceases to exist beginning with
Vantage 8.0 and Open Edge 10.

Stan

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mario Aguirre
Sent: Friday, April 13, 2007 12:47 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Sales Order Backlog Report

Order Management/reports. Make sure you have the user rights to see it.
The info for the menu structure maintenance under utilities is:

Parent Menu ID: OMMN400
Order Sequence: 20 Enabled is checked
Security: the same as other Order Management Reports have. You can
customized with Menu Security later.
Program: Check Menu Item, Program Name: om/omr40.w and check mark Run
Persistent.

Is there a possibility that the program was deleted? Good luck.

Mario E. Aguirre - IT Manager
Lakin General Corporation, Inc.

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of Bill Jackson
Sent: Friday, April 13, 2007 10:33 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Sales Order Backlog Report

We're running Vantage 6.10, I've been asked to 'revise' our standard
Sales Order Backlog report, the problem is I can't find it!
Not available thru Report Style Maintenance, I'm guessing that it is
non-editable, buried in the application.

Can anyone shed any light?

---------------------------------
Ahhh...imagining that irresistible "new car" smell?
Check outnew cars at Yahoo! Autos.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

system · February 27, 2008, 5:05pm

So, a question for the sales order backlog report in 8.03.404 for
anyone that can help. It's now a Crystal report, the data definition
is listed as SOBacklog.

I'm trying to modify it because it's pulling in a ShortPartNum which
truncates the part numbers after so many characters. We need the full
length part numbers in the report.

However, when I go to the report definition, it's referencing a table
called BkLog - which doesn't exist in the database as far as I can
see. Anyone know either where this table is or how I can
access/modify how the data is being populated. Would like to get full
part numbers listed in our report.

system · March 5, 2008, 2:24pm

Still trying to figure this out if anyone has any idea.

I was able to get the long part numbers to appear by adding the
OrderRel table to the list of tables included. However I'm now trying
to get the OrderReqQty value to show on each entry so the backlog
report can display how many are ordered for each release.

The XML that comes from the report loops through the BkLog table for
each order entry, and I'm unable to get any other table linked in to
the looping mechanism. Any new table/field linked into the report only
displays at the top as a header with no values.

--- In vantage@yahoogroups.com, "Patrick Parker" <pbparker@...> wrote:
>
> So, a question for the sales order backlog report in 8.03.404 for
> anyone that can help. It's now a Crystal report, the data definition
> is listed as SOBacklog.
>
> I'm trying to modify it because it's pulling in a ShortPartNum which
> truncates the part numbers after so many characters. We need the
full
> length part numbers in the report.
>
> However, when I go to the report definition, it's referencing a table
> called BkLog - which doesn't exist in the database as far as I can
> see. Anyone know either where this table is or how I can
> access/modify how the data is being populated. Would like to get
full
> part numbers listed in our report.
>