Inputs required in creating a report

chaitali_bhattacharya

I need some logic inputs for creating a report.

There is a process of consignment purchase the process for which is as below:

An item A is purchased from a particular vendor at various times and at various rates. The payment that'll be made to the vendor would be calculated depending on the sales that have been made for the items.

Eg:

Two pieces of an Item A is purchased from a vendor at the rate
of Rs 100 on 3rd Nov 2005. One piece of the same Item A is purchased from the same vendor at the rate of Rs. 150 on 4th Nov. This item is transfered from the location to a location store and then sales order is raised from this location.
sales order of quantity on piece is raised for the item A on 5th Nov and then another sales order is being raised for the same item of quantity 2 on 6th Nov.

Now payment is to be made to the vendor on a FIFO basis. Therefore, when the payment is to be made it'll be @ Rs 100 for one piece and then for the second sales order it should be @ Rs 100 for one piece and @ Rs 150 for the second piece.

If anyone has made any similar report please give me some inputs.


Hope I hav been able to explain the requirement clearly.

Thanks & Regards

bbrown

Use "Item Ledger Entry" to find the sales. Then find the inbound (purchase) entries to which they are related. You may have to work through multiple application layers due to internal transfers.