Generate Consignment Payment Invoices

Answer

Background: In the Item Master application, an item can be marked as a consignment item. Consignment items will function as other Inventory items, but an automated Invoicing process can be set up to create invoice records for financial transactions that occur on the consignment items within a pre-determined invoicing period. Additionally, these invoices can be generated manually. This is different than the invoice process for regular, consumption items in inventory; non-consignment items can only be invoiced upon usage. The invoices can subsequently be generated by running the Cron Task, ConsignmentInvoiceCronTask.

To designate an Inventory item as a Consignment item:

-Open the record in the Inventory application

-Click the checkbox for "Consignment?"

-Select Action | View/Edit Consignment Details

-In the Invoice Generation Type field, select either Consumption, Frequency, or Manual

-If the Invoice Generation Type is set to Frequency, appropriate values can then be entered in the Frequency and Frequency Units fields; this will determine the "invoicing period". An invoice will capture the financial transactions for this item throughout the indicated frequency.

Note: if there is a net gain/loss of zero on an item, such as if an item was issued and then returned within the same "invoicing period", then an invoice will NOT get created. In other words, the invoices that get generated will reflect only net debits or credits.

In the Cron Task Setup application the frequency of the invoice generations can be set on the instance of ConsignmentInvoiceCronTask. Additionally, there is a setting in the Organizations application that can limit the number of lines that will get created on a single invoice:

-Open the Organization record

-Select Action | Purchasing Options | Invoice Options

-Enter a value in the field, "Maximum Number of Lines for a Consignment Invoice:"

-Save the record