Skip to Content

Add new entry in an existing discount group

Hi All,

I am using SAP B1 9.1, I have discount groups defined for various customers for various manufacturers. I have got a new manufacturer, want to add new discount for this for all customers. Manually this job will be a tedious one as we have 300 customers for who we have already defined discount group for existing manufacturer.

I have got the sample file from SAP DTW as "EDG1- DiscountGroupLineCollection", don't know whether this is the correct template file for this purpose.

Here , in this template, I have entered all the customers codes, discount, discount type, object type. in the AbsEntry field I have entered the Manufacturer code, but it gives me error on import through DTW.

Would you kindly let me know which filed is for Manufacturer code ?

My sample template is as bellow...

ParentKey LineNum AbsEntry ObjectType ObjectCode DiscountType Discount PaidQuantity FreeQuantity MaximumFreeQuantity AbsEntry LineNum AbsEntry ObjectType ObjectCode DiscountType Discount PaidQuantity FreeQuantity MaximumFreeQuantity 1 0 43 ADA1 D 10 1 1 43 C005 D 10

Thanks

Suman

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Sep 19, 2015 at 10:39 AM

    Hi,

    Please check sample template under C:\Program Files (x86)\SAP\Data Transfer Workbench\Templates\Samples\1. Add New Data\Inventory\Price Lists\Special Prices\Discount Groups

    Thank you.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Suman,

      You have the right template. You will also need the header template OEDG

      The second object code field in the EG1 template is the manufacturer number from OMRC table, the objcode in the header table is the Business partner code.

      The line to use for update is a count of the number of lines already in the table for the busness partner / manufacturer number combination.

      I recommend doing the upload in a copy database first as it is easy to get wrong, and hard to fix!

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.