NetSuite: Avoid posting to Closed Period?

Wondering why can you post to periods that have been closed? E.g. Why is NetSuite allowing you to post to AP when the period is closed? Are you logged in as Administrator? Administrator users have the access to “Override Period Restrictions permission” by default. Create a new role and make sure this permission is removed.

Magento: How to build reporting datawarehouse for Magento?

Disclaimer : Below information is from my experience with Magento platform. Right! so you have experienced the kiss of death by your awesome report or a feed generation in the dead of night ? Why ? Data intensive jobs especially mundane tasks like sitemap/google feeds generation take up lot of your DB power and results
Continue reading Magento: How to build reporting datawarehouse for Magento?

Magento: Sales Order Line Item Schema

@Version 1.0      Table Name: reporting_sales_flat_order_item This table contains information about each line items as described below. If something does not fit into your ecommerce configuration, do give us a shout at info@suiteweekly.com Column title e.g value Description Notes item_id 1280555 Line Item ID This is the ID of the line item and can
Continue reading Magento: Sales Order Line Item Schema

Magento: Sales Order Schema

@Version 1.0      Table Name: reporting_sales_flat_order This table contains information about orders as described below. If some thing does not fit into your ecommerce configuration, do give us a shout at info@suiteweekly.com . sales_flat_order Description entity_id Order ID in Magento state The order state describes the position of an order in the workflow. Can be
Continue reading Magento: Sales Order Schema

Magento: Product Information Schema

@Version 1.0      Table Name: reporting_product_flat This table contains information about each product with all their attributes as described below. If some thing does not fit into your ecommerce configuration, do give us a shout at hello@reckless.io. We do understand many of these attributes do not make sense to your business. This is complete customisable using
Continue reading Magento: Product Information Schema