IdealWare Online Users ManualAP2-06 A/P PROCESSING |
|
┌────────────────────────────────────────────────────────────────────────────────â”
│08/07/07 Tm6 ***** TERMINAL DEPENDENT BATCH SELECTION ***** PRCODE│ │ │ │ COMPANY: 01 IDEAL LTD. │ │ BATCH NUMBER: 0002 │ │ │ │ G/L DATE: 08/07/07 │ │ CONTROL TOTAL: 0.00DR │ │ │ │** PRESS 'CR' TO CONTINUE; 'F3' TO RE-ENTER; F4 TO END: │ │ │ └────────────────────────────────────────────────────────────────────────────────┘ |
Defaults to the company code, no input required.
Defaults to the next available batch number, no input required.
Enter a G/L date for the batch.
[Enter] for the current system date.
Many programs use the dates of the individual transactions in the batch as the date the G/L is affected by the transaction. For those programs, the Batch G/L date is simply used to indicate the date of batch creation. Some programs use the Batch G/L date as the date the G/L is affected by ALL transactions in the batch. The effective date is noted in PROCEDURE - DATA ENTRY.
Enter a control total for the batch.
[Enter] to bypass.
Generally, a control total is optional. However, some programs require a control total. In either case a control total serves as a handy check-sum against the total entries in a batch and should be entered. Simply add up the total of the transactions to be made in the batch and Enter that as your control total.
[Enter] to advance to data entry screen.
[F3] to re-enter G/L date or control total.
[F4] to exit to menu.
PROCEDURE - DATA ENTRY
A/P INVOICE POSTING
|
┌────────────────────────────────────────────────────────────────────────────────â”
│08/28/96 ***** A/P INVOICE POSTING ***** │ │────────────────────────────────────────────────────────────────────────────────│ │BATCH: 0020 CONTROL: .00 ACTUAL: .00 LEFT: .00 │ │────────────────────────────────────────────────────────────────────────────────│ │FOLIO NO. ______ │ │SUPPLIER CODE │ │TERMS CODE │ │CURRENCY CODE │ │────────────────────────────────────────────────────────────────────────────────│ │INVOICE NO. DESCRIPTION │ │CHEQUE NO. │ │INVOICE DATE │ │DISCOUNT DATE │ │DUE DATE HOLD? │ │────────────────────────────────────────────────────────────────────────────────│ │ACCRUAL AMOUNT YD ACCRUAL VAR RECEIPT# │ │SUB-TOTAL │ │G.S.T. │ │GROSS NET │ │DISC @ % │ │G/L AMOUNT │ │────────────────────────────────────────────────────────────────────────────────│ │PRESS F1 FOR NEXT, F2 TO DISPLAY, F4 TO END, 'AUTO' FOR RECURRING INVOICES. │ │ │ └────────────────────────────────────────────────────────────────────────────────┘ |
[F1] for the next available folio number.
[F2] to display existing folios in the batch one by one.
See PROCEDURE - BATCH MODIFICATION.
[F4] to exit to menu.
"A""U""T""O" to enter a recurring invoice.
See PROCEDURE - RECURRING INVOICE.
Enter a folio number to identify the new invoice.
If you enter an already existing folio number (within this batch), the system will give you the option to bypass, modify or delete it (See PROCEDURE - BATCH MODIFICATION).
&bnsp;
[Enter] or [F1] for the next available folio number.
This selection will apply the next available sequential folio number in the system; the folio number assigned to an invoice is unique and the number will never be reused.
[F4] to exit to menu.
Enter the supplier code.
The default terms for the supplier are automatically displayed. Either accept the default terms by pressing [Enter] or enter one of the following options.
Enter the desired terms code or the Receipt Number.
For trade goods (accrual) purchases for which the supplier terms are different from the normal default and if there is only one receipt per invoice, you should enter the Receipt Number here (refer to INVOICE POSTING - RECEIPT NUMBER ENTRY below).
For non-accrual purchases and accrual purchases with more than one receipt per invoice for which the supplier terms are different from the normal default you should enter the correct terms code here.
[Enter] to accept the displayed default terms code.
For accrual purchases for which the default terms are valid and when there is only one receipt per invoice, you have the option of entering the receipt number here or in the ACCRUAL AMOUNT field below (refer to INVOICE POSTING - RECEIPT NUMBER ENTRY below).
[F5] to display supplier terms codes for selection.
[F10] to display A/P accruals for selection.
Displays the currency code as set up on the supplier master file and may be changed if required by pressing [F3] at the next field.
The program takes into account the exchange rate when posting invoices with foreign currency, such as US$.
Enter the supplier's invoice number.
[F3] to re-enter previous field.
This field is bypassed; to enter an invoice description press [F3] to return to this field.
This field is only used if a cheque has already been issued for the invoice. The system will credit your G/L bank account code and credit and debit your G/L accounts payable account code as well as update this information to the cheque reconciliation file. To enter a cheque number here press [F3] at the next field.
Enter the invoice date.
This date is used by the system, together with the information from the terms code, to calculate the respective discount and due dates. If the entered invoice date is different from the G/L batch control date by more than 90 days, the system responds with the following warning prompt.
"Y" to accept the date and proceed with data entry.
"N" to re-enter the invoice date.
[Enter] for current date.
[F3] to re-enter previous field.
Displays the calculated discount date based on the invoice date and the terms code.
Displays the calculated due date based on the invoice date and the terms code. The discount and due dates can be changed by pressing [F3] at the next field.
This field is bypassed. If you wish to place an invoice on hold, press [F3] at the next field and then type "H" in this field.
If you did not enter a receipt number in the TERMS CODE field above, the first of the following prompts will be displayed. If you did enter a receipt number the second prompt will be displayed.
Enter the receipt number for trade payables only.
If you entered the receipt number in the TERMS CODE field above do not enter it again here, instead press [Enter] to display the accrual amount.
[Enter] to:
(1) Display the total accrued payables amount when a receipt number has been entered in the TERMS CODE field.
OR
(2) Bypass this field if a cheque has already been issued for the invoice or if the invoice is for non-trade payables.
[F5] to display accruals detail inquiry to select a receipt.
You can: (a) flag individual receipts by entering the associated line number followed by the [F6] key or (b) press [F6] alone to flag all of the displayed receipts. When you exit the inquiry by pressing the [F4] key, the program automatically enters in all flagged receipts for you.
[F8] to access Receipt Number Entry.
Used if multiple receipts need to be specified (or refer to F5 option). Refer to INVOICE POSTING - RECEIPT NUMBER ENTRY.
[F12] to access supplier cost file maintenance.
See 31026 Supplier/Product Costing Maintenance.
Displays the receipt number.
When a single receipt number was entered at the TERMS CODE or ACCRUAL AMOUNT field, it will be displayed. When more than one receipt is selected (by pressing [F8] at the ACRRUAL AMOUNT field and selecting multiple receipts) this field displays: MULTI.
Enter the amount for goods on the invoice (excluding PST).
THEN:
[Enter] to add GST to the sub-total amount.
This will calculate and add GST in the GST field below.
[F5] if GST is included in the sub-total amount for goods.
This calculates the GST from the entered amount. When there is an accrual amount, this will generate a variance if the GST was not included in the amount for goods on the receipt.
[F6] if there is no GST.
This Alert message is generated when the sub-total differs from the accrual amount, when an accrual amount is present.
[Enter] to accept the variance and continue.
If you have not simply made an entry error - the variance will be posted to the accrued variance account. This can occur when the supplier's invoice includes charges added or discounts applied after receiving the trade goods. You might rather post these to specific G/L accounts by pressing [F8].
[F3] to re-enter sub-total amount.
If you made an entry error in the sub-total field, eg pressed [F5] instead of [Enter] or vice versa.
[F8] to enter other G/L amounts.
By default an accrual variance will be posted to the accrued variance account. If you wish to post a variance to different account(s) press [F8] to access general ledger code entry (Refer to INVOICE POSTING - GENERAL LEDGER CODE ENTRY).
[F12] to access supplier cost file maintenance.
See 31026 Supplier/Product Costing Maintenance.
Displays the accrual variance, if any.
If there is a variance, make sure you understand why and verify that it is correct and not due to an entry error. If the supplier's invoice includes added charges or discounts and you have disbursed these to their respective G/L accounts, there should be no variance.
Displays the calculated GST amount based on whether you pressed [Enter] or [F5] after entering the sub-total above.
[Enter] to accept the displayed GST amount.
[F2] to set GST amount to zero.
[F3] to re-enter sub-total.
Displays the sub-total + GST amount.
Displays the discount percentage and amount calculated on the sub-total as per supplier terms code.
[Enter] to accept the displayed amount.
[F8] to recalculate the discount.
Based on the gross amount = sub-total + GST.
Displays the yard/store code.
Displays the net amount of the invoice (sub-total - discount).
Displays the amount posted to G/L accounts by non-trade entries and allows allocation of amounts to G/L expense accounts.
[Enter] to accept the default G/L account and amount.
The default G/L expense account is setup in the supplier master maintenance program. For non-trade suppliers you will generally simply press [Enter] to accept the default post the invoice total to the default account. For posting non-trade expenses for suppliers that have been setup as both trade and non-trade and for any non-trade supplier that does not have the default set, you will have to enter the desired G/L accounts. See INVOICE POSTING - GENERAL LEDGER CODE ENTRY. This field is bypassed if a receipt number was referenced above.
Example Invoice Posting Data Entry display:
|
┌────────────────────────────────────────────────────────────────────────────────â”
│08/08/96 ***** A/P INVOICE POSTING ***** │ │────────────────────────────────────────────────────────────────────────────────│ │BATCH: 0018 CONTROL: .00 ACTUAL: 7,500.00 LEFT: 7,500.00- │ │────────────────────────────────────────────────────────────────────────────────│ │FOLIO NO. 000027 │ │SUPPLIER CODE METRO METRO SUPPLY COMPANY │ │TERMS CODE A6 1% 30 DAYS; DISC TYP I, DAYS 30; DUE TYP I, DAYS 30 │ │CURRENCY CODE CN CANADIAN FUNDS │ │────────────────────────────────────────────────────────────────────────────────│ │INVOICE NO. 234567 DESCRIPTION │ │CHEQUE NO. │ │INVOICE DATE 08/08/96 │ │DISCOUNT DATE 09/07/96 │ │DUE DATE 09/07/96 HOLD? │ │────────────────────────────────────────────────────────────────────────────────│ │ACCRUAL AMOUNT 5,750.00 YD 01 ACCRUAL VAR .00 RECEIPT# 000103 │ │SUB-TOTAL 5,750.00 │ │G.S.T. 402.50 │ │GROSS 6,152.50 NET 5,692.50 │ │DISC @ 1.00 % 57.50 │ │G/L AMOUNT │ │────────────────────────────────────────────────────────────────────────────────│ │** OK TO UPDATE? (CR IF OK; F3 TO BACKUP; F4 TO BYPASS): _ │ │ │ └────────────────────────────────────────────────────────────────────────────────┘ |
[Enter] to accept the data as entered and advance.
[F3] to re-enter previous field.
[F4] to clear all data and return to FOLIO NO. field.
When you press either [Enter] or [F4] you are returned to the FOLIO NO. field where you can continue to add additional invoices to the batch or press [F4] again to exit the program.
[F4] to exit the program.
You are offered the option of printing a detailed or summary register.
If the Detailed GL Distribution Y/N in your AP control file is set to "?" this message will appear before the system displays the print menu. By selecting "Y" or "N" here you indicate whether or not you want the system to print a detailed GL distribution report or not. If not, the system will print a summary GL distribution instead. The default is "Yes".
[Enter] to print a detailed G/L register.
You are taken to the print menu.
[F3] to change "Y" to "N".
Then press [Enter] to go to the print menu; see PROCEDURE - REGISTER PRINTING & UPDATING.
[F4] to exit to menu, the batch remains open.
PROCEDURE - BATCH MODIFICATION
When you access an open batch the following prompt is displayed at the bottom of the data entry screen:
Enter the folio number of the invoice you wish to modify.
[F1] for the next available folio number.
See PROCEDURE - DATA ENTRY.
[F2] to display existing folios in the batch one by one.
The following prompt is displayed.
Enter the folio number to begin the display.
[Enter] to begin display at the first folio in the batch.
[F4] to return to data entry.
[F4] to exit to menu.
When you select an existing folio the following prompt is displayed.
[Enter] to clear the display.
"D" to delete the folio.
The folio is deleted without further warning, however, you may undelete it if necessary (Refer to UNDELETING A FOLIO).
"M" to modify the folio.
[Enter] to restore original value.
[F3] to backup through data fields.
[F8] to access G/L code entry (Refer to GENERAL LEDGER CODE ENTRY).
[Enter] to accept changes to data fields.
[F3] to backup through fields to make additional changes.
"G" to display G/L code(s) and amount(s) of the folio.
"R" to display receipt(s) of the folio.
UNDELETING A FOLIO
You can restore a deleted folio if the batch is still open. If the batch has been updated, the folio is unrecoverable. To restore a deleted folio, proceed as follows.
At the FOLIO NO. field enter the number of the deleted folio, if you know it, or press [F2] to display the folios in the batch - the deleted folio will display a DELETED message after the folio number - press [F4] to end the display and then enter the folio number.
[Enter] to initiate recovery of the folio.
[F2] to bypass and leave the folio in deleted status.
The cursor moves to the SUPPLIER CODE field and restores the previous value. Press [Enter] to confirm. The cursor then moves to each data field one by one, simply press [Enter] at each field to restore the previous values.
[Enter] to restore the folio.
[F3] to modify the data fields.
[F4] to not restore the folio.
PROCEDURE - RECURRING INVOICES
At the FOLIO NO. field of the data entry screen:
"A""U""T""O" (ie type AUTO and press [Enter]).
The following prompt is displayed.
Enter the recurring invoice you wish to post.
[F3] or [F4] to cancel and return to FOLIO NO. field.
[F5] to display Recurring Invoice Journals list.
After you select the recurring invoice journal you wish to post the system displays the first invoice entry of the journal.
[Enter] to accept invoice for processing.
The next invoice in the journal is displayed.
"D" to change the invoice dates.
"A" to change the invoice amounts.
"S" to not include the invoice in current processing.
[F4] to exit the journal.
Any changes other than dates and/or amounts to a recurring invoice must be done through the recurring invoice maintenance program (see 24714 - Accounts Payable Maintenance, Recurring Invoice).
PROCEDURE - REGISTER PRINTING & UPDATING
After you have completed data entry you are taken to the Print Selection menu where you may print the batch registers.
PRINTER SELECTION & CONFIGURATION
|
┌────────────────────────────────────────────────────────────────────────────────â”
│08/14/07 ***** PRINTER SELECTION ***** │ │ │ │ │ │** MAKE SURE PRINTER IS READY BEFORE PRESSING CR ..... │ │ │ │1. PRINTER NAME ................................. P1 OKIDATA 390 │ │ │ │2. CHARACTERS PER INCH ? (10,12,17) ............. 10 │ │ SINGLE OR DOUBLE DENSITY ? (S,D) ............. S SINGLE DENSITY │ │ │ │** PRESS CR TO SET PRINTER, OPTION# TO CHANGE, F4 TO END (BYPASS): _ │ │ │ └────────────────────────────────────────────────────────────────────────────────┘ |
"1" to change printers.
"2" to change the CPI and/or print density.
[Enter] to print.
[F4] to not print and exit to the menu.
[F5] to display a list of printers for selection.
After printing the registers you have the following options. If you do not print the registers, the batch options are not available.
"R" to reprint the register.
"M" to enter additional data into the batch.
"U" to update the batch.
"A" to abort the batch, all data in the batch is lost.
"E" to exit, batch remains open, no data is lost.
Example A/P Invoice Register Printout follows.
INVOICE POSTING - GENERAL LEDGER CODE ENTRY
PURPOSE
The general ledger code entry program allows you to distribute the offsetting accounts payable amount to various general ledger accounts.
PROCEDURE
Example General Ledger Code Entry display:
|
┌────────────────────────────────────────────────────────────────────────────────â”
│ ***** GENERAL LEDGER CODE ENTRY ***** │ │ ------------------------------------------------------------------------------ │ │ ENTERED: 50.00DR COMBINE: 50.00DR CTRL: 50.00DR DIFF: 0.00DR │ │ ------------------------------------------------------------------------------ │ │ SEQ G/L CODE AMOUNT DESCRIPTION │ │ ------------------------------------------------------------------------------ │ │ 01. 001221 30.00DR Accounts Payable Adjustments │ │ 02. 001229 20.00DR Allowance for Doubtful a/c's │ │ 03. __________ │ │ 04. │ │ 05. │ │ ------------------------------------------------------------------------------ │ │ ENTER G/L CODE DESIRED (PRESS F4 TO END, F5 FOR G/L CODE INQUIRY). │ │ │ └────────────────────────────────────────────────────────────────────────────────┘ |
Enter the code of the G/L account to which you wish to post.
[F4] to exit G/L code entry.
[F5] to display G/L code listing for selection.
Example G/L Code Listing display:
|
┌────────────────────────────────────────────────────────────────────────────────â”
│ 08/29/96 ***** G/L CODE LISTING ***** 12:54:10 │ │ ────────────────────────────────────────────────────────────────────────────── │ │ G/L CODE SUB ACCOUNT DESCRIPTION │ │ ────────────────────────────────────────────────────────────────────────────── │ │ 1 01-01-1000 BANK ACCOUNT │ │ 2 01-01-1010 CHEQUE REFUND HOLDING ACCOUNT │ │ 3 01-01-1100 TILL PAYMENT HOLDING ACCOUNT │ │ 4 01-01-1200 ACCOUNTS RECEIVABLE │ │ 5 01-01-1210 ACCOUNTS RECEIVABLE ADJUSTMENT │ │ 6 01-01-1220 CASH SALE HOLDING ACCOUNT │ │ 7 01-01-1300 INVENTORY │ │ 8 01-01-1310 INVENTORY ADJUSTMENTS │ │ ────────────────────────────────────────────────────────────────────────────── │ │ ** SELECT INQUIRY OPTION (F12 FOR OPTIONS); F4 TO EXIT INQUIRY: ___ │ │ │ └────────────────────────────────────────────────────────────────────────────────┘ |
With the current version of the software you must type the store/division number and the account code into the G/L code field of the G/L code entry screen.
For example: to enter the inventory account in the above display you would type: 011300
This is derived thus: 01-01-1300 INVENTORY
[Enter] for next screen of data.
[F3] for previous screen of data.
[F4] to exit the inquiry.
[F12] to display the following general inquiry options.
|
GENERAL INQUIRY OPTIONS
F1 = LINE MODE/PAGE MODE
[F1] to toggle from page mode to line mode.
The default is page mode.
F2 = SET POINTER
[F2] to change the pointer without exiting the screen.
Enter an item to begin the display; press [Enter] to begin with the first item.
UPARROW, F3 = UP ONE PAGE
[↑] or [F3] to backup through the display.
One page at a time (in PAGE MODE) or one line at a time (in LINE MODE).
DNARROW, CR = DOWN ONE PAGE
[↓] or [Enter] to advance through the display.
One page at a time (in PAGE MODE) or one line at a time (in LINE MODE).
F4 = EXIT INQUIRY/PROCESSING OPTIONS
[F4] to return to data entry screen.
LINE#+CR = EXIT INQUIRY WITH SELECTED ITEM
LINE#[Enter] to return to data entry with selected item.
F5 = SYSTEM INQUIRY
[F5] to access SYSTEM GLOBAL INQUIRY OPTIONS.
LINE#+F5 = INQUIRE UPON SELECTED ITEM
LINE#[F5] to inquiry on the selected item.
F9 = REPORT
[F9] to print a report.
F12 = THIS LIST OF OPTIONS
[F12] to display this list of options. |
FIELDS
Displays the total amount entered in this screen.
Displays the total amount entered in this screen.
Displays the sub-total amount entered in the invoice posting data entry screen.
Displays the difference between the ENTERED and the CTRL amounts.
Defaults to the next available sequence number. When you press [F3] in the G/L CODE field, the cursor is placed at the SEQ number where the following options are available.
[Enter] to start entry on the current line.
[F1] to delete the line's distribution.
[F3] to exit and backup to the data entry screen.
[F4] to exit the screen.
[F5] for General Ledger codes inquiry.
"#" to display from the number entered.
Enter the desired general ledger account code.
You must enter the division code (two characters) and the account code (four characters) and the sub-account code (four characters), if you select a sub-account.
[F4] to exit general ledger code entry.
[F5] to display general ledger codes inquiry.
Enter the line number of the desired code to retrieve it.
Enter the amount to be posted.
[Enter] to apply the total remaining amount.
Displays the general ledger account description.
ALERT MESSAGES
An account that has sub-accounts must be entered with the sub-account suffix.
Upon exiting the general ledger codes entry screen, the system verifies that the amounts entered in this screen equal the amount entered in the SUB-TOTAL field of the invoice posting data entry screen. Press [Enter] to return to the SEQ field of the general ledger codes entry screen where more distribution can be done.
INVOICE POSTING - RECEIPT NUMBER ENTRY
PURPOSE
The receipt number entry program allows you to select and enter one or several receipts into the invoice posting program.
PROCEDURE
RECEIPT NUMBER ENTRY SCREEN:
|
┌────────────────────────────────────────────────────────────────────────────────â”
│ ***** RECEIPT NUMBER ENTRY ***** │ │ ------------------------------------------------------------------------------ │ │ ENTERED: .00 COMBINE: .00 CTRL: .00 DIFF: .00 │ │ ------------------------------------------------------------------------------ │ │ SEQ RECEIPT# AMOUNT DESCRIPTION │ │ ------------------------------------------------------------------------------ │ │ 01. __________ │ │ 02. │ │ ------------------------------------------------------------------------------ │ │ ENTER RECEIPT# DESIRED (PRESS F4 TO END, F5 FOR RECEIPT# INQUIRY). │ │ │ └────────────────────────────────────────────────────────────────────────────────┘ |
Enter the number of the receipt you wish to access.
[F4] to exit receipt entry.
[F5] to display accruals detail inquiry for selection.
You may select any number of receipts for inclusion.
After you have selected the receipt(s) press [F4] to return to the invoice posting data entry screen with the selected receipts.
FIELDS
Displays the total amount entered in this screen.
Displays the total amount entered in this screen.
Displays the sub-total amount entered in the invoice posting data entry screen.
Displays the difference between the ENTERED and the CTRL amounts.
Defaults to the next available sequence number. When you press [F3] in the G/L CODE field, the cursor is placed at the SEQ number where the following options are available.
[Enter] to start entry on the current line.
[F1] to delete the line's distribution.
[F3] to exit and backup to data entry screen.
[F4] to exit the screen.
[F5] to display the General Ledger codes inquiry.
"#" to display from the number entered.
Enter the number of the receipt you want to add.
[F4] to exit the receipt number entry screen.
[F5] to display accruals detail listing for selection.
Enter the amount to be posted.
[Enter] to apply the total remaining amount.
Displays the receipt description.
Alternatively, at the the invoice posting RECEIPT # field you may press [F5] to display the list of outstanding receipts for selection.
|
┌─────────────────────────────< GENERAL INQUIRY >──────────────────────────────â”
│Oct26/99 ***** A/P ACCRUALS DETAIL ***** 13:51:08│ │──────────────────────────────────────────────────────────────────────────────│ │ SUPPIER RECEIPT REC DATE TRM DUE DATE AMOUNT P.O. NUM PACKING SLIP │ │──────────────────────────────────────────────────────────────────────────────│ │ 1 WEYCAN 000037 Sep07/99 AB Oct15/99 64.95- 01-W07450 CG64347A │ │ 2 WEYCAN 000047 Sep08/99 AB Oct15/99 1474.79- 01-W07360 │ │ 3 WEYCAN 000048 Sep08/99 AB Oct15/99 2121.82- 01-W07413 │ │ 4 WEYCAN 000051 Sep08/99 AB Oct15/99 4409.28- 01-W07405 │ │ 5 WEYCAN 000056 Sep08/99 AB Oct15/99 1512.00- 01-W07302 │ │ 6 WEYCAN 000057 Sep08/99 AB Oct15/99 3609.60- 01-W07438 │ │ 7 WEYCAN 000058 Sep08/99 AB Oct15/99 1972.76- 01-W07433 │ │ **** END OF FILE **** │ │──────────────────────────────────────────────────────────────────────────────│ │** SELECT INQUIRY OPTION (F12 FOR OPTIONS); F4 TO EXIT INQUIRY: ___ │ │ │ └──────────────────────────────────────────────────────────────────────────────┘ |
[F12] to display the general inquiry options.
See above for full list of general inquiry options.
[F4] to exit the inquiry and return to data entry screen.
IDEAL BUILDING SUPPLIES LTD.
08/08/96 13:18:22 PAGE: 1
A/P INVOICE REGISTER - BATCH: PI0018
--------------------------------------------------------------------------------------------------------------------------------
SUPPLIER REFERENCE/ CHEQ/ INVOICE DISCOUNT DUE/CHQ $ GROSS DISCOUNT NET ********* G/L *********
FOLIO# CODE DESCRIPTION STORE DATE DATE DATE TYP AMOUNT AVAILABLE AMOUNT CODE AMOUNT
--------------------------------------------------------------------------------------------------------------------------------
000025 METRO 12345 01 08/01/96 08/31/96 08/31/96 CN 5,350.00 50.00 5,300.00 RCPT: 000067
ACCRUAL CON: 01-2100 5,000.00DR
G.S.T.: 01-5300 350.00DR
000026 METRO 12451 01 08/01/96 08/31/96 08/31/96 CN 2,675.00 25.00 2,650.00 RCPT: 000068
ACCRUAL CON: 01-2100 2,500.00DR
G.S.T.: 01-5300 175.00DR
000027 METRO 234567 01 08/08/96 09/07/96 09/07/96 CN 6,152.50 57.50 6,095.00 RCPT: 000103
ACCRUAL CON: 01-2100 5,750.00DR
G.S.T.: 01-5300 402.50DR
000028 ACKLA 234598 01 08/08/96 09/20/96 09/20/96 US 492.06 .00 492.06 RCPT: 000020
ACCRUAL CON: 01-2100 459.87DR
G.S.T.: 01-5300 32.19DR
000029 ACKLA 3456 01 08/08/96 09/20/96 09/20/96 US 2,293.36 .00 2,293.36 RCPT: 000021
ACCRUAL CON: 01-2100 2,143.33DR
G.S.T.: 01-5300 150.03DR
---------- ---------- ---------- ----------
16,962.92 132.50 16,830.42 16,962.92DR
========== ========== ========== ==========
RECORDS: 5 ACTUAL: 15,853.20 CONTROL: 15,853.00 DIFFERENCE: .00
FIELDS:
FOLIO# folio reference number
SUPPLIER CODE supplier code
REFERENCE/DESCRIPTION invoice number and description
CHEQ/STORE cheque number (if previously issued) or store code
INVOICE DATE invoice date
DISCOUNT DATE discount date
DUE/CHQ DATE payment due date or cheque date (if previously issued)
$ TYP currency type
GROSS AMOUNT gross amount
DISCOUNT AVAILABLE available discount
NET AMOUNT gross amount - discount amount
G/L CODE G/L code
G/L AMOUNT G/L amount assigned
RCPT receipt number
ACCRUAL CON Accrual Control account
G.S.T. GST
IDEAL BUILDING SUPPLIES LTD.
08/08/96 13:18:24 PAGE: 1
A/P ACCRUAL VARIANCE REGISTER - BATCH: PI0018
--------------------------------------------------------------------------------------------------------------------------------
INVOICE INVOICE ACCRUAL ACCRUAL RECEIPT RECEIPT
FOLIO# SUPPLIER REFERENCE CHEQUE DATE SUB-TOTAL AMOUNT VARIANCE RECEIPT# STORE DATE AMOUNT
--------------------------------------------------------------------------------------------------------------------------------
000025 METRO 12345 08/01/96 5,000.00 5,000.00 .00 000067 01 06/03/96 5,000.00
000026 METRO 12451 08/01/96 2,500.00 2,500.00 .00 000068 01 06/03/96 2,500.00
000027 METRO 234567 08/08/96 5,750.00 5,750.00 .00 000103 01 08/08/96 5,750.00
000028 ACKLA 234598 08/08/96 459.87 459.87 .00 000020 01 01/11/96 459.87
000029 ACKLA 3456 08/08/96 2,143.33 2,143.33 .00 000021 01 01/23/96 2,143.33
---------- ---------- ---------- ----------
RECORDS PRINTED: 5 15,853.20 15,853.20 .00 15,853.20
========== ========== ========== ==========
FIELDS:
FOLIO# folio number
SUPPLIER supplier code
REFERENCE invoice number
CHEQUE cheque number (if previously issued)
INVOICE DATE invoice date
INVOICE SUB-TOTAL invoice sub-total
ACCRUAL AMOUNT accrual amount
ACCRUAL VARIANCE accrual variance
RECEIPT# receipt number
STORE store code
RECEIPT DATE receipt date
RECEIPT AMOUNT receipt amount
IDEAL BUILDING SUPPLIES LTD.
08/08/96 13:18:24 PAGE: 1
GENERAL LEDGER POSTING SUMMARY
SOURCE CODE: PI BATCH NUMBER: 0018 G/L DATE: 08/07/96
--------------------------------------------------------------------------------------------------------------------------
ACCOUNT ACCOUNT G/L REF REFERENCE/ DEBIT CREDIT
CODE NAME DATE NUMBER DESCRIPTION AMOUNT AMOUNT
--------------------------------------------------------------------------------------------------------------------------
01-01-2000 ACCOUNTS PAYABLE 08/01/96 f000025 METRO SUPPLY COMPANY 5,350.00
01-01-2000 ACCOUNTS PAYABLE 08/01/96 f000026 METRO SUPPLY COMPANY 2,675.00
01-01-2000 ACCOUNTS PAYABLE 08/08/96 f000027 METRO SUPPLY COMPANY 6,152.50
01-01-2000 ACCOUNTS PAYABLE 08/08/96 f000028 ACKLANDS 492.06
01-01-2000 ACCOUNTS PAYABLE 08/08/96 f000029 ACKLANDS 2,293.36
01-01-2100 ACCRUED CONTROL 08/01/96 f000025 METRO SUPPLY COMPANY 5,000.00
01-01-2100 ACCRUED CONTROL 08/01/96 f000026 METRO SUPPLY COMPANY 2,500.00
01-01-2100 ACCRUED CONTROL 08/08/96 f000027 METRO SUPPLY COMPANY 5,750.00
01-01-2100 ACCRUED CONTROL 08/08/96 f000028 ACKLANDS 459.87
01-01-2100 ACCRUED CONTROL 08/08/96 f000029 ACKLANDS 2,143.33
01-01-5300 G.S.T. EXPENSE 08/07/96 1,109.72
------------ ------------
16,962.92 16,962.92
============ ============
FIELDS:
SOURCE CODE designates batch type
BATCH NUMBER batch number
G/L DATE G/L date of posting
ACCOUNT CODE account code
ACCOUNT NAME account name
G/L DATE G/L date of invoice
REF NUMBER sequential reference number
REFERENCE/DESCRIPTION supplier name or description
DEBIT AMOUNT amount debited
CREDIT AMOUNT amount credited
IdealWare only:
Invoices referenced to an accrual generated by the inventory receipts program will display this information based on the supplier information associated with the receipt. Thus, for such invoices there is no need to enter this information manually.