Test Reports with G/L Accounts?

finder · 2007-03-28

Hi,

I have a question about test reports. These reports you can find almost everywhere where is possibility to post document. These reports include some general information and posting group information. We have a customer who would like to see exact G/L transaction as it could look after posting (already with G/L accounts not only posting groups) in this report. Does somebody have a good idea how to make it or is it just too much work to start with this kind of report.

Thanks in advance,
Anti

Marije_Brummel · 2007-03-28

Most G/L transactions in CU 80 and 90 are created from the postingbuffer so maybe you can copy this transaction to a report.

Alex_Chow · 2007-03-28

It's not that hard.

All you need to do is to use the following rule:

- If the type is Customer, use the customer posting group for that customer
- If the type is Vendor, use the vendor posting group for that vendor
- If it's item, use the combination of the GPPG and GBPG defined on the general posting setup
- If it's G/L, then use the G/L account

The discounts will be posted based on the Customer posting group and the General Posting Setup depending on what type of discount the customer is getting.

The report is not that tough, but it'll require some time to develope.

andrejsm · 2007-03-28

It takes 20% time to develop 80% of solution. But there is a number of exceptions, like Fixed assets, Item charges and maybe some more.

Test Reports with G/L Accounts?

Comments

Categories