Why Purch. Header table related to Sales Inv. Header table

podolly

Hi experts,

I have run a database test with maximum choices after my accountant runs a bit postings in NAV 5.0 SP1. And finally I find this error prompted.



Can anyone explain why "Purchase Header"."Last Prepayment No." is related to "Sales Invoice Header"."No."? I really get no clues why they should be related.

Thanks.

jannestig

I think you would have to look at the actual document shown, since you are running a database test from i assume File + database + test, it will be testing the relationships between all tables. The Sales invoice and purchase table as related through the prepayment field, All though i unfamiliar with the honkkong or chinese version I am assuming that a number of prepayments hae been made to the vendor from the customer but not yet paid to 100 through prepayments. Either way looking at the document named p000004 will show you what is outstanding