Skip to Content
0
Former Member
Apr 04, 2014 at 06:57 AM

Food Testing Follow Report

18 Views

Dear all SAP Expert,

I need your help to make a query for my Boss.

I'm using SAP B1 in meat processing company. My Boss want a report to show food testing that we give to customer and the progress of sales before food testing and after food testing done.

So, the procedure that I make is like this :

  • I'm using Good Issue Module to make issue of Finish Good for food testing. I'm using UDF in title :
    • U_Customer ==> to record customer that do food testing
    • U_GI_Reason ==> user fill with "FOODTEST" to give tag for food testing activities

The report that my boss want is :

  1. Column 1 ==> food testing date ==> based on posting date in Good Issue Module
  2. Column 2 ==> Customer name ==> based on customer name in Good Issue Module
  3. Column 3 ==> Item Code ==> based on item code in Good issue module
  4. Column 4 ==> Item name ==> based on item name in Good Issue module
  5. Column 5 ==> Sales last 6 months ==> based on sales for item that food tested in period 6 months before food testing date
  6. Column 6 ==> Food testing value ==> based on total value in good issue module
  7. Column 7 ==> Sales 1-15 days ==> based on sales for item that food tested in period 1-15 days after food testing date
  8. Column 8 ==> Sales 6-30 days ==> based on sales for item that food tested in period 16-30 days after food testing date
  9. Column 9 ==> Sales 31-45 days ==> based on sales for item that food tested in period 31-45 days after food testing date
  10. Column 10 ==> Sales 46-60 days ==> based on sales for item that food tested in period 46-60 days after food testing date

I'm really thank you for any one that can help me to make this query. I'm really appreciated for your kind help