shikin
Participant
Member since ‎06-26-2020

User Statistics

  • 83 Posts
  • 0 Solutions
  • 4 Kudos given
  • 1 Kudos received

User Activity

Duplicate PO Number in SQL Query

10-02-2023
Hi everyone. I have linked the outgoing payment, invoice n etc in one query but the results when i get is duplicated rows when i include in PO number in this query. Please refer my sql query below: SELECT <br>T3.[GroupName], <br>T0.[DocDate], <br>...

SQL Query for Production Order Layout

09-26-2023
Hi experts. I have one SQL Query that i want to use it in my crystal reports but there are some value appeared to be wrong. Here is my code and the current output. SELECT distinct '1st Row' as 'type', t1.DocEntry, t0.bomCode as 'bomCode', ...

Production Order Layout

09-24-2023
Hi all. I am using SAP B1 version 10 where i have a configurator for BOM and also Sales configurator. Meaning that by default it will follow BOM configurator and at the same time sales PIC also can configure when the time they want to create Sales ...

Formatted search for Delivery Order

08-15-2023
I have this one sql query that i want to use it in Delivery Order item details column. Here is my code: if (SELECT 1 FROM ORDR T0 <br>INNER JOIN RDR1 T1 ON T0.DocEntry=T0.DocEntry<br>WHERE isnull( T0.[U_Unit] ,0)>0 and T1.[ItemCode] =$[dln1.itemc...

Formatted Search to change document series in Purchase Request

08-03-2023
Hi. Currently the default series when we creates Purchase request is 'Primary'. But now I need to separate it if IT department then they need to use 'Indirect' series that I already created. Right now my user need to manually select the series and ...
View more
Kudos from
View all
Kudos given to