[version en cours de rédaction] | [version en cours de rédaction] |
Ligne 78 : | Ligne 78 : | ||
{{Tuto Step | {{Tuto Step | ||
|Step_Title=<translate>Import Steps</translate> | |Step_Title=<translate>Import Steps</translate> | ||
− | |Step_Content=<translate># Click "Next" for the first row | + | |Step_Content=<translate>#Click "Next" for the first row |
− | # Click "Next" for the first column | + | #Click "Next" for the first column |
− | # Change the "WorksOrderNumber" column to a "Text Column" | + | #Change the "WorksOrderNumber" column to a "Text Column" |
− | # Change the "BomReference" column to a "Text Column" | + | #Change the "BomReference" column to a "Text Column" AND the "Shelf Location" column |
{{Warning|...These steps are important because Monday will miss of the letters from the JC number and BOM reference}} | {{Warning|...These steps are important because Monday will miss of the letters from the JC number and BOM reference}} | ||
How to import a picking list created in Sage to a Monday board
Auteur Gareth Green | Dernière modification 13/12/2019 par Gareth Green en cours de rédaction ⧼frevu-button-review-label⧽
How to import a picking list created in Sage to a Monday board
Sage, Monday, Picking List, Import Importing_Picking_List_from_Sage_To_Monday_Annotation_2019-10-21_113243.jpg
This procedure demonstrates how to use the "Sage Hooks" MS Access database to grab the data created in Sage and exort to a spreadsheet. The spreadsheet is then imported into a new Monday board, then copied across to the correct Picking List for the machine build.
A pick run is a chunk or set of Job Cards that will be picked in a controlled amount. This is normally 10-20 job cards. it is managed in this way to keep the amount of time between the allocation on Sage and the physical pick as short as possible.
This is located in g:\Sage\Exports
Click "OK" or "Yes" if there is a security question to enable Macros
Then click "Create Board"
The destination board for a build is labelled:
Bnnn Picking List
Where Bnnn is the build number for the machine. They should be stored under the 'Stores' folder.
To create a new Picking List, simply duplicate one that is already there, and duplicate the "Structure Only"., and click "Keep subscribers"
Then rename it to the correct build number.
The picking list will now be populated with the exported parts
en none 0 Draft
Vous avez entré un nom de page invalide, avec un ou plusieurs caractères suivants :
< > @ ~ : * € £ ` + = / \ | [ ] { } ; ? #