When you run the Amazon (FBA) returns to NetSuite RA and item receipts flow, FBA returns with ‘Reimbursed’ status are synced with NetSuite.
Since FBA returns are processed via the Amazon (FBA) Inventory Adjustments to NetSuite Inventory Adjustments flow (available in the FBA Inventory Adjustments add-on, syncing them using the Amazon (FBA) returns to NetSuite RA and item receipts flow results in duplication of records.
To avoid this issue, we recommend you to add an input filter in the Post return authorization lookup, the Post item receipt lookup, and the Close return authorization output destination to ignore FBA returns with ‘Reimbursed’ status in the Amazon (FBA) returns to NetSuite RA and item receipts flow.
Add input filter in the Post return authorization lookup
- Access the Amazon (FBA) returns to NetSuite RA and item receipt integration flow.
- In the Post return authorization lookup, click the Define options icon.
- The Input filter button (
) will appear to the left of the Post return authorization lookup.
- Click the Input filter button (
) to access the Define input filter dialog box.
- In the Rules section of the Define input filter dialog box, select the rows[0].status option from the options available in the drop-down list.
- Select the not equals option in the drop-down list that appears after the record type is selected.
- Enter the value as Reimbursed in the text box that appears after the record type is selected.
The input filter will be displayed as shown in the following image:
- Click Save & close to confirm the changes made and return to the flow.
You need to add input filters in the Post item receipt lookup and the Close return authorization output destination before you can run the flow.
Add input filter in the Post item receipt lookup
- Access the Amazon (FBA) returns to NetSuite RA and item receipt integration flow.
- Click the Input filter button (
) to the left of the Post item receipt lookup to access the Define input filter dialog box.
- In the Rules section of the Define input filter dialog box, select the And operator.
- Click Add Rule.
- In the grouping that appears, select the rows[0].status option from the options available in the drop-down list.
- Select the not equals option in the drop-down list that appears after the record type is selected.
- Enter the value as Reimbursed in the text box that appears after the record type is selected.
The input filter will be displayed as shown in the following image:
- Click Save & close to confirm the changes made and return to the flow.
You need to add an input filter in the Close return authorization output destination before you can run the flow.
Add input filter in the Close return authorization output destination
- Access the Amazon (FBA) returns to NetSuite RA and item receipt integration flow.
- Click the Input filter button (
) to the left of the Close return authorization output destination to access the Define input filter dialog box.
- In the Rules section of the Define input filter dialog box, select the And operator.
- Click Add Rule.
- In the grouping that appears, select the rows[0].status option from the options available in the drop-down list.
- Select the not equals option in the drop-down list that appears after the record type is selected.
- Enter the value as Reimbursed in the text box that appears after the record type is selected.
The input filter will be displayed as shown in the following image:
- Click Save & close to confirm the changes made and return to the flow.
Run the flow
- Access Flows > FBA returns.
- Click Run next to the Amazon (FBA) returns to NetSuite RA and item receipt integration flow.
After the flow runs successfully, FBA returns with ‘Reimbursed’ status will not be synced with NetSuite. All other records will be synced successfully.
Comments
0 comments
Please sign in to leave a comment.