As configurações para a Faturação Personalizada têm como objetivo a criação de expressões em VB.NET, de forma a serem utilizadas na Emissão Automática de Faturação.
Para criar configurações de faturação personalizada, deverá apenas ser acedido em Menu | Framework | Configuração de Faturação Personalizada. Os registos aqui criados ficarão depois disponíveis na Emissão Automática de Faturação, na opção de Faturação Personalizada, desde que estejam ativos.
IO ecrã de Configuração de Faturação Personalizada está disponível nas gamas Advanced e Enterprise, com Cegid PHC On ativo.
Para conhecer todas as funcionalidades inerentes a este ecrã, serão explicados os campos que compõem a área da Informação Principal.
Visão Geral
Esta área do ecrã é composta pelos seguintes campos:
Descrição: Neste campo, deverá ser indicada a descrição da configuração.
Inativa: Esta opção permite indicar se a configuração está ativa ou inativa. Uma vez inativa, deixa de estar disponível na Emissão Automática de Faturação.
Expressão: Neste campo, deverá ser preenchida a expressão em VB.NET, cujo resultado servirá como origem dos dados para a Emissão Automática de Faturação. Na expressão, deverão ser adicionados os itens da classe FTAutoClass, cujas propriedades estão enumeradas abaixo e têm nome idêntico ao cursor TESTE, disponível no PHC CS Desktop.
Propriedades
Enumeração de todas as propriedades da classe FTAutoClass:
Public Property Docano As Integer
Public Property Stipo As Integer
Public Property Moeda As String = ""
Public Property Oristamp As String = ""
Public Property Ofistamp As String = ""
Public Property Treechkbox As Boolean
Public Property Snstamp As String = ""
Public Property Estab As Integer
Public Property No As Long
Public Property Nome As String = ""
Public Property Nome2 As String = ""
Public Property Ndos As Integer
Public Property bdempresas As String = ""
Public Property Obrano As Integer
Public Property Nmdos As String = ""
Public Property Ref As String = ""
Public Property Design As String = ""
Public Property Qttped As Decimal
Public Property Qttemi As Decimal
Public Property Armazem As Integer
Public Property Ar2mazem As Integer
Public Property Debito As Decimal
Public Property Desconto As Decimal
Public Property Rdata As Date
Public Property Data As Date
Public Property Cobrador As String = ""
Public Property Rota As String = ""
Public Property Serie As String = ""
Public Property Noserie As Boolean
Public Property Desc2 As Decimal
Public Property Desc3 As Decimal
Public Property Desc4 As Decimal
Public Property Desc5 As Decimal
Public Property Desc6 As Decimal
Public Property Nex As Integer
Public Property Bistamp As String = ""
Public Property Descar As String = ""
Public Property Encom As String = ""
Public Property Pcusto As Decimal
Public Property Pcp As Decimal
Public Property Tabiva As Integer
Public Property Iva As Decimal
Public Property Diferido As Decimal
Public Property Tobs As String = ""
Public Property Stock As Boolean
Public Property Trfa As Boolean
Public Property Ivaincl As Boolean
Public Property Litem2 As String = ""
Public Property Litem As String = ""
Public Property Lobs3 As String = ""
Public Property Lobs2 As String = ""
Public Property Nmobs As String = ""
Public Property Etitulo As Boolean
Public Property Composto As Boolean
Public Property Cccrstamp As String = ""
Public Property Tiliquido As Decimal
Public Property Partes As Decimal
Public Property Altura As Decimal
Public Property Largura As Decimal
Public Property Espessura As Decimal
Public Property Lote As String = ""
Public Property Cor As String = ""
Public Property Tam As String = ""
Public Property Ediferido As Decimal
Public Property Etiliquido As Decimal
Public Property Edebito As Decimal
Public Property Epcusto As Decimal
Public Property Epcp As Decimal
Public Property Pvmoeda As Decimal
Public Property Sttexteis As Boolean
Public Property Usalote As Boolean
Public Property Sxstock As Decimal
Public Property Sastock As Decimal
Public Property Lsxstock As Boolean
Public Property Lsastock As Boolean
Public Property Plafond As Decimal
Public Property Eplafond As Decimal
Public Property Saldo As Decimal
Public Property Esaldo As Decimal
Public Property Saldlet As Decimal
Public Property Esaldlet As Decimal
Public Property Fifref As String = ""
Public Property Fincusto As String = ""
Public Property Ficcusto As String = ""
Public Property Fivendedor As Decimal
Public Property Fivendnm As String = ""
Public Property Fref As String = ""
Public Property Ncusto As String = ""
Public Property Ccusto As String = ""
Public Property Vendedor As Decimal
Public Property Vendnm As String = ""
Public Property Cl_vendedor As Decimal
Public Property Cl_vendnm As String = ""
Public Property Cl_fref As String = ""
Public Property Cl_ccusto As String = ""
Public Property Cl_ncusto As String = ""
Public Property Cl_segmento As String = ""
Public Property Cl_tipo As String = ""
Public Property Cl_descarga As String = ""
Public Property Cl_pagamento As String = ""
Public Property Cl_morada As String = ""
Public Property Cl_local As String = ""
Public Property Cl_codpost As String = ""
Public Property Cl_ncont As String = ""
Public Property Cl_pncont As String = ""
Public Property Cl_zona As String = ""
Public Property Cl_moeda As String = ""
Public Property Cl_vencimento As Decimal
Public Property Cl_tpdesc As String = ""
Public Property Cl_tpstamp As String = ""
Public Property Cl_cobranca As String = ""
Public Property Cl_pais As Integer
Public Property Cl_nocredit As Boolean
Public Property Cl_tabiva As Decimal
Public Property Cl_alimite As Decimal
Public Property Cl_eancl As String = ""
Public Property Pscm As String = ""
Public Property Pscmdesc As String = ""
Public Property Zncm As Decimal
Public Property Znregiao As String = ""
Public Property Ptcm As String = ""
Public Property Ptcmdesc As String = ""
Public Property Encm As String = ""
Public Property Encmdesc As String = ""
Public Property Excm As Integer
Public Property Excmdesc As String = ""
Public Property Ntcm As Integer
Public Property Usaintra As Boolean
Public Property St_cpoc As Integer
Public Property St_ecomissao As Decimal
Public Property St_tabiva As Decimal
Public Property St_familia As String = ""
Public Property St_nccod As String = ""
Public Property St_convunsup As Decimal
Public Property St_massaliq As Decimal
Public Property St_usr1 As String = ""
Public Property St_usr2 As String = ""
Public Property St_usr3 As String = ""
Public Property St_usr4 As String = ""
Public Property St_usr5 As String = ""
Public Property St_usr6 As String = ""
Public Property St_iectsug As Boolean
Public Property St_iectin As Decimal
Public Property St_eiectin As Decimal
Public Property Stfami_iectfx As Decimal
Public Property Stfami_eiectfx As Decimal
Public Property Stfami_iectadp As Decimal
Public Property St_ns As Boolean
Public Property St_iecaisref As Boolean
Public Property St_nsujpp As Boolean
Public Property St_amostra As Boolean
Public Property Matricula As String = ""
Public Property Vhstamp As String = ""
Public Property Ftstamp As String = ""
Public Property Mhstamp As String = ""
Public Property Sattotal As Boolean
Public Property Naomexe As Boolean
Public Property Flno As Integer
Public Property Uni2qtt As Decimal
Public Property Unidade As String = ""
Public Property Unidad2 As String = ""
Public Property Classe As String = ""
Public Property Lang As String = ""
Public Property Filtroft1 As Integer
Public Property Filtroft2 As Integer
Public Property iectisento As Boolean
Public Property Xftcheck As Boolean
Public Property Cabiecacodisen As String = ""
Public Property Iecacodisen As String = ""
Public Property Iecasug As Boolean
Public Property Iecagrad As Decimal
Public Property Volume As Decimal
Public Property Peso As Decimal
Public Property Pbruto As Decimal
Public Property Codfiscal As String = ""
Public Property Stiecasug As Boolean
Public Property Stiecagrad As Decimal
Public Property Stvolume As Decimal
Public Property Stpeso As Decimal
Public Property Stpbruto As Decimal
Public Property Stcodfiscal As String = ""
Public Property Cl_niec As String = ""
Public Property Niec As String = ""
Public Property taxpointdt As Date
Public Property Tpdesc As String = ""
Public Property Tpstamp As String = ""
Public Property Agstcstamp As String = ""
Public Property Mrstamp As String = ""
Public Property Mnstamp As String = ""
Public Property Fminstamp As String = ""
Public Property Linhas As Boolean
Public Property Umftmr As Boolean
Public Property Compstamp As String = ""
Public Property Lrecno As String = ""
Public Property Complrecno As Boolean
Public Property Ecovalor As Boolean
Public Property Fiecostamp As String = ""
Public Property Biecostamp As String = ""
Public Property Cativo As Boolean
Public Property Debitoori As Decimal
Public Property Edebitoori As Decimal
Public Property Cl_glncl As String = ""
Public Property Cl_codfornecedor As String = ""
Public Property Cl_localentrega As String = ""
Public Property Ngstamp As String = ""
Public Property Negocio As String = ""
Public Property Descnegocio As String = ""
Public Property Ngstatus As String = ""
Public Property Cl_obsdoc As String = ""
Public Property Etotalciva As Decimal
Public Property Totalciva As Decimal
Public Property Mtotalciva As Decimal
Public Property Qutiporeg As Integer
Public Property Qustampregisto As String = ""
Public Property Csupstamp As String = ""
Public Property Formapag As String = ""
Public Property Cambio As Decimal
Public Property Cambiofixo As Boolean
Public Property Autostamp As String = ""
Public Property Idno As Integer
Public Property Fin As Decimal
Public Property Cl_descregiva As String = ""
Public Property Ecusto As Decimal
Public Property Custo As Decimal
Public Property Linmotiseimp As String = ""
Public Property Codlinmotiseimp As String = ""
Public Property Cl_motiseimp As String = ""
Public Property Cl_codmotiseimp As String = ""
Public Property Motiseimp As String = ""
Public Property Codmotiseimp As String = ""
Public Property Datarect As Date
Public Property Tipodoc As Decimal
Public Property Operext As Boolean
Public Property Cecope As String = ""
Public Property Cl_codpais As String = ""
Public Property Cl_descpais As String = ""
Public Property Oftstamp As String = ""
Public Property Cl_distrito As String = ""
Public Property Multi As Boolean
Public Property ppperiodicidade As String = ""
Public Property ppperiodo As String = ""
Public Property Ppbillingagreement As String = ""
Public Property Ppallowsubscription As Boolean
Public Property Ppallowpaynow As Boolean
Public Property Ppprofileid As String = ""
Public Property Ppsbstamp As String = ""
Public Property Cobradovpaypal As Boolean
Public Property Subscritovpaypal As Boolean
Public Property Cadmintipo1stamp As String = ""
Public Property Cadmintipo2stamp As String = ""
Public Property Cadmintipo3stamp As String = ""
Public Property Cadmintipo4stamp As String = ""
Public Property Motorista As String = ""
Public Property Lioristamp As String = ""
Public Property Stns As Boolean
Public Property Clmodalidade As String = ""
Public Property Modalidade As String = ""
Public Property intid As String = ""Exemplo
Exemplo de uma expressão em VB.NET com o título "Avenças":
'Lista com valores da preparação
Dim Teste = CType(ObjPara, List(Of FtAutoClass))
Dim ClientesFaturar = PhcCommandBuilder.CreateSelect("top 3 no,estab, clstamp").
From("cl").
Where("inactivo = 0").
GetSqlResult
If ClientesFaturar.HaveItens Then
For Each cliente In ClientesFaturar
'Instanciar um objeto para adicionar à lista TESTE e preencher as propriedades com os valores pretendidos
'A aplicação preenche sempre os dados obtidos a partir do artigo e do cliente
With New FtAutoClass
.Docano = Date.Now.Year
.Oristamp = cliente.ItemToString("clstamp")
.No = cliente.ItemToInteger("no")
.Estab = cliente.ItemToInteger("estab")
.Ref = "B001"
.Qttped = 10
.Qttemi = .Qttped
.Edebito = 12
.Etiliquido = 120
.Data = Date.Now
.Design = "Faturação via conf. personalizada"
Teste.Add(.ThisObject)
End With
Next
End If
Return TesteDepois, ao ser acedido o ecrã Emissão Automática de Faturação e escolhida a opção Faturação Personalizada, estará disponível o título Avenças; ao ser selecionado esse registo e clicado em Preparar a emissão automática de faturação, será possível verificar, por exemplo, que, nas linhas, constam os valores definidos no código VB.NET, como, por exemplo, a Quantidade Pedida. Desta forma, ao serem selecionados os registos e clicado em Emitir, serão emitidos os documentos de faturação, tendo em conta a configuração de faturação personalizada escolhida.
Caso o ecrã Configuração de Faturação Personalizada esteja em modo de edição, e seja clicado o botão Expandir para edição de código, poderá ser encontrado, na área de Exemplos, um exemplo de Configuração de Faturação Personalizada.