Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Item NOT printing on PURCHACE ORDER 2

Status
Not open for further replies.

johnny45

Technical User
Nov 8, 2006
136
0
0
CA
I created a Purchase order with many items.
One of the Items on the PO DOES NOT PRINT....
If I query the PO this item shows up in the results...

However when I go to print the PO this Items does not show up in the print out.

I verified the Item and it is like all the others that print out on the PO.

The Total dollars and units reflect (include) the Item that does not print out...

I even tried a new PO and just tried to put the Item which does not print out and the Item still does not show up.....

Does anyone have any sugestions ?
 
What is different about the item?
Non stock, non inventory, inactive, ...
 
Nothing seems different...
I compared to a few items that print and I see no difference....

I even deleted the item form the PO and re inserted it...
 
Again, Thank You BOTH for the imput.

Yes I spend alot of time to come up with the fact that yes a custom PO is being used.

Funny that ONLY SEEMS to be this one item that is problamatic.

I tried the STANDARD PO and this anomaly Item PRINTS OUT !!!!

So I guess tuba2007 is correct in maybee the custom form is problamatic....

Not sure how to proceed...

 
Look at the links between the tables in the custom report, the problematic item is being excluded from the report because of these links.
 
I got it...
I checked the link on the table I suspected....and sure enough I changed the link from inner join to left outer join(the only other option available)...and VOILA the Item prints....

Thank You again ettienne & tuba2007 for all you efforts in helping and pointing me in the right direction...

Cheers :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top