Picked Not Invoiced

The Picked Not Invoiced GL Account is a clearing account.   If all Picks and Credit Memo transactions have been picked and fully invoiced, you would expect the account balance to be zero.   If you first perform a GL Batch posting, you should be able to tie down the Picked not Invoiced Data View value to the GL Account balance for Picked not Invoiced.


Sales>Data Views>Picked/Shipped Not Invoiced




Prior to Build 405


Historically, there were many ways for the Picked Not Invoiced to not be cleared properly.   We previously allowed sales orders to be closed without lines being fully invoiced.   It was also possible to return inventory items and not create the required credit memo for the transaction.   You may need to make a one-time journal entry to Picked not Invoiced account per the steps below.  


Steps to Reconcile GL Balance - Picked Not Invoiced


  1. Run Sales>Data Views>Picked/Shipped Not Invoiced report
  2. Make sure that you have invoiced all items on the report.
  3. Run the Picked Costs not Equal to Invoice Costs option and correct all lines per the following steps KB - Correcting Picked Costs not Equal to Invoice Costs
  4. Verify that the Picked Costs not Equal to Invoice costs view no longer has any line items
  5. Run a GL Batch Posting
  6. Run the Picked Not Invoiced option of the Data View and compare the value to the Balance Sheet of the Picked Not Invoiced account
  7. Make a one time Journal Entry to tie down the balance sheet Picked not Invoiced account to the Data View report


One Time Journal Entry to Adjust GL Picked not Invoiced to match the Data View value



DebitCredit
PNI GL Balance > Data View ValueInventory Adjustments (Adjustments COGs)
Picked Not Invoiced
PNI GL Balance < Data View ValuePicked Not Invoiced

Inventory Adjustments (Adjustments COGs)




Picked Not Invoiced for Finished and Closed Sales Orders


You should no longer be able to close a sales order that has a mismatch in the Picked Not Invoiced account.  You do not need to address these individual sales order transactions in Finshed/Closed Sales Orders.   These values will get corrected via the one time journal entry outlined above.    To review historical data on Finished/Closed Sales you can go to the Utilities>Database Queries and copy and paste the following query:


SELECT
SP.JOBNO,
SP.JOBSTATS,
SP.CUSTNAME ,
SP.TRADINGNAME,
SP.SORTNO,
SP.LINETYPE,
SP.REFID,
SP.DESCRIPT,
SP.QTY AS ORDER_QTY,
SP.PICKQTY as PICKED_TD,
SP.INVQTY AS INVOICED_TD,
SP.pniqty AS REM_QTY_TO_INVOICE,
SP.PNIUNITCOST AS COST,
SP.PNITOTCOST AS COST_TO_INVOICE
FROM SP_PNI_FOR_CLOSED_FINISHED_SOS SP