Error at Sales Order Close


Sales>Data Views>PIcked/Shipped Not Invoiced


Background


Prior to Build 405, you were able to return a Pick to inventory and not create the required credit memo for the returned transaction.   If the line item ID inventory value changed and then the line was re-picked this would create a situation where the picked value differs from the invoiced value.   This would create a balance sheet problem with the Picked Not Invoiced clearing account.


Review Open Sales Orders


You can identify open Sales Orders that have this value differential by accessing the Sales>Data Views>Picked/Shipped Not Invoiced and select the Picked Costs not equal to Invoiced Costs option.  These SO lines need to be corrected in order to correct the Picked Not Invoiced account and close any of the Sales Orders listed.  


Steps to Correct

  1. Identify the Sales Orders lines that need correction using the Picked/Shipped Not Invoiced Data View>Picked Costs not equal to Invoiced Costs option 
  2. Go the SO Pick screen and highlight the line item and go to the Transaction Tab in the lower portion of the screen and Reverse the Pick transaction
  3. Create a Shipment and Create an Invoice for the Credit Memo.
  4. Go back to the SO Pick screen and re-pick the quantities for the line then create a Shipment and Invoice.
  5. Customer Payment - the Credit memo offsets the Invoice for a net zero payment.  
    1. If in Financial Transfer Accounting Configuration, 
      1. Transfer both the Credit Memo and Invoice Vouchers as part of the AR Voucher Transfer process.
      2. In your customer payment screen, Pay the Credit Memo and Invoice Against each other for a net zero payment
    2. If in DBA Legacy Financials Accounting Configuration
      1. Go to AR > Customer Payments and Pay the Credit Memo and the Invoice against each other for a net zero payment
  6. Confirm that the value has dropped off of the Picked Not Invoiced Data View
  7. You will now be able to Close the Sales Orders that have been corrected
  8. Correct all lines that show up in this view until there are none left.  
  9. Verify that the value in the Picked Not Invoiced Data View ties down to the GL Account Balance for Picked Not Invoiced  KB - Picked not Invoiced Reconciliation 


Review Finished and Closed Sales Orders


You may want to review your historical data to see if this impacted your Picked not Invoiced account.   We do not recommend attempting to correct all of these transactions.  This is best handled with a one time Journal Entry correction to the Picked not Invoiced account.  KB - Picked not Invoiced Reconciliation


Go to 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,
SP.PICKQTY,
SP.INVQTY,
SP.PICKED_TOTAL_LINE_COST,
SP.INVOICE_TOTAL_LINE_COST,
SP.LINE_DIFFERENCE
FROM SP_COST_MISMATCH_FULL_INV_PNI SP