Exclude Backordered Items on Invoice

NetSuite has an Accounting Preference available to not show Item Lines that are not yet fulfilled in InvoicesShow Unfulfilled Items on Invoices (Setup > Accounting > Accounting Preferences > Order Management tab > Invoicing)

This preference works hand in hand with the Invoice in Advance of Fulfillment Accounting Preference.

Here are the illustrations that will help better understand the behavior of the Accounting Preferences:

SALES ORDER:

Item A = Qty: 2

Item B = Qty: 1

ITEM FULFILLMENT:

Item A = Qty: 2

Scenario 1: Invoice in Advance of Fulfillment = T, Show Unfulfilled Items on Invoices = T

  • When you click Bill from the Item Fulfillment page, the Invoice will show as follows:

Item A = Qty: 2

Item B = Qty: 1

  • When you click Bill from the Sales Order page, the Invoice will show as follows:

Item A = Qty: 2

Item B = Qty: 1

Scenario 2: Invoice in Advance of Fulfillment = T, Show Unfulfilled Items on Invoices = F

  • When you click Bill from the Item Fulfillment page, the Invoice will show as follows:

Item A = Qty: 2

  • When you click Bill from the Sales Order page, the Invoice will show as follows:

Item A = Qty: 2

Item B = Qty: 1

Scenario 3: Invoice in Advance of Fulfillment = F, Show Unfulfilled Items on Invoices = F

  • When you click Bill from the Item Fulfillment page, the Invoice will show as follows:

Item A = Qty: 2

  • When you click Bill from the Sales Order page, the Invoice will show as follows:

Item A = Qty: 2

Scenario 4: Invoice in Advance of Fulfillment = F, Show Unfulfilled Items on Invoices = T

  • When you click Bill from the Item Fulfillment page, the Invoice will show as follows:

Item A = Qty: 2

Item B = Qty: 0

  • When you click Bill from the Sales Order page, the Invoice will show as follows:

Item A = Qty: 2

Item B = Qty: 0

Please note that in this scenario, you are allowed to edit the quantities of the unfulfilled item and bill it which overrides the Accounting Preference Invoice in Advance of Fulfillment = F.

Leave a comment

Your email address will not be published. Required fields are marked *