receiving_goods:supplier_invoices

This is an old revision of the document!


7.01. Receiving goods (supplier invoices)

All received goods should be recorded in mSupply either by:

  • Entering a supplier invoice; or
  • Using the purchase order system, which leads to the creation of a supplier invoice when you finalise a goods receipt.

In some countries a supplier invoice is called a “bill”.

Confirming a supplier invoice is what actually puts the goods into stock in mSupply, ready for issue. It calculates the selling price based on the margin you have chosen for that supplier or for that item, depending on how you have set your mSupply preferences.

You will notice there is a Prices tab in the Supplier Invoice window - this is for use with invoices received in foreign currencies, which will usually be done via the goods receipt system.

Each line received on a supplier invoice will be treated as a separate line in your stock. You can manually consolidate these later, or set a preference to automatically consolidate items with the same batch, expiry date, pack size, location, donor, cost and sell price.

If you are receiving the goods from another virtual store in your mSupply system, and they are not responding to an internal requisition (purchase order) from your store, then they should have followed the procedure for transferring goods to another store.

Provided that they have finalised their customer invoice, a new supplier invoice will be created automatically in your store, populated with the stock lines that they are sending to you. In this instance, you should NOT create a new Supplier invoice, and can skip most of the following section.

Search for this automatically created invoice using Suppliers>Show invoices…

Depending on the store preferences, the supplier invoice may be finalised. If not, you will be able to add, edit or delete lines on the supplier invoice if what you actually received is different to what the supplier invoice states…

To create a new supplier invoice, choose Supplier > New invoice. The supplier invoice entry window will open with the cursor in the Name field:

If you have turned on any of the custom stock fields in store preferences they will be displayed as columns (between the Batch and Expiry columns) in the list of invoice lines and the information you entered for these fields will be shown in the appropriate cells.

Name: Enter the first few characters of the supplier's name, and then press the Tab key. Any name that has the “Supplier” check box checked can be used. If only one name matches the entry, the supplier name will be filled in. Otherwise, a list will be displayed:

Double-click the appropriate entry, or click Cancel to try again. You can also use the up and down arrows or the “u” and “d” keys on the keyboard to move the highlighted item up or down, then click the Use button or use the Enter key to choose the highlighted item.

Select a Requisition to associate with the new Supplier Invoice, then click OK.

This will return you to the Supplier Invoice window with the name of the supplier you have chosen entered in the Name field.

The downward pointing arrow to the right of the Name field takes you directly to the Edit Customer/Supplier window, giving access to all the information relating to the name entered.

Their ref: Enter the serial number on the bill the supplier gave you.

Comment: Click on the downward pointing arrow to the right of the Comment field to display a window where any comment relating to this invoice can be noted.

Category: Category for supplier transaction is created in File>Preferences>Invoices1 . The categories created are listed in this category field.

Colour: Clicking on the colour box in the top right corner presents you with a selection of eight colours from which the desired one should be selected; this does not make any change on the invoice window itself, but when the list of invoices is displayed, the line showing this particular invoice will show the entry using text of your chosen colour.

Confirm date: This is normally read only but will be editable if the “Allow entry of dates on invoices” preference is turned on in Preferences on the Invoices 1 tab.

There is some information at the top of the invoice that is read-only and cannot be edited:

  • Invoice number: This is the invoice number. The number is automatically incremented and assigned when the invoice is first saved (which actually occurs when the first line is added to it) and is unique within a store. Note that supplier invoices in different stores could have the same invoice number.
  • Entry date: The date the invoice was created.
  • Confirm date: The date the invoice was confirmed. Will be “00/00/00” if the invoice has not been confirmed.
  • Status: The current status of the supplier invoice:
    • nw = new (just created, can still be edited, stock not yet added to mSupply)
    • sg = suggested (has been opened since first creation, still editable, stock not yet added to mSupply)
    • cn = confirmed (stock has been added to mSupply but invoice is still editable)
    • fn = finalised (stock has been added to mSupply and the invoice is no longer editable)
  • Goods received ID: If the supplier invoice was created automatically when a goods received note was finalised then the goods received note's ID will appear here in blue, indicating that it is a link and, if clicked, will open the goods received note.
  • Purchase order ID: Again, if the supplier invoice was created automatically when a goods received note was finalised then the ID of the purchase order which the goods were ordered on will appear here in blue, indicating that it is a link and, if clicked, will open the purchase order.
  • Requisition ID: If the supplier invoice was linked to a requisition, the requisition number appears here.
  • Entered by: The user name of the user who created the invoice.
  • Store: The name of the store the invoice belongs to.

New line: Add an item to the invoice. See Adding lines to an invoice below for more details. To edit a line, double-click on it.

Add items from requisition: Displays a list of items from the linked requisition, which you can add to the supplier invoice. You can add one or more items by highlighting them and clicking OK. To edit a line, double-click on it.

Delete line: Delete item(s) from an invoice. Highlight the line(s), then click this button. Multiple lines can be deleted simultaneously.

Hold checkbox: If checked, the invoice status cannot be changed.

Note: Items on a supplier invoice with new (nw) status have not been entered into the system yet. Putting a new invoice on hold allows you to enter the supplier invoice, but not allow the stock to be available for issuing until all the details have been checked.

Finalise check box: If checked, clicking the OK button will finalise the supplier invoice. Once finalised, the invoice can no longer be edited so be sure first that all the details are correct. Only users with the Can finalise individual invoices permission can check this box. Other users will be warned if they try to turn it on, and the check box will automatically uncheck.

When the OK button is clicked, you will be asked to Confirm invoice and enter into stock now?

  • If you click Later the invoice will still have a new (nw) status
  • If you click Confirm and the Finalise box was not checked, the invoice will be confirmed (cn)
  • If you click Confirm and the Finalise box was checked, the invoice will be confirmed (cn) and finalised (fn)

A finalised invoice cannot be edited.

Should a finalised invoice need to be changed, the entire invoice may be cancelled, and the correct data may be entered as a replacement.

In order to maintain the accuracy of any subsequent audit trail, mSupply creates a transaction which reverses all the stock movements on the invoice being cancelled, having due regard to all appropriate details, such as batch numbers, etc. See Cancelling finalised invoices

If Confirm supplier invoices without asking is checked in the “Invoices 1” tab of the Preferences window, then all invoices will be finalised automatically.

If you have the store preferences set to force supplier invoice authorisation, you will not be able to confirm supplier invoices until they have been authorised. See here for details.

Copy: Copies the invoice details to the clipboard, allowing you to paste them into a spreadsheet or email message.

Delete: Deletes the entire invoice. When deleted, there will be no trace of your entry and the invoice number assigned will be reused.

Note: Unless the invoice has a new (nw) status, if you have added lines to an invoice, you must manually delete each line using the Delete line button before deleting the invoice. This is intentional, to save the “Oops, I just deleted my invoice with 100 lines on it” feeling. <HTML>

</HTML>

Invoice status Description
nw The invoice has just been created - clicking Delete will automatically delete each line and the entire invoice
sg The Delete button will only delete the invoice if you have first deleted all lines using the Delete line button
cn Same as for suggested (sg) status
fn No changes or deletions can be made and the Delete button will be disabled

<HTML>

</HTML>

Print checkbox: If checked, the supplier invoice or packing slip will be printed when the OK button is clicked. If the supplier invoice has a suggested (sg) status, a packing slip will be printed; otherwise an invoice will be printed.

OK: Saves the changes you have made and exits the window.

OK and Next: Saves the changes you have made and opens a new supplier invoice.

General tab

This shows a detailed view of each line on the invoice. This is the tab you see when you first open or create a customer invoice.

Summary by item tab

Displays a summary of each item's requested quantity, sent quantity and received quantity. Different batch numbers of the same item are consolidated into a single line.

Summary by batch tab

This tab shows each batch but grouped by item and showing summary price information for each batch.

Price tab

There can be a lot of information on this tab! It is all detailed in the Price tab section below.

Log tab

The log tab displays all the log entries that have been made regarding this invoice. All log entries are stored in the mSupply log and this tab will display all the log entries in there which were made for this invoice.

Custom data tab

This tab shows the custom fields that have been set up for supplier invoices.

All custom data will be saved with the invoice (i.e. when you click the OK or OK & Next button).

Click the New line button to add a line to the invoice. This window appears:

The cursor will be in the field ready for you to enter the item name.

Item: Enter as much of the item name (or code) as you know, then press the Tab key. As usual, if only one entry matches, it will be filled in. More than one matching entry will present you with a list from you should double-clicking on the required item. The text you type will be matched against both the item name and the code. A match for either will display the item.

Note: To query for an item name or code that contains (rather than starts with) “250mg” (for example), enter “@250mg” in the search field (without the quotes).

Hint: you can use the “up” and “down” arrow keys to change the highlighted item (You can also press u to move up and d to move down!) . Pressing the enter key will choose the highlighted item.

Note: If you did wish to apply a different margin to the whole invoice, click the cancel button, and edit the margin for that supplier by choosing Supplier >Edit supplier and change the margin. If you wish to apply a different margin to just some lines, you can do this as you enter the lines, as long as Editing margins is enabled in the Preferences.

If the the item you are entering is not listed, you can click New item to add it.

Note: it is a good idea to agree upon a standard form for entering items. For example, will you enter an “infant feeding tube” as:

  • “infant feeding tube”
  • “feeding tube, infant”
  • “tube, infant feeding”

Duplicated items can later be merged, but it is better to get it right first time!

Note: if you need to see the full details of the item itself after selecting it, click on the down arrow icon () to the right of the item name field and you will be taken to the item's details window.

Now there are a series of fields to enter to fill in the basic information for the line

Sent quantity: How many packs did the supplier send? (Sometimes this is different to the quantity received!)

Received quantity: How many packs did you receive?

Pack size: How many units are in each pack?

Total quantity: mSupply will automatically calculate the total quantity of individual units (received quantity x pack size).

Note: Say you receive 50 packs of 100 amoxycillin caps, you should enter “50” in the received quantity field and “100” in the pack size field. However, if you issue the capsules in strips of 10 to customers (e.g. you allow them to order 20 or 30 capsules), you should enter quantity “500” and pack size “10”.

Pack to one: Clicking this button will automatically redistribute the total quantity received to pack size to 1.

Batch: The batch number or other identifying information. The batch appears on the invoice, so you can use this field to differentiate between brands if you need to (eg you operate using generic names, but occasionally want to give a specific brand- you can put an abbreviation for the brand name here as well as the batch).

Expiry: You can use “/” or “.” to separate the day/month/year. Note: Use whichever date format you have set in your computer (dd/mm/yy or mm/dd/yy or yy/mm/dd). You can enter the year as 2 digits, which will be understood as a date between 1961 and 2060. This should cover the expiry date on most things you receive in the next 52 years!

Location: The location of the item should be entered in this field.

Volume per pack: How much space the pack occupies in metres cubed (m3).

Invoice line unit cost: Enter your cost price for one pack of the pack size you entered above. If your supplier's currency is different to that of mSupply the cost price will appears in the supplier's currency.

Adjusted local cost: Displays the cost of a single unit of the item in local currency.

% Margin and sell price: If you have allowed editing of these fields in Preferences, you can adjust the margin (and the sell price will adjust automatically), or you can adjust the sell price (and the margin will adjust automatically).

Manufacturer: This field displays the name of the manufacturer of the item. It will only be shown if you have turned the Able to specify manufacturer when receiving, ordering or quoting for items preference on in the store preferences.

Entering a manufacturer follows the same pattern as entering an item or supplier - type the first few letters of the manufacturer's name or code, and press the Tab key. Choose the required manufacturer from the list if more than one is displayed.

You can add a new manufacturer by clicking on the New button.

Donor: The donor of the item can be entered to this field. A valid donor should be entered, type the wildcard character '@' and press the TAB button to view your list of donors.

Price extension: This information field provides the cost price in local currency for the total quantity of the item you have entered.

Custom fields 1-8: The appearance of these fields is controlled by the Custom stock field preferences. Any information you enter in these fields will be displayed wherever stock information is displayed (e.g. when issuing stock on a customer invoice or when viewing the stock of an item on the stock tab of the item details window). The fields can also be reported on so they are an important and powerful way of tracking different categories of stock. For full details please see Custom stock fields.

Click OK if you are finished, or OK & next to add another line. (The invoice lines added will be displayed in Items Display Field.)Click Cancel to exit to the main screen without saving any of the details.

mSupply provides the feature of receiving service items into stock. Service items are items that are not normally held in stock and are called non-stock items in mSupply. See here for more information on those. One use of service items is for managing assets. For more information on this, see the chapter on Asset Management.

Supplier invoice lines can be edited at any time until the invoice is finalised.

To edit a line, simply double-click on the line you wish to edit.

Editing lines if stock has been issued

If you have already issued stock of this line to a customer, you will be warned with a window like this:

Clicking View issued invoices will show you a list of customer invoices containing this particular line:

Clicking OK will take you to the item issue window, where certain fields only may be edited. You may not reduce the received quantity to a figure lower than the quantity already issued.

The item issue window: You will be presented with a window where you can edit the line details in much the same way as when entering new details.

In the graphic above you will notice the “units issued: 100” text in blue to the right of the Quantity field. This will only be present if stock has already be issued to customers. You can click on that text to display a list of issued invoices as described above with the View issued invoices button.

Note that the OK & Next button is very useful for editing a whole invoice. Simply double-click the first line of the invoice, then use the OK & Next button to go from line to line.

Note also that many options for the window are set in the mSupply Preferences. For example, whether or not line one is chosen automatically, and whether you can use placeholder lines.

Resizing columns: These columns are resizable. If any of the column data is cut-off or remains hidden, the column width can be increased or decreased by positioning the mouse at the borders of the column. The cursor changes to a cross with arrowheads on the horizontal bar. Click and drag the cursor to the left or right.

Sorting columns: Columns may be sorted either in ascending or descending order by clicking on the header.

The order of the columns can be re-arranged by clicking on the header and dragging it to the new position.

To delete a line, do one of the following:

  • Click on the line you wish to delete, then click on the Delete line button:
  • Double-click the line to edit it (see above) and set it's quantity to zero.

Click the OK button. You will be asked for confirmation. Click OK to proceed.

You cannot delete a line from a supplier invoice that has been finalised.

Selling price calculations in mSupply

mSupply uses a number of items of information to calculate the selling price of an item. This enables you to have the price calculated just the way you like it.

Here's the logic mSupply uses:

  • Does the item have a selling price specified? If it does, this price will be used regardless of any other information. Note that the price entered for the item is for one unit. The price will be multiplied by the pack size to get the selling price for the line.
  • If either the supplier margin or the item margin is specified as zero, then the other (non-zero) value will be used?
  • If a margin is specified for both the supplier and the item, the Preference Item margin overrides supplier margin will be examined to see if it is on or off. If it is set, the item margin will be used, if not the supplier margin will be used.

For example: <HTML>

</HTML>

Cost price Pack size Supplier margin Item margin Preference set for Item margin overriding Supplier margin Item price Price used
100 100 6 10 yes 1.15 115
100 100 6 10 no 1.15 115
100 100 6 10 yes 0 110
100 100 6 10 no 0 106
100 100 0 10 no 0 110
100 100 6 0 yes 0 106

<HTML>

</HTML>

Note that if you have turned on “allow editing margins and sell prices on supplier invoices” in the Preferences you will be able to over-ride the prices mSupply calculates.

This tab provides functions for applying discounts and apportioning different charges to items.

Applying a discount to the whole invoice

If a supplier gives a discount at the bottom of the invoice rather than adjusting the price of each invoice line, you can use the discount button.

This window will be shown:

If you enter “5” the cost price of each line will be reduced by 5%, and the invoice total will be recalculated. It should then match the amount the supplier is actually charging you.

If you want the sell price calculated based on the new cost price, check the “Recalculate sell price” checkbox. The selling price rules as described above will still apply.

Applying local charges

Local charges are any charges you want to add to the cost of individual items on this invoice in your data file's local currency (i.e. the default currency used in your data file - this might not be the same as the currency you use when you visit a local shop!). These could be administration charges, local freight charges, handling charges etc.

You can either enter the amount of local charge to apply to each invoice line or the total amount of charges to apply to the invoice.

Entering local charge amounts on each invoice line

You do this by directly entering the amounts to apply to each line in the cells of the Local charge column in the table. As you do this, mSupply will automatically increase the sell price per pack by the amount you have entered divided by the number of packs for the line and will add the amount you entered to the current value in the Local charges field above the table.

Entering the total amount to apply to the whole invoice

To do this, you simply enter the total amount in the Local charges field above the table. When you do that, mSupply will automatically apply a portion of the local charges to each invoice line's sell price, according to the ratio of that line's Price extension to the sum of all the Price extensions of all lines on the invoice. You can see how much mSupply added to each line in the Local charge column. If you wish, you can edit the local charges applied to each line after this by simply clicking on the appropriate Local charge cell in the table and typing in the cost to apply. As you do that, mSupply will keep track of the total local charges applied to all lines in the Local charges field.

Applying foreign currency charges

These charges are applied in the currency selected in the currency selected in the Currency drop down list, following the rate displayed in the Currency rate field (which you can manually adjust if the default shown by mSupply is not what you require). The charges could be, for example, international freight charges or administration charges.

Simply type the amount of foreign currency charges to apply to the whole invoice in the Extra foreign currency charges field and mSupply will apply a portion of the whole amount to each line, according to the ratio of the line's Price extension to the sum of the Price extensions of all lines. mSupply will automatically update the sell price value for each item.

Applying other charges

These charges will NOT be added to the sell or cost prices of the items on the invoice. You enter them in the Other charges section below the table of items:

  • Item(s) field: Enter what the charges are for in this field.
  • Amount field: Enter the total amount of the other charges in here. When you do this, you will see the amount added directly to the Subtotal and Total amounts and none of it will be added to the sell or cost prices of the individual items in the table.

Applying tax to the invoice

Tax, like other charges, will not be added to the sell or cost prices of the individual items. To add tax, click on the % tax rate below the Subtotal field on the right hand side below the table of items and enter the rate you wish to use. mSupply will calculate the amount of tax (the % you entered of the Subtotal value) and automatically add it to the Subtotal value to give you the new Total.

If you have set a default tax rate in the preferences (see General preferences) you will see it applied as soon as you open the invoice. Also, you will only be able to edit the tax rate if the Allow editing tax rate and amount on invoices preference is turned on (see Invoices preferences).

To view or edit any supplier invoice, choose Supplier>Show invoices. The details of how this works is virtually identical to that of viewing customer invoices.

Rapid access to Goods Received note from Supplier invoice, and vice versa

Supplier invoices show the Goods Received transaction number in the upper right area of the window. By clicking on that, the Goods received transaction will be displayed. Similarly, the Edit goods received list has a link Click here to open Supplier inv ……. which will display the required invoice.

There are 2 ways to print a supplier invoice but both require it to be open. The first way is to check the print checkbox in the bottom right hand corner of the supplier invoice window:

When the checkbox is checked and you click on the OK button, the printing options window is displayed. The invoice will be closed after printing.

The second way is to hold down the Shift key on the keyboard and click on the printer icon in the bottom right hand corner instead of checking it. This will also open the printing options window but the invoice will stay open after printing.

This is the printing options window:

  • Form to use drop down list: Select the form you want to use to print the invoice. There may be several in the list. There is also a None option if you don't want to print the invoice but just want to print pallet labels.
  • Remember this choice checkbox: The form you choose in the Form to use drop down list will be selected (and everyone else!) next time the supplier invoice printing options window is opened if this checkbox is checked.
  • Print pallet labels checkbox: Check this if you want 100x150mm pallet labels in a specific format to be printed out from a label printer. A label will be printed for each line on the supplier invoice. Note: the label printer has to be installed and configured in mSupply before this option will work - see Label printer installation and Printing preferences (setup) for details.
  • Destination radio buttons:
    • Printer: the invoice will be printed out straight away.
    • Preview: a preview of what the invoice will look like when it is printed will be displayed in your installed PDF file reader. You might be able to print the invoice from the PDF reader, depending on its features.
    • PDF file on disk: the invoice will be saved to disk in PDF format.
    • Email PDF: the invoice will be created as a PDF file and attached to an email for you to send. You can double-click the email attachment to see a preview of the invoice. The email preferences in File > Preferences should be setup correctly before using this feature.
    • Export to Excel: the invoice will be exported as a spreadsheet file and opened for you (provided you have a spreadsheet application installed).

When you click on the OK button the invoice will be printed in the form you have chosen.

  • Last modified: 2019/11/13 15:55
  • by Emily Porrello