Hi All, Is anybody using an ODBC? We have an issue that we are unable to find the field “As Of Date” on a Invoice. Looking at the schema for Transacrikns, the only date field is the TransDate which is different.

Is that not a custom label or something? Go to an invoice, add &xml=t to the end of the URL and see if you can see the field name with the date value on that record.

Hey! No, it’s an out of the box field. I have done the trick above as suggested and field still shows as AsOfDate 🙃

Strange, I just ran a column name search against every ODBC table and no results close to that field name and I cant see it in the connect browser either. If you go to Customization > Lists, Records, Fields > Transaction Body Fields ... can you see it listed there?

Please see attached, no it’s not a custom field. I have checked and even the help is the generic out of box help. When I go to customise form screen, it shows as As Of Date too

Thanks, I dont know why that had been turned off on mine. Anyway, looked high and low and can't find this field in ODBC, even searched on any field with the word 'date' in it. Having said that, you can definitely get to it via SuiteScript ... so you could create a custom field, replicate the 'asofdate' value to that field with a script and then pick up the new field via ODBC. Not ideal, but I cant think of another way if they have left it out of the ODBC schema.

Thank you for trying to help! I was going around in loops trying different fields and I reached out to Support, I got the classic reply.... it’s an enhancement request that if it’s not in the schema browser than it’s not supported! Never mind it’s the most important date field on the invoice 🙃🤣 I was thinking too that a work around here is a custom field and do a mass upload to the custom field, the only issue is... I’ll have to get finance to open all the periods again so I will be able to upload to the field since the records are locked when the period is locked! Not ideal 😅

I've worked around something similar before by creating a custom record. Have an invoice id field and asofdate field. Do a mass update , then going forward you could keep the records updated with a user event script.