Purchase order, sales order processing in tally any version

This query is : Resolved

Querist : Anonymous

Querist : Anonymous (Querist)

20 September 2013 We are a trader. We purchase from Manufacturers and sells the same goods to our Customers.

We do accounts in tally but currently not using Purchase Order and Sales Order features of tally.

Any one who have implemented similar process as mentioned below, you are invited to my location or I can meet you anywhere in bangalore or near by locations to get understanding.

Any links, suggetion, feedback or further query is also invited. Also, there could be other useful reports, we have not think of as of now but could be useful for us.

What are the process, we are looking for to implement in tally:
------------------------------------------------------------------
Since all the process is manually and out of tally system, We are unable to find out lot of analysis report in this case and that's the reason, We need to implement and streamline the process for following in tally, Please help us, how can we achieve it.

1. Linking Sales Invoice to Sales Order.

2. Linking Sales Order to Purchase Order.

3. Linking Purchase Order to Purchase Invoice.

4. Linking Purchase Invoice to GRN (Goods send in Transport by Supplier on our behalf)

What reports we are looking for:
-------------------------------------------
Purpose of linking all the above is to get the following or some other reports to better management.

A. Sales Order Reports:
--------------------------
1. What Sales Order has been generated / Raised for customer.

2. What are the Sales Order for which We have not generated any purchase order yet and need to generate.

3. How much quantity we have shipped to customer against specific sales order.

4. How much qantity, still pending to ship to customer against sales order.

5. How to settle the sales order as complete (PreClosure/ Foreclousure) though we have supplied only partial quantity against this sales order and we are not able to supply the remaining quantity for this sales order.

6. What are the sales order against which we have not dispatched any goods at all?

7. What are the time frame between our sales order to sales invoice generation?

B. Purchase Order to Sales Order Linking:
-------------------------------------------------
1. What purhcase order has been generated and issued to suppliers against specific sales order. There could be chances that against one sales Order, we might have issued different purchase orders to different supplier.

C. Linking Purchase Order to Purchase Invoice to Track:
--------------------------------------------------------
1. Purchase Order against which we have received goods either at our godown or on our behalf at transport.

2. Purchase Order against which we have not recieved any goods at all or recieved partial goods from supplier.

3. What quantity has been received from supplier against specific purchase order, Is there any quantity yet to recieve or recieved extra quantity than mentioned in purchase order.

How we are following the process outside of Tally as of now.
------------------------------------------------------------
The current scenerio we are following as steps given below and not using Purchase Order, Sales Order in tally. Only we use in tally is to generate sales invoice and book purchase invoice so we process Point No. 4 in tally. Except that processing everything manually.

1. While booking sales order, we generate a sales order no. We keep a Sales Order Book.

2. Now once the sales order is booked, we generate purchase order to supplier having our purchase order no. and specifications. We keep a Purchase Order Book.

3. Once the supplier ships the products to our godown or to the local transport on our behalf (to deliver directly to our customer) and provide us Waybill (LR) in our firm name

4. Supplier generate their Sales Invoice in our name (Purchase Invoice for us)

5. We manually note down the Sales Order No. on the supplier invoice for our understanding that this goods has been dispatched to which of our customer i.e. basically tracking so incase we require to get details, we refer the same sale order no. metion on invoice.

6. We generate our Sales Invoice to our customer.

Your help will be appreciated.

Regards,
Martin, Bangalore