cancel
Showing results for 
Search instead for 
Did you mean: 

purchase price list

Former Member

Hi,

When i am doing a goods receipt of an item , it is not updating the last purchase price list.

Pls advise.

Rgds

Accepted Solutions (1)

Accepted Solutions (1)

former_member583013
Active Contributor
0 Kudos

Praveen,

This question is similar to one from Freddy,

The main reason why the Last Purchase Price gets updated only after the A/P Invoice is because, there is a possibility that the price on the A/P Invoice can be different than the GRPO.

The AP Invoice price is the final price which is based on the Vendor's Invoice. In general business practise the GRPO price is the same as price on PO which is considered as the promised price by the Vendor

Please test this by creating the GRPO for an Item and then change the price on the A/P Invoice and see the Journal entry and the Last Purchase Price

Best wishes

Suda

Answers (2)

Answers (2)

former_member186095
Active Contributor
0 Kudos

Hi,

Based on F1 helpfile of SAP B1 2007A,

Last purchase price list - the price list is automatically updated when an item enters the stock with its entering price.

For more detail:

In addition, two price lists are automatically created and calculated by the system:

Last purchase price list u2013 the price list is automatically updated when an item enters the stock with its entering price.

Last evaluated price list u2013 the price list is automatically updated after you run the Inventory Valuation report.

Rgds,

Former Member
0 Kudos

Hi,

According to SAP:

Last Purchase Price List:

The prices in this price list are updated automatically by the system when the following transactions are performed:

1. When you enter an incoming invoice # see Purchasing

2. When you enter a goods receipt # see Goods Receipt

3. When you enter a positive opening balance for an item # see Inventory and Stock Postings

4. When you enter a positive inventory result that triggers a goods receipt # see Inventory and Stock Postings

5. When a product with a BOM is manufactured, where the price of the product is calculated from the last purchase prices of the components # see Production.

6. When data imports are performed

If none of these transactions have been performed in the system for an item, the "Last Purchase Price" price list will not contain the item

Only the list of the transactions mentioned above changes the price of an item in the "Last Purchase Price" price list.

Even if you enter one of these transactions, but assign it the value 0, the price will not be included or updated in the "Last PurchasePrice" price list.

You can refer other price lists to the "Last Purchase Price" price list with a defined factor. You cannot, however, change the prices in the "Last Purchase Price" price list manually.

Irina

Former Member
0 Kudos

Hi Irina,

according to your posting based on SAP note, I'm also getting that the price is not updated after good receipt but after AP invoice is created,

Or perhaps there is another setting in B1 that will be enable the system to updated the last purchase price after good receipt ?

Is there anyone know about this setting ?

Former Member
0 Kudos

Hi Praveen,

Base on my testing, last purchase price list will not be updated until A/P invoice created against your goods receipt PO.

If you only do a good receipt, it should not affect last purchase price list at all.

Thanks,

Gordon