Do you know how to set up the purchase order expiry days for a supplier or set of suppliers in bulk?

Do you know how to set up the purchase order expiry days for a supplier or set of suppliers in bulk?

Purpose of Maintaining the Expiry in Purchase Order :

Inventory Management: Including expiry dates in purchase orders helps retailers keep track of product shelf life and manage their inventory effectively. This ensures that products with shorter shelf lives are sold first, reducing the risk of spoilage or wastage.

Minimize Losses: Maintaining expiry dates enables retailers to identify products approaching their expiration and take timely actions, such as offering discounts or removing them from shelves, to minimize losses.

Benefits of Maintaining the Expiry in Purchase Order :

Optimize Stock Rotation: By monitoring expiry dates, retailers can implement first-in, first-out (FIFO) stock rotation practices, ensuring older items are sold before newer ones, preventing expired stock from accumulating.

Enhanced Customer Experience: Retailers can ensure that customers receive fresh and quality products, leading to higher satisfaction and trust in the store's offerings.

We have two Configurations namely "Expiry in PO" and "PO expiry days" to set the Expiry date for a Purchase Order.

Expiry in PO - This configuration must be enabled if we need to give an expiry date for a PO. In-order to enable configuration : Go to Tools → Configuration → Business Configuration → Search with "Expiry in Po" and enable the respective configuration as per the below screen shot.

Step 2 : Go to Purchase -> Purchase Order screen.

Enter a date on which PO Expires in the Expiry date field in the Purchase Order Screen as per the below screen shot.

 

PO Expiry days - This configuration can be used when we need to give a standard time of expiry for all POs.

Note: "Expiry in PO" must also be enabled if this configuration is to be used.

In-order to enable this configuration : Go to Tools → Configuration → Business Configuration → Search with "PO expiry days" and enter the number of days in which a PO should expire and click save.

 

Let's say we set the number of days as 4, then in PO screen, the expiry date will automatically load as 4 days from the current date. If we wish to change it then we can click on the field and edit the date.

 

To verify the Purchase Order Expiry date in Report :

Go to Reports → Purchase → Transactions → Purchase Order Summary





FAQ :

1) The expiry date column is not visible in the purchase order summary report, and we need to know how to enable it?

To make the expiry date column visible in the purchase order summary report, you should enable it from the report settings column corresponding to the specific report, as shown in the screenshot below.