i want to make one customization in my Tally ERP 9 i.e. automatic generation of purchase order while entering items in sales order. The items should get in the purchase order of those parties from whom last purchase was done. It should have following features:
1. Purchase order automatically generated should show name, quantity and last purchase rate in PO.
2. It should be possible to change the item from one Party to other party in case it is not available with that party
3. All things should be editable in automatically generated PO like rate, quantity, etc.
Lets suppose I buy
Apple phones from Snapdeal (Last Purchased) and Flipkart
Samsung phones from Snapdeal and Amazon (Last Purchased)
Sony phones from Amazon and Flipkart (Last Purchased)
I have 3 customers now A,B,C
A wants 2 Apple phones and 1 Sony
B wants 3 Sony and 2 Samsung and 5 Apple
C wants 6 Samsung and 2 Sony
When i will make a sale order for all customers:
For customer A: When i will make SO and enter items, 2 Apple phones should automatically get into PO of Snapdeal and 1 sony into PO of Flipkart
For B: 3 sony into PO of Flipkart, 2 Samsung into PO of Amazon and 5 Apple into PO of Snapdeal
Similarly for C
Atlast, when i open PO of Flipkart, it should show total 6 quantities of Sony phones and its last purchase price.
7 Apple phones in PO of Snapdeal
8 Samsung phones in PO of Amazon.
This is example of one item for one party, like wise there can be any no. of items from one party.