* Sales - Credit Memo

As of 2/29/16 - THIS ARTICLE IS NOW UNDER CONSTRUCTION: 

Overview of the Credit Memo screen

• The Credit Memo screen is used to create a Credit to a Customer's account.
• Credit Memo's are most easily created from the Invoice screen (on the Invoice you want to credit back).

X Screen - Quick Steps...

How to ADD a new Credit Memo - From the Invoice screen

• Press F7 to find the Invoice you would like to credit back.
• Enter the Qty you want to return (in the Qty Return field) on each item (on the Invoice) you want to return.
• Click the Functions button and select #4 (Return Item(s) on this Invoice.  Then choose from the 2 return options. Then click OK.
• When prompted, click Add to Credit Memo button.
• If prompted to return the item to the supplier (rather than just back into stock) make a selection.
  
  
  Credit Memo Option - Return Item Back to Supplier 

  Information Box content. Put here some hints and tips.

• If prompted to Return the Item back into stock as a 'Damaged' item Type YES (if the item is damaged) or just click OK or Cancel to proceed.
  
  
  Information Box Title

  Information Box content. Put here some hints and tips.

• If prompted to automatically 'apply' the Credit back to the Invoice choose Yes or No.
  
  
  Credit Memo options

  Information Box content. Put here some hints and tips.

  
  

  
  

How to ADD a new Credit Memo - From the Credit Memo screen

How to FIND a Credit Memo

How to DELETE a Credit Memo

How to PRINT a Credit Memo

How to APPLY a CREDIT MEMO to a Customer's Account (to satisfy 1 or more Invoices)

See section below called: Various Ways to Apply a Credit Memo

How to ADD a new Return Authorization - From the Invoice screen PW 18.0601 SR30364

• Press F7 to find the Invoice you would like to credit back.
• Enter the Qty you want to return (in the Qty Return field) on each item (on the Invoice) you want to return.
• Click the Functions button and select #5 (Create RA for all items on this Invoice that have a Qty in the Return field.) Then click OK.
• Call function fnReturnItemsWithCRMs to create Credit Memo
• Get Invoice Number
• Validate for Items with return Qty > 0
• Close Invoice form
• Create new Credit memo
• Get Credit Memo Number from CM form
• Update Credit Memo with Sold To and Ship To Customers
• Assign Sales Tax Codes to Credit memo form
• Delete temp table tblCreditMemoFromInvoiceTemp
• Insert return Quantities to temp table which are having Return Qry > 0
• Insert Assembly components to Temp table
• ReSet the return Quantities in related Invoice
• Open form frmCreditMemoFromInvoice
• Call function fnUpdateCreditMemoRA
• Make chkReturnAuthorization Check box = True
• Show "Return Authorization" label
• Add DateRACreated, RACreatedBy, if blank in CM form
• Form frmCreditMemoFromInvoice Click AddToCreditMemo
• Append Selected LineItems to CM from tblCreditMemoFromInvoiceTemp
• Update link between Invoice LineItems and CM LineItems
• Update Components of HeaderLineNumber if Assembly items available
• IF chkReturnAuthorization is True
• Make Ship Qty =0 of all LineItems of the CM
• LogRecord "Invoice Header"
• Open recordset from Temp Table and loop
• IF EditableAssembly
• NeedsPO = False
• Else
• IF RA or Class <> "Stock"
• NeedsPO=False
• Else
• Popup and ask "Do you wish to return item XYZ to the supplier"and get result to NeedsPO 
• IF NeedsPO = False
• Call Function fnUpdateDamagedItemQty to update Damaed Qty
• Get SalesMan, CustomerOrderNum, PaymentsTerm and ShipVia from Invoice table 
• If NeedsPO = False
• If Class  = "Stock" And RA = False 
• Figure out the individual cost
• If EditableAssembly = False 
• Add Quantity back to Inventory
• Else
• If Class ='Stock'
• IF HeaderLineNumber=0
• MsgBox " You Wish To Return Each Component of Item # XYZ?
• IF Yes  then BOMAll=True Else goto ItemasWhole
• IF BOMAll=True Then Call Delete_BOM_Components_CM 
• Recalc Inventory count and average cost for old inventory item
• Else
• Recalc Inventory count and average cost for old inventory item
• Else
• Recalc Inventory count and average cost for old inventory item
• Update [Invoice Lineitems] SET [Needs PO]= true, [Supplier Number] =  SuppNum 
• IF Item is Damaged 
• UPDATE [Invoice Lineitems] SET [DamagedQTY]= true,[Comments]=Comments from Popup Message
• Update [Invoice Lineitems]  with Cost IndCost * ShipQty and LineItems Totals
• Update Comments field of Added Shipment of the Item in [Inventory Products]
• Log Record "Invoice"
• Move Next rec
• Loop
• IF Payments available for the CM then mark it as Paid
• Assign Current User as Salesman
• Assign strCustomerOrderNum as [Your Order #]
• Assign [Payment Terms]
• Assign [Shipped Via]
• IF Payment Term blank assign Payment Term from Invoice
• Calculate Taxes
• IF Not RA and CSP blnApplyCrInvo= True
• IF Invoice is Paid
• Show MSGBox "Do you want to automatically apply this Credit Memo to Invoice" and If Yes
• Call fnAutoCreateCreditForInvoice
• Calc Payment Totals
• Calc Invoice Totals
• If Payment Tot = Invo Tot then Update Invoice as Paid =True
• Call fn_CalcGrandTotals to Calculate Grand Total
• LogRecord "Invoice Header"
• DoCmd.OpenForm "Credit Memo"

Various Ways to Apply A Credit Memo

How to Apply a Credit Memo to a Customer's account on the Receive Payments screen

How to Apply a Credit Memo to a Customer's account on the Invoice screen

How to Apply a Credit Memo to a Customer's account on the Sales Order screen.

Credit Memo Optional Settings