Cash requirement

couberpu

Good Morning,

I need help on finding a report to help our comapny project the cash requirement.

We are running 3.60 with 3.7 run time on sql option.

The requirement is to project cash based on purchase invoice and prepayment. We did a lot of oversea business and vendor would ask for payment to make the product. But we would not get any shipment or invoice until monthes later. I am sure if we can just use the cash projection report in AP to do the job. I am thinking about using Purchase order as the base to create our own report.
Please advise if there was a report in the system or if there is a better way to do this.

Thanks,
CouberPu

ssingla

Do you have Form 355 Receivables-Payables Lines? If yes, does it suffice your requirements?

couberpu

This is what was required:

Unpaied Purchase Invoice + Received not invoiced amount + open purchase line amount (Not yet received) by vendor

Is there any form or report does this kind of calculation?

Thanks

Alex_Chow

Combine the the following reports:

10093 - Open Vendor Entries
10096 - Outstanding Purch.Order Status
10101 - Reconcile AP to GL

couberpu

Thanks for all the help.

Just one more question: Is there a 'cash management' in Navision.

Alex_Chow

couberpu wrote:

Thanks for all the help.

Just one more question: Is there a 'cash management' in Navision.

Yes there is. But only from version 4.0 forward.

ssingla

Alex Chow wrote:

couberpu wrote:

Thanks for all the help.

Just one more question: Is there a 'cash management' in Navision.

Yes there is. But only from version 4.0 forward.

Is this part of Localization? I fail to find the same in our localized database

asmilie2b

Hello Alex,

I was interested in the report you mention, "10093 - Open Vendor Entries". Would that be part of a localization somewhere? As I checked in W1 cronus 2009 R2 it doesn't seem to exist. We have a need for a simple report showing open entries so I hoped that one might be close to what we need.

cheers

ssingla

asmilie2b wrote:

"10093 - Open Vendor Entries"

It surely is a localization report.

Alex_Chow

It's the NA locatization.

Savatage

Report 10093 - Open Vendor Entries
https://docs.google.com/document/d/1v8n ... Nf7TM/edit

you'll need to edit the ($) to fit your field names.