Services Limited
Integrated Business Solutions
|
|
Services Limited | Integrated Business Solutions | |
|---|---|---|---|
| SUPPLIERS REPORTS |
Cheapes - No. 924 - 10/09/09 Part No. Description Unit Ordered Price BAG Bag 5 25.00 BATC Battery Ea 100 6.89 CELL CellPhone 2 127.00 FAN Fan Ea 5 10.00 Designs Ltd - No. 925 - 10/09/09 Part No. Description Unit Ordered Price FLY Fly Spray 10 5.45 PAD A4 Pad Ea 100 .89 SPEAKER Speakers Pa 4 19.00Produce a Register of Orders:
Order Due Supplier Ordered Costed By Name
------------------------------------------------------------------------------------------------------------------------------------------------------------
924 10/09/09 CHEAP 1118.00 O Jill Cheapes
925 10/09/09 DESIGN 219.50 O Jill Designs Ltd
------------------------------------------------------------------------------------------------------------------------------------------------------------
1337.50 Orders
1337.50 Totals
------------------------------------------------------------------------------------------------------------------------------------------------------------
Order/Supplier Due Name Product Qty Supp Code Description ------------------------------------------------------------------------------------------------ 924 CHEAP 10/09/09 Cheapes JS BATC 50 Battery CELL 1 CellPhone FAN 5 Fan 924 CHEAP 56 itemsReceipt some parts of both Orders:
Order Checked from: Ref. Name Date
Product Bin Quantity per Description
924 CHEAP 100 Cheapes 10/09/09 Receipt OR R
BAG 5.000 Bag
BATC 50.000 Each Battery
CELL 1.000 CellPhone
100 56.000 by: Jill due 10/09/09
Order Checked from: Ref. Name Date
Product Bin Quantity per Description
925 DESIGN 101 Designs Ltd 10/09/09 Receipt OR R
PAD 100.000 Each A4 Pad
101 100.000 by: Jill due 10/09/09
Product Description Quantity Cost Add-on Tax Value Sell L/t Bin
CHEAP 924 10/09/09 JS OR Cheapes Cost
BAG Bag 5.000 25.628 3.140 125.00 350.00
BATC Battery 50.000 7.063 8.660 344.50
CELL CellPhone 1.000 130.190 3.190 127.00
Freight 15.000
1001 JS 56.000 596.500 15.000 611.50
Product Description Quantity Cost Add-on Tax Value Sell L/t Bin
DESIGN 925 10/09/09 JS OR Designs Ltd Cost
PAD A4 Pad 100.000 .890 11.12 89.00 5.00
1002 JS 100.000 89.000 11.13 100.13
Run reports for Stock On Order - by Product and by Supplier:
By Product
Product Description Units Cost On Hand Due.
Order details: Order Supplier Due Orig. Cost Rec'd Due
Branch: CH Christchurch
Category HA Sales
BATC Battery Each 7.06 50 50
924 CHEAP 10/09/09 100 6.89 50 50
CELL CellPhone 130.19 1 1
924 CHEAP 10/09/09 2 127.00 1 1
FAN Fan Each 10.00 3 5
924 CHEAP 10/09/09 5 10.00 5
FLY Fly Spray 5.67 2 10
925 DESIGN 10/09/09 10 5.45 10
SPEAKER Speakers Pair 19.00 4
925 DESIGN 10/09/09 4 19.00 4
Sub total 56 70
Total 56 70
Grand total 56 70
By Supplier
Product Description Units Cost On Hand Due.
Order details: Order Supplier Due Orig. Cost Rec'd Due
Branch: CH Christchurch
Supplier CHEAP Cheapes
BATC Battery Each 7.06 50 50
924 CHEAP 10/09/09 100 6.89 50 50
CELL CellPhone 130.19 1 1
924 CHEAP 10/09/09 2 127.00 1 1
FAN Fan Each 10.00 3 5
924 CHEAP 10/09/09 5 10.00 5
Sub total 54 56
Supplier DESIGN Designs Ltd
FLY Fly Spray 5.67 2 10
925 DESIGN 10/09/09 10 5.45 10
SPEAKER Speakers Pair 19.00 4
925 DESIGN 10/09/09 4 19.00 4
Sub total 2 14
Total 56 70
Grand total 56 70
Receipt the remaining parts:
Order Checked from: Ref. Name Date
Product Bin Quantity per Description
924 CHEAP 200 Cheapes 10/09/09 Receipt OR R
BATC 50.000 Each Battery
CELL 1.000 CellPhone
FAN 5.000 Each Fan
200 56.000 by: Jill due 10/09/09
Order Checked from: Ref. Name Date
Product Bin Quantity per Description
925 DESIGN 201 Designs Ltd 10/09/09 Receipt OR R
FLY 10.000 Fly Spray
SPEAKER 4.000 Pair Speakers
201 14.000 by: Jill due 10/09/09
Run receipted Stock report:
Product Description Units Cost Rec. Ret.
Order details: Order Supplier Rec'd Ref. Qty
Branch: CH Christchurch
Category HA Sales
BATC Battery Each 7.06 50
CH 924 CHEAP 10/09/09 200 50
CELL CellPhone 130.19 1
CH 924 CHEAP 10/09/09 200 1
FAN Fan Each 10.00 5
CH 924 CHEAP 10/09/09 200 5
FLY Fly Spray 5.67 10
CH 925 DESIGN 10/09/09 201 10
SPEAKER Speakers Pair 19.00 4
CH 925 DESIGN 10/09/09 201 4
Sub total 70
Total 70
Grand total 70
Product Description Units Cost Rec. Ret.
Order details: Order Supplier Rec'd Ref. Qty
Branch: CH Christchurch
Supplier Cheapes
BATC Battery Each 7.06 50
CH 924 CHEAP 10/09/09 200 50
CELL CellPhone 130.19 1
CH 924 CHEAP 10/09/09 200 1
FAN Fan Each 10.00 5
CH 924 CHEAP 10/09/09 200 5
Sub total 56
Supplier DESIGN Designs Ltd
FLY Fly Spray 5.67 10
CH 925 DESIGN 10/09/09 201 10
SPEAKER Speakers Pair 19.00 4
CH 925 DESIGN 10/09/09 201 4
Sub total 14
Total 70
Grand total 70
And a Register of Receipts - see (see Report Builder
for more)
Product Description O/o Due Orig Rec'd. Costed Cost Value St Order Over-supply
------------------------------------------------------------------------------------------------------------------------------------------------------------
BATC Battery 10/09/09 100 100 50 6.89 689.00 I 924 CHEAP
CELL CellPhone 10/09/09 2 2 1 127.00 254.00 I
FAN Fan 10/09/09 5 5 10.00 50.00 R
FLY Fly Spray 10/09/09 10 10 54.50 R 925 DESIGN
SPEAKER Speakers 10/09/09 4 4 76.00 R
------------------------------------------------------------------------------------------------------------------------------------------------------------
Due Supplier Value Status Name *** Run Totals ***
943.00 = Costed Orders
------------------------------------------------------------------------------------------------------------------------------------------------------------
Product Received under / over Supplier
BATC 50.0 50.0 10/09/09 924 CHEAP 100 Battery
50.0 10/09/09
CELL 1.0 1.0 10/09/09 CellPhone
1.0 10/09/09
FAN 5.0 10/09/09 Fan
FLY 10.0 10/09/09 925 DESIGN 201 Fly Spray
PAD 100.0 10/09/09 A4 Pad
SPEAKER 4.0 10/09/09 Speakers
Run a Costings Register before exporting Costings to Creditors
Supplier Date Invoice Order Due Period Branch TOTAL Product/PL Description Quantity Cost Tax (4X) CIS Seq A CHEAP 10/09/09 1001 924 Purchase 20/10/2009 6 CH Christchurch 230 P BAG Bag 5.000 128.140 125.00 350.00 240 P BATC Battery 50.000 353.150 344.50 250 P CELL CellPhone 1.000 130.190 127.00 260 S Freight 15.000 14.99 280 X Ref. 1001 Supplier Totals: 611.500 611.50 611.49 290 A DESIGN 10/09/09 1002 925 Purchase 20/10/2009 6 CH Christchurch 300 P PAD A4 A4 Pad 100.000 89.000 89.00 5.00 320 X Ref. 1002 Supplier Totals: 89.000 11.13 100.13 89.00 340 Batch No. 79 2 Documents Cred 156.000 700.500 11.13 711.63 700.49
Order/Supplier Due Name Product Qty Supp Code Description ------------------------------------------------------------------------------- 924 CHEAP 10/09/09 Cheapes Jill CELL 1 10/09/09 1001 Battery 924 CHEAP 1 items 130.190.......
Creditor Ref. Date Due Order Dept.Br. Tr. Per. Batch Tx.
Expense TOTAL Value GST Disc. % Qty. Product Dept.
Batch Header 00/0000 5 53
CHEAP Cheapes 1001 10/09/2009 20/10/2009 SALE CH 1 6 79 Z 0000000
368000 Freight + Cartage .01 .01 .00 1.00 SALE
270001 Purchases - Sales 611.49 611.49 .00 SALE
Document Totals 611.50 611.50 .00 56.00
DESIGN Designs Ltd 1002 10/09/2009 20/10/2009 SALE CH 1 6 79 X 0000000
270001 Purchases - Sales 100.13 89.00 11.13 SALE
Document Totals 100.13 89.00 11.13 100.00
** Run Totals ** Docs. = 2 711.63 700.50 11.13