in Module "ReadRecordFromCreditorID".
I've had a quick poke around, but can't find any orphaned CurrencyID values; and certainly all creditors with non-null CurrencyID have a valid one.
Any suggestions on where to look?
SELECT RecID, Name, ShortName, DecimalPlaces, IsEnabled, IsLocal FROM FX_Currency WHERE RecID = (SELECT CurrencyID FROM CR_Main WHERE CreditorID = @CR_Main_RecID)
pricerc wrote:It's 7.1 SR5.
pricerc wrote:There are lots of null CurrencyID records in CR_Main.
Can I just set them all to our local currency?
pricerc wrote:My bad - SR6.
Mike.Sheen wrote:pricerc wrote:My bad - SR6.
No it isn't.
We didn't have service releases for 7.1!
Return to Technical and or Programming
Users browsing this forum: No registered users and 12 guests