<strong style="color: red;">Notice:</strong>
- * This template has not yet been translated into English and Spanish.
This template has two data marts with information fully integrated with ERP Pronto or Omega Cloud with automatic daily updates.
The first data mart has several global metrics such as monthly and daily invoicing evolution, main customers, main salespeople, evolution of inventory levels, aging of accounts payable and receivable.
The other datamart contains billing information as follows: - invoice issue date;'''Metrics Data Mart'''
- company code; Has several global metrics such as:* monthly and daily invoicing evolution, * main customers, * main salespeople, * evolution of inventory levels, * aging of accounts payable and receivable.
- branch code;
- '''Billing Data Mart informations:''' * invoice issue date;* company code; * branch code; * invoice and item number; - * type of movement code and description; - * products groups descriptions (Levels 1, 2, 3 and 4); - * product code; - * product description; - * customers fancy name; - * customer city; - * customer state; - * customer's country; - * seller; - * product sales unit; - * sold amount; - * gross value; - * discount; - sum of * total taxes (ICMS, ICMS SUBST, PIS and COFINS); - * commissions; - * total amount deducted from discounts, taxes and commissions; - * product cost; - * profit margin ; - * PIS value; - * Cofins value; - * ICMS value; - * ICMS ST value; - * IPI value; - * profit margin %; - * average Net value; - * average Total value.
<strong style="color: red;">Important:</strong>: In order to use your data in this template, you must to get in touch with us:
* Company: Sadig* Business contact* E-mail: comercial@sadig.com* Phones: 11 4331-1062 / 51 3632-5300
