Hello:
In the POP10100 table, there is the "Remaining PO Subtotal" field. Is there a way of showing this "broken out" by that purchase order's line item and to do so in SmartList Designer?
Thank you!
John
*This post is locked for comments
Thank you, Shannon!
Yes, this is very helpful!
John
Hi John,
The OPOSTSUB field in the POP10110 table will show the amount for each line item that is Posted against the Extended Cost for each line item on the PO. So you could pull the OPOSTSUB and EXTDCOST fields from the POP10110 table and the amount that is remaining to be posted can be determined from those two fields and that should match the POP10100 REMSUBTO field. For example:
I have a PO with three line items on it PO2056, here is the select statements for those fields and a screenshot of the results:
select REMSUBTO, SUBTOTAL, * from POP10100 where PONUMBER = 'PO2056'
select OPOSTSUB, EXTDCOST, * from POP10110 where PONUMBER = 'PO2056'
I hope that information helps.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
