Customer feedback & Ideas for IRIS

Suggest & prioritise ideas for our customer-driven roadmap

More AutoMail tags connected to VAT Filer

At the moment, only the net payable figure is retrievable.

 

Surely we should be able to pull up other information related to an obligation period.

 

All fields in the following 3 database tables are a must:

 

itb_VATPeriodInformation

,[ClientNo]
,[VATPeriodId]
,[DateDueOrReceived]
,[AmountDue]
,[AmountReceived]
,[AmountOutstanding]
,[ClientType]

 

itb_VATLiabilities

,[VATPeriodId]
,[VATDueInPeriodOnSalesAndOtherOutputs]
,[VATDueInPeriodOnAcquisitonsFromOtherEC]
,[TotalVATDue]
,[VATReclaimedInThisPeriodOnPurchasesAndOtherInputs]
,[NetVATToBePaidToHMRCOrReclaimed]
,[TotalValueOfSalesAndAllOtherOutputsExcludingVAT]
,[TotalValueOfPurchasesAndAllOtherInputsExcludingVAT]
,[TotalValueOfSuppliesOfGoodsAndRelatedCostsToEC]
,[TotalValueOfAllAcquisitionsOfGoodsToEC]
,[DataEntryComplete]
,[LatestReturnProduced]
,[ReturnSentToClientForSignature]
,[SignedReturnReceivedFromClient]
,[ReturnSentToHMRC]
,[AcknowledgementReceivedFromHMRC]
,[ProcessingDate]
,[PaymentIndicator]
,[ChargeRefNumber]
,[FormBundleNumber]
,[ErrorCode]
,[SubmittedByStaffId]
,[DataOrigin]

 

itb_VATPeriods

,[ClientNo]
,[StartDate]
,[EndDate]
,[DueDate]
,[PeriodKey]
,[ReceivedDate]
,[VATPeriodStatus]
,[ClientType]

  • Louis Evangelou
  • Jul 19 2019
  • Attach files