PO Subtotal
rwahlert asked 9 years ago
Has anyone else sen this before and is able to reply with a solution?
Thanks.
Ralph
Walt Herman answered 4 years ago
First thing I did was to run the SQL statement against the SmartConnect database which eliminated the field being required.
UPDATE SmartConnect..[Field] SET Required = 0 WHERE Node = 'taPoHdr' AND TechnicalName = 'SUBTOTAL'
Step 2 was to mark the “Update if Exists” field to TRUE in the PO Header node.
End of story till it no longer is! LOL! Thanks…
KB answered 12 months ago
i know a very old post, but wanted to say thanks to walt herman for his reply, this solved the issue i was having with trying to raise purchase orders using smartconnect 2021
the table structure has changed slightly, but the above answer gave enough information for me to make the change
i find it staggering that 3 years on that this field is still set to be required by default, when quite clearly it should not be.
Mark Wiley answered 2 months ago
I’m on SmartConnect 21 and this is the correct scripts for this version:
–To view:
select *
from SmartConnect..MsGpField AAA
join SmartConnect..MsGpNode BBB
on AAA.NodeId = BBB.MsGpNodeId
where BBB.Name = ‘taPoHdr’
and AAA.TechnicalName = ‘SUBTOTAL’
–To change:
update AAA
set Required = 0
from SmartConnect..MsGpField AAA
join SmartConnect..MsGpNode BBB
on AAA.NodeId = BBB.MsGpNodeId
where BBB.Name = ‘taPoHdr’
and AAA.TechnicalName = ‘SUBTOTAL’
Ralph,
I would set your destination to Dynamics GP- File and run the map so you are able to see the data in xml format. Maybe there is something going on in the background that you can't see or haven't picked up on in your original data.