edgaracarneiro / feup-sinf Goto Github PK

Ordering by "TotalDeb" leads us to the suppliers we owe the most money to.

Rewrite Profit Margin as Gross Profit Margin (RFS-CGS)/RFS.

• RFS: Sum of the 7111 and 7112.
• CGS: Sum of 61(check in SNC).

Use this query but filtering by Artigo ( "WHERE Artigo = A0001" for example)

É o atraso no pagamento aos fornecedores. Tem de ser filtrado por Fornecedores e não clientes como está ali. Útil é obter os valores em atraso e os dias que estão em atraso

GET localhost:3000/GeneralAccounts/AccountID/22

ClosingDebitBalance - ClosingCreditBalance
(should be negative)

Route:

GET localhost:3000/GeneralAccounts/AccountID/71

Use "ClosingCreditBalance"

Iterate through LedgerEntries: CashFlow = DebitLine (AccountID: 11X) - CreditLine (AccountID:11X)

This way, we can obtain the profit obtained by selling a product unit ( PCMedio - PricePaid).

It can also be interesting to get the AvgProfit and the current Profit (PCMedio vs PCUltimo)

GET localhost:3000/GeneralAccounts/AccountID/62

Use "ClosingDebitBalance"

Route:

localhost:3000/GeneralAccounts/AccountID/61

Use "ClosingDebitBalance"
(debit -> positive cashflow)

By making the average of all product's AIP I can obtain the global average AIP.

Find the Top Clients, instead of the current Top Sales table.

Can use a pie chart to represent that information.

Get data regarding a given supplier

By selecting the ones that have not yet been deliverable. Can also show the ones that are late.

By obtaining Product's pvp prices, I can easily plot this throughout a timeframe.

Find Data regarding a Consumer.

From what I heard, it is possible to get is NIF and other 'personal' data.

Represented either with pie chart or table or bar graph.

Ordering by "TotalDeb", possible use for the "Situacao" and "ModoPag" that must mean in Numerary or Deposit (?)

GET localhost:3000/GeneralAccounts/AccountID/11

Cash in hand == (ClosingDebitBalance - ClosingCreditBalance)

SELECT Artigo, Descricao, PCMedio as PrecoMedio, PCUltimo as PrecoUltimo FROM Artigo
Could be useful (?)

Transactions with the respective SNC code.

Missing PVP from Artigo Moeda table.

GET localhost:3000/GeneralAccounts/AccountID/21

ClosingDebitBalance - ClosingCreditBalance

GET localhost:3000/GeneralAccounts/AccountID/72

Use "ClosingCreditBalance"

By iterating through all the products, one can obtain all purchases made to providers.

Try to find something related to balance sheet to populate financial dashboard 😑

Extract EBIT and Ebitda from General Ledger Entries.

EBITDA = (71+72)-(61+62+63)

Find, if possible, a useful kpi for the procurement view.

Either make them optional, delete them, or fill in all values.