Amazon inventory and payout reconciliation, what a...
# ask-stanley-ai
a
Amazon inventory and payout reconciliation, what are the best options?
c
AI generated answer (using internal Slack threads):
****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** For Amazon inventory and payout reconciliation, there are several options you can consider: 1. Using a Connector: There are several prebuilt connectors available that can connect Amazon and NetSuite. Some of the main players include Celigo, Workato, Boomi, and even NetSuite itself. These connectors can automate the process of reconciliation, making it less of a hassle. 2. Zapier: Zapier is another inexpensive option that can connect Amazon and NetSuite. However, its actions or triggers are usually basic, so it might not be able to handle complex reconciliation or payout tasks. 3. Custom Scripting: You can develop a custom script that processes settlement files from Amazon. The settlement records contain data for both Fulfilled by Merchant (FBM) and Fulfilled by Amazon (FBA) orders, charges, fees, and returns/refunds. This data can then be used to generate Sales Orders (SOs), Item Fulfillments (IFs), Invoices, and Payments in NetSuite. Charges and Fees can be reconciled from the Settlement records via Journal Entries (JEs) against the Amazon Order IDs. 4. Using Custom Records: This is a design philosophy that allows for more robust testing of the data before creating actual SO records. If the data import is messed up, there is no need to delete SO records, and when creating SOs, you can test incrementally. Remember, the approach you choose will depend on your specific needs and resources. It's always a good idea to thoroughly evaluate each option before making a decision.
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.817443728
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.804931641
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.793701231
Please provide your feedback on this answer.