Hi Team,
I am using SAP B1 9.2 PL09. Today i have faced one new Issue in SAP Standard Functionality. While Taking inward two serial number Item through GR(DocNum : 1). First Item serial number was not updated in serial number table. second item se...
Hi,
How to take serial number wise GRPO & Delivery details for trading Item. The below Script has working fine but it's taking too much of time to Run. How to simplify this Query?
select T0.ItemCode,T0.itemName,T0.DistNumber,
(select T1.BaseN...
Hi All,
I have develop the below query to take inventory aging report, Almost i got a solution. Here i required your suggestion to complete this report. The below is my query,
select Distinct T0.ItemCode,T0.OnHand,
CASE WHEN Datediff(day, T1....
Hi,
When i'm trying to execute query based schedule report, I'm getting below error Log file
sap-error-file.txt
Steps I have Done It,
1. First i have create a query report and it's working.
2. Then i create a layout by create report option...
Hi Balakumar Viswanathan, Thanks for the reply. Still i'm not clear on license part. How to assign SDK License? You mean any SAP B1 customer can create & Assign SDK License !!!?Cheers!Prabakaran R
Hi Vimal, Try this below query,SELECT father FROM ITT1 where father not in (select code from OITT)You will get Deleted parent code from OITT. Then use below query to take child component details of deleted parent item,Select * from ...
Hi Team, The below approval query will give the solution for this question,SELECT Distinct 'True' from INV1 T1
Inner join OINV T5 on T5.DocEntry = T1.DocEntry Inner join OCRD T2 on T5.CardCode=T2.CardCode
where T5.DocStatus='O...
Hi John Ellis, This all can be done through Crystal report or PLD.(1) Proforma Invoice - This document has to be taken from Sales order (Duplicate of sales order)(2) Packing Slip - If you are doing partial shipment from sales order...
