3 vendors in one item #

sendoh

hi all,
I'm Looking for a Solution for the ff. scenario
example
item #- a001
qty. - 5
Cost - 10.00
Vendor- Vend0001

item #- a001
qty. - 18
Cost - 12.00
Vendor- Vend0002

item #- a001
qty. - 10
Cost - 15.00
Vendor- Vend0003

let say we have a sales of 23 pcs of item a001
my problem is how does the system know if the item is the sales of Vend0001 or Vend0002 or Vend0003....

where using FIFO..
LSRetail 4.0 and nav 4.0

pls. help me any suggestion.... #-o #-o

Malajlo

If you're using FIFO, then the entries are closed in that way. First in - first out.
So answer to your question is:
go to Item ledger, filter on item, filter on open entries, sort by Entry ID. Or by posting date.

insanni

maybe u should consider to use Item tracking line to identify the vendor for the same item ?

easabangan

Your problem will be solved by using the specific costing method and by using the item tracking. Take a research on this feature and find out how it will help you a lot.