Open AR - conversion problems

Gary:

Thanks for your reply.

My AP and AR invoices are flagged as open.

I found that the display of invoice amounts on the aging report depends on entries in the pay dates field (is actually a number value that looks like a julian date) and in the pay amounts and doc pay amounts field. I calulate the number of days between 01/01/00 and the due date and then add 263 for the value in the pay dates field. Originally, I took it as a date field. This field along with the others need to be populated even if it is an open invoice with no payments.

I figured it by dumping my data and data from a demo data base to Excel and then compared the two files. It has been a real learning experience.

Carl Peterson
Nexus Software, Inc.
Plymouth, Michigan
cpeterson@...

Gary Parfrey <garyp@...> wrote:
You need to make sure they are flagged as open invoices

Gary Parfrey

Dot Net IT Limited, Reg No 4412519

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mosquito Shoes
Sent: 23 May 2007 01:01
To: vantage@yahoogroups.com
Subject: [Vantage] Open AR - conversion problems

We are importing summary open AR records into the arinvched and
arinvcdtl files and having problems with the records showing in the AR
age analysis report and not able to post cash receipts.

We exported records from a Vanage 8.03 demo database and our records
match field per field.

Does anyone know if I have miss populating other files and/or have
incorrect data in the conversion file.

Thanks,

Carl Peterson
Nexus Software, Inc.
Plymouth, Michigan
1-734-812-9532
cpeterson@... <mailto:cpeterson%40nexussoftware.net>

---------------------------------
TV dinner still cooling?
Check out "Tonight's Picks" on Yahoo! TV.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]






---------------------------------
Bored stiff? Loosen up...
Download and play hundreds of games for free on Yahoo! Games.

[Non-text portions of this message have been removed]
We are importing summary open AR records into the arinvched and arinvcdtl files and having problems with the records showing in the AR age analysis report and not able to post cash receipts.

We exported records from a Vanage 8.03 demo database and our records match field per field.

Does anyone know if I have miss populating other files and/or have incorrect data in the conversion file.

Thanks,

Carl Peterson
Nexus Software, Inc.
Plymouth, Michigan
1-734-812-9532
cpeterson@...



---------------------------------
Bored stiff? Loosen up...
Download and play hundreds of games for free on Yahoo! Games.

[Non-text portions of this message have been removed]
We are importing summary open AR records into the arinvched and arinvcdtl files and having problems with the records showing in the AR age analysis report and not able to post cash receipts.

We exported records from a Vanage 8.03 demo database and our records match field per field.

Does anyone know if I have miss populating other files and/or have incorrect data in the conversion file.

Thanks,

Carl Peterson
Nexus Software, Inc.
Plymouth, Michigan
1-734-812-9532
cpeterson@...



---------------------------------
TV dinner still cooling?
Check out "Tonight's Picks" on Yahoo! TV.

[Non-text portions of this message have been removed]
You need to make sure they are flagged as open invoices



Gary Parfrey

Dot Net IT Limited, Reg No 4412519

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mosquito Shoes
Sent: 23 May 2007 01:01
To: vantage@yahoogroups.com
Subject: [Vantage] Open AR - conversion problems



We are importing summary open AR records into the arinvched and
arinvcdtl files and having problems with the records showing in the AR
age analysis report and not able to post cash receipts.

We exported records from a Vanage 8.03 demo database and our records
match field per field.

Does anyone know if I have miss populating other files and/or have
incorrect data in the conversion file.

Thanks,

Carl Peterson
Nexus Software, Inc.
Plymouth, Michigan
1-734-812-9532
cpeterson@... <mailto:cpeterson%40nexussoftware.net>


---------------------------------
TV dinner still cooling?
Check out "Tonight's Picks" on Yahoo! TV.

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]