Is there a way to import special prices applicable to ALL card codes?

[Former Member]

Hi everyone,

I have tried importing DTW special prices to applicable to all business partners.  SAP note 928625 says you can do so by leaving the card code empty.  This does not work.  I've tried using the template in the SAP note and also no success.  I have also tried using *1, 1*, *,%, %1 and empty in the card code but no success.  Tried numerous variations to upload but does not work.  I can upload normally if I enter a card code though.

Can someone please help me ASAP.  This should be for DTW 8.81.319 version.

Many Thanks in advance,

Brian

[former_member217514 · Accepted solution]

Does it have to be DTW?

Will the Update Special Prices Globally not work? (Inventory -> Price Lists -> Special Prices -> Update Special Prices Globally)

[Former Member · Accepted solution]

Hi Jeff,

yes I do know there is a way to update it this way, but is there no way to do it in DTW update for ALL BP's?

Many thanks,

Brian

[Johan_H · Accepted solution]

Hi Brian,

The point is, that in the end either method uses the DI API, and does the job the exact same way: each will simply cross all card codes with all item codes, and create a single entry for each.

In effect therefore, using the B1 client's global update, is the easiest way to do it from a user's point of view.

In case you want to automate this in any way, for example you want to run it at night or in the weekend because the process slows down the system, your best alternative is to build a console application, using the DI API, and running it as a scheduled job on the server. That would give you the added advantage of being able to check for changes, and only update those, instead of blindly always updating everything.

Regards,

Johan

[former_member217514 · Accepted solution]

The only way I can think of through the DTW is to use ODBC for your Data Source.  This will give you limited scripting and may be enough to accomplish what you want to do.

Another option would be to create a query in B1 for the Special prices, then output to excel.  Then unfortunately you would have to manually change all the prices.  Then upload the file.

Finally, there is always the option of writing a bit of code to create a tab delimited file for you.  This would be my first go to move, but I am a developer and I would use the DI API as well.

If you are setting the Special Price across the board for your Business Partners, you may want to use price lists.  Special Prices just override price lists for a specific Business Partner.  Price Lists are easier to update.

[Former Member · Accepted solution]

Hi All,

issue now resolved.  looks like a template issue!  If I use the templates on SAP note it worked when left blank when using the same data (though did have to leave the currency blank).  However when I tested with previous successful templates it did not work with a blank in it.  Also I tested a previous version of SAP B1 2007A PL 8 of DTW version 2005.0.29 API version 8.0.232 and the *1 did work for all card codes.

thanks for all the input on this and issue now closed.

Brian

[Johan_H]

Hi Brian,

What is the reason that you cannot just provide the card codes?

Regards,

Johan

[Former Member]

Hi Johan,

yes can be done but hundreds of BP's and items.  Will have to be copying and pasting quite a bit over and over again.

Is there a way around this.  Apparently *1 or blank use to work on DTW import!  I can go into “copy special prices to Sel. Criteria” but is there no wokaround in DTW?

Many Thanks,

Brian

[Johan_H]

Hi Brian,

I do not know how to do a global update with the DTW, other than to provide all possible card codes .

I know it can be done in the client, and it can be done with the DI API.

Do you mean to automate the process with the DTW, or would it still remain a manual job (somebody runs the DTW every day/week/etc.) ?

Regards,

Johan

[Former Member]

Hi Johan,

someone would most likely un it weekly basis.

Many Thanks so far Johan,

Brian