Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Search found 3 matches
- 25 Jan 2021, 08:24
- Forum: Sage 50 UK version General Help
- Topic: Inactive stock flag ODBC
- Replies: 9
- Views: 7772
Re: Inactive stock flag ODBC
Thanks for the suggestion. Just tried the 32bit odbc driver (and i'm running access for off365 32bit version) but no different i'm afraid. Strangely other fields showing in your screen grab are not present in my STOCK fields exposed via either 32 or 64bit odbc (eg I can't see DISC_E_LEVEL10_RATE, PU...
- 22 Jan 2021, 11:57
- Forum: Sage 50 UK version General Help
- Topic: Inactive stock flag ODBC
- Replies: 9
- Views: 7772
Re: Inactive stock flag ODBC
Thanks for fast reply but I've scoured the STOCK table via ODBC so many times now (via table linked into an Access dbase) There's no field of that name or similar in what i'm seeing. I've got INTRASTAT_COMM_CODE, INTRASTAT_IMPORT_DUTY_CODE, IGNORE_STK_LVL_FLAG But not INACTIVE_FLAG I'm using Sage50 ...
- 22 Jan 2021, 09:11
- Forum: Sage 50 UK version General Help
- Topic: Inactive stock flag ODBC
- Replies: 9
- Views: 7772
Inactive stock flag ODBC
Hi, Trying to find the table/field through ODBC that shows when a stock item is marked as inactive. I assumed it would be in STOCK (just as the IGNORE_STK_LEVEL_FLAG is when stock level control is turned off which has 0 or 1 to designate) But I can't find it in STOCK or any other likely tables. Than...