Global Delete of Price Information (tdpcg0200m000)

Use this session to delete pricing information from (a selection of) the following sessions:

  • Matrix Priorities (tdpcg0120m000)
  • Sales Price Matrices (tdpcg0130m010)
  • Purchase Price Matrices (tdpcg0130m020)
  • Transfer Price Matrices (tdpcg0130m030)
  • Sales Line Discount Matrices (tdpcg0130m110)
  • Sales Total Discount Matrices (tdpcg0130m120)
  • Purchase Line Discount Matrices (tdpcg0130m130)
  • Purchase Total Discount Matrices (tdpcg0130m140)
  • Line Promotion Matrices (tdpcg0130m210)
  • Order Promotion Matrices (tdpcg0130m220)
  • Client Freight Rate Matrices (tdpcg0130m310)
  • Carrier Freight Rate Matrices (tdpcg0130m320)
  • Price Book Lines (tdpcg0131m000)
  • Discount Schedules (tdpcg0121m000)
  • Freight Rate Books (tdpcg0150m000)

You can create a report to display all pricing information that has been deleted.

Note
  • To generate a report simulating the update of deleted pricing information, you must select the Simulation Only check box and the Print Changes check box.
  • To actually delete the information, you must clear the Simulation Only check box and select the Print Changes check box.

 

Delete to Expiry Date
Pricing information with an expiry date and time that falls before the date specified in this field, is deleted.
Delete Duplicate Lines without Expiry Date
If this check box is selected, price matrices, price books, default price books, or freight rate books without an expiry date are deleted, provided more recent and unexpired pricing information is available for these documents.

If this check box is cleared, only expired pricing information is deleted.

Example

This table shows the lines of price book AAA000001:

Price BookItemEffective DateExpiry Date
AAA000001X1 January15 January
AAA000001X15 January-
AAA000001X20 January-
AAA000001X30 January

 

Delete to Expiry Date: 21 January

This happens to the price book lines if you run this session with the Delete Duplicate Lines without Expiry Date check box selected:

  • The first line is deleted, because it is expired.
  • The second line is deleted, because a more recent unexpired line is effective (line 3).
  • The third line is kept, because this is the most recent line that is effective for the price book.
  • The fourth line is kept, because its effective date is in the future.

If you run this session with the Delete Duplicate Lines without Expiry Date check box cleared, only the first line is deleted.

Delete Matrix Priorities
If this check box is selected, information from the Matrix Priorities (tdpcg0120m000) session is deleted.
Note

Only matrix priorities with an expiry date that falls before the Delete to Expiry Date are deleted. The Delete to Expiry Date must be before the system date.

Delete Price Matrices
If this check box is selected, depending on the Matrix Type that you select, pricing information is deleted from the following sessions:
  • Sales Price Matrices (tdpcg0130m010)
  • Purchase Price Matrices (tdpcg0130m020)
  • Transfer Price Matrices (tdpcg0130m030)
  • Sales Line Discount Matrices (tdpcg0130m110)
  • Sales Total Discount Matrices (tdpcg0130m120)
  • Purchase Line Discount Matrices (tdpcg0130m130)
  • Purchase Total Discount Matrices (tdpcg0130m140)
  • Line Promotion Matrices (tdpcg0130m210)
  • Order Promotion Matrices (tdpcg0130m220)
  • Client Freight Rate Matrices (tdpcg0130m310)
  • Carrier Freight Rate Matrices (tdpcg0130m320)
Note

Only pricing matrices with an expiry date that falls before the Delete to Expiry Date are deleted. The Delete to Expiry Date must be before the system date.

Delete Price Books
If this check box is selected, pricing information from the Price Book Lines (tdpcg0131m000) session is deleted.
Note

Only price books with an expiry date that falls before the Delete to Expiry Date are deleted. The Delete to Expiry Date must be before the system date.

Delete Base Price from Default Price Books
If this check box is selected, price books are deleted that have the Base Price check box selected in the Price Book Lines (tdpcg0131m000) session.
Note

Only price books with an expiry date that falls before the Delete to Expiry Date are deleted. The Delete to Expiry Date must be before the system date.

Delete Freight Rate Books
If this check box is selected, pricing information from the Freight Rate Books (tdpcg0150m000) session is deleted.
Note

Only freight rate books with an expiry date that falls before the Delete to Expiry Date are deleted. The Delete to Expiry Date must be before the system date.

Delete Discount Schedules
If this check box is selected, pricing information is deleted from the Discount Schedules (tdpcg0121m000) session.
Note

Only discount schedules are deleted with an expiry date that falls before the Delete to Expiry Date. The Delete to Expiry Date must be before the system date.

Simulation Only
If this check box is selected, a report simulating the update of deleted pricing information is displayed. The data update is only displayed not processed.
Print Changes
If this check box is selected, a report with the (simulated) changes is printed.