|By: Guest||Posted on: Jun 2 2022 at 04:59:15 AM|
We have to run two databases, one in MiniMrp, and one to print labels for goods in. We copy the parts database from MiniMrp to an excel file, that our label printer uses.
We then stick a GRN label on our reels etc.
This take a lot of time, and we have just had two human errors selecting the wrong part.
Is there any way to output the GRN print to excel directly, we can then print real labels from the data, no risk and save time.
GRN DATE CODE DESCRIPTION QTY
6605 12/12/2021 ABCDE A Part we ordered 500
6605 12/12/20021 12345 Another part 300
Or any other way.
|By: Guest||Posted on: Jun 3 2022 at 10:24:24 AM|
|In the GRN windows there's no "Excel" button.|
But you could click with the mouse in the top left cell and drag over to the bottom right to highlight all the cells. On the Keyboard press CTRL-C (to copy)
Then open an excel sheet. Click into the top left corner and on the keyboard press CTRL-V To paste the data into excel.
Would that work for you?
|By: Guest||Posted on: Jun 5 2022 at 10:30:48 AM|
Thank you - did not think of that! works perfect, simple!
|By: Guest||Posted on: Jun 19 2023 at 01:25:06 PM|
|I am using Excel Power Query to pull data from the Database for labels. Its been working very well for us. |
You should be able to bring the database data into a searchable table in your label printing spreadsheet.
Reply - add a comment to this topic.
You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.