450
I need to get a few more fields on the PO that don't seem to be in the line rollup temp table but are on the PO Line in sql. These two to start: PRMSHPDTE, Purchase_IV_Item_Taxable.
Also if anyone knows why the Company Name would not show up on the Ship To side, it is an address from one of the sites and I though it would bring thru the overall company name or maybe even the description of the site, but nothing.
*This post is locked for comments
Hi Nancy,
When a temp table is created for default reports in Report Writer it is usually so the code behind the report can avoid 'one-to-many' table relationships, which may have been the case with the original design if the PO Line table is not a default table option.
Such table links may cause issue in RW as it is a one-pass system and doesn't have the ability to 'go back' into processed report data to recalculate additional field content for display; instead it gathers, calculates, displays and then empties a singular line of data before moving on to repeat the process on the next line.
As such, even if can link the table successfully chances are the code will not be able to pick it up correctly afterward.
However, if the fields are necessity you can always test linking the additional table to see if you can get a consistent result to use in production.
You are correct you will also have to create relationships from existing tables to create such an table availability. The best description of this feature is Chapter 12 (Table Relationships) of the Report Writer user guide.
Best Regards,
Jeff
Unfortunately Purchase Order Line table is not available off the Purchase Order Line Rollup Temp in the already defined list and I don't know how to define the relationship. The only tables I have available to add from the PO Line Rollup Temp are POP PA PO Line View and the Hist View. I tried them and those fields are not on those tables. Any idea why the PO line table isn't there?
Hi Nancy,
As Leslie noted, you will want to connect to the PO Line (POP10110) table for the additional detail. Regarding the Send To Company name not pulling in I'm not finding any known issues on that but as a workaround you should be able to replace the Company Name field with the Vendor Name field from the already linked PM Vendor Master to get a more consistent result.
Best Regards,
Jeff
Hi Nancy,
For the fields you want (PRMSHPDTE and Purchase_IV_Item_Taxable), you need to add the Purchase Order Line table to your report. Click New on the Purchase Order Line Rollup Temp and add the table Purchase Order Line. Both fields you want exist in the Purchase Order Line table. The fields are named 'Promised Ship Date' and 'Purchase IV Item Taxable'.
Kind regards,
Leslie
Thanks I wasn't sure how to do that I do see Purchase Order Line Temp in the tables off of Purchase Order Line Rollup Temp, its that it, since it said Temp I never tried it, I guess I should have. If it is not the correct choice could you let me know what is or how to add, thanks for you help.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (