Skip to Content
เมนู
คุณต้องลงทะเบียนเพื่อโต้ตอบกับคอมมูนิตี้
คำถามนี้ถูกตั้งค่าสถานะ
2 ตอบกลับ
4728 มุมมอง

I'm needing to show each individual currency in the analytic account's "Costs & Revenues" lines, I would need to dynamically add columns for the different currencies each invoice has and show the total below (mimicking the behavior of the 'Amount' column that's already there), is there a way to do this or a workaround with a similar result?

The analytic account lines already store the amount in the original currency as well as the converted one to the company currency.

I want to avoid going mad by adding a field for each currency by hand.

อวตาร
ละทิ้ง

Hi, Ray, thanks for the answer, but I would need to have a different column for each possible currency and show the amount the same way the 'Amount' column does.

คำตอบที่ดีที่สุด

Each Analytic Account Line has a move_id field that stores the linked Journal Item that was responsible for creating it.  Each Journal Item has a currency_id field which is blank if the Currency matches the base Currency of the Company, and populated with the Currency of the Income/Expense otherwise.

Create a related field that you add to the List View.

move_id.currency_id

It will only make sense to total lines in the same Currency.


อวตาร
ละทิ้ง
Related Posts ตอบกลับ มุมมอง กิจกรรม
1
ต.ค. 25
11582
2
ก.ค. 24
3279
1
มิ.ย. 24
5668
1
ต.ค. 23
98
413 Request Entity Too Large แก้ไขแล้ว
1
ส.ค. 23
2194