26.03. Transaction Status & Type Codes

mSupply uses a series of two letter codes to denote the different types of transactions it can handle.

Code Meaning
ci customer invoice (goods supplied to a customer)
cc customer credit (goods returned by a customer)
si supplier invoice (goods received from a supplier)
sc supplier credit (goods returned by you to a supplier)
sr repack (changing the pack size of a stock line)
bu build (manufacturing (building) items from other items in stock)
rc receipt (cash receipt) from a customer (a customer pays for invoices issued)
ps payment (cash payment) to a supplier

Inventory adjustments have a type of “si” if stock is being increased and “sc” if stock is being reduced. They have a reserved name whose name[type] field has a value of “invad”

mSupply uses a set of two letter codes to keep track of the status of each transaction:

Code Meaning
nw new invoice
sg Suggested
cn Confirmed
fn Finalised
wp The order has been received over the internet (a “web” order), and it is currently being processed
wf The order has been received over the internet (a “web” order), and it is finalised
Code Meaning
sg The order has been created, but the “stock on order” value for each item has not yet been updated. If another order for the same item is processed, mSupply will not take account of suggested orders. Suggested orders can be deleted.
cn The “stock on order value” for each item has been updated. Confirmed orders can also be “unconfirmed” if you cancel an order. Items & quantities can still be edited.
fn The order has been received, Goods Receipts and Supplier Invoices have been created for all stock received.
The order is now completed and all stock not delivered is no longer considered “on order”.
No more stock can be received.
Code Meaning
nw The “new supplier invoice” menu item has been chosen, but the OK button on the invoice has not yet been pressed, or confirming the invoice has been postponed. (This option is only available if “confirm supplier invoices automatically” is unchecked in the Preferences). Note: quitting mSupply by choosing the “quit” command from the file menu or click the application close box (Windows only) while you are entering a new supplier invoice will result in the invoice being saved with status “nw”. To confirm the invoice, open it then click the OK button
sg This status is not used for supplier invoices- invoices of status “nw” become status “cn” when the OK button on the form is pressed
cn The invoice has been entered, but can still be edited.
fn The invoice has been finalised , and can no longer be edited.
Code Meaning
nw The “customer new invoice…” menu item has been chosen, but the OK or “confirm” button has not yet been pressed.
sg The invoice has been created. An order from a customer has been received, and the items put against the invoice are still in your store, but are no longer “available” to issue to other customers. (i.e., the “available” amount for each item line has been reduced, but the “quantity” amount has not). Note that if “one step confirm” is checked in the Preferences, then customer invoices move straight from being status “nw” to status “cn”
cn The invoice has been confirmed by clicking the “confirm” button, which is done when the stock leaves the store. Lines that couldn't be supplied are added to the “backorder” file. The invoice can still be edited.
fn The invoice has been finalised, and can no longer be edited. If the Customer invoice is to another store in your system, then finalisation of the Customer Invoice also triggers generation in the receiving store of the Supplier Invoice or Goods Receipt (if the Customer Invoice is the result of a Purchase Order / Requisition from the receiving store)
Code Meaning
nw The build is being entered for the first time.
sg Suggested - the raw materials are taken out of stock, but the finished product (the item to build) is not yet entered into stock.“
cn Confirmed - the raw materials are taken out of stock and the finished product is entered into stock
fn Finalised - the build can no longer be edited

Previous: 26.02. Reminders | | Next: 26.04. Budgets
  • Last modified: 2022/11/29 10:51
  • by Gary Willetts