could you please help me with below requirement:
The following changes required to the automatic journals for sales invoices-
1. The normal posting of revenue would be:-
Dr. BP Customer
Cr. Sales Revenue
2. Accounting changes:-
The requirement for the journal is to split the revenue from each invoice item line in to the components on the lot record as listed below-
Cr 600000 = Sales Agri (Cost Price column)
Cr 601000 = Transport Recovery
Cr 601010 = Agency Fee
Cr 601020= Financing Fee
Cr 601030 = Rewarehousing Fee
Cr 601040 = Rebates
Cr 601050 = Other
Cr 601060 = Agents Commission
Dr BP Customer
3. Multiple Lots:-
If multiple lots are allocated to the sales item line, the value in the journal must be the sum of the lot individual lot component values selected.
The suggestion is to use additional modifier lines in the account code for the individual components in the lot table to be accounted for. Normal stock and cost of sales postings are not affected as these are as per standard X3 function.
I would appreciate if you can provide feedback on our requirement and a cost estimate to set this up for the customer.