Serial/batch report can be viewed from base document only

[Former Member]

Dear Experts,

Our customer would like to show "Batch/Serial Transction Report" directly from AR Delivery Document using right click function on that document. Unfortunately, the report cannot be displayed and system message said that "Serial/batch report can be viewed from base document only".

Did we miss something?

Please give us a kind reason why.

FYI,

Not all Delivery document showed the same message. The batch report work well for some documents.

Thanks,

Indra.

[former_member1269712 · Accepted solution]

Hi Indra,

Open that document which is showing you message and check which is base document I think that delivery made base on Return. If you are making delivery based on Return then Serial/Batch report will show on rentrun transaction only.

Thanks

Sachin

[Former Member · Accepted solution]

Dear Sachin,

So many thanks for your response.

But, the base document is come from "Sales Order" document, not Good Return document.

We already try to use another Batch Transaction report from menu Inventory Report in the Inventory Module.

But it also showing the same message.

Is there any way to retrieve the batch report?

Thank you,

Indra

[former_member1269712 · Accepted solution]

Hi Indra,

Try this query...

SELECT T0.[ItemCode], T0.[ItemName], T0.[BatchNum], T0.[WhsCode], T0.[Quantity], 
case when T0.[Direction]=0 then 'In' when T0.[Direction]=1 then 'Out' end, 
Case when T1.[Status]=0 then 'Released' end 
FROM IBT1 T0  
INNER JOIN OIBT T1 ON T0.BatchNum = T1.Batchnum and T0.Itemcode=T1.ItemCode 
WHERE T1.[ItemCode] =[%0] and T1.[BatchNum] =[%1]

Thanks

Sachin