Posting Vendor Bill Variances

After you have associated item records with variance accounts, you can create variance journal postings. For information about ways to create variance postings, see Vendor Bill Variances. Then, after your transactions are set to create variance postings, you can create variance journal entries on the Post Vendor Bill Variances page.

Note:

These journal entries address variances only for inventory, non-inventory, other charge, and service items.

To post a variance journal entry:

  1. Go to Transactions > Payables > Post Vendor Bill Variances.

    Note:

    Vendor bills in pending approval status appear on this page because the quantity buckets must be allocated so that NetSuite properly operates. This also helps you prevent over billing.

  2. On the Post Vendor Bill Variances page, verify or select the posting period for the journal entry you are creating.

  3. Verify or enter the date for the journal entry. The current date automatically fills this field.

  4. If you have a NetSuite OneWorld account, select a subsidiary from the list in the Subsidiary field.

    If your vendor records are shared with multiple subsidiaries, the item records that can be posted reflect the combination of selected vendor and subsidiary. For more information about globally shared vendor records, see Assigning Subsidiaries to a Vendor.

  5. In the Transaction Type field, make a selection to filter the list of transactions:

    • Choose Purchase Order to show closed purchase order lines with a variance that do not have the Match Bill To Receipt box checked.

    • Choose Bill to show only vendor bills linked to Purchase Orders that have the Match Bill To Receipt box checked.

  6. When you have selected Bill in the Transaction Type field, you can make a selection in the Transaction Status field:

    • Choose Open to show all open vendor bills.

    • Choose Paid in Full to show only vendor bills that are completely paid.

  7. In the Vendor field, select a vendor to filter the list to show only transactions associated with the selected vendor.

  8. Clear the Include Bills Without Receipts box to exclude bills from the list that have no item receipts entered against them. Check this box to include all bills regardless of receipts.

  9. Check the box in the Select column next to all transactions you want to create a variance journal entry for.

  10. Click Create Journal Entries. The Post Vendor Bill Variances Results page opens and shows the journals created by the entry. You can click the link to open the journal and see the lines posted.

For information about the journals created for variances, see Vendor Bill Variance Journals.

Important:

After the variances on the journal entry are created and posted, associated purchase orders, receipts, and vendor bills transactions cannot be changed.

The variance journal entries must be voided or deleted to allow changes to associated transactions. Also, the accounting period must be open for the entries being considered and the A/P must be unlocked.

Vendor Bill Variances Status Page

To view the status of vendor bill variance calculations you are performing, go to Transactions > Payables > Post Vendor Bill Variances. This page displays the date and time the variance journal was created. It also provides the processing percentage complete, and a link to the results of completed journals in the Status column.

Vendor Bill Variances Results Page

The Post Vendor Bill Variances Results page is displayed in the following two ways:

  • After you click Create Journal Entries on the Post Vendor Bill Variances page

  • When you click the Complete link in the Status column of the Post Vendor Bill Variances Status page

Post Vendor Bill Variances Results page displays the following information:

  • The transaction type that the journal was created from, which is a link to open the transaction

  • The item on the transaction that had a variance calculated

  • The number of the journal entry created, which is a link to open the journal

  • The total amount posted by the journal

To view individual lines posted by the journal, click the journal number to open the entry. For more information, see Vendor Bill Variance Journals.

Related Topics

Vendor Bill Variance Journals
Mass Updates for Variance Accounts
Vendor Bill Variances

General Notices