Purchase Price Mgmt

[kevin_kettels]

I have set some test items up under P41061/ Supplier Item/Price Revisions and included effectivity dates.
For example: Item xyz @ 2.00 for period 8/01/02 to 8/31/02
and also item xyz @ 1.00 for period 9/01/02 to 12/31/02

Using the PO Entry P4311 I have discovered that the price that flows into the PO is based upon the order date "TRDJ".

Therefore entering an order on 8/13/02 for delivery in Aug/02 yields a price of 2.00/unit. Entering an order on 8/13/02 for delivery in Nov/02 also returns a price of 2.00/unit, not the expected 1.00.

JDE is basing it's price lookup functionality on the order date and not the requested delivery date "DRQJ".

Has anyone else ran into the need to base supplier pricing on requested delivery date and if so how have you worked it out. My call to the support line people left them a little dumbfounded. Their comment was that this functionality was to take advantage of lower prices from vendors before their new higher prices take effect. I have the transverse, the prices are going down at a future date. Some of our items have 12+ week lead times therefore we can not wait to place the order until we reach the starting effective date. We could fudge the order date, but that then creates other issues. Maybe it's mod time for P4311.

Any assistance is appreaciated.

World A8.1 Cum 2.

 

[Niranjan]

See attachment.
Check if this helps you.
Regards,
Niranjan
Systemic Software Solutions India Pvt.Ltd.

 

[vasuvv2300]

This was a problem with one of my customers. I hit my head with JDE and got a noted for Future comment. This would mean next decade(Hope !!).

Well, I solved it by using the item pricing rule and vendor pricing rule. Have the rules as the dates and it will work. Ask the users to enter the requested delivery date in the pricing rule. This is an extra burden but it is better than modifying the software.

In the vendor pricing instructions, attach the prcing rule to the vendor say test.

Set up the Inventory pricing rules 40/PC UDC as different dates you require the price for. You could even give the month code, if you have monthly prices. Or else use some codes which the users will understand.



In the inventory pricing rules, attach the pricing group and item number in the fold area. Remember now the effectivity date does not matter to you because you are going to use the pricing rule for the date. Enter the quantity as the max quantity you will order at any time.

In supplier pricing rules , reset all the levels for different dates.

I think this should work. I made it work. If you want I can let you know the full set up and an example.

 

[DVerner]

In general I am not for mods to the software, but.... we did mod P4311 to
use requested date.
For you programmers this is a easy mod. Be sure to document.

1579.30 C* Load Required fields for retreiving Price information
from
1579.40 C* the Catalog / Price Breaks file (F41061).
1579.50 C*
1579.60 CSR MOVE PDAN8 @6AN8
1579.70 CSR MOVE $$CNV @6CNV
1579.80 CSR MOVE VDCRRP @6CRRP
1579.90 CSR MOVE VDCRCD @6CRCD
1580.00 CSR MOVE SHCATN @6CATN
1580.10 CSR MOVE SFUOM @6UOM
1580.20 CSR MOVE SFUOM3 @6UOM1
1580.30 CSR MOVE $$UORG @6UORG
1580.40 C*
1580.50 C*R VDTRDJ IFEQ *BLANKS
1580.60 CSR SFDRQJ IFEQ *BLANKS
1580.70 CSR MOVEL$$EDT $NBR6
1580.80 CSR ELSE
1580.90 C*R MOVEAVDTRDJ @NM
1581.00 CSR MOVEASFDRQJ @NM
1581.10 CSR EXSR C0012
1581.20 C* ---- -----



Dan Verne