When activating the “3PL Invoicing” menu, the “3PL invoicing selection criteria” form opens. There, you can select an invoicing period type and an invoicing period according to the selected period type.
Invoicing period types:
Note: It is possible to select a period which not ended yet, but a warning window will pop up after clicking on the ‘Generate Invoices’ button.
Then you can load 3PL invoicing customers that still need to be invoiced for the selected period. These are the customers who meet both of the following conditions:
Select a 3PL invoicing partner from the list. When none of the partners is selected, the system will generate an invoice for each partner on the list. Different generation types can be selected:
The 3PL invoices consist of a certain amount of prices, in separate lines, all calculated differently. The created 3PL invoice is linked to the invoicing period by the ’3PL Period’ UDF. This UDF contains the starting date of the invoicing period. Business partners who already have an invoice for the same starting invoicing date will not be listed in the 3PL invoicing selection criteria window.
The quantity is the number of goods receipt PO’s with the Doc Date included in the invoicing period.
The unit price is the invoicing item’s price, for the price list of the invoicing customer.
The quantity is the total number of goods receipt PO lines belonging to goods receipt PO’s with the Doc Date included in the invoicing period.
The unit price is the invoicing item’s price, for the price list of the invoicing customer.
For each goods receipt PO line, a price is calculated that is equal to the item’s 3PL inbound price (which can be set up on the Produmex tab of the item master data) multiplied by the received quantity (in inventory UoM). The inbound item quantity price is the total of all these prices for ¬all goods receipt PO’s in the invoicing period.
On the 3PL invoice, the quantity for that item is always 1, and the total price is set as unit price.
The quantity is the number of sales deliveries with the Doc Date included in the invoicing period.
The unit price is the invoicing item’s price, for the price list of the invoicing customer.
The quantity is the total number of delivery lines belonging to sales deliveries with the Doc Date included in the invoicing period.
The unit price is the invoicing item’s price, for the price list of the invoicing customer.
For each sales delivery line, a price is calculated that is equal to the item’s 3PL outbound price (which can be set up on the Produmex tab of the item master data) multiplied by the delivered quantity (in inventory UoM). The outbound item quantity price is the total of all these prices for ¬all sales deliveries in the invoicing period.
On the 3PL invoice, the quantity for that item is always 1, and the total price is set as unit price.
For each location type for which active 3PL settings have been defined, the algorithm calculates the bin location usage of each supplier’s stocks on this location type, day per day. The stock level of every day is calculated from the current inventory and the inventory history.
For each day, the algorithm calculates the list of locations that should be invoiced for storage of the supplier’s items:
The storage price of each bin location is defined in the price list of the item linked to its location type, and the total storage price for the day is the sum of the bin location prices. If a bin location has no location type, then its price is zero.
If the shortest invoiceable duration is ‘Week’ or ‘Month’, then if a location is used on any day of the week/month, it is considered as used during the whole week/month, and its daily storage price is then multiplied by the corresponding number of days.
On the 3PL invoice, one separate line is added for each location type that takes part into the calculation.