purchase and sale report

[Former Member]

Dear All Experts,

I WANT A QUERY IN WHICH I GET THE FOLLOWING DETAILS:-

The logic should display item wise purchase and their sales details with qty and sr# for a given period of time.

i.e suppose any item is purchased with 100 qty and against them i want to know its sales details.

GRPO ITEM NAME, GRPO#, GRPO DATE,INVOICE NO,INVOICE DATE,INVOICE QTY,INVOICE ITEM NAME,INVOICE ITEM SR#

[Former Member]

Hi,

You should check out the Serial Number Transaction report. If you choose to run it by Documents, you will want to keep in mind that if you do a Delivery before Invoice, the S/N will be on the Delivery not the invoice.

Tip: select the 'Display All Transactions for Selected Item' field as depending on your criteria, not all transactions will be displayed.

HTH,

Heather

[Former Member]

Hi Chintesh........

Have you maintained your product batch wise?

If yes then you can get the Purchase and sales against a particular purchase.

You have to refer Batch Transaction Report for that.

If you have not maintained items batch wise then its difficult to get the report Sales against a particular Document Purchase...

Regards,

Rahul

[Former Member]

we are not maintaining through batch, but i think we can track with sr# at the time of purchase and then sell.

[Former Member]

Ok No issues......

If you are maintaining Serial wise then you can refer Serial No. Transaction Report.

Its in Inventory reports........

Regards,

Rahul

[former_member186095]

you can simply develop the query using OINM (Transaction journal table) table. You may left join to OITW (warehouse) and OITM table (item master data).

you can paste the query here and ask us here if you find error or trouble to develop the query.

JimM