Metcash Imports
Aegis #11025
- A new field on the stock record will be used to record the type of change to stock item that signals label should be printed. We will record price ups, price downs, promotions, description/comment changes, recently received items, and barcode changes. We will also maintain a printed flag. If a printed flag is present, and one of the above is changed, the flags will be cleared, and then set to the appropriate flag. If the printed flag is NOT present, we will combine the previous flag with the one required now (e.g using a logical OR)
- We will maintain an index of these flags and stock items, so as to allow a quick lookup when printing the labels.
- We will provide a new option in stlrep called Print Suggested Labels. This option will allow the user to filter the above mentioned index according to the type of change they want to print. Once a label has been printed, the entry will be removed from the index.
- A reindex of the stock file will also rebuild this index.
- We will add reporting to the metcash import for price ups and price downs
- Whenever we update an item through the import, we will ensure that the supplier is 3, which is IGA Distribution, regardless of what supplier is specified in the file.
- We will no longer create new suppliers.
- We will provide the user with the option to specify if they want to manually override the start and end dates of promotions. If they do decide to override them, the dates will be used for ALL the promotions in the file
Task |
Time Required(hrs) |
Ensure supplier is always supplier 3 and no longer create new suppliers |
3 |
Add reporting for price ups and downs |
1 |
Option to allow user to specify start/end dates of promotions |
2 |
Maitainance of Stock file and index of suggested items for printing labels |
5 |
Changes to Label printing stlrep program to allow filtering by new index |
3 |
Time for quote/documentation/testing |
3 |
Total |
17 |
Aegis #10960
Completed 8/12/06
- The stock codes provided in the import will be looked up in the alternate supplier stock code index. In the case where there is more than one exact match on the supplier stock code, we will ignore this line and report it.
- Any new items that are to be created from the import file will have their item number generated automatically. The supplied item number will be used as the supplier item number. Also, the default supplier for these items will be supplier code "3"
- Any promotional start dates will be treated as if they were specified to be the day before.
- The description(TID006) and comment(TID014) records will be switched.
- Creditor records (TID009) will have any leading zeros stripped, so as to ensure that no incorrect creditors are created.
- Category records (TID008) will have a special mapping applied. The first non-zero digit will be treated as the main category. This category will then have the same mapping applied as was used in the import. E.G, a category of 8 will map to the category of 0108, a category of 6 will map to 0106 etc
- Alternate Category records (TID015) will now be ignored
- We will also make some changes to the label printing program so as to allow the user to filter the items by creation date and by price last updated date. There will be a separate quote for the requested changes to the label layout.
Task |
Time Required(hrs) |
Updates to Metcash fields |
2 |
Changes to use different index for stock lookup |
1 |
Changes to label printing program |
1 |
Quote/Testing/Documentation |
1 |
Total |
5 |
$900