packaging report

[Former Member]

hi,

i want to generate report to know the packaging material requirement.

It’s required to have a report which can figure out the requirement of Packaging material from the open Purchase Requisitions. The Date entered by the user in the selection screen should be considered as the Purchase Requisition Delivery date and the same should be used for picking the open Purchase requisitions and we have to calculate the requirements of the packaging material (cumulative) for week 1-3, week 4, week 5, week 6, week 7-8, week 9-10 and week 11-14.

The report that is generated should be in a downloadable format and it should also be sent to the vendor if the email address is given in the Selection Screen.

If there are no purchase requisitions available for the material then the Fixed Vendor should be displayed in the output.

Criteria to consider the Open Purchase Requisitions:

a.) The Purchase Requisitions that has been created through MRP only should be taken into account.

b.) Do not consider the Purchase Requisitions that have been converted into Purchase Order’s.

c.) Do not consider the Purchase Requisitions that has the Closed Indicator set in the Quantities/dates Tab at Item Level.

d.) Do not consider the items in Purchase Requisitions that has the deletion flag set at Item Level.

e.) The Purchase Requisitions that are partially converted into Purchase Orders should also be considered.

input selection screen fields:

T001W - WERKS Plant (mandatory)

DATE Delivery Date (mandatory)

MARA-MATNR Material (not mandatory)

T024- EKGRP Purchasing Group (not mandatory)

EMAIL Email Single with extension. (not mandatory)

output fields:

T001W - WERKS Plant

DATE Date (at which the report is run)

LFA1-LIFNR Vendor Number

LFA1-NAME1 Vendor Name

EORD-LIFNR Fixed Vendor

MARA-MATNR Material Number

MARC-ZZOLDNR Old Part Number

MAKT-MAKTX Material Description

EINA-IDNLF Vendor Material Number – Info Record

MARA-MEINS Base Unit of Measure

MARD-LABST On hand Inventory

Week 1-3

week 4

Week 5

Week 6

Week 7-8

Week 9-10

Week 11-14

MARC-NFMAT Follow Up Material

MARC-MMSTA Part Status

please send me detail code for generating this report

my emaid is srisaihar@yahoo.co.in

thank u in advance

srisaihari

[Former Member]

Hi Sri ,

u have to put ur logic and if u have any doubt u can ask anybody . But dont try like this.