‘Menus’ – ‘Purchase Orders’ – ‘Import Purchase Orders’
To enter a new Purchase Order from Excel, select ‘Import Purchase Order’ from the PO_Template‘Purchase Orders’ menu as shown below.
You can also open this form from the following toolbar icon.
This will firstly open the currency selection screen, where you can select in which currency this purchase order will be entered in.
If batches are in use, you will see
From here you can select which batch this transaction will be linked with. For more information on the behaviour of the batch field please click here
The import purchase order screen will now display as shown below.
Please click on the image to view it full screen, then the back button to return.
Above the grid are several fields that relate to the purchase order as a whole, the PO number, a description, the date, the amount, the delivery conditions and a tick box to select whether the PO should only be included in the ledger after the next period reset. The transaction number and currency information is shown in the top right hand corner as well.
As usual any fields shown in blue are mandatory, and the form cannot be saved until text has been entered in these fields.
Next copy your purchase order entries from Excel using ‘Edit’ – ‘Copy’ (inside of Excel), or instead use your operating system shortcuts (Ctrl-c for PCs, or Command-c for MACs). Then come back to mydaEs and press the ‘Paste from Excel’ button. The information will now be visible onscreen in the grid.
Below is an example after the ‘Paste from Excel’ button is pressed. mydaEs attempts to validate your entries, and if any entries fail validation, they will be shown in red. Any fields that are mandatory but not yet filled in, will be shown in blue. The entry will not be able to be saved until these are corrected.
Please click on the image to view it full screen, then the back button to return.
The columns shown onscreen will change depending on the requirements in your project. You may see a location and/or set field. There can also be a free field and 1099 code field as well. If GST or VAT has been selected for this currency, you will also see a GST/VAT Code field as well as the money fields which change to display Net/GST(VAT)/Gross rather than just an amount field. Most of these fields have look-up forms behind them to assist your data entry. You can just type in the start of what needs to be entered and tab out of the field to either bring up the look-up screen to assist you during data entry.
You can right click any line in the grid to bring up 3 extra options to either add in another line, delete the current line or clear all entries in the grid to start again.
At the bottom of the screen you can press the ‘Find’ button to bring up the ‘Find Transactions’ report or the ‘Find POs’ button to bring up the ‘Detailed PO’ report.
At the top of the screen is an ‘Attachments’ tab, where you can manually link documents to this purchase order. The documents are then saved in mydaEs for viewing/retrieval later, rather than keeping paper files.
You can press the add button and then locate the document/s you wish to attach. You can also drag and drop the files direct from ‘Computer’ on your PC or ‘Finder’ on your MAC. You can also choose to then view/export or delete the attachments you have imported.