cancel
Showing results for 
Search instead for 
Did you mean: 

SAP B1 DTW EDG1

0 Kudos

Hi, (SAP Business One 9.3)

Trying to update the specific BP discount for item groups.

So the BP Discount already exists for item groups and there is some item groups that manually have a discount matched to them.

So I believe all I need to be doing is DTW the EDG1 table however when I try this I get a error..

DTW - Setup Data - Inventory - Price Lists - Special Prices - Discount Groups

DiscountGroupLineCOllection in DTW and all source and target fields match up.

I get the error - Error while convert ObjectType 65171

It fails on the 1st column. See below for what is being used.

ParentKey LineNum AbsEntry ObjectType ObjectCode DiscountType Discount PaidQuantity FreeQuantity MaximumFreeQuantity AbsEntry LineNum AbsEntry ObjectType ObjectCode DiscountType Discount PaidQuantity FreeQuantity MaximumFreeQuantity


Hopefully someone can spread some light on this!

Thanks

pressfit
Participant
0 Kudos

When we are using both templates OEDG and EDG1, we are getting the same errors:

Using LineNum Column starting from 0: This entry already exists in the following tables (ODBC -2035)65171

Not using LineNum Column: Error while convert ObjectType 65171

It seems to be slightly random. There are some records that are getting update but some others which don't with the first error.

It would be really helpful if someone can clarify this issue.

Accepted Solutions (0)

Answers (2)

Answers (2)

Ezioze
Explorer
0 Kudos

For discount groups update you have to use dgboItemGroups instead of 52 in column ObjectType

kenan_jaddeny
Contributor
0 Kudos

you should use both of the templates at the same time; OEDG and EDG1

Hi, Have tried that and still get some error?

Or I get this: 1 Update Failed 3 This entry already exists in the following tables (ODBC -2035)65171


Thanks