u/sheravy

Hi all,

I'm trying to access the allocatedSupply table through NetSuite2.com (ODBC) and have run into some strange behaviour.

Our company has two NetSuite instances. I have been granted what appears to be the same permissions in both instances. When running SuiteQL directly in the NetSuite UI, I can successfully query allocatedSupply in both environments:

1. SELECT * FROM allocatedSupply

2. SELECT TOP 5 * FROM allocatedSupply

Both return data as expected.

However, when I run the same queries through the NetSuite2.com ODBC driver:

• Instance A returns an empty table. Interestingly, it includes all the columns I see in the UI plus some additional columns.
• Instance B returns "Base table allocatedSupply was not found"

I've also tried joining allocatedSupply to transactionLine, but that either returns no data or produces the same error.

A few things I'm wondering:

• Is allocatedSupply actually supported through NetSuite2.com ODBC?
• Are there any known limitations where a table is available in SuiteQL but not through ODBC?
• Could this be permission-related even though I can query it from the UI?
• Has anyone found an alternative way to retrieve allocated supply information?
• Any ideas why two instances would behave differently with the same user permissions?

Any suggestions or workarounds would be greatly appreciated. Thanks!

Hi Chch-ians, I wonder if there are anyone have some data on the monthly performance on the solar systems that the panels only face to the east and the west?

As our main roof contains asbestos, so we can only have the solar panels installed on our garage roof. However, the roof face to the west and the east.

Thanks in advance for sharing your experience

Edit: typo

For anyone who wants to try making sourdough bread by themselves and try to make sourdough starter, but a bit budget tight, try to mix the all purpose flour with some wheat germs from scratch, and use cooled-down boiled water.

I’m not sure if you can start with 30g flour + wheat germs + 30g of water, as I started from 60g+60g without wheat germs, and I was struggled to get the starter grow due to the low temperature in CHCH, even I put it on the top of my fish tank where is always quite warm. But after I added wheat germs, the growth after feeding is much quicker and stronger.

After 1 month (including 2weeks of struggles), my starter is stably strong enough to make sourdough for me. And as I only need up to 70g of starter each time as I only use 350g of high grade flour to make it, so I only leave 20g of starter in the jar every time I finish making one, then put it into the fridge. Before its hibernation, I normally put a tiny bit of water and wheat germs in the jar, mixed well.

I also try the “oven light on” trick to provide the warm environment for my starter’s growth before making dough, and it works.

I know one recipe can use the starter discard to make sourdough bread without adding any commercial yeast, but I guess it requires strong starter, and I haven’t tried yet.

Also, now I don’t follow any recipes for basic sourdough bread now even I only have made 2, because 2 of great instructional YouTube videos articulate the ratio of components so well that you can always make your own recipes based on your knowledge on your flour.