IdealWare Online Users Manual

IY2-07-04 I/Y PROCESSING
30117 Receipts, Register Printing

 

PURPOSE

 

The receipts batch registers consist of the following:

 

RECEIPTS DETAIL REGISTER

  • Prints a detailed report showing each receipt and detail line. Your system can be configured to print one receipt per page and print associated accrual information immediately following the receipt information. This allows you to file one receipt's combined detail/accrual register with the packing slip for subsequent match up with the supplier's invoice.
  • Calculates an average cost based on the value of products received plus prorated additional costs, if any.
  • Prints cost information for each detail line and for each order received.
  • Prints each product's price, which can be useful if you print price labels during receiving.

RECEIPTS SUMMARY REGISTER

  • Prints a summary report for each receipt broken down by accruals, line C displays the freight accruals and line D the brokerage accruals.
  • Prints relevant order header information.

RECEIPTS MOVEMENT REGISTER

  • Prints a summary report showing all products that are included in any of the receipts that are selected for the batch.
  • Prints quantity, value and cost information for before and after receipt.

GENERAL LEDGER POSTING SUMMARY

  • Prints a summary report showing how the General Ledger will be affected. The program uses the general ledger codes defined in the A/P currency and product group files. See 31018 - PRODUCT GROUP MAINTENANCE.

Once the registers have been printed, the program returns to the Batch Selection screen. The registers should then be reviewed for such things as:

  • Invalid costs (Detail Register) indicating that average costs might be incorrect.
  • Inaccurate quantities (Movement Register) indicating that Inventory Receiving might not be up to date.

Once the registers have been reviewed, receipts can be modified or deleted if required or the batch can be updated. See 30118 - BATCH UPDATE.

 


PROCEDURE

 

To access the batch register options:

  • Press [F1] at the Batch Selection Screen.
  • Press [F3] or [F4] at the RECEIPT# field of the receipts data entry screen.

BATCH REGISTER OPTIONS

┌──────────────────────────────────────────────────────────┐
│                                                          â”‚
│ ** BATCH REGISTER OPTIONS:                               â”‚
│                                                          â”‚
│ (D) DATA ENTRY                          (U) UPDATE BATCH â”‚
│ (R) PRINT REGISTER                      (A) ABORT BATCH  â”‚
│                                                          â”‚
│ ** CHOOSE FROM ABOVE (F3=BATCH SELECTION; F4=END): _     â”‚
│                                                          â”‚
└──────────────────────────────────────────────────────────┘
** CHOOSE FROM ABOVE (F3=BATCH SELECTION; F4=END):

 

"D" to access data entry for further processing.

 

See PROCEDURE - DATA ENTRY.

 

 

"R" to print batch registers.

 

See PROCEDURE - REGISTER PRINTING AND UPDATE.

 

 

"U" to update batch.

 

See PROCEDURE - REGISTER PRINTING AND UPDATE.

 

 

"A" to abort the batch.

 

>> ENTER 'ABORT' TO ABORT OR PRESS CR: _____

 

"A""B""O""R""T" to abort batch.

 

** ENTER UPDATE/ABORT PASSWORD:

 

Enter your password.

 

The batch is deleted without further warning.

 

 

[Enter] to cancel and return to Batch Options menu.

 

[Enter] to cancel abort and return to Batch Options menu.

 

[F3] to exit to batch selection screen.

 

[F4] to exit to menu.

 


PROCEDURE - REGISTER PRINTING AND UPDATE

 

To print the batch registers select [R] at the batch options menu. The printer selection menu displays.

 

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): _            â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
** 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 are returned to the batch register options menu. To update the batch select [U]. See 30118 - BATCH UPDATE.

 

An example inventory receipts register printout follows.

  



                                              IDEALWARE - 01 IDEAL BUILDING SUPPLY LTD
06/06/06  16:38:48                                                                                                   PAGE: 1
                                         INVENTORY RECEIPTS DETAIL REGISTER - BATCH: YR0042

-----------------------------------------------------------------------------------------------------------------------------------
SEQ  PRODUCT     DESCRIPTION/                  ENTERED QTY/   ENTERED PRC/ PRODUCT  FREIGHT/  EXCHNGE/  RESERVE/    VALUE    AVERAGE
                 SUPPLIER'S CODE                   STD QTY        STD PRC   EXTEN.   BROKER     OTHER   RESERVE   RECEIVED    COST
-----------------------------------------------------------------------------------------------------------------------------------

SUPPLIER: GENPA      P.O. NUMBER: 01-100038    RECEIPT DATE: 06/05/06   RECEIPT NUMBER: 000072   PACK SLIP:

0010 320589      SPECIAL ORDER                       1 EA       9.99 EA       9.99       .00       .00       .00
                                                                                         .00       .00       .00      9.99     9.99
0020 340810      1L PAINT THINNER                    1 BOX     11.00 BOX     11.00       .00       .00       .00
                                                    10 EA       1.10 EA                  .00       .00       .00     11.00     1.10
0030 278480      DRYWALL SCREWS  2" COARSE           1 LB       1.31 LB       1.31       .00       .00       .00
                                                                                         .00       .00       .00      1.31     1.31
                                                                          --------  --------  --------  --------  --------
     RECEIPT TOTALS:                                                         22.30       .00       .00       .00
                                                                                         .00       .00       .00     22.30
SUPPLIER: MACMI      P.O. NUMBER: 01-100133    RECEIPT DATE: 06/06/06   RECEIPT NUMBER: 000073   PACK SLIP: A512341

0010 109705      2X4 S4S STD&BTR GR FIR 8-14      7267 FBM   1000.00 MFBM      .00       .00       .00       .00
                                               7266.71 FBM   1000.00 MFBM                .00       .00       .00       .00      .00
0020 109670      2X4 S4S STD&BTR GRN FIR 8         300 PCS   1000.00 MFBM  1600.01     22.02       .00       .00
                 MACMIF248                     1600.01 FBM   1000.00 MFBM                .00       .00       .00   1622.03  1013.76
0030 109680      2X4 S4S STD&BTR GRN FIR 10        250 PCS   1000.00 MFBM  1666.68     22.94       .00       .00
                 MACMIF2410                    1666.68 FBM   1000.00 MFBM                .00       .00       .00   1689.62  1013.76
0040 109690      2X4 S4S STD&BTR GRN FIR 12        500 PCS   1000.00 MFBM  4000.02     55.04       .00       .00
                 MACMIF2412                    4000.02 FBM   1000.00 MFBM                .00       .00       .00   4055.06  1013.76
                                                                          --------  --------  --------  --------  --------
     RECEIPT TOTALS:                                                       7266.71    100.00       .00       .00
                                                                                         .00       .00       .00   7366.71
SUPPLIER: CINDU      P.O. NUMBER:              RECEIPT DATE: 06/06/06   RECEIPT NUMBER: 000074   PACK SLIP: B12515

0010 340810      1L PAINT THINNER                   20 BOX     20.90 BOX    418.00     20.17      5.64       .00
                                                   200 EA       2.09 EA                16.14      8.07       .00    468.02     2.34
0020 272020      B&D 9778-04 PAINT STRIPPER         15 EA      36.20 EA     543.00     26.21      7.33       .00
                                                                                       20.97     10.48       .00    607.99    40.53
0030 345080      DOW SILICONE PAINTABLE WHITE       25 EA       3.00 EA      75.00      3.62      1.02       .00
                                                                                        2.89      1.45       .00     83.98     3.36
                                                                          --------  --------  --------  --------  --------
     RECEIPT TOTALS:                                                       1036.00     50.00     13.99       .00
                                                                                       40.00     20.00       .00   1159.99
                                                                          --------  --------  --------  --------  --------
     BATCH TOTALS:                                                         8325.01    150.00     13.99       .00
                                                                                       40.00     20.00       .00   8549.00
                                                                          ========  ========  ========  ========  ========



FIELDS

SEQ#              sequence in batch
PRODUCT           product code
DESCRIPTION       description of product
SUPPLIER'S CODE   supplier code
ENTERED QTY       number of units
STD QTY           standard quantity unit of product
ENTERED PRC       price
STD PRC           standard price of product
PRODUCT EXTEN     extension
FREIGHT           freight charges
BROKER            broker code
EXCHANGE          exchange
OTHER             other charges
RESERVE           reserve
VALUE RECEIVED    total value of items received
AVERAGE COST      average cost





                                                          IDEALWARE -
06/06/06  16:38:52                                                                                                PAGE: 1
                                       INVENTORY RECEIPTS SUMMARY REGISTER - BATCH: YR0042

---------------------------------------------------------------------------------------------------------------------------------
RECEIPT  SUPPLIER    P.O.     PACK SLIP    RECEIPT   TERMS   DUE        PRODUCT  FREIGHT/ RESERVE/   ACCRUAL    EXCHANGE  RECEIPT
NUMBER   CODE/DESC  NUMBER     NUMBER       DATE     CODE    DATE        TOTAL    BROKER     OTHER   AMOUNT     AMOUNT    AMOUNT
---------------------------------------------------------------------------------------------------------------------------------

000072   GENPA     - 100038               06/05/06    NC   07/20/06      22.30       .00       .00
         GENERAL PAINT &                                                             .00       .00     22.30       .00     22.30

000073   MACMI     - 100133   A512341     06/06/06    AB   07/15/06    7266.71       .00       .00
         MACMILLAN BLOEDEL                                                           .00       .00   7266.71       .00   7266.71

      C  MACMI     - 100133   A512341     06/06/06    AB   07/15/06        .00    100.00       .00
         MACMILLAN BLOEDEL                                                           .00       .00    100.00       .00    100.00

                                                                      --------  --------  --------  --------  --------  --------
         RECEIPTS TOTALS:                                              7266.71    100.00       .00
                                                                                     .00       .00   7366.71       .00   7366.71

000074   CINDU                B12515      06/06/06    NC   07/20/06    1036.00       .00       .00
         CANADIAN INDUSTRIAL                                                         .00     20.00   1056.00     13.99   1069.99

      C  SILVER               B12515      06/06/06    NC   07/20/06        .00     50.00       .00
         SILVER STEED LTD                                                            .00       .00     50.00       .00     50.00

      D  METRO                B12515      06/06/06    NC   07/20/06        .00       .00       .00
         METRO SUPPLY COMPANY                                                      40.00       .00     40.00       .00     40.00

                                                                      --------  --------  --------  --------  --------  --------
         RECEIPTS TOTALS:                                              1036.00     50.00       .00
                                                                                   40.00     20.00   1146.00     13.99   1159.99

                                                                      --------  --------  --------  --------  --------  --------
         BATCH TOTALS:                                                 8325.01    150.00       .00
                                                                                   40.00     20.00   8535.01     13.99   8549.00

                                                                      ========  ========  ========  ========  ========  ========



FIELDS

RECEIPT NUMBER     receipt number
SUPPLIER CODE      supplier code
DESCRIPTION        description of product
P.O. NUMBER        purchase order number
PACK SLIP NUMBER   packing slip number
RECEIPT DATE       date of receipt
DUE DATE           date payment due
PRODUCT TOTAL      total value of product
FREIGHT            freight charges
BROKER             broker code
RESERVE            reserve
OTHER              other charges
ACCRUAL AMOUNT     accrual amount
EXCHANGE AMOUNT    exchange amount
RECEIPT AMOUNT     amount of the receipt




                                              IDEALWARE - IDEAL BUILDING SUPPLY LTD
06/06/06  16:38:52                                                                                                 PAGE: 1
                                       INVENTORY RECEIPTS MOVEMENT REGISTER - BATCH: YR0042

-----------------------------------------------------------------------------------------------------------------------------------
                            BASE    **** MASTER BEFORE ****     ****** RECEIVED ******    **** MASTER AFTER *****    COST
PRODUCT DESCRIPTION         UNIT    QTY      VALUE     COST     QTY     VALUE     COST    QTY      VALUE     COST   CHANGE      %
-----------------------------------------------------------------------------------------------------------------------------------

109670     2X4 S4S STD&BTR  FBM     520-    233.19-  448.65    1600  1,622.03  1013.76   1080   1,388.84  1285.67   837.02  186.56
109680     2X4 S4S STD&BTR  FBM   10726-  4,328.89-  403.58    1667  1,689.62  1013.76   9060-  2,639.27-  291.33   112.25-  27.81-
109690     2X4 S4S STD&BTR  FBM   31601  15,561.72   492.47    4000  4,055.06  1013.76  35601  19,616.78   551.02    58.55   11.89
272020     B&D 9778-04 PAIN EATR      0        .00    36.20      15    607.99    40.53     15     607.99    40.53     4.33   11.96
278480     DRYWALL SCREWS   LBCO     14      18.56     1.31       1      1.31     1.31     15      19.87     1.31      .00     .02
320589     SPECIAL ORDER    EA        1       9.99     9.99       1      9.99     9.99      2      19.98     9.99      .00
340810     1L PAINT THINNER EA       20      41.88     2.09     210    479.02     2.28    230     520.90     2.26      .17    7.93
345080     DOW SILICONE PAI EABL     53     156.36     2.95      25     83.98     3.36     78     240.34     3.08      .13    4.40
                                        ----------                 ----------                 ----------
BATCH TOTALS:                            11,226.42                   8,549.00                  19,775.42
                                        ==========                 ==========                 ==========




FIELDS

PRODUCT         product code
DESCRIPTION     description of product
MASTER BEFORE   values before adjustments
   QTY          quantity
   VALUE        value
   COST         average cost
ADJUSTED        adjusted values
   QTY          quantity
   VALUE        value
   COST         average cost
MASTER AFTER    values after adjustments
   QTY          quantity
   VALUE        value
   COST         average cost
COST CHANGE     change in cost of item due to adjustment
%               percentage change in item cost





                                IDEALWARE
 06/06/06  16:38:53                                               PAGE: 1
                     GENERAL LEDGER POSTING SUMMARY

 SOURCE CODE: YR           BATCH NUMBER: 0042           G/L DATE: 06/05/06
-------------------------------------------------------------------------
  ACCOUNT     ACCOUNT                                DEBIT          CREDIT
    CODE        NAME                                 AMOUNT         AMOUNT
-------------------------------------------------------------------------

01-00-1300     Inventory                           8,549.00
01-00-2115     Accrued Payables                                   8,535.01
01-00-5100     Exchange                                              13.99
                                               ------------   ------------
                                                   8,549.00       8,549.00
                                               ============   ============




FIELDS

SOURCE CODE     designates batch type
BATCH NUMBER    number of batch which generated the posting
DATE            date of posting
ACCOUNT CODE    G/L account code
ACCOUNT NAME    G/L account name
DEBIT AMOUNT    the debited amount
CREDIT AMOUNT   the credited amount