@b are you referring to reconciling your NS inventory location with Amazon's FBA inventory numbers?

Yes, exactly

At my old place we would just do an inventory adjustment at the end of the month. Always was messy though.

@b based on previous experience, your NS inventory location and the Amazon FBA inventory numbers will never be in sync until after you do that inventory adjustment. If you're looking at near real-time inventory numbers for your FBA products, you will need to go the route of grabbing those numbers from Amazon reports via Amazon's MWS scheduled reports (mostly CSV plaintext formats) and then updating custom fields in NS to help you manage that inventory. Amazon has an internal process that moves the inventory across their warehouses and oftentimes they "misplace" items either during the receiving process or through moving the product across their warehouse systems.

@Eric B thank you, we end up with a lot of negative inventory because we adjust out items based on what Amazon says they have.

Amazon's inventory is negative?

Our location in Netsuite is negative and very different than what Amazon says it has

So what happens is that you're depending on your NS location to manage FBA inventory making you send more items to Amazon when in reality there is enough inventory in their warehouse to cover demand.

what happens is that Amazon orders stock for the DCs so we send it but need to know what we have at our 3PL vs what we have at Amazon DC, so we transfer the stock into our NetSuite Amazon FBA location. Then each month we invoice based on what Amazon told us they sold, which takes stock out of our NS location. We also use the reports to try and reconcile but we are finding that because of timing or other reasons we are getting negative inventory in our NS locations while there is positive inventory at Amazon. Just wondering if anyone else has dealt with this and how you manage the timing. There seem to be a lot of variables as to where stock is at a given time.

As I've mentioned, you'll need to download the report from Amazon using MWS and process it and update a custom field in NS and rely on that for actual inventory reflected by Amazon FBA.

Ok, thank you