Separate Trade Revenue account into Cash Sales Revenue and Credit Sales Revenue

68 views
Skip to first unread message

Sajee

unread,
Jul 25, 2016, 10:46:28 AM7/25/16
to iDempiere
Hi Team,

I just want to see the Trade Revenue account in to TWO :- Cash Sales Revenue and Credit Sales Revenue based on the Payment Rule{Cash, Credit}. The client want to see the TWO new accounts in Trial Balance to identify how much is the Cash Sales Value and Credit Sales Value against the Customers.
Can we do any work around with the Accounting Dimensions concept. Or do we need to Create these TWO account elements and Change the posting based on the Payment Rule(If  Cash -> Cash Sales Revenue and If Credit -> Credit Sales Revenue)

Any help appreciated. Many Thanks 

Syed (syvasoft)

unread,
Jul 26, 2016, 12:40:50 PM7/26/16
to iDempiere
Hi Sajeev,

I recommend the option of having two different account elements and change the posting based on the Payment Rule.

armenrz

unread,
Jul 28, 2016, 12:13:57 AM7/28/16
to iDempiere
Hi,

If this separation is so important to his business, you can activate User Element dimension and create two elements: Cash and Credit.
And then use GL Distribution to distribute the revenue to the TWO accounts.

This approach can be done without touching the code.

Regards,

Armen
Goodwill.co.id


Syed (syvasoft)

unread,
Jul 28, 2016, 2:33:50 AM7/28/16
to iDempiere
Nice approach :) 

Sajee

unread,
Jul 29, 2016, 1:51:21 PM7/29/16
to iDempiere
Thanks Armen and Syed for your suggestions.

 @Armen I will try your suggestion and let you know in this same thread. I havn't tried this GL Distribution before. Anyway I will update you the status.
Reply all
Reply to author
Forward
0 new messages