RJL Software - The Essential Ingredient
RJL asap - advanced sales and production


Example Reports Production Sheet with Ingredients Production Sheet by Group Production Sheet by Round Delivery Notes Driver's Report Weekly Invoices Statement Aged Debtors Sales Analysis Example 1 Sales Analysis Example 2 Sales Analysis Example 3 Sales Analysis Example 4 Sales Analysis Example 5
                                 INVOICE 
     TRUELY SCRUMMY FOODS                     
     23 ACACIA AVENUE                          INVOICE  NUMBER 10867  
     TRUMPTON                                  DATE : Sunday 05/10/08     
     SOMERSET                                  ACCOUNT CODE : ASD001  
                                               ROUND/DROP : WINC     / 1 
     01333 424424                              STORE NO : storeno8 

     INVOICE TO                                DELIVER TO                              
     ASDORIA STORES (Winchester)               ASDORIA STORES (Winchester)             
     WINNAL ROUNDABOUT                         WINNAL ROUNDABOUT                       
     WINCHESTER                                WINCHESTER                              
     SO22 9WW                                  SO22 9WW                                
                                                                                       
                                                                                       
     VAT NO GB 345 456 3     TERMS 30 DAYS                TEL                
     COMPANY NO 3453453                        

ORDER    NUMBERS                           ORD3434                                                                                  
DELIVERY NOTE NUMBERS                       8972              9025                                                                
CODE     DESCRIPTION                VAT      MON      TUE      WED      THU      FRI      SAT      SUN     TOTAL  PRICE      TOTAL
-------- -----------                ---      ---      ---      ---      ---      ---      ---      ---  --------  -----   --------
BEE001   BEEF AND HORSE SANDWICH      1       10       10        0        0        0        0        0        20  2.392     47.840
BEE101   BEEF AND HORSERADISH ROLL    1        0       10        0        0        0        0        0        10  2.491     24.910
BLT001   BACON LETTUCE TOMATO SANDWI  1       10       10        0        0        0        0        0        20  1.980     39.600
CHE001   CHESSE AND ONION             1       10       10       10       10       10        0        0        50  2.390    119.500
CHE002   CHEESE AND TOMATO SANDWICH   1       10        0       10        0        0        0        0        20  2.390     47.800
CHI202   CORONATION CHICKEN BAGUETTE  1        0        0       10        0        0        0        0        10  2.000     20.000
CHI901   CHICKEN SALAD FLATPACK       1        0        0       10        0        0        0        0        10  2.390     23.900
EGG001   EGG MAYONNAISE S/WICH        1       10        0        0        0        0        0        0        10  2.390     23.900
EGG201   EGG MAYO BAGUETTE            1        0       10       10        0        0        0        0        20  2.000     40.000
HAM001   HAM AND TOMATO SANDWICH      1       10        0        0        0        0        0        0        10  2.390     23.900
HAM002   HAM SALAD SANDWICH           1       10        0        0        0        0        0        0        10  2.390     23.900
HAM003   HAM CHEESE AND TOMATO TRIPL  1       10        0        0        0        0        0        0        10  2.390     23.900
HAM901   HAM AND TOMATO FLATPACK      1        0        0        0        0       10        0        0        10  2.390     23.900
HAM902   HAM CHEESE AND TOMATO FLATP  1        0        0        0        0       10        0        0        10  2.390     23.900
PIE001   STEAK AND KIDNEY PIE         1        0        0        0        0       10        0        0        10  2.000     20.000
PIE002   MEAT AND POTATO PIE          1        0        0        0        0       10        0        0        10  2.000     20.000
PIE003   STEAK AND ONION PIE          1        0        0       10        0       10        0        0        20  2.000     40.000
PIE004   CHICKEN AND MUSHROOM PIE     1        0       10        0        0       10        0        0        20  2.000     40.000
PIE005   CHICKEN TIKKA PIE            1        0        0        0        0       10        0        0        10  2.000     20.000
PIE006   CORNISH PASTY                1        0        0       10        0       10        0        0        20  2.000     40.000
PIE007   CHEESE AND ONION PASTY       1        0       10        0        0       10        0        0        20  0.000      0.000
PIE008   GIANT PORK PIE               1        0        0       10       10        0        0        0        20  0.000      0.000
PRA001   PRAWN COCKTAIL SANDWICH      1       10       10        0       10        0        0        0        30  1.980     59.400
PRA101   PRAWN COCKTAIL ROLL          1        0        0        0       10        0        0        0        10  0.000      0.000
PRA201   PRAWN COCKTAIL BAGUETTE      1        0        0        0       10        0        0        0        10  0.000      0.000
TUN001   TUNA MAYONNAISE SANDWICH     1       10       10        0       10        0        0        0        30  2.000     60.000
TUN101   TUNA MAYONNAISE ROLL         1        0        0        0       10        0        0        0        10  0.000      0.000
TUN201   TUNA MAYONNAISE BAGUETTE     1        0        0        0       10        0        0        0        10  0.000      0.000
TUN901   TUNA MAYONNAISE FLATPACK     1        0        0        0       10        0        0        0        10  0.000      0.000
Less Returns .....                      
BEE001   BEEF AND HORSE SANDWICH      1        0        0       -3        0        0        0        0        -3  2.392     -7.176
CHE001   CHESSE AND ONION             1        0        0       -5        0        0        0        0        -5  2.390    -11.950
EGG001   EGG MAYONNAISE S/WICH        1        0        0       -6        0        0        0        0        -6  2.390    -14.340
HAM001   HAM AND TOMATO SANDWICH      1        0        0        0       -3        0        0        0        -3  2.390     -7.170
                                        -------- -------- -------- -------- -------- -------- -------- ---------
TOTAL                                        100       90       66       87      100        0        0       443           765.714

                                                                  Less Discount -   SANDWICHES   500.80 @ 10.00%            50.080
                                                                                    ROLLS         24.91 @ 10.00%             2.491
                                                                                    BAGUETTES     60.00 @ 10.00%             6.000
                                                                                    PIES         180.00 @ 10.00%            18.000
                                                                           Less Discount of  20.000% ON  689.143           137.829
                                                                                                                        ----------
                                                                                                      NETT TOTAL           551.31

                                                                                                       VAT TOTAL             0.00
                                                                                                                        ----------
                                                                                                   INVOICE TOTAL           551.31
                                                                                                                        ==========
                                                                                                  Previous Total          1805.50
                                                                                                     Total Owing          2356.81

VAT CODE  1  No VAT          RATE  0.00%  AMOUNT   551.314  VAT    0.000

Payment within 30 Days please
Any queries then please contact accounts on the above number

                                 INVOICE 
     TRUELY SCRUMMY FOODS                     
     23 ACACIA AVENUE                          INVOICE  NUMBER 10868  
     TRUMPTON                                  DATE : Sunday 05/10/08     
     SOMERSET                                  ACCOUNT CODE : ALB001  
                                               ROUND/DROP : WINC     / 2 
     01333 424424                              

     INVOICE TO                                DELIVER TO                              
     THE ALBION                                THE ALBION                              
     ANDOVER ROAD                              ANDOVER ROAD                            
     WINCHESTER                                WINCHESTER                              
     SO22 7XP                                  SO22 7XP                                
                                                                                       
                                                                                       
     VAT NO GB 345 456 3     TERMS                        TEL 01962 861429   
     COMPANY NO 3453453                        

DAY        DATE DEL NO ORD NO           RRP  RETURNS     TOTAL DISCOUNT       NET
---        ---- ------ --- --      -------- --------  -------- --------  --------
MON  29/09/2008   8970 ALB001_1     835.050    0.000   835.050   86.888   748.163

TUE  30/09/2008      0              570.900    0.000   570.900   67.688   503.213

WED  01/10/2008   9023              158.000    0.000   158.000   15.750   142.250

THU  02/10/2008      0              858.450    0.000   858.450  119.325   739.125

FRI  03/10/2008      0              949.050    0.000   949.050  139.175   809.875

TOTAL                              3371.450    0.000  3371.450  428.825  2942.625

                         Less Discount of  30.000% ON 2942.625            882.788
                                                                       ----------
                                                         TOTAL           2059.838

                  Less Overrider Discount  10.000% ON 2059.838            205.984
                                                                       ----------
                                                    NETT TOTAL           1853.85
                                Delivery (10p per product del)              0.00
                                   Delivery(20p Net Delivered)              0.00
                                Delivery (10p per product del)              0.00
                                                     VAT TOTAL             38.70
                                                                       ----------
                                                 INVOICE TOTAL           1892.55
                                                                       ==========

VAT CODE  1  No VAT          RATE  0.00%  AMOUNT  1632.724  VAT    0.000
VAT CODE  2  Standard Rate   RATE 17.50%  AMOUNT   221.130  VAT   38.698

CATEGORY      DISC%     AMOUNT        DISC AMOUNT
SANDWICHES   25.000   1715.300          428.825
ROLLS         0.000    479.550            0.000
BAGUETTES     0.000   1141.600            0.000
JUICE         0.000     20.000            0.000
PIES          0.000     15.000            0.000

Invoices for Week Ending 05/10/2008 - Products with Zero Prices

CUSTOMER  NAME                            INVOICE   ROUND       PRODUCT     DATE    DELIVERY
--------  ------------------------------  -------   ----------  --------  --------  --------
ASD001    ASDORIA STORES (Winchester)       10867   WINC/1      PIE007    30/09/08     1       
ASD001    ASDORIA STORES (Winchester)       10867   WINC/1      PIE007    03/10/08     1       
ASD001    ASDORIA STORES (Winchester)       10867   WINC/1      PIE008    01/10/08     1       
ASD001    ASDORIA STORES (Winchester)       10867   WINC/1      PIE008    02/10/08     1       
ASD001    ASDORIA STORES (Winchester)       10867   WINC/1      PRA101    02/10/08     1       
ASD001    ASDORIA STORES (Winchester)       10867   WINC/1      PRA201    02/10/08     1       
ASD001    ASDORIA STORES (Winchester)       10867   WINC/1      TUN101    02/10/08     1       
ASD001    ASDORIA STORES (Winchester)       10867   WINC/1      TUN201    02/10/08     1       
ASD001    ASDORIA STORES (Winchester)       10867   WINC/1      TUN901    02/10/08     1