Jump to content


Click the link below to see the new game I'm developing!


Photo
- - - - -

How to write this SL / PROIV report


6 replies to this topic

#1 Vol Yip

Vol Yip

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 393 posts
  • Gender:Male
  • Location:Hong Kong

Posted 31 August 2005 - 07:11 AM

All,

Needs some insight on the following requirements.

I need to write a SuperLayer report which prints open SO and open PO status.

Open SO info from OPENSO files.
Open PO info from OPENPO files.

I need to write a report, which sort by Item, by SO delivery date with the following layout:


SO Del date SO No. Avail Qty SO Open Qty PO Due Qty PO Sch date
=======================================================

Since SO and PO are coming from 2 sources, I am planning to create a temp file to prepare for the report.
But even the temp file can hold SO and PO at the same time, at most I can think of the layout will be:

010905 xxxxx xxxxx xxxxxx :D

Thanks,

Vol

Edited by Vol Yip, 31 August 2005 - 07:14 AM.


#2 Steven Torrance

Steven Torrance

    Advanced

  • Members
  • PipPipPip
  • 52 posts
  • Gender:Male
  • Location:Edinburgh, United Kingdom

Posted 31 August 2005 - 07:45 AM

Vol,

I did a similar report a while back.

The workfile only held the first line of the report per SO item, and held the first item from the PO.
I used an LU to find the first PO item (if it exists!) and add it to the workfile.
Workfile has as the key COMP, SO_NUM, SO_ITEM. It has as fields PO_NUM and PO_ITEM. You would also put in a PO_COMP if it could differ from the SO COMP.

For each line on the main report, run an LR that deselects the first PO line (as it has already been printed as part of the main report), but prints the rest.
(In select logic
IF #FIRST = 0 THEN
DSEL
ENDIF
#FIRST = 1

The LR takes as parameters the COMP, SO_NUM and SO_ITEM

It is important that you have the same sort order on the LR and on the LU!!!!

It's not very nice - but works. :D

Steven

#3 CSuarezdelReal

CSuarezdelReal

    Advanced

  • Members
  • PipPipPip
  • 91 posts
  • Gender:Not Telling

Posted 31 August 2005 - 03:46 PM

Hi Vol!

Steven's advice is nice, but I would think it misses Open PO details when no SO is associated. As per my understanding, you want ALL the OPENSO records along with ALL the OPENPO records printed in a single report.

Also, I would think the relationship between Open PO's and SO's would be many-to-many.

I would split the report into two main PS, without using working files. Since your customer doesn't seem to want several PO dates presented on the same line, SO lines would repeat if the SO Item appears in several PO's. The first PS loop would read ALL the OPENSO file sorted by Item and SO delivery date and an inner PS would read OPENPO based on the Item; this inner loop would actually print the report line as you depict.

When this PS finishes, I would add another PS loop to read ALL the OPENPO file, then I would DSELF if the PO item appear in ANY OPENSO record (using something like the LU Steven mentioned), printing the report line the same way as the previous one to nicely fit on columns.

If you do not want this clearly splitter report (as if you whish to strictly sort your report by delivery date for both, SO and PO), you can define a temporary file with index "Delivery Date" plus "Item" (and probably SO Line plus PO Line) and populate this table using an Update process similar to the one I described. Out of this temp file you would run your report.

Does this make sense to you?.

Regards,

Claudio Suarez del Real "It is not the strongest of the species that survive, nor the most intelligent, but the ones most responsive to change."


#4 Vol Yip

Vol Yip

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 393 posts
  • Gender:Male
  • Location:Hong Kong

Posted 31 August 2005 - 05:22 PM

Hi,

Thanks for all the replies.

This is a backorders by item report. User wants to see, for each Item, what is the outstanding SO and PO, if any.

I.e., I would expect the report will some what like:

Item A

010505 xxxx xxxxx xxxxx yy 050605
010705 xxxx xxxxx xxxxx yy 090905
........................................ yy 120505

Item B
010805 xxxx xxxxx xxxxx yy 121205
111105 xxxx xxxxx xxxxx



in the above example, there are 2 open SO and 3 open PO for item A
2 open SO and one open PO for item B

where, there could be no SO for an item but it has open PO, the report may need to show as:

Item C
yy 010105

But I am guessing user may not want to see Item C if there is no Open SO. I am checking this with user.

I am still digesting all your suggests on how to implment them into my requirement.....

Regards,

Vol

#5 Vol Yip

Vol Yip

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 393 posts
  • Gender:Male
  • Location:Hong Kong

Posted 06 September 2005 - 04:58 PM

All,

I need some more help on this. Let me elaborate again my requirement.

For example, for Item A, it has 3 open SO. (in OPENSO file)

SO 111, Del date 01/10/05, Qty 100
SO 123, Del date 10/10/05, Qty 200

and it has 3 Open PO, (in Openpo file)

PO 787, Sched date 25/09/05, Qty 100
PO 789, Sched date 05/10/05, Qty 150
PO 888, Sched date 30/10/05, Qty 100

For Item B, it has 2 open SO

SO 222, Del date 11/11/05, Qty 10
SO 333, Del date 12/12/05, Qty 20

and it has 1 open PO

PO 999, Sched date 12/12/05, Qty 2

I want to create a report which prints:

SO Del date Qty PO Sched date Qty
----------------------------------------------------------------------

Item A: Item description of A

111 01/10/05 100 787 25/09/05 100
123 10/10/05 200 789 05/10/05 150
.............................888 30/10/05 100

Item B: Item description of B

222 11/11/05 10 999 11/11/05 2
333 12/12/05 20

Item C and so on

I am not sure how a 2 /PS/ group function can fullfil this. Could anyone give me more hints?

Regards,

Vol

Edited by Vol Yip, 06 September 2005 - 05:00 PM.


#6 Steven Torrance

Steven Torrance

    Advanced

  • Members
  • PipPipPip
  • 52 posts
  • Gender:Male
  • Location:Edinburgh, United Kingdom

Posted 07 September 2005 - 02:51 PM

Vol,

This can get very messy from the business point of view.

What if PO789 arrives before PO787? The report starts to tell lies!
Scenario 2: PO787 is short delivered by 5 pieces and is closed off.

What you are really trying to achieve here is committing a quantity off of a Purchase Order to a Sales Order - but without actually doing it!

I'm sure that with some smart pieces of logic that go back through your workfile in a recursive manner you could achieve this - but I would try and put the above scenarios to the customer and explain why the report is a bad idea!
Too many holes, and any user not fully understanding the implications could cause big stock problems!

Steven

#7 Vol Yip

Vol Yip

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 393 posts
  • Gender:Male
  • Location:Hong Kong

Posted 08 September 2005 - 03:54 AM

Hi Steven,

I see what yours concerns.

This report is purely a backorder by item report which tells user what are the outstanding SO delivery and what are the expected replenishment from open PO.

User just wants to see 2 groups of information aglin beautifully besides one group (SO) prints and then the other group (PO) prints below the previous one.

:lol:

Regards,

Vol



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Click the link below to see the new game I'm developing!