New Purchase Invoice
The form opens via the path Purchases > Purchase Invoices > New Invoice or through the New button located in the Purchase Invoice Search form.
How to create a purchase invoice
1. Mandatory Data
- Purchase invoice type in Tables > Purchases > Purchase Invoice Type;
This field determines the numbering range of the document being entered and automatically proposes the Internal number of the invoice based on the inclusion date and the last number entered; - Supplier can be entered using the field help or manually;
- Date: the current date is proposed automatically but can be modified manually respecting the progression rule between date and number;
- Internal number: automatically proposed based on the invoice type, but can be manually modified while always respecting the progression rule between date and number;
- Document Number: in this field, it is possible to enter a document number that may differ from that proposed in the previous field.
The form contains a series of tabs.
Header
After selecting the mandatory data in the upper section, the user can continue entering the following data manually or with the field help, or, based on the procedures chosen, the application fills in the fields automatically.
If the document is created automatically, for example through Fulfillment from Supplier Order or Fulfillment from DDT, these data are taken from the originating document from which the invoice was generated.
2.1 Supplier Data
By entering the Supplier, all specific data from the Header tab will be automatically proposed according to the data previously set in the supplier registry in the fields corresponding to their address and in the sections:
- Currency: section containing Currency, Exchange Rate, Currency Date.
- Country: section containing Country, Language, Zone.
- Delivery: section containing Shipments, Freight, Packing, Default Price List and its Validity range.
All these fields can be deleted or manually modified by the user.
2.2 Optional Header Data
-
Invoices status: when the invoice is created, no flags are active. The section includes the fields:
Controlled: the active flag allows the invoicing of the invoice;
Accounted: the flag is activated automatically when the invoice supports the Accounting procedure;
Loaded: the flag becomes active when the invoice supports the Warehouse Loading procedure. In the case of an invoice created from a transport document already loaded, the general parameter VE-PurchaseInvoices_VerifyLoadStatusDDT will block the Loaded flag even in the invoice. Historicized: activating this flag will make the document no longer visible for subsequent procedures.
Cancelled: the active flag allows the invoice to be canceled.
The flags can be removed through restoration operation procedures.
-
Arrival date: in this field, one can enter the date of arrival of the goods.
-
Load date: this field is automatically filled with the current date at the time of loading or with the date used for warehouse registration, depending on the procedure used.
-
Supplier Annotations: this field is retrieved from the supplier registry, while in the case of creation from a single order/DDT, the same data contained in the corresponding field of the originating document will be retrieved. It can also be entered manually.
-
Our/Your reference: in these fields, an internal reference and a supplier reference for the document are usually indicated.
If present, it is retrieved from the supplier registry; otherwise, it can be entered manually. If the order is completed using the Fulfillment from Order procedure or through Purchase DDT Valuation, the fields Supplier Annotations and Our/Your reference will propose the information present in the corresponding fields of the originating document (this transfer is valid only in the case of invoices created by retrieving data from a single originating document). -
Initial note: in the case of fulfillment, the information present in the order will be re-proposed. Alternatively, notes previously entered in the corresponding table located in the path Configuration > Tools > Management of Coded Notes can be selected; for this, the user must double-click on the field to open the Help and select the data; otherwise, they can be entered manually.
-
Project: using the field help, the document can be linked to a project. This association only works at the item header level. The project is automatically entered if the DDT is created through the fulfillment of an order that contains it.
-
CUP/CIG: if in the tax information of the supplier registry it is enabled for the management of CIG and CUP, it will be possible to fill in this data in the document. The fields are located under the Supplier Annotations section.
-
Ref. FA: positioned under the Country section. It is used after creating the Cancellation of an invoice to manually connect the two invoices by entering the invoice's number, type, and date of the originating invoice.
-
Acc. rec.: positioned under the Country section. Reports the number, date, and protocol of the accounting entry derived from the accounting of the invoice.
2.3 Payments
The Payment Terms are automatically reported from the Supplier Registry > Payments tab and can be modified/removed by the user.
If a financial discount is associated with the Payment type, the amount of the discount is considered only for accounting purposes, i.e., in the due dates of the document and not in the invoice total.
Specific Button
Delete Payments: used to delete the selected payment lines.
2.4 Discounts
Only predefined discounts retrieved from the Supplier Registry > Discounts tab are proposed and can be modified/removed by the user.
The discounts proposed in the header of the document are reflected in each new item line inserted in the document.
If a new discount is entered in the header after entering the item lines, it will not be replicated in the item lines already inserted.
Specific button:
Delete discounts: used to delete the selected discount lines.
2.5 Shipping
Here, the information entered in the supplier registry, the Delivery tab, is proposed, only if there are default data.
The combo box proposes all Recipients and Destinations entered in the supplier registry.
Shipping addresses (recipient/destination and carrier) can also be entered descriptively without being previously inserted among the contacts.
2.6 Carrier
In this field, it is possible to enter the Carrier that will carry out the shipment. If this has been entered in the supplier registry, tab Delivery, it will be possible to select it from the dropdown menu of the second column; alternatively, it is sufficient to double-click on the third column (Carrier) to select one of the company's contacts.
Optionally, details of the Number plate and Transportation Date/Time can be added.
2.7 Extra Data
Here is proposed the information entered in the Subject Registry > Extra data tab, only if default data exists.
Header Procedures:
Automatic Warehouse Loading
This procedure is launched using the Automatic load on warehouse button found in the document header and respects a series of parameters previously set in the invoice. For details, refer to the identical procedure: Loading Purchase Invoices into Warehouse.
The result can be viewed in Logistics > Records or in the Loading Purchase Invoices into Warehouse procedure, Summary tab.
If in the Purchase Invoice Parameters the flag Automatic load/unload is active, at the moment the Controlled flag in the invoice header is activated, it will automatically propose to load the document into the warehouse. Therefore, this field will be editable only once the Controlled field is activated and the Document Number is entered.
D.N. execution
This procedure allows the creation of a purchase invoice by fulfilling one or more purchase DDTs.
In the document header, by pressing the D.N. execution button, the form will open where it is possible to filter the DDTs addressed to the supplier of the document. It is then possible to insert items into the invoice, fully or partially fulfilling the DDTs.
To use this procedure, certain initial conditions must be met:
- the supplier of the DDTs must be the same as that of the invoice;
- the DDT you want to fulfill must have the Controled flag active and must not already be Valorized.
Procedure
You must set in the header of the new invoice the Invoice Type you want to create and the Supplier. Once these data are entered, you should click on the D.N. execution button to open the fulfillment form.
The filters for supplier and currency will be automatically carried over based on the supplier entered in the invoice.
In the filter area, you can choose whether to view the data in a Grid, a Hierarchical structure or both solutions.
The Hierarchical structure allows for a clearer division of the DDTs available for fulfillment and the items contained in each. It also allows for mass selection of all items contained within a DDT simply by activating the flag on the DDT line.
The Grid allows for greater customization of the form by adding fields from the Object navigator. In this case, mass selection must be done using the keyboard keys and clicking the Select/Deselect button in the ribbon bar.
Once all desired filters are set, clicking the Search button will display all checked DDTs that have not yet been valued or are partially valued in the lower part.
In the result grid, the user then has the option to:
- Select all or some of the proposed items: to do this, simply select the flag present at the start of the item line. The Quantity to Fulfill will automatically be set equal to the Residual quantity.
- Select some items for a partial quantity. In this case, the Quantity to Fulfill must be modified accordingly.
To complete the procedure, you will then need to click the Transfer button, which will retrieve all the data present in the selected DDTs and bring it back to the invoice.
Specific Buttons
Search: allows searching for available DDTs for transfer.
Transfer: allows transferring the selected items/orders.
Select all: allows selecting all items from the list.
Deselect all: allows deselecting all items from the list.
Select: allows activating flags for all rows selected with the mouse.
Deselect: allows deactivating flags for all rows selected with the mouse.
Order Fulfillment
This procedure allows the creation of a purchase invoice by fulfilling one or more supplier orders.
In the document header, by pressing the Get from Orders button, the form will open where it is possible to filter the orders related to the supplier of the document. It is then possible to insert items into the invoice, fully or partially fulfilling an entire order or a row.
To use this procedure, certain initial conditions must be met:
- the supplier of the orders must be the same as that of the invoice;
- the order to be fulfilled must have the Printed flag active and must have already been Confirmed.
Procedure
You must set in the header of the new invoice the Invoice Type you want to create and the Supplier. Once these data are entered, click the Get from Orders button to open the fulfillment form.
The filters for supplier and currency will be automatically carried over based on the supplier entered in the invoice.
In the filter area, you can choose whether to view the data in a Grid, a Hierarchical structure, or both solutions.
The Hierarchical structure allows for a clearer division of the various orders and the items contained in each. It also allows for mass selection of all items contained within an order by simply activating the flag on the order.
The Grid allows for greater customization of the form through the addition of fields from the Object navigator. In this case, mass selection must be performed by using the keyboard keys and clicking the Activate/Deactivate Only Selected Rows button in the ribbon bar.
Once all desired filters are set, clicking the Search button will display all printed orders that have been confirmed and not yet fulfilled or are partially fulfilled below.
The procedure retrieves all data present in the order, and as a consequence, the purchasing conditions present in the order will be applied, even if they have currently changed.
In the event of fulfilling multiple orders with the same payment solution and/or same destination, the information contained in the order will be reported in the invoice; alternatively, those from the supplier registry will be retrieved.
In the result grid, the user then has the option to:
- Select all or some of the proposed items: to do this, simply select the flag at the start of the item line. The Quantity to Fulfill will automatically be set equal to the Residual quantity.
- Select some items for a partial quantity. In this case, the Quantity to Fulfill must be modified accordingly.
To complete the procedure, you must then click the Execution button, which will retrieve all the data present in the order and bring it back to the invoice.
Specific Buttons
Search: allows searching for supplier orders.
Execution: allows transferring the selected items/orders.
Forced Order Execution: allows forced fulfillment of the selected order or item rows.
Select all: allows selecting all items from the list.
Deselect all: allows deselecting all items from the list.
Activate only selected rows: allows activating flags for all rows selected with the mouse.
Deactivate only selected rows: allows deactivating flags for all rows selected with the mouse.
In the case of multiple partial fulfillments for a given item line within the same invoice, it is possible to choose whether to sum the quantities into a single line in the invoice or to maintain separate lines by disabling or enabling the Unsumed Item Quantity Order flag in the table of Purchase Invoice Types.
Sdi - Document Closure
With the Sdi - Document Closure button, the module is opened for manually linking any orders and purchase DDTs to the invoices generated from the received XMLs. This procedure is also automatically initiated when this linking is performed from the Incoming Purchase Documents screen.
The module is divided into two main sections: one on the left, dedicated to displaying DDTs and Orders, and one on the right, showing the items of the invoice.
The grid of orders and DDTs contains the following columns:
- Invoice Linked Line Number
- Document Type
- Number
- Date
- Line Number
- Item Class
- Item Codes
- Item Description
- Quantity
- Prices
- Total Discount
- Net Amount
- Net Unit Price
The lines already linked to the invoice items will be highlighted in green for easier identification.
The invoice grid contains the following columns:
- Line number
- Item Class
- Item Codes
- Item Description
- Quantity
- Prices
- Total Discount
- Net Amount
- Net Unit Price
The lines already linked to DDT or Orders items will be highlighted to facilitate verification.
In these grids, only the lines of DDTs or Orders that have not been executed or forced previously are displayed. To execute the linking, it is necessary to enter the invoice line number in the Linked Invoice Line Number column and click the Associate button.
The same invoice number cannot be simultaneously linked to a DDT and an Order.
With the Associate button, the lines with the "Linked Invoice Line Number" will be executed in the corresponding DDTs or Orders.
The Rollback Link button allows for the cancellation of the linking, restoring the correct execution status for the DDTs or Orders.
During the linking phase, the system performs several checks to ensure data consistency:
- Prices: Differences between the prices reported in the orders/DDTs and those of the automatically generated invoice.
- Discounts: Discrepancies between the total discount values.
- Net Unit Price: Differences between the net unit price indicated in the invoice and that reported in DDTs/Orders.
- Total Amount: Differences between the total amount of the invoice and the sum of the total amounts of the lines executed in DDTs/Orders.
If one or more of these checks fail, the linking is not performed automatically, and the error is reported in the error grid, indicating the invoice line number and the description of the error.
Items
In this tab, all the articles with their related data are entered.
The data is entered manually, with the help of the field help or can be proposed by the connected procedures.
To insert a new article into the grid, simply position yourself on the row to fill in the various data or use the New Item button present in the ribbon bar.
If the invoice was created through the fulfillment of a supplier order or a purchase DDT, the following data will be retrieved from the originating document.
3.1 Mandatory Data (Dati obbligatori)
- Line number: this field will automatically and progressively populate as data is entered in the line.
- Line type offers the option to select from the combo-box articles with different characteristics:
- Codified Item: these are items coded in the registry and can be accounted for in analytical accounting and registered in the warehouse.
- Non-coding Item: these are descriptive articles that can be accounted for in analytical accounting but cannot be moved to the warehouse.
- Charge Item: these are coded or non-coded items and are summed separately in document summaries; if the expense item is coded and of tax interest, it will be moved to the warehouse; if it is non-coded or not of tax interest, it will not be moved to the warehouse.
- Note Item: these are descriptive notes reported in the document print; they do not affect accounting and storage.
- GiveAway Item: the gift item is managed as a coded or non-coded item for tax and warehouse purposes, but as it is a gift, it is counted separately in document summaries, and depending on the VAT recovery flag, the VAT amount of the gift may or may not be borne by the subject.
If you start directly with the insertion of the article, its class, code, and row type (Codified Item) will be automatically entered.
- Class/Code/Item Description: these can be entered manually or with the aid of the field help which will propose all the related data entered in the Item registry. After entering the article, its Description will be automatically retrieved from the registry. If the article has Variants, it will be possible to select the desired variant from the Data tab.
- Units of Measure: the main unit of measure of the item is proposed, but in the case where alternative units of measure are coded in the item registry, the user has the option to choose another one.
- Quantity: represents the quantity of the main unit of measure and by default has the value 1; it can be manually modified or can be taken from the document considered for fulfillment.
-
Price: the price is proposed from the price list entered in the contact registry; the reference price list for the article itself is displayed in the Discounts/Price Lists tab. The same document may contain articles with prices taken from different price lists, if multiple cascading price lists are associated in the subject registry (see Contact Registry). By double-clicking in the Price list field (within the Discounts/Price Lists tab), the user has the option to select a different price list from the default one, from which the price of the entered article will be retrieved.
If there is no price list, the proposed data can be retrieved from the last cost of the item registry, if the flag Zero Cost in the Absence of Price Lists in the Purchase Invoice Parameters is not active. -
Amount: this is calculated automatically net of discounts.
-
Total discounts: indicates the total amount of discounts present in the Discounts/Price Lists tab for each item row.
-
VAT: is primarily the data entered in the VAT field of the Contact Registry. If this is not present, the value in the Item registry will be proposed, but the user has the option to enter a different value.
3.2 Optional Article Data
-
Supplier Article Code/Description: in this section, you can add the code and description that the supplier uses to identify the item; this data is proposed automatically if in the item registry, tab Preferred Suppliers an item supplier has been associated.
-
Purchase turnover type: the data entered in the tab Generalities of the item registry is proposed. If this is not present, no data is proposed, and at the time of accounting for the invoice, the value entered in the Default Counterpart Cost/Revenue (Costo/Ricavo di contropartita predefinito) field of the contact registry will be considered.
Specific Buttons
Recalculate Recycle: if Conai Management is enabled for the document, it is possible to recalculate the values with this button after any modifications.
Packages management: allows opening the management of returnable packaging used in the purchase document.
This button becomes active if the document is saved but not loaded. Clicking this button opens the corresponding form where you can enter the quantity, select the row, and execute the transfer of the selected packaging into the item rows by clicking the Execute button. In this form, the items that have been entered with the nature of Packaging and that are present in the table of Returnable Packaging are reported.Receptions reversal: this button is active only for Purchase Invoice Types that have the Nature of Credit note. In the form, all invoices addressed to that supplier will be displayed. After selecting the item rows and the respective quantities to be cancelled, simply press the Receptions reversal button to insert them into the invoice.
Update price lists: the Update Current Price List button allows updating prices in the current price list for each selected item row.
The button Create new price list with new validity, on the other hand, will open a pop-up to enter the validity dates of the new price list, which will contain only the selected rows and will be addressed to the supplier entered in the invoice.
When creating/updating a price list through this procedure, only discounts that have been manually entered into the invoice are reported in the price list.