on 11-05-2019 9:24 AM
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
For discount groups update you have to use dgboItemGroups instead of 52 in column ObjectType
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you should use both of the templates at the same time; OEDG and EDG1
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.