RMA Creation in Sage100 from CIMcloud Platform

Overview

This article reviews the standard RMA creation in Sage100 when an RMA is entered on the CIMcloud platform and is synced to Sage100. The standard process is for the RMA to sync to Sage100 once it has been submitted on the CIMcloud platform. RMA creation and sync to Sage100 is part of the bundle Returns (RMA’s) With Sync into Sage 100 and if not already purchased will require the bundle to be purchased before it can be used. Information on set-up and how the bundle works in the CIMcloud platform can be found here – <article coming soon>.

The RMA sync is a creation process only and once the RMA has synced from CIMcloud to Sage any updates have to be processed in Sage.

RMA Creation

Once the RMA is triggered to sync into Sage it will populate the following fields in Sage as noted. If there are different defaults or if you have different requirements, enter a ticket with the requested changes. The changes  will either be made or information on customizing the process will be provided depending on the changes being requested.

  1. RMA Status – The Default on install is set to “N” (New)
  2. Expire Date – This is defaulted to 30 days after the RMA is created in Sage
  3. Inspect on Receipt – This is defaulted to “Y”
  4. Cross Ship – This is defaulted to “Y”
  5. Apply Restocking Charges – This is defaulted to “Y”
  6. Print Customer RMA – This is defaulted to “Y”
  7. Print RMA Receiver – This is defaulted to “N”
  8. Batch Fax¬† – This is defaulted to “N”
  9. RMA Number – The default for this is a “W” followed by the RMA on the site with leading 0s to make the total length 7 characters.
  10. Customer Number – the customer number associated with the RMA this will be an existing customer number and includes the Division Number.
  11. Return Ship Via – This is set to blank as the default
  12. Email – this is the email address entered as the contact email by the user creating the RMA in CIMcloud
  13. Comment – This is the RMA header level comment entered by the user on the RMA in CIMcloud

Addresses

The default is to have the customer address information default from the customer in Sage and if it is a new shipping address to add it to Sage as a customer shipping address. It will also edit the shipping address in Sage if an existing address has been used and modified.

  1. Return Ship To Code – The Ship to Code used or created when the user creates the RMA in CIMcloud
  2. Return Ship To Name – The Ship to Name used or created when the user creates the RMA in CIMcloud
  3. Return Ship To Address 1 – The Ship to Address Line 1 used or created when the user creates the RMA in CIMcloud
  4. Return Ship to Address 2 – The Ship to Address Line 2 used or created when the user creates the RMA in CIMcloud
  5. Return Ship To City – The Ship to City used or created when the user creates the RMA in CIMcloud
  6. Return Ship to State – The Ship to State used or created when the user creates the RMA in CIMcloud
  7. Return Ship to Zip Code – The Ship to Zip Code used or created when the user creates the RMA in CIMcloud
  8. Return Ship To Country – The Ship to Country used or created when the user creates the RMA in CIMcloud
  9. Return Ship to Address 3 – The Ship to Address Line 3 used or created when the user creates the RMA in CIMcloud

Lines

  1. Invoice Number – The invoice number selected when the return was created in CMCloud (if populated based on CIMcloud set-up options)
  2. Item Code – The SKU of the product on the return
  3. Return Reason – This will be mapped from the erp code set up on the return reason selected on the return created in CIMcloud for the particular line. If not populated it will be defaulted to “Damaged”
  4. Cust Action – This is currently controlled as just a default value. The base default is “N” or none for all RMAs. A different default value can be set easily by entering a ticket.
  5. Return Qty – The quantity requested for the line on the RMA
  6. Item Action – This is the ERP Code associated with the return action selected. If not populated it will default to “N” – None
  7. Comment – this is the line comment entered on the RMA in CIMcloud.
  8. Item Type – This is the item type and is set to default to 1

 

 

 

Was this article helpful?