MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Reference > Common Features > Screens > VAT Report Selection Program > CF320S01 - Function Select

CF320S01 - Function Select

 

 

 WILLIAMS                        COMMON FEATURES                       18/12/94

 DSP01                         TAX REPORT SELECTION                      SELECT

                                                                               

                         Option              1                                 

                            1 - Report                                         

                            2 - Extract                                        

                            3 - Report and Extract                             

                            4 - Justification report                           

                            5 - Month end tax report                           

                            6 - Year end tax report                            

                            7 - Manually booked tax report                     

    Report Options:                                                             

                Company/Location                                               

                Beginning Date                 Ending Date                     

                Tax Source Code                Tax Code                        

                Tax end month                  Tax end year                    

                Declaration point              Tax type                        

                Summary/Detail                 Home/Export Flag                

                                                                               

                Break by Source     N                                          

                                                                               

 F2=Command          F3=Exit             F4=Prompt                             

                                                                               

 

 

This screen is used to select the Tax History File Extract or one of several tax reports.  The extract option places VAT and GST accounting transactions into the VAT History File (CFVATHP).  The VAT/GST Extract Report (AR550) lists the contents of the file.  The Justification Report lists fields from the VAT History File that indicate how VAT and GST were calculated for a document (including tax rate, tax type, taxable amount, non-taxable amount, and whether or not the customer/vendor is tax exempt).  The Month-End and Year-End reports identify the VAT or GST amount that was calculated for each document in the corresponding time period.  The Detail, Month-End, and Year-End reports can be printed using a 132-character format or a 198-character format, depending on the entries in category 025 in the Reference File.  For more information see the report descriptions of these reports (CF550, CF590, and CF610) in the report section of the user manual.  The Manually Booked Tax Report prints all journal lines that were entered with a VAT account.  If there are any differences between manually booked VAT amounts and calculated VAT amounts, this report will explain those differences due to different VAT extractions in the subledgers.  To limit what transactions are included on a report, enter any or all of the optional fields.

Note:  The extract report is performed across all company/locations.  Therefore, no selection criteria will acknowledged for this report.

OPTION

Required.  This field is used to select one of the options listed.

COMPANY/LOCATION

Optional.  Used to limit the report to a single company/location.  If this field is left blank all company/locations will be processed.  Must exist on the Reference File category 002.

BEGINNING DATE

Must be blank for Month-End and Year-End reports.  Required for all other options.  A record in the VAT History File will only be processed if its accounting date is equal to this date or later than this date.

END DATE

Must be blank for Month-End and Year-End reports.  Required for all other options.  A record in the VAT History File will only be processed if its accounting date is equal to this date or earlier than this date.

TAX SOURCE CODE

Optional.  Used to limit the selected report to transactions that originated in Accounts Receivable or Accounts Payable Valid values are defined on Reference File category 021.  If this field is left blank, VAT and GST transactions from all sources will be included.

TAX CODE

Optional.  Used to limit the report to a specific VAT or GST code.  If left blank, all tax codes will be processed.

DECLARATION POINT

Optional.  Used to limit the report to tax history records where tax is declared at invoice or payment time.  Valid values are defined on Reference File category 022.  If this field is left blank, taxes declared at both points will be included.

TAX TYPE

Optional.  Used to limit the selected report to VAT History File records where VAT or GST processing is exonerated, suspended, partially recoverable, or normal.  Valid values are defined on Reference File category 024.  If this field is left blank, all tax types will be included.

SUMMARY/DETAIL

Required if the Report or the Report and Extract option is selected.  Used to specify if the summary (S) or detail (D) report should be generated.

TAX END MONTH

Required for the Month-End Report.  Must be blank for all other options.  Records in the VAT History File with accounting dates in this month will be included in the report.  Note that the entered value refers to the calendar month, not to an accounting period.

TAX END YEAR

Required for the Year-End Report.  Must be blank for all other options.  Records in the VAT History File with accounting dates in this year will be included in the report.

HOME/EXPORT FLAG

Optional.  Used to limit the selected report to VAT History File records with a particular value in the Home/Export field.  Valid values are defined on Reference File category 406.  If this field is left blank, both home and export records will be included.

BREAK BY SOURCE

Optional.  This field is used to indicate whether all transactions of the same VAT code/VAT rate can be accumulated independent of the VAT source.  Valid values are:

Y - Yes, allow the report to break by VAT source.

N - No, allow the report to break by VAT code.  Totals by VAT rate within a VAT code will be printed.

COMMAND KEYS

F2    - Display a window where a fast path option or mnemonic can be entered.  Fast path allows the next menu selection to be made directly from this screen.  When the window is displayed, pressing F3 will remove it.

F3    - Exit and return to the previous conversation.

F4    - Display a list of values for the field where the cursor is positioned.  If you select one of the items from the list, it will be returned to the application screen.