How to make Journal Posted Grouping/Summary ?

dede_aja_tuhdede_aja_tuh Member Posts: 39
Please help ME!

I already search and try in NAV about Posted Journal from Sales or Purchase Transaction. This is what i got (example purchase) :

Item No - Item Name - Qty - @ - Amount
70000 ---- Side Panel ---- 10 --- 100 --- 1000
70001 --- Base
10 ---- 200 --- 2000

Journal hit when Posted Purchase Receipts for 2 (two) row line item in full quantity : (COA Code & Name under just example)

COA Code Code Name
[D] 2131 Raw Material 1000
[C] 5530 AP Accrued 1000

[D] 2131 Raw Material 2000
[C] 5530 AP Accrued 2000

From data above, it shown that i get the same inventory account and AP Accrued Account for 2 line item.

My question is : how if i want to do grouping/summary the same account? So i just get shown 2 jurnal (not 4 journals like data above) for 2 line item?? My purpose is just like this exampe :

COA Code Code Name
[D] 2131 Raw Material 3000
[C] 5530 AP Accrued 3000

Thanx in advance.

Comments

  • crisnicolascrisnicolas Member Posts: 177
    NAV acts just like you are asking... this is standard...
    It does group G/L accounts when posting... but for example, if those two lines have different dimension values, then grouping is not possible.
  • dede_aja_tuhdede_aja_tuh Member Posts: 39
    Thanks for Reply Crisnicolas.

    But when i post receipt the PO, it just separate the journal depends on item row line (not like grouping G/L Account like u said).

    Maybe u can tell me some setting in NAV that i can use to take this problem out?

    Many thanks.
  • crisnicolascrisnicolas Member Posts: 177
    This does not depend on any setting... it's the way NAV works.
    Try it out on a Cronus.

    Maybe you have some customization that makes this act differently...
Sign In or Register to comment.