Accounts are summed together when posting purchase invoice

joh_ver
joh_ver Member Posts: 31
edited 2004-06-29 in NAV/Navision Classic Client
Hi,

Hope you can help me: In version 3.70 I have the following situation.
Purchase lines created:

Type No. Quantity Direct Unit Cost Excl. VAT
G/L Account 2085 1 100
G/L Account 2085 1 10
G/L Account 4420 1 100
G/L Account 4420 1 10

I use no dimensions. After posting the following G/L entries have been made:

G/L Account No. Gen. Bus. PG Gen. Prod. PG Amount
2085 BINNENLAND PRODUCTS19 220
1518 27,5
1601 -247,5

So all lines have been summed up in account 2085. This account is NOT used in any posting setup (Vendor, General, VAT, ..).
I checked the setup of the G/L accounts, they seemed right.

Has anyone an idea wether this is a bug or a setup not right ?
Thanks,
Johan.

Comments

  • RobertMo
    RobertMo Member Posts: 484
    Lines are grouped for G/L entries.
    Check Primary Key of T49:
    Type,G/L Account,Gen. Bus. Posting Group,Gen. Prod. Posting Group,VAT Bus. Posting Group,VAT Prod. Posting Group,Tax Area Code,Tax Group Code,Tax Liable,Use Tax,Dimension Entry No.,Job No.,Fixed Asset Line No.
    These are the fields that are used to ditinguish if the lines will be grouped or not...
               ®obi           
    ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
  • alberto
    alberto Member Posts: 60
    In G/L setup did you flag "Summarize G/L Entries" ?
  • joh_ver
    joh_ver Member Posts: 31
    Thanks for your input. It appeared to be the PK of Table 49 was changed (?) during the migration from 3.10 to 3.70

    So, it's working now.

    Ciao,
    Johan.

Categories