WAREHOUSE BOXES - RULE FOR REPLACE

Hello everyone,
I need to set up a workflow where, reading from an Excel warehouse file, I have a series of homogeneous products categorized by CATEGORY, PRODUCT, and SIZE. Some products are assigned to customers while others are free and therefore assignable. I need a rule that will alert me when, under the same conditions of:

CATEGORY
PRODUCT
SIZE

there is fresher merchandise already assigned that can be replaced with older merchandise.

I am able to prepare the part of cleaning the Excel file, but I am unable to create the rule.

attached an example of warehouse data

Thank you very much for your support.

I don’t see an attachment.

2 Likes

Cartel1.xlsx (9.2 KB)

here the attachment

sorry

Can you also draft your expected output to confirm and better understand what you are looking for?

If I look at the file it appears that you want to replace FREE with CUST-01 because that’s the last known customer for CAT1,Product/A,050CM?

1 Like

Hi @ArjenEX,
thanks for your support
Cartel1.xlsx (9.3 KB)

I need to understand if our internal sofware recognize this and work well
the excel file have to allert me if some changes hasn’t be made

thanks

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.