By using this website, you agree to our Terms of Use (click here)
Does anyone have a working import that has the same items with the same prices going into the lines for a sales price worksheet? Mine keeps saying duplicate sales price and errors out, but I have selected a new customer on the second pass for the item, which works when I do it by hand...
What does the Data Source for this Import Scenario look like?
| FS NO. | PK | PPD | Real Cost |
| FS3349 | 12 | 2.95 | 35.40 |
| F16544 | 4 | 6.25 | 25.00 |
| F16545 | 4 | 7.00 | 28.00 |
| F16547 | 12 | 1.80 | 21.60 |
The middle two columns are not used in the import. I know that when I sell a segment of items, I need to hit multiple customers with the price sheets. I was hoping to create an import scenario for each "set" of customers. Worst case, I just create an import for each customer in our system, but that's a lot of bloat..
Have you thought about just including Customer in the Data Source? I've never tried to create two rows with an import scenario before. One thing you might do is deactivate the second set of rows for the second customer and see if that gets you past the error.
That works! Sorry for the delay, got side-tracked from my upload. For anyone else following along:
This will import lines into a Sales Price Worksheet with reference ID 000003. My Data is formatted as:
FS NO. (Inventory ID) <> COST (Pending Price) <> CUSTOMER (Customer ID)
Thanks again Tim!
Awesome! And thanks for sharing your final solution Michael.