Creating Your Own Templates


See the standard instructions for a general guide on how to create your own spreadsheets for entering receipts.


Spreadsheet Design


You should first decide whether you want to enter a single receipt transaction or multiple receipt transactions per spreadsheet.


A single receipt sheet should have the transaction number, supplier number as a single cells, normally at the top of the sheet.


Transaction






Supplier

S001





Date






PO Number

000104











Line

Warehouse

Product

Outstanding

Received

Units

1

BB

ALLOYWHEEL         

5.00


EACH     









A multiple receipt sheet should have all header detail ranges as a column of cells.  All header detail and detail ranges must have the same number of cells.


Trans No

Supplier

PO Number

Rec Date

Line No

W/H

Product

Rec'd Qty

Description

Out Qty


S001

000103   


1

W3

461-115            


CAM LEVER 115      

5.00


S001

000103   


2

W1

461-210            


ASTRA FUEL PUMP    

5.00


S001

000103   


3

BB

ALLOYWHEEL         

ALLOY WHEEL        

5.00


To use the browse facility, you must use the "Add Browse" option to activate this for the sheet.