Role: SAP Business One Consultant
Duration: 1 week to start (Extendable)
Location: Los Angeles, CA, or Remote
Interview: Skype/Telephonic
Description:
Net and gross commission calculation – requires additional development
· The invoice request will be generated in an external system.
· The invoice will be imported as a draft into SAP using DTW. The invoice draft will have the following:
o Cost centers
o Program details
o Installments
· The invoice will then be converted from the draft to final invoices using the wizard
o During the invoice creation following needs to be applied
§ If Net commission- negative line on the A/R invoice
§ If Gross Commission- A journal entry for the commission debiting commission and liability account. ( This might need to be split on the basis of the installment on the A/R invoice)
§ Also if the agent has a discount then add a negative discount line on the invoice
§ Apply the cost centers to the discount and commission lines
· The commission and discounts will be stored in the system and depends on the agent and the program(project)
o The idea would be to create a reference tables somewhere in SAP to create relationship between program (project) and agent (business partner)
o The following information will be needed on the reference table
§ Business partner
§ Project
§ Net/Gross Commission
§ Commission Amount
§ Discount %
· A new Tab "Commission" will be added on the BP Master Data;
· The new tab will have 5 columns:
o Project code – Editable (Choose from list from the standard Project table);
o Project Name – Not editable;
o Commission Type – Editable – (Valid Values: GROSS, NET);
o Commission Amount - Editable ;
· Discount % -Editable;
· Two UDF will be added U_GrossCommDeb and U_GrossCommCre on the BP master data where the user will be able to specify which account we need to use to create the JE for gross commission;
Dhruv soni
Sr. Recruiter
Rider Consulting Inc
No comments:
Post a Comment