PRINT CLIENT INVOICES / REPORTS - #28

PURPOSE

This option is available if the CUSTOMER INVOICING feature was purchased. This menu option allows you to print BOTH A/R Invoices (for the purpose of billing back employees' wages) and Billed VS. Earned reports (for comparing costs and profits).

If you have also purchased KLM Accounting and the appropriate setup has been done this program will produce detail Journal records for the AR, Sales and Tax Accounts.

KEEP IN MIND

Information is required in the following files;

  • Valid COMPANY Master File in Menu #1
  • Valid EMPLOYEE Master records in Menu #5
  • Valid LABOUR records in Menus #19 or #9 or #10
  • Valid COA (Client) Master file in Menu #27

In addition, if reporting by specific items such as department the following files must also exist:

  • Valid LABOUR Master file in Menu #4
  • Valid DEPARTMENT Master file in Menu #1

In addition, if transferring journal records to KLM Accounting the following ACCOUNTING files are required.

  • Valid CHART OF ACCOUNTS File in ACCMENU #2
  • Valid TRANSACTION TYPES File in ACCMENU #5

Reports and/or Invoices can be run as many times as you wish. Limitations placed on listing must be met or data is not printed.

Invoicing should be done after running the payroll (Menu #20) and checked to make sure any errors have been corrected.

POSTING of billed amounts can be done during the printing of either AR Invoices or the Billed Vs. Earned report. This is an option and thus can be overridden.

Re-sequencing of labour records should be done only if errors have been detected (items were missed).

ONE Invoice is produced per customer containing a breakdown of all employees who have worked for said customer (for the time period specified) along with the amount billed for each.

Invoices will print on blank paper with a standard layout. Custom forms can be created. Contact KLM Software if you wish custom forms.

The Earned Vs. Billed Report will list and compare each employee's earnings against the amount billed for the employee's service. **

PRINT/POST CLIENT (COA) INVOICES OR REPORT

To print and/or post Customer Invoices or a Billed Vs. Earned report, do the following:

1) At the Payroll System Menu select Print Client Invoices/Report.

2) At the Payroll Billing - Invoice Print & Post Menu verify the prompts. Note, defaults exist for many of the prompts. There are 5 sections to this screen.

FROM: PAYROLL RECORDS TO INCLUDE IN THIS RUN:

Include ALL Companies Enter the Payroll COMPANY you wish to draw records form thus limiting the payroll records to an individual company.

Labour File (to use) This prompt selects the actual labour (job) detail file to draw records from.

Payroll For Week This prompt sets a week range limit for the records within the selected file. Only those records that meet the limit will be selected.

Customer (Blank for all) This prompt allows you to limit records to those of just one customer or group or sub-group of customers.

TO: ACCOUNTING POSTING INFORMATION FROM RECORDS CREATED IN THIS RUN

Post Invoice: Answer Y (for yes) or N (for no), to post (create detail journal records) the contents of this file to the KLM Accounting System.

Post To Prompts set the Account Period, Transaction Date and Account GL Detail File to post to.

INVOICE / REPORT PRINT OPTIONS

Print Select either 1 for Earned vrs Billed Report or 2 for Invoices (this is the default)

Print Sequence Determines the order for both reports and or invoices information is printed.

Page UP If Y for yes, program will force a page break after each time a new sort limit is met (i.e. employee number). This is used only with the Report option.

INVOICE FORMS ONLY OPTIONS

Invoice Date: The program will default to the system date (today's date) but you can change it.

Starting Invoice Number The program will remember the last Invoice Number printed (used by system) and select the next number in order. You can override this number.

Print Company Name & Address If you used per-printed forms, leave this N (for no). If you print on black paper select Y (for yes), so the the company information will print on the form.

LABOUR SEQUENCE LINKS MAINTENANCE

Complete Re-link Triggers a utility that resets the sorting sequence of the labour detail records. Depending upon the size of your file this can take some time.

One Customer To save time, you can limit this sort to one customer.

3) Once all prompts have been filled in click on RUN REPORT to either begin printing Invoices or the Earnings VS Billed Report. In either case, a standard Windows Print Setup Screen appears. Select your printer then continue.

Note 1: When posting records, any record that does not meet the posting restrictions, will be rejected. The program beeps and an error message will be displayed.

Note 2: While you can print either reports or invoices many times, you should only POST invoices once per run.

4) When printing is complete EXIT the option and return to the Payroll System Menu.

PROBLEMS PRINTING/POSTING LABOUR INFORMATION

Like all reports if the items do not meet limitations, they will be excluded. To speed up the printing of reports, this program links (creates sorted files) for certain common elements such as: Employee #, Labour #, Department #, COA # and Reference #.

Altering of these will cause problems with report listings.

If any of the following occurs when you are trying to PRINT and/or POST records:

  • Items are missing; not on reports etc.
  • Report listings appear to be repeating themselves; listing the same records over & over.
  • Reports stop part way through listing.

Do the following, to confirm the report and/or invoices MET the limits:

  • Check your limits. Are they correct?
  • Verify the data exists AND is within any limits required.

If the data is within the limits, verify that the SEQUENCING options work;

a) If asking for your listings by Name sequence, try asking for the same report by Number.

b) If the report runs without incident, the error lays in the NAME SORT functions. See COA Information for instructions on re-setting Name or Search Number sequence.

OR 1) If the report is still in error, then the problems lay with the LABOUR sequencing functions.

2) For situation b) do an LABOUR RE SEQUENCING by answering YES to the COMPLETE RE-LINK field prompt on this menu.

REPRINTING INVOICES/REPORT

Invoices and/or reports can be printed as many times as required. No alteration of the payroll data is done.

If you have NOT posted your invoices or report:

  • Verify that the limits & sequencing are both correct.
  • Reprint the invoices or report.

If you have posted your invoices or report:

  • Verify that the limits & sequencing are both correct.
  • Delete the journal records from the Accounting files.
  • Reprint the invoice(s) or report.